messariDaily Fees + Revenue copy copy
Updated 2025-03-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from Abbas_ra21 / Daily Fees + Revenue copy @ https://flipsidecrypto.xyz/Abbas_ra21/q/KCOarTEzyhhr/daily-fees-revenue-copy
-- forked from Daily Fees + Revenue @ https://flipsidecrypto.xyz/studio/queries/520a72ec-ba95-448e-a554-14af886d3d77
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS DATE,
case when platform='dragonswap' then 'Dragonswap' else 'Others' end AS Platform,
COALESCE(SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)), 0) AS volume
FROM
sei.defi.ez_dex_swaps
where
block_timestamp::date >= dateadd('day',-390,current_date)
GROUP BY
1,2
QueryRunArchived: QueryRun has been archived