0-MIDdaily
Updated 2025-03-04
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select BLOCK_TIMESTAMP::date as day
,sum(AMOUNT_USD) as volume
,avg(AMOUNT_USD) as avg_volume
,count(distinct ORIGIN_FROM_ADDRESS) as swappers
,count(distinct TX_HASH) as swaps
from arbitrum.core.ez_token_transfers
where ORIGIN_TO_ADDRESS='0xdef1c0ded9bec7f1a1670819833240f027b25eff'
and ORIGIN_FUNCTION_SIGNATURE='0x415565b0'
and ORIGIN_FROM_ADDRESS=TO_ADDRESS
and BLOCK_TIMESTAMP::date>=current_date-7
group by 1
QueryRunArchived: QueryRun has been archived