drone-mostafaUntitled Query
Updated 2022-09-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
count (distinct tx_hash) num_transactions,
count (distinct ORIGIN_FROM_ADDRESS) num_users,
sum (amount) volume,
avg (amount) avg_volume,
avg (amount_usd) avg_volume_usd,
sum (amount_usd) volume_usd,
min (amount) min_amount,
min (amount_usd) min_amount_usd ,
max (amount) max_amount,
max (amount_usd) max_amount_usd ,
median (amount) median_amount,
median(amount_usd) median_amount_usd
from ethereum.core.ez_token_transfers
where to_address = lower('0x5e3ef299fddf15eaa0432e6e66473ace8c13d908')
and ORIGIN_FUNCTION_SIGNATURE='0x6ab15071'
and block_timestamp::date >= '2022-07-01'
Run a query to Download Data