Pine AnalyticsDinari 8
Updated 2024-06-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
count(DISTINCT tx_hash) as events,
count(DISTINCT sender) as swappers,
sum(
CASE when symbol_in like 'USDC' then amount_in
else amount_out end
) as volume
FROM arbitrum.defi.ez_dex_swaps
WHERE token_in in (
lower('0x2f71b3804a74a013d00065225752dba9ad061e51'),
lower('0x407274ABb9241Da0A1889c1b8Ec65359dd9d316d'),
lower('0x43333771E8d5FD74E5491d10aeAc2BFdC23D19C8')
)
OR token_out in (
lower('0x2f71b3804a74a013d00065225752dba9ad061e51'),
lower('0x407274ABb9241Da0A1889c1b8Ec65359dd9d316d'),
lower('0x43333771E8d5FD74E5491d10aeAc2BFdC23D19C8')
)
Auto-refreshes every 3 hours
QueryRunArchived: QueryRun has been archived