kasadeghUntitled Query
Updated 2022-11-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select date_trunc (day,block_timestamp) as date,
count (distinct tx_hash) as TX_Count,
count (distinct to_address) as Users_Count,
sum (raw_amount/1e18) as Total_ACX_Volume,
avg (raw_amount/1e18) as Average_ACX_Volume,
min (raw_amount/1e18) as Minimum_ACX_Volume,
max (raw_amount/1e18) as Maximum_ACX_Volume
from ethereum.core.ez_token_transfers
where from_address = '0xe50b2ceac4f60e840ae513924033e753e2366487'
and contract_address = '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f'
group by 1
order by 1
Run a query to Download Data