DAY | PRIME_TVL | USD_TVL | |
|---|---|---|---|
1 | 2024-12-15 00:00:00.000 | 21780117 | 315158292.99 |
2 | 2025-03-06 00:00:00.000 | 23671825 | 99658383.25 |
3 | 2024-07-17 00:00:00.000 | 18159346 | 163434114 |
4 | 2025-01-23 00:00:00.000 | 23031130 | 254724297.8 |
5 | 2024-12-09 00:00:00.000 | 21795983 | 299040886.76 |
6 | 2024-10-15 00:00:00.000 | 19005469 | 157175228.63 |
7 | 2025-02-14 00:00:00.000 | 23250410 | 161357845.4 |
8 | 2024-11-27 00:00:00.000 | 21821852 | 264262627.72 |
9 | 2024-07-24 00:00:00.000 | 18385096 | 136233561.36 |
10 | 2025-01-12 00:00:00.000 | 22755495 | 299917424.1 |
11 | 2024-06-21 00:00:00.000 | 16525367 | 174342621.85 |
12 | 2024-08-16 00:00:00.000 | 18842259 | 112676708.82 |
13 | 2024-11-17 00:00:00.000 | 21758247 | 181246197.51 |
14 | 2024-08-31 00:00:00.000 | 18793704 | 135690542.88 |
15 | 2025-03-08 00:00:00.000 | 23565285 | 93789834.3 |
16 | 2024-12-06 00:00:00.000 | 21849152 | 359200058.88 |
17 | 2025-02-25 00:00:00.000 | 23583906 | 107542611.36 |
18 | 2024-07-06 00:00:00.000 | 17631678 | 136998138.06 |
19 | 2024-06-15 00:00:00.000 | 12167831 | 124841946.06 |
20 | 2024-08-06 00:00:00.000 | 18612580 | 110186473.6 |
freemartianDaily TVL
Updated 1 day ago
999
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
prices AS(
-- the last price of a day
SELECT
hour AS price_day,
price,
ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('DAY', hour) ORDER BY hour DESC) AS row_num
FROM ethereum.price.ez_prices_hourly
WHERE token_address = '0xb23d80f5fefcddaa212212f028021b41ded428cf'
AND hour::date >= '2024-06-01'
qualify row_num = 1
ORDER BY 1 ASC
),
eth_deposits AS (
SELECT
block_timestamp,
tx_hash,
decoded_log:user AS user,
decoded_log:amount / pow(10,18) AS amount,
-- price * (decoded_log:amount / pow(10,18)) AS amount_usd,
'Deposit' AS label
FROM ethereum.core.ez_decoded_event_logs
-- INNER JOIN prices ON (block_timestamp::date = price_day)
WHERE contract_address = '0x4a3826bd2e8a31956ad0397a49efde5e0d825238'
AND event_name = 'DepositCreated'
AND block_timestamp::date >= '2024-06-01'
),
eth_withdraws AS (
SELECT
block_timestamp,
tx_hash,
decoded_log:user AS user,
Last run: 1 day ago
...
317
15KB
43s