DATE | PLATFORM | VOLUME | |
|---|---|---|---|
1 | 2024-05-01 00:00:00.000 | Others | 1119882.43353894 |
2 | 2024-09-16 00:00:00.000 | Dragonswap | 883744.160876975 |
3 | 2024-08-07 00:00:00.000 | Dragonswap | 957190.436492283 |
4 | 2025-03-09 00:00:00.000 | Dragonswap | 165849.322019463 |
5 | 2025-02-20 00:00:00.000 | Others | 9590468.50802313 |
6 | 2025-01-07 00:00:00.000 | Dragonswap | 15529064.1589058 |
7 | 2024-11-13 00:00:00.000 | Others | 4636882.55176586 |
8 | 2025-01-19 00:00:00.000 | Others | 1542100.46097189 |
9 | 2024-08-16 00:00:00.000 | Others | 264713.88496696 |
10 | 2025-03-09 00:00:00.000 | Others | 811724.003742694 |
11 | 2024-03-03 00:00:00.000 | Others | 1625667.6186457 |
12 | 2024-03-22 00:00:00.000 | Others | 1247715.96194245 |
13 | 2024-04-26 00:00:00.000 | Others | 858019.16977435 |
14 | 2024-09-27 00:00:00.000 | Dragonswap | 1881340.91252274 |
15 | 2024-12-25 00:00:00.000 | Dragonswap | 8011425.49481887 |
16 | 2024-12-27 00:00:00.000 | Others | 2011594.46491559 |
17 | 2024-11-15 00:00:00.000 | Dragonswap | 8875283.37704796 |
18 | 2024-03-05 00:00:00.000 | Others | 3244298.10486855 |
19 | 2024-12-12 00:00:00.000 | Dragonswap | 16024839.5800313 |
20 | 2024-07-28 00:00:00.000 | Dragonswap | 471745.231348562 |
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
Last run: 26 days ago
...
677
37KB
2s