DDATE | CHAIN | TOKEN_ADDRESS | SYMBOL | AMOUNT | AMOUNT_USD | LATEST_TVL_AMOUNT | LATEST_TVL_USD | |
|---|---|---|---|---|---|---|---|---|
1 | 2025-07-03 00:00:00.000 | arbitrum | 0x912ce59144191c1204e64559fe8253a0e49e6548 | ARB | 0 | 0 | 249226.229325487 | 88471.35199792 |
2 | 2025-07-03 00:00:00.000 | arbitrum | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | USDC | -94012.510435 | -93986.280944589 | 4176814.82260699 | 4175649.49127151 |
3 | 2025-07-03 00:00:00.000 | arbitrum | 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 | USDT | 0 | 0 | 121843.087170998 | 121843.087170998 |
4 | 2025-07-03 00:00:00.000 | arbitrum | 0x95146881b86b3ee99e63705ec87afe29fcc044d9 | VRTX | -685.556419565 | -9.330283965 | 24656106.4573764 | 335564.613154995 |
5 | 2025-07-03 00:00:00.000 | arbitrum | 0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f | WBTC | 0.88967049 | 96973.19373951 | 330.43048327 | 36016592.2459466 |
6 | 2025-07-03 00:00:00.000 | arbitrum | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | WETH | 0 | 0 | 1372.911034156 | 3544471.87510111 |
7 | 2025-07-03 00:00:00.000 | arbitrum | 0x5979d7b546e38e414f7e9822514be443a4800529 | wstETH | 0 | 0 | 212.435580102 | 661632.738583902 |
8 | 2025-07-03 00:00:00.000 | base | 0xbc45647ea894030a4e9801ec03479739fa2485f0 | BENJI | 0 | 0 | 3353995.29343775 | 48483.463272 |
9 | 2025-07-03 00:00:00.000 | base | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | USDC | 0 | 0 | 359138.904208 | 359076.773177572 |
10 | 2025-07-03 00:00:00.000 | base | 0x4300000000000000000000000000000000000006 | WETH | 0 | 0 | 99.754975116 | 257374.818647772 |
11 | 2025-07-03 00:00:00.000 | blitz | 0xb1a5700fa2358173fe465e6ea4ff52e36e88e2ad | BLAST | 0 | 0 | 22597446.3870497 | |
12 | 2025-07-03 00:00:00.000 | blitz | 0x4300000000000000000000000000000000000004 | ETH | 0 | 0 | 5292.904840808 | |
13 | 2025-07-03 00:00:00.000 | blitz | 0x4300000000000000000000000000000000000003 | USDB | 0 | 0 | 2528647.85218549 | |
14 | 2025-07-03 00:00:00.000 | mantle | 0xcda86a272531e8640cd7f1a92c01839911b90bb0 | METH | 0 | 0 | 269.139393484 | 743174.607228729 |
15 | 2025-07-03 00:00:00.000 | mantle | 0x09bc4e0d864854c6afb6eb9a9cdf58ac190d0df9 | USDC | 0 | 0 | 936101.030702 | 938909.333794105 |
16 | 2025-07-03 00:00:00.000 | mantle | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead1111 | WETH | 0 | 0 | 72.532111306 | 187328.683869868 |
17 | 2025-07-03 00:00:00.000 | mantle | 0x78c1b0c915c4faa5fffa6cabf0219da63d7f4cb8 | wMNT | 0 | 0 | 10455.387183088 | 6130.385746748 |
18 | 2025-07-03 00:00:00.000 | sei | 0x3894085ef7ff0f0aedf52e2a2704928d1ec074f1 | USDC | 0 | 0 | 1503858.955649 | |
19 | 2025-07-03 00:00:00.000 | sei | 0xe30fedd158a2e3b13e9badaeabafc5516e95e8c7 | WSEI | 0 | 0 | 187727.895023558 | |
20 | 2025-07-02 00:00:00.000 | arbitrum | 0x912ce59144191c1204e64559fe8253a0e49e6548 | ARB | 0 | 0 | 249226.229325487 | 88471.35199792 |
TheLaughingMan[BASE] VERTEX - TVL Query (ALL INSTANCES)
Updated 20 hours 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 arb_data as (
SELECT
'arbitrum' as chain
, block_timestamp::date as ddate
, token_address
, symbol
, SUM(amount) as amount
, SUM(amount * price) as amount_usd --override to latest prices
from arbitrum.vertex.ez_clearing_house_events t --token_address
LEFT JOIN (
SELECT
token_address
, price
from arbitrum.price.ez_prices_hourly
WHERE 1=1
AND hour> CURRENT_DATE - 1
qualify row_number() OVER (partition by token_address ORDER BY HOUR DESC) = 1
) p using (token_address)
where 1=1
AND modification_type IN ('deposit', 'withdraw')
GROUP by 1, 2, 3, 4
)
, base_data as (
SELECT
'base' as chain
, block_timestamp::date as ddate
, t.token_address
, symbol
, SUM(amount) as amount
, SUM(amount * price) as amount_usd --override to latest prices
from base.vertex.ez_clearing_house_events t --token_address
LEFT JOIN (
SELECT
token_address
, price
Last run: about 20 hours agoAuto-refreshes every 24 hours
...
16150
2MB
13s