Date | Swap Count | Swap Volume ($SPEC) | Swap Volume ($USD) | Swapper Count | Chain | |
|---|---|---|---|---|---|---|
1 | 2024-05-01 00:00:00.000 | 4437 | 888541.542611675 | 8371971.72 | 1016 | Ethereum |
2 | 2024-05-01 00:00:00.000 | 69005 | 13466446.9325953 | 122129119.21 | 21432 | Base |
3 | 2024-06-01 00:00:00.000 | 48036 | 6166179.20379784 | 56887097.19 | 5359 | Base |
4 | 2024-06-01 00:00:00.000 | 1777 | 384711.225094817 | 3652539.39 | 502 | Ethereum |
5 | 2024-07-01 00:00:00.000 | 1059 | 211363.912055448 | 1486677.12 | 362 | Ethereum |
6 | 2024-07-01 00:00:00.000 | 29323 | 4371238.21456295 | 30044951.54 | 3187 | Base |
7 | 2024-08-01 00:00:00.000 | 29050 | 3516215.02714305 | 21673744.84 | 2247 | Base |
8 | 2024-08-01 00:00:00.000 | 1182 | 279548.230665141 | 1751234.17 | 329 | Ethereum |
9 | 2024-09-01 00:00:00.000 | 36851 | 2876983.20202443 | 20643678.82 | 2365 | Base |
10 | 2024-09-01 00:00:00.000 | 1353 | 342916.484021812 | 2523151.5 | 430 | Ethereum |
11 | 2024-10-01 00:00:00.000 | 2748 | 541489.037262646 | 5108415.43 | 958 | Ethereum |
12 | 2024-10-01 00:00:00.000 | 84263 | 4536749.31340735 | 42967651.52 | 4344 | Base |
13 | 2024-11-01 00:00:00.000 | 4612 | 1198785.51511245 | 14385045.29 | 1685 | Ethereum |
14 | 2024-11-01 00:00:00.000 | 132654 | 11500204.1613293 | 126506045.36 | 14839 | Base |
15 | 2024-12-01 00:00:00.000 | 114590 | 8396394.91802957 | 101482819.83 | 15205 | Base |
16 | 2024-12-01 00:00:00.000 | 4793 | 1220802.35118148 | 16187671.52 | 1891 | Ethereum |
17 | 2025-01-01 00:00:00.000 | 1670 | 89822.064115006 | 816852.17 | 518 | Base |
18 | 2025-01-01 00:00:00.000 | 90 | 17687.540919288 | 169420.08 | 61 | Ethereum |
Eman-RazSPEC Swaps Over Time
Updated 2025-04-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
with overview as (select block_timestamp, tx_hash, origin_from_address as swapper, symbol_in || '➡' || symbol_out as token_pair, case
when token_in = lower('0xAdF7C35560035944e805D98fF17d58CDe2449389') then sum(amount_in)
when token_out = lower('0xAdF7C35560035944e805D98fF17d58CDe2449389') then sum(amount_out)
end as volume, sum(coalesce(amount_in_usd,amount_out_usd)) as volume_usd, platform as dex, case
when token_in = lower('0xAdF7C35560035944e805D98fF17d58CDe2449389') then 'Sell'
when token_out = lower('0xAdF7C35560035944e805D98fF17d58CDe2449389') then 'Buy'
end as swap_direction, 'Ethereum' as "Chain"
from ethereum.defi.ez_dex_swaps
where (token_in = lower('0xAdF7C35560035944e805D98fF17d58CDe2449389')
or token_out = lower('0xAdF7C35560035944e805D98fF17d58CDe2449389'))
and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'
group by block_timestamp, token_in, token_out, tx_hash, origin_from_address, symbol_in, symbol_out, platform
union all
select block_timestamp, tx_hash, origin_from_address as swapper, symbol_in || '➡' || symbol_out as token_pair, case
when token_in = lower('0x96419929d7949D6A801A6909c145C8EEf6A40431') then sum(amount_in)
when token_out = lower('0x96419929d7949D6A801A6909c145C8EEf6A40431') then sum(amount_out)
end as volume, sum(coalesce(amount_in_usd,amount_out_usd)) as volume_usd, platform as dex, case
when token_in = lower('0x96419929d7949D6A801A6909c145C8EEf6A40431') then 'Sell'
when token_out = lower('0x96419929d7949D6A801A6909c145C8EEf6A40431') then 'Buy'
end as swap_direction, 'Base' as "Chain"
from base.defi.ez_dex_swaps
where (token_in = lower('0x96419929d7949D6A801A6909c145C8EEf6A40431')
or token_out = lower('0x96419929d7949D6A801A6909c145C8EEf6A40431'))
and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'
group by block_timestamp, token_in, token_out, tx_hash, origin_from_address, symbol_in, symbol_out, platform)
select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", count(distinct tx_hash) as "Swap Count", sum(volume) as "Swap Volume ($SPEC)",
sum(volume_usd) as "Swap Volume ($USD)", count(distinct swapper) as "Swapper Count", "Chain"
from overview
group by 1,6
order by 1
Last run: about 1 month ago
18
1KB
42s