MONTH | PLATFORM | SYMBOL_IN | TOKEN_IN | TOTAL_AMOUNT | |
|---|---|---|---|---|---|
1 | 2024-01-01 00:00:00.000 | uniswap-v2 | WETH | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 1739049141.02 |
feyikemiAssignment 3
Updated 2024-02-22
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
›
⌄
-- Identify tokens deposited on uniswap, balancer, and sushiswap in January
-- Where total amount deposited for each token is above $1B
SELECT
date_trunc(month, block_timestamp) month,
platform,
symbol_in,
token_in,
SUM(amount_in_usd) total_amount
FROM ethereum.defi.ez_dex_swaps
WHERE platform IN ('uniswap-v2', 'balancer', 'sushiswap')
--AND month = 1 This includes January of other years
AND block_timestamp::date BETWEEN '2024-01-01' AND '2024-01-30'
AND amount_in_usd IS NOT NULL
GROUP BY 1, 2, 3, 4
HAVING total_amount > 1000000000
ORDER BY 5 DESC
LIMIT 100
Last run: over 1 year ago
1
108B
2s