Popex404DYDX Jan 2023 Daily Transfers
    Updated 2024-07-24
    select
    date_trunc('d',block_timestamp) as "Date",
    label as "Destiny",
    sum(amount) as "DYDX Volume",
    sum(amount_usd) as "$USD Volume",
    count(distinct tx_hash) as "Transfers",
    count (distinct from_address) as "Senders"
    from ethereum.core.ez_token_transfers join ethereum.core.dim_labels on To_address = address
    where from_address not in (select distinct address from ethereum.core.dim_labels)
    and contract_address = lower('0x92D6C1e31e14520e676a687F0a93788B716BEff5')
    and block_timestamp >= '2023-01-01'
    group by 1,2
    QueryRunArchived: QueryRun has been archived