drone-mostafaUntitled Query
    Updated 2022-09-21
    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