Popex404DYDX Jan 2023 Daily Transfers
Updated 2024-07-24
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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