DATE | CHAIN | TVL_USD | |
|---|---|---|---|
1 | 2023-12-01 00:00:00.000 | Polygon zkEVM | 28010076 |
2 | 2023-12-01 00:00:00.000 | Linea | 36113327 |
3 | 2023-12-01 00:00:00.000 | Scroll | 14303931 |
4 | 2023-12-01 00:00:00.000 | Starknet | 34886089 |
5 | 2023-12-02 00:00:00.000 | Polygon zkEVM | 28004155 |
6 | 2023-12-02 00:00:00.000 | Starknet | 34413083 |
7 | 2023-12-02 00:00:00.000 | Scroll | 15031964 |
8 | 2023-12-02 00:00:00.000 | Linea | 36872500 |
9 | 2023-12-03 00:00:00.000 | Starknet | 33341750 |
10 | 2023-12-03 00:00:00.000 | Linea | 39351189 |
11 | 2023-12-03 00:00:00.000 | Scroll | 15867742 |
12 | 2023-12-03 00:00:00.000 | Polygon zkEVM | 28220598 |
13 | 2023-12-04 00:00:00.000 | Starknet | 32434402 |
14 | 2023-12-04 00:00:00.000 | Linea | 41290916 |
15 | 2023-12-04 00:00:00.000 | Polygon zkEVM | 28718567 |
16 | 2023-12-04 00:00:00.000 | Scroll | 15939863 |
17 | 2023-12-05 00:00:00.000 | Polygon zkEVM | 28349642 |
18 | 2023-12-05 00:00:00.000 | Scroll | 16428860 |
19 | 2023-12-05 00:00:00.000 | Starknet | 33279286 |
20 | 2023-12-05 00:00:00.000 | Linea | 42173340 |
mamad-5XN3k32024-01-24 04:35 PM
Updated 2024-01-24
9
1
2
3
4
5
6
7
8
›
⌄
select
date_trunc('day', DATE) as date
,chain
,TVL_USD
from external.defillama.fact_chain_tvl
where chain in ('Linea','Polygon zkEVM','Scroll','Starknet','Zkfair')
and DATE::date >= '2023-12-01'
order by 1 asc
Last run: over 1 year ago
...
255
12KB
1s