deevhyndaily transaction volume per chain
Updated 2025-01-21
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
34
35
36
›
⌄
SELECT
date_trunc('day', block_timestamp) AS day,
platform,
'Arbitrum' AS chain_name,
(SUM(amount_in_usd + amount_out_usd) / 2) AS volume
FROM arbitrum.defi.ez_dex_swaps
WHERE platform IN ('uniswap-v3', 'uniswap-v2')
AND date_trunc('day', block_timestamp) >= '2023-06-01'
AND amount_in_usd IS NOT NULL
AND amount_out_usd IS NOT NULL
GROUP BY day, platform
UNION
SELECT
date_trunc('day', block_timestamp) AS day,
platform,
'Avalanche' AS chain_name,
(SUM(amount_in_usd + amount_out_usd) / 2) AS volume
FROM avalanche.defi.ez_dex_swaps
WHERE platform IN ('uniswap-v3', 'uniswap-v2')
AND date_trunc('day', block_timestamp) >= '2023-06-01'
AND amount_in_usd IS NOT NULL
AND amount_out_usd IS NOT NULL
GROUP BY day, platform
UNION
SELECT
date_trunc('day', block_timestamp) AS day,
platform,
'Base' AS chain_name,
(SUM(amount_in_usd + amount_out_usd) / 2) AS volume
FROM base.defi.ez_dex_swaps
WHERE platform IN ('uniswap-v3', 'uniswap-v2')
AND date_trunc('day', block_timestamp) >= '2023-06-01'
QueryRunArchived: QueryRun has been archived