DDATE | CHAIN | VOLUME | |
|---|---|---|---|
1 | 2025-01-14 00:00:00.000 | arbitrum | 1.45 |
2 | 2025-01-14 00:00:00.000 | base | 4.66 |
3 | 2025-01-14 00:00:00.000 | optimism | 8.1 |
4 | 2025-01-15 00:00:00.000 | arbitrum | 6394.326878 |
5 | 2025-01-15 00:00:00.000 | base | 6675.087736 |
6 | 2025-01-15 00:00:00.000 | optimism | 6630.732527 |
7 | 2025-01-16 00:00:00.000 | arbitrum | 47635.802664 |
8 | 2025-01-16 00:00:00.000 | base | 36028.731218 |
9 | 2025-01-16 00:00:00.000 | optimism | 48884.334839 |
10 | 2025-01-17 00:00:00.000 | arbitrum | 20218.455814 |
11 | 2025-01-17 00:00:00.000 | base | 12939.413393 |
12 | 2025-01-17 00:00:00.000 | optimism | 19525.318119 |
13 | 2025-01-18 00:00:00.000 | arbitrum | 21428.025611 |
14 | 2025-01-18 00:00:00.000 | base | 17277.741319 |
15 | 2025-01-18 00:00:00.000 | optimism | 20439.866157 |
16 | 2025-01-19 00:00:00.000 | arbitrum | 46532.777488 |
17 | 2025-01-19 00:00:00.000 | base | 34639.790015 |
18 | 2025-01-19 00:00:00.000 | optimism | 64333.862098 |
19 | 2025-01-20 00:00:00.000 | arbitrum | 88451.328116 |
20 | 2025-01-20 00:00:00.000 | base | 33120.935925 |
TheLaughingManbase volumes
Updated 8 days 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 router_addresses as (
SELECT * from (
values
('0x99bc55df1eb02db64ff20fe457c996b2d53bff7e'), --V1
('0x2e480b1096e5f705cc3e049685846ed3022aa226') --V1.5
) as a (address)
)
, op_data as (
SELECT
'optimism' as chain
, block_timestamp
, tx_hash
, from_address
, to_address
, symbol
, amount
, amount_usd
from optimism.core.ez_token_transfers
WHERE 1=1
AND to_address IN (SELECT * from router_addresses)
AND contract_address in (
'0x0b2c639c533813f4aa9d7837caf62653d097ff85', -- USDC
'0x94b008aa00579c1307b0ef2c499ad98a8ce58e58', -- USDT
'0x7f5c764cbc14f9669b88837ca1490cca17c31607' -- USDC.e
)
)
, base_data as (
SELECT
'base' as chain
, block_timestamp
, tx_hash
, from_address
, to_address
, symbol
Last run: 8 days ago
...
366
18KB
16s