# Click the Variables button, above, to create your own variables.
GET ${exampleVariable1} // _search
{
"query": {
"${exampleVariable2}": {} // match_all
}
}

GET /ethereum_txn_v1/_search
{
"query": {
"match": {
"tx_hash": "0x0b65bbb0558d2b8809492a2a76961a455718e6fb6997d8edbf53e19825e55724"
// "tx_hash": "0x0145d3b6b33437f168a05aa4706fc067e2a1dc49e11a012ed86119eb043ce0b6"
}
}
}
GET /ethereum_txn_v1/_search
{
"query": {
"match": {
"attend_address": "0x2a06a272d4687c96df500c303a5b35c0ebae3bd3"
}
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
],
"size": 101,
"from": 16
}

GET /ethereum_txn_v2/_search
{
"query": {
"match": {
"attend_address": "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"
}
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
],
"size": 101,
"from": 16
}

GET /ethereum_txn_v1/_search
{
"size": 1000,
"query": {
"match_all": {}
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

GET /tron_txn_v1/_search
{
"size": 1000,
"query": {
"bool": {
"must": [
{
"match_all": {}
}
]
}
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

GET /tron_txn_v1/_search
{
"size": 1000,
"query": {
"bool": {
"must": [
{
"match_all": {}
}
]
}
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

GET /ethereum_txn_v1/_search
{
"size": 1,
"query": {
"match_all": {}
},
"sort": [
{
"_script": {
"type": "number",
"script": {
"lang": "painless",
"source": "doc['value'].value.length()"
},
"order": "desc"
}
}
]
}

GET /ethereum_txn_v1/_search
{
"query": {
"match": {
"tx_hash": "0xb30ea38233f338a860241d5e294e3b8926a0d42e3e021490731d9530b4531a9f"
// "tx_hash": "0x0145d3b6b33437f168a05aa4706fc067e2a1dc49e11a012ed86119eb043ce0b6"
}
}
}

GET /ethereum_txn_v1/_search
{
"query": {
"bool": {
"filter": [
{ "term": { "attend_address": "0xe8aad85b7a674c44a641c8c4be22ded40ceee561" } }
]
}
},

"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

GET /ethereum_txn_v1/_search
{
"query": {
"bool": {
"filter": [
{ "term": { "attend_address": "0xe8aaD85B7A674c44A641C8c4be22DED40CeeE561" } }
]
}
},
"_source": {
"includes": ["from","to","value","timestamp", "events"]
// "exclude": ["input", "logs"]
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

GET /ethereum_txn_v1/_search
{
"size": 1000,
"query": {
"bool": {
"filter": [
{ "term": { "block_number": 16001067 } }
]
}
},
"_source": {

// "exclude": ["input", "logs"]
}
/*
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
*/
}

GET /ethereum_txn_v1/_search
{
"size": 1000,
"query": {
"term": {
"block_number": 18019072
}
},
"_source": {
// "include": ["attend_address", "tx_hash", "block_number"],
"excludes": ["input", "logs"]
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

GET /bitcoin_txn_v1/_search
{
"size": 1000,
"query": {
"term": {
"block_number": 800002
}
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

POST /bitcoin_txn_v1/_search
{
"query": {
"match_all": {}
}
}

POST /bitcoin_txn_v3/_search
{
"query": {
"match_all": {}
}
}

GET /ethereum_txn_v1/_search
{
"size": 1000,
"query": {
"bool": {
"filter": [
{ "term": { "block_number": 18017148 } }
]
}
},
"_source": {

// "exclude": ["input", "logs"]
}
/*
"sort": [
{
"block_number": {
"order": "asc"
}
}
]
*/
}

GET /ethereum_txn_v1/_search
{
"size": 1000,
"query": {
"term": {
// "block_number": 18019072,
"block_number": 800001
}
},
"_source": {
// "include": ["attend_address", "tx_hash", "block_number"],
"excludes": ["input", "logs"]
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

POST /ethereum_txn_v1/_search
{
"query": {
"match_all": {}
},
"post_filter": {
"bool": {
"must": [
{
"term": {
"attend_address": "0xfe9529b753b412941127fea1981e5ce0a85c101e"
}
}
]
}
},
"sort": [
{
"value": {
"order": "desc"
}
}
]
}

POST /ethereum_txn_v1_re/_search
{
"query": {
"match_all": {}
},
"post_filter": {
"bool": {
"must": [
{
"term": {
"attend_address": "0xfe9529b753b412941127fea1981e5ce0a85c101e"
}
}
]
}
}
}

GET /ethereum_txn_v1/_search
{
"size": 1000,
"query": {
"bool": {
"filter": [
{
"range": {
"timestamp": {
"gte": 0,
"lte": 1992239423
}
}
}
]
}
},
"_source": {
"excludes": ["input", "logs"]
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

GET /ethereum_txn_v1/_search
{
"size": 1000,
"query": {
"bool": {
"filter": [
{
"range": {
"timestamp": {
"gte": 1693452731,
"lte": 1693452731
}
}
}
]
}
},
"_source": {
"excludes": ["input", "logs"]
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

GET /ethereum_txn_v1/_search
{
"size": 1000,
"query": {
"bool": {
"filter": [
{
"range": {
"timestamp": {
"gte": 1692256056000,
"lte": 1692256056000
}
}
}
]
}
},
"_source": {
"excludes": ["input", "logs"]
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

GET /tron_txn_v1/_search
{
"size": 1000,
"query": {
"bool": {
"filter": [
{
"range": {
"timestamp": {
"lte": 1692256058000
}
}
}
]
}
},
"_source": {
"excludes": ["input", "logs"]
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

GET /bitcoin_txn_v1/_search
{
"size": 1000,
"query": {
"bool": {
"filter": [
{
"range": {
"block_number": {
"gte": 310000, // Start timestamp (e.g., January 15, 2023)
"lte": 18000000 // End timestamp (e.g., January 16, 2023)
}
}
}
]
}
},
"_source": {
"excludes": ["input", "logs"]
},
"sort": [
{
"block_number": {
"order": "asc"
}
}
]
}

GET /bitcoin_txn_v1/_search
{
"size": 1000,
"query": {
"match_all": {}
}
}

GET /bitcoin_txn_v1_re/_search
{
"size": 1000,
"query": {
"bool": {
"filter": [
{ "term": { "attend_address": "bc1qddgsd5xzwcnfh5kg2pnqpnrzc0eygk3un8kr0s" } }
]
}
}
}

GET /bitcoin_txn_v1_alias/_search
{
"size": 1000,
"query": {
"bool": {
"filter": [
{ "term": { "list_address_to": "bc1qnxqs46jyvdf2elelsg96g8xezttcpf9kv7n4f9" } }
]
}
}
}

GET /bitcoin_txn_v1_alias/_search
{
"size": 1000,
"query": {
"bool": {
"should": [
{"term": {"list_address_to": "1FeexV6bAHb8ybZjqQMjJrcCrHGW9sb6uF"}},
{"term": {"list_address_from": "1FeexV6bAHb8ybZjqQMjJrcCrHGW9sb6uF"}}
],
"minimum_should_match": 1
}
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

GET /bitcoin_txn_v1_alias/_search
{
"size": 1000,
"query": {
"match_all": {}
}
}

GET /tron_txn_v1/_search
{
"size": 1000,
"query": {
"match_all": {}
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

GET /tron_txn_v1/_search
{
"size": 1000,
"query": {
"bool": {
"filter": [
{ "term": { "attend_address": "TKm31K6LBmfY2oW55AVHnU5GCJMSCJHeNh" } }
]
}
}
}

GET /tron_txn_v1/_search
{
"size": 1000,
"query": {
"bool": {
"filter": [
{ "term": { "attend_address": "TBTEajt4pr93pJY6fuxCvURHNLa5pP5t8x" } }
]
}
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

GET /tron_txn_v1/_search
{
"size": 1000,
"_source": {
"excludes": ["input", "logs"]
},
"sort": [
{
"block_number": {
"order": "desc"
}
}
]
}

POST /_reindex
{
"source": {
"index": "bitcoin_txn_v1"
},
"dest": {
"index": "bitcoin_txn_v1_re"
}
}

POST /_reindex
{
"source": {
"index": "ethereum_txn_v1"
},
"dest": {
"index": "ethereum_txn_v1_re"
}
}

POST /_aliases
{
"actions": [
{ "add": { "index": "ethereum_txn_v1_re", "alias": "ethereum_txn_v1_alias" } }
]
}

POST /_reindex
{
"source": {
"index": "tron_txn_v1"
},
"dest": {
"index": "tron_txn_v1_re"
}
}

POST /_aliases
{
"actions": [
{ "add": { "index": "tron_txn_v1", "alias": "tron_txn_v1_alias" } }
]
}