DAY | DAILY_BSOL_TVL | BSOL_TVL_USD | DAILY_CHANGE_SOL | DAILY_CHANGE_USD | |
|---|---|---|---|---|---|
1 | 2022-01-01 00:00:00.000 | 0 | 0 | ||
2 | 2022-01-02 00:00:00.000 | 0 | 0 | 0 | 0 |
3 | 2022-01-03 00:00:00.000 | 0 | 0 | 0 | 0 |
4 | 2022-01-04 00:00:00.000 | 0 | 0 | 0 | 0 |
5 | 2022-01-05 00:00:00.000 | 0 | 0 | 0 | 0 |
6 | 2022-01-06 00:00:00.000 | 0 | 0 | 0 | 0 |
7 | 2022-01-07 00:00:00.000 | 0 | 0 | 0 | 0 |
8 | 2022-01-08 00:00:00.000 | 0 | 0 | 0 | 0 |
9 | 2022-01-09 00:00:00.000 | 0 | 0 | 0 | 0 |
10 | 2022-01-10 00:00:00.000 | 0 | 0 | 0 | 0 |
11 | 2022-01-11 00:00:00.000 | 0 | 0 | 0 | 0 |
12 | 2022-01-12 00:00:00.000 | 0 | 0 | 0 | 0 |
13 | 2022-01-13 00:00:00.000 | 0 | 0 | 0 | 0 |
14 | 2022-01-14 00:00:00.000 | 0 | 0 | 0 | 0 |
15 | 2022-01-15 00:00:00.000 | 0 | 0 | 0 | 0 |
16 | 2022-01-16 00:00:00.000 | 0 | 0 | 0 | 0 |
17 | 2022-01-17 00:00:00.000 | 0 | 0 | 0 | 0 |
18 | 2022-01-18 00:00:00.000 | 0 | 0 | 0 | 0 |
19 | 2022-01-19 00:00:00.000 | 0 | 0 | 0 | 0 |
20 | 2022-01-20 00:00:00.000 | 0 | 0 | 0 | 0 |
permarydaily tvl
Updated 2025-04-27
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
›
⌄
WITH tvl_base AS (
-- Paste full TVL base query here if needed or reuse from above
-- To keep this standalone, we re-run the full logic:
WITH bsol_accounts AS (
SELECT DISTINCT stake_account
FROM solana.gov.ez_staking_lp_actions
WHERE stake_authority = '6WecYymEARvjG5ZyqkrVQ6YkhPfujNzWpSPwNKXHCbV2'
OR withdraw_authority = '6WecYymEARvjG5ZyqkrVQ6YkhPfujNzWpSPwNKXHCbV2'
),
raw_daily_snapshots AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
stake_account,
post_tx_staked_balance,
stake_active,
ROW_NUMBER() OVER (
PARTITION BY DATE_TRUNC('day', block_timestamp), stake_account
ORDER BY block_timestamp DESC
) AS rn
FROM solana.gov.ez_staking_lp_actions
WHERE succeeded = TRUE
AND stake_account IN (SELECT stake_account FROM bsol_accounts)
),
latest_snapshots_per_day AS (
SELECT *
FROM raw_daily_snapshots
WHERE rn = 1
),
all_dates AS (
SELECT DISTINCT DATE_TRUNC('day', date_day) AS day
FROM crosschain.core.dim_dates
WHERE date_day BETWEEN '2022-01-01' AND CURRENT_DATE
),
filled_data AS (
SELECT
d.day,
Last run: about 2 months ago
...
1213
98KB
48s