DS | BALANCE | ACTIVE_HOLDERS | CUMULATIVE_HOLDERS | |
|---|---|---|---|---|
1 | 2025-05-14 00:00:00.000 | 103670044.044318 | 233 | 447 |
2 | 2025-05-13 00:00:00.000 | 103719931.544628 | 232 | 446 |
3 | 2025-05-12 00:00:00.000 | 103371976.647552 | 232 | 444 |
4 | 2025-05-11 00:00:00.000 | 83315157.834297 | 234 | 441 |
5 | 2025-05-10 00:00:00.000 | 83494610.8578889 | 231 | 434 |
6 | 2025-05-09 00:00:00.000 | 82110525.3943006 | 230 | 426 |
7 | 2025-05-08 00:00:00.000 | 80874326.5022943 | 228 | 423 |
8 | 2025-05-07 00:00:00.000 | 78674598.6716096 | 232 | 416 |
9 | 2025-05-06 00:00:00.000 | 78106422.1093627 | 227 | 405 |
10 | 2025-05-05 00:00:00.000 | 76847307.382977 | 229 | 401 |
11 | 2025-05-04 00:00:00.000 | 75990107.5246642 | 231 | 394 |
12 | 2025-05-03 00:00:00.000 | 75897409.2907187 | 229 | 387 |
13 | 2025-05-02 00:00:00.000 | 73970700.0154293 | 222 | 376 |
14 | 2025-05-01 00:00:00.000 | 73009905.9442231 | 216 | 367 |
15 | 2025-04-30 00:00:00.000 | 73377442.7054303 | 217 | 364 |
16 | 2025-04-29 00:00:00.000 | 72783176.4903535 | 214 | 359 |
17 | 2025-04-28 00:00:00.000 | 67423054.1761861 | 215 | 357 |
18 | 2025-04-27 00:00:00.000 | 69108882.0024514 | 213 | 353 |
19 | 2025-04-26 00:00:00.000 | 69108829.1532427 | 213 | 352 |
20 | 2025-04-25 00:00:00.000 | 69244868.0223305 | 213 | 352 |
Pendletoken_daily_balance
Updated 2025-05-14
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 token_start_date AS (
SELECT date(min(date_trunc('day', BLOCK_TIMESTAMP))) as first_date
from {{chain}}.core.ez_token_transfers
where CONTRACT_ADDRESS = lower('{{token_contract_address}}')
),
in_flows AS (
SELECT
BLOCK_TIMESTAMP AS evt_block_time,
TO_ADDRESS AS user,
RAW_AMOUNT/1e{{decimals}} as amount
from {{chain}}.core.ez_token_transfers
where CONTRACT_ADDRESS = lower('{{token_contract_address}}') and BLOCK_TIMESTAMP >= (select first_date from token_start_date)
),
our_flows AS (
SELECT
BLOCK_TIMESTAMP AS evt_block_time,
FROM_ADDRESS AS user,
-RAW_AMOUNT/1e{{decimals}} as amount
from {{chain}}.core.ez_token_transfers
where CONTRACT_ADDRESS = lower('{{token_contract_address}}') and BLOCK_TIMESTAMP >= (select first_date from token_start_date)
),
date_series AS (
SELECT DATEADD(DAY, VALUE::INT, first_date::DATE) as "date"
FROM token_start_date, TABLE(FLATTEN(ARRAY_GENERATE_RANGE(0, DATEDIFF('DAY', first_date, current_date)+1)));
),
user_daily AS (
SELECT user,
date_trunc('day', evt_block_time) as ds,
sum(amount) as daily_amount
FROM (
SELECT * FROM in_flows
UNION ALL
SELECT * FROM our_flows
)
GROUP BY 1, 2
),
Last run: 30 days ago
...
145
7KB
9s