BlockTrackerTVL Over Time
Updated 2023-11-20
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 global pools overview @ https://flipsidecrypto.xyz/edit/queries/a6e50735-8cfd-4119-9180-2cf42ee049a3
/*
with gp as ( SELECT * FROM
( values
('GXWqPpjQpdz7KZw9p7f5PX2eGxHAhvpNXiviFkAB8zXg', 'usdc'),
('DfYCNezifxAEsQbAJ1b3j6PX3JVBe8fu11KBhxsbw5d2', 'sol'),
('5p8B6KhJjesV212heBu1o86W2vUSnW1P83ZNnMLtCAAx', 'msol'),
('3Zaz6vATY8br9WceXWD1Xa7fcyCpKSNanWFDRTEjjPqb', 'wbtc'),
('7vj6xtMi62a65yLNhe2APCib7baQsCqsu1y45G93xrdP', 'weth'),
('8A99Z4mV5uoicHbiBsaMhYvJtmwPygtVXpNvtPrh7usS', 'usdt'),
('2AG6YN9Wi7JDrFcLNhaEP2NrXyZKFj7EjMPdkvwPdRR1', 'jitosol')
) as a(account,symbol))
,
*/
--JCNCMFXo5M5qwUPg2Utu1u6YWp3MbygxqBsBeXXJfrw
with gp as ( SELECT * FROM
( values
('JCNCMFXo5M5qwUPg2Utu1u6YWp3MbygxqBsBeXXJfrw')
) as a(account))
,
tokens_price as (
SELECT
date_trunc('d',RECORDED_HOUR) as date,
symbol,
token_address,
median(close) as usd_price
FROM solana.price.ez_token_prices_hourly a
WHERE date >= dateadd('month', -24, current_date)
GROUP BY 1 , 2 , 3
)
,
final as (
SELECT
'deposit' as type,
Run a query to Download Data