zakkisyedTVL on Blast
Updated 2024-06-12
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
›
⌄
WITH daily_sums AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
SUM(value) AS daily_amount
FROM
blast.core.fact_transactions
WHERE
LOWER(to_address) = LOWER('0x1558959f1a032F83f24A14Ff539944A926C51bdf')
AND STATUS = 'SUCCESS'
GROUP BY
DATE_TRUNC('day', block_timestamp)
)
SELECT
date,
daily_amount,
SUM(daily_amount) OVER (ORDER BY date ASC) AS cumulative_sum
FROM
daily_sums
ORDER BY
date DESC;
-- track eth transferred back to mainnet
--select sum(amount) from blast.core.ez_native_transfers
--where from_address = lower('0x3924A9a1706285f5e92486Dc19945e43fb2F98cf')
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived