samlazy-teal
Updated 2024-11-16
99
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 raw as (
-- select
-- tx_hash,
-- contract_address,
-- amount
-- from near.core.ez_token_transfers
-- where contract_address in (
-- 'near', '802d89b6e511b335f05024a65161bce7efc3f311.factory.bridge.near'
-- )
-- and block_timestamp::date >= '2024-11-01'
-- )
-- select
-- tx_hash
-- from raw r1
-- inner join raw r2 using(tx_hash)
-- left join near.defi.ez_dex_swaps n1 using (tx_hash)
-- where r1.contract_address = 'near'
-- and r2.contract_address = '802d89b6e511b335f05024a65161bce7efc3f311.factory.bridge.near'
-- and n1.tx_hash is null
-- and n1.block_timestamp::date >= '2024-11-01'
-- limit 10
-- select * from ethereum.nft.ez_mev_arbitrage
-- where miner_tip_usd > 0
-- limit 10;
select * from near.price.ez_prices_hourly
where is_native
limit 10
QueryRunArchived: QueryRun has been archived