MostafaUntitled Query
    Updated 2023-09-05
    select
    date_trunc('week', block_timestamp) as date,
    count(distinct TX_HASH) as All_transactions,
    sum(All_transactions) over (order by date) as cumulative_transfers,
    COUNT(distinct ORIGIN_FROM_ADDRESS) as users,
    sum(users) over (order by date) as cumulative_users,
    sum(AMOUNT) as Total_volume,
    sum(AMOUNT_USD) as Total_volume_USD,
    sum(AMOUNT_USD)/All_transactions as AVG_volume_per_transactions,
    sum(AMOUNT_USD)/users as AVG_volume_per_users
    from Ethereum.core.ez_token_transfers
    where CONTRACT_ADDRESS= lower ('0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce')
    group by 1
    Run a query to Download Data