dayvidjoshUni TVL copy
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
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from jp12 / Uni TVL @ https://flipsidecrypto.xyz/jp12/q/fjU9HAAb5P99/uni-tvl
WITH pools_tvl as (
SELECT date_trunc('week', block_timestamp) as week, pool_name, pool_address,
avg(TOKEN0_BALANCE_USD + TOKEN1_BALANCE_USD) as avg_TVL,
min(TOKEN0_BALANCE_USD + TOKEN1_BALANCE_USD) as min_TVL,
max(TOKEN0_BALANCE_USD + TOKEN1_BALANCE_USD) as max_TVL
-- ,row_number() over (order by date_trunc('week', block_timestamp) desc) as rn
FROM uniswapv3.pool_stats
WHERE TOKEN0_BALANCE_USD IS NOT NULL and TOKEN1_BALANCE_USD IS NOT NULL --and POOL_ADDRESS = '0x917c52869df752d784ec73fa0881898f9bfd0fd8'
GROUP BY 1, 2, 3
)
-- WHERE pool_address = '0xbd5fdda17bc27bb90e37df7a838b1bfc0dc997f5' and block_timestamp > CURRENT_DATE - 2
-- LIMIT 1000
-- , week_tvl as (
SELECT week, sum(avg_TVL) as avg_TVL, sum(min_TVL) as min_TVL, sum(max_TVL) as max_TVL
FROM pools_tvl
-- WHERE avg_TVL > 1000000
GROUP BY 1
-- LIMIT 500
-- )
-- SELECT *
-- FROM pools_tvl
-- WHERE avg_TVL >= 3000000000
-- 0x917c52869df752d784ec73fa0881898f9bfd0fd8
-- BORING-WETH 3000 60
-- SELECT *
-- FROM week_tvl
-- WHERE rn >= 2
-- SELECT *
-- FROM uniswapv3.pool_stats
Run a query to Download Data