DATE | VOLUME | |
|---|---|---|
1 | 2024-02-02 00:00:00.000 | 14837950 |
2 | 2024-01-31 00:00:00.000 | 28536203 |
3 | 2024-01-30 00:00:00.000 | 36821750 |
4 | 2024-01-21 00:00:00.000 | 26992392 |
5 | 2024-02-01 00:00:00.000 | 17387075 |
6 | 2024-01-29 00:00:00.000 | 19792985 |
7 | 2024-01-28 00:00:00.000 | 19145387 |
8 | 2024-01-25 00:00:00.000 | 21770311 |
9 | 2024-01-24 00:00:00.000 | 21586652 |
10 | 2024-01-19 00:00:00.000 | 35930277 |
11 | 2024-01-20 00:00:00.000 | 30123427 |
12 | 2024-01-26 00:00:00.000 | 16159883 |
13 | 2024-01-22 00:00:00.000 | 40587532 |
14 | 2024-01-27 00:00:00.000 | 16092623 |
15 | 2024-01-23 00:00:00.000 | 23450164 |
seaweed-uew7B4defillama_example
Updated 2024-02-06
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
›
⌄
⌄
/***
-- Get Chain TVL--
SELECT * FROM external.defillama.fact_chain_tvl LIMIT 10
-- Get DEX Volume --
SELECT * FROM external.defillama.fact_dex_volume
WHERE date >= current_date - interval '1 days'
LIMIT 10
-- Fetch live data directly fron the API
SELECT
livequery.live.udf_api('https://api.llama.fi/protocol/pancakeswap') as response;
SELECT
livequery.live.udf_api('https://api.llama.fi/chains') as response;
***/
--SELECT
--livequery.live.udf_api('https://api.llama.fi/protocol/pancakeswap') as response;
select date, sum(volume) as volume
from external.defillama.fact_dex_volume
where protocol like '%sushi%'
--curve dex
--uniswap v3
and date >= '2024-01-19'
and date <= '2024-02-02'
group by 1
Last run: about 1 year ago
15
556B
2s