DATE | CHAIN | CUMULATIVE_SUPPLY | TVL_USD | |
---|---|---|---|---|
1 | 2024-06-04 00:00:00.000 | Ethereum | 0.001 | 85.918 |
2 | 2024-06-05 00:00:00.000 | Ethereum | 0.00108 | 92.79144 |
3 | 2024-06-06 00:00:00.000 | Ethereum | 0.0011 | 94.5098 |
4 | 2024-06-17 00:00:00.000 | Ethereum | 0.00139999 | 120.28434082 |
5 | 2024-06-28 00:00:00.000 | Ethereum | 0.00139999 | 120.28434082 |
6 | 2024-07-08 00:00:00.000 | Ethereum | 0.17869999 | 15353.54574082 |
7 | 2024-07-11 00:00:00.000 | Ethereum | 0.17930299 | 15405.35429482 |
8 | 2024-07-16 00:00:00.000 | Ethereum | 0.18130299 | 15577.19029482 |
9 | 2024-07-18 00:00:00.000 | Ethereum | 0.18230299 | 15663.10829482 |
10 | 2024-07-24 00:00:00.000 | Ethereum | 0.18210199 | 15645.83877682 |
11 | 2024-07-26 00:00:00.000 | Ethereum | 0.18310199 | 15731.75677682 |
12 | 2024-07-29 00:00:00.000 | Ethereum | 0.18292099 | 15716.20561882 |
13 | 2024-08-02 00:00:00.000 | Ethereum | 0.18312199 | 15733.47513682 |
14 | 2024-08-09 00:00:00.000 | Ethereum | 0.18400199 | 15809.08297682 |
15 | 2024-08-12 00:00:00.000 | Ethereum | 0.18380099 | 15791.81345882 |
16 | 2024-08-15 00:00:00.000 | Ethereum | 0.18460499 | 15860.89153082 |
17 | 2024-08-16 00:00:00.000 | Ethereum | 0.18441899 | 15844.91078282 |
18 | 2024-08-19 00:00:00.000 | Ethereum | 0.18467999 | 15867.33538082 |
19 | 2024-08-20 00:00:00.000 | Ethereum | 0.18597999 | 15979.02878082 |
20 | 2024-08-21 00:00:00.000 | Ethereum | 8.85758708 | 761026.16673944 |
datavortexTvl Per Chain
Updated 2025-03-02
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 events AS (
-- Ethereum Mint
SELECT
'Ethereum' AS chain,
date_trunc('day', block_timestamp) AS date,
decoded_log:value / 1e8 AS minted_amount,
NULL AS burned_amount
FROM ethereum.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0x8236a87084f8B84306f72007F36F2618A5634494')
AND decoded_log:from = '0x0000000000000000000000000000000000000000'
AND event_name = 'Transfer'
UNION ALL
-- Ethereum Burn
SELECT
'Ethereum' AS chain,
date_trunc('day', block_timestamp) AS date,
NULL AS minted_amount,
decoded_log:value / 1e8 AS burned_amount
FROM ethereum.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0x8236a87084f8B84306f72007F36F2618A5634494')
AND decoded_log:to = '0x0000000000000000000000000000000000000000'
AND event_name = 'Transfer'
UNION ALL
-- Base Mint
SELECT
'Base' AS chain,
date_trunc('day', block_timestamp) AS date,
decoded_log:value / 1e8 AS minted_amount,
NULL AS burned_amount
FROM base.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0xecAc9C5F704e954931349Da37F60E39f515c11c1')
Last run: 2 months ago
...
420
27KB
66s