SocioAnalyticaSEI volume monthly aggregation
Updated 2025-02-02
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
›
⌄
SELECT
date_trunc('month', date) as month,
'Outflow' direction,
bridge,
integrator,
NULL as outgoing_chain_volume_rank,
dest_chain as chain,
-- CASE WHEN outgoing_chain_volume_rank < 10 THEN src_chain ELSE 'Other' END as source_chain,
sum(tx_count) as tx_count,
sum(volume_usd) as volume_usd,
FROM $query('406d1ab7-75d6-4cec-a2b7-aa6d5d1e0227')
GROUP BY 1,2,3,4,5,6
UNION
SELECT
date_trunc('month', date) as month,
'Inflow' direction,
bridge,
integrator,
outgoing_chain_volume_rank,
src_chain as chain,
-- CASE WHEN outgoing_chain_volume_rank < 10 THEN src_chain ELSE 'Other' END as source_chain,
sum(tx_count) as tx_count,
sum(volume_usd) as volume_usd,
FROM $query('1c94facc-1e23-4665-8f75-d5ddbb4c3c27')
GROUP BY 1,2,3,4,5,6
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived