TOTAL_VOLUME | |
|---|---|
1 | 11481557.635366 |
TheLaughingMantotals
Updated 9 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
›
⌄
-- forked from base volumes @ https://flipsidecrypto.xyz/studio/queries/907cad5b-533d-4d8e-85d3-125493710c43
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
Last run: 9 days ago
1
19B
17s