Pre-Sages Lab (Team 2)WBTC-WETH Pool Liquidity
Updated 2025-03-03
999
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
28
29
30
31
32
33
34
35
36
›
⌄
-- WITH RECURSIVE date_series AS (
-- SELECT
-- TIMESTAMP '{{start_date}}' AS DT
-- UNION
-- ALL
-- SELECT
-- DT + INTERVAL '1 DAY'
-- FROM
-- date_series
-- WHERE
-- DT + INTERVAL '1 DAY' <= CURRENT_TIMESTAMP
-- ),
WITH RECURSIVE date_series AS (
SELECT TIMESTAMP '2024-02-28' AS DT
UNION ALL
SELECT DT + INTERVAL '1 DAY'
FROM date_series
WHERE DT + INTERVAL '1 DAY' <= TIMESTAMP '2025-02-28'
),
main_tokens as (
SELECT
USD_VALUE_NOW,
symbol,
CONTRACT_ADDRESS,
CURRENT_BAL,
decimals,
FROM
ethereum.core.ez_current_balances
WHERE
user_address = lower('0xCBCdF9626bC03E24f779434178A73a0B4bad62eD')
AND USD_VALUE_NOW IS NOT NULL
order by USD_VALUE_NOW desc
LIMIT 2
QueryRunArchived: QueryRun has been archived