datavortexpregnant-black
Updated 2024-10-31
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
›
⌄
WITH WeeklyVolume AS (
-- Arbitrum Blockchain inflow and outflow volumes
SELECT
DATE_TRUNC('week', block_timestamp) AS TimeLine,
'Arbitrum' AS Blockchain,
SUM(CASE WHEN symbol_in = 'USDC' THEN COALESCE(amount_in_usd, 0) ELSE 0 END) AS InflowVolumeUSD,
SUM(CASE WHEN symbol_out = 'USDC' THEN COALESCE(amount_in_usd, 0) ELSE 0 END) AS OutflowVolumeUSD
FROM arbitrum.defi.ez_dex_swaps
GROUP BY TimeLine
UNION ALL
-- Base Blockchain inflow and outflow volumes
SELECT
DATE_TRUNC('week', block_timestamp) AS TimeLine,
'Base' AS Blockchain,
SUM(CASE WHEN symbol_in = 'USDC' THEN COALESCE(amount_in_usd, 0) ELSE 0 END) AS InflowVolumeUSD,
SUM(CASE WHEN symbol_out = 'USDC' THEN COALESCE(amount_in_usd, 0) ELSE 0 END) AS OutflowVolumeUSD
FROM base.defi.ez_dex_swaps
GROUP BY TimeLine
UNION ALL
-- Solana Blockchain inflow and outflow volumes
SELECT
DATE_TRUNC('week', block_timestamp) AS TimeLine,
'Solana' AS Blockchain,
SUM(CASE WHEN swap_from_symbol = 'USDC' THEN COALESCE(swap_from_amount_usd, 0) ELSE 0 END) AS InflowVolumeUSD,
SUM(CASE WHEN swap_from_symbol = 'USDC' THEN COALESCE(swap_from_amount_usd, 0) ELSE 0 END) AS OutflowVolumeUSD
FROM solana.defi.ez_dex_swaps
GROUP BY TimeLine
)
SELECT
TimeLine,
Blockchain,
QueryRunArchived: QueryRun has been archived