SocioCryptotransaction count
Updated 2023-09-27
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from BlockTracker / transaction count per address (DFK) @ https://flipsidecrypto.xyz/BlockTracker/q/wsPyFiRHUkry/transaction-count-per-address-dfk
SELECT 'DFK' as title,
livequery.live.udf_api(
'POST',
'https://subnets.avax.network/defi-kingdoms/dfk-chain/rpc',
{'Content-Type': 'application/json'},
{
'jsonrpc':'2.0',
'id': 1,
'method':'eth_getTransactionCount',
'params': [
'{{wallet_address}}',
'latest'
]
}
):data:result::string as response,
utils.udf_hex_to_int(response) as n_txs
UNION
SELECT 'DEXALOT' as title,
livequery.live.udf_api(
'POST',
'https://subnets.avax.network/dexalot/mainnet/rpc',
{'Content-Type': 'application/json'},
{
'jsonrpc':'2.0',
'id': 1,
'method':'eth_getTransactionCount',
'params': [
'{{wallet_address}}',
'latest'
]
}
Run a query to Download Data