h4wkAll Base DLN TXs
Updated 2024-08-18
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 price as (
select hour::date as price_date,
token_address,
symbol,
decimals,
avg(price) as price
from Base.price.ez_prices_hourly
group by 1,2,3,4
)
, ETH_price as (
select hour::date as price_date,
token_address,
symbol,
decimals,
avg(price) as ETH_price
from ethereum.price.ez_prices_hourly
where symbol = 'WETH'
group by 1,2,3,4
)
, base_from_Base as (
select distinct tx_hash
from Base.core.fact_token_transfers t
where 1 = 1
and block_timestamp >= '2023-04-01' and block_timestamp < CURRENT_DATE
and to_address = '0xef4fb24ad0916217251f553c0596f8edc630eb66'
)
, cancelled_tx as (
select tx_hash
FROM Base.core.fact_event_logs
where 1 = 1
and block_timestamp > '2023-04-01'
and topics[0] = '0x7d7d1c5b3eadbe275ceb358e65cd57410b35997187258dbaaae42ab6e1405fd8'
)
, from_Base as (
select block_timestamp::date as date,
'From' as route_type,
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived