kasadeghUntitled Query
    Updated 2022-11-30
    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