0x9C8e4C5e889Db770cA4B9DF30BD13c106fb907c5select mevs
Updated 2024-10-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with all_swaps as
(
select *
from solana.defi.fact_swaps
where (swap_to_mint = 'H8yTNoEFiPa9WBKWHxBUC9gRCYufdmcwafjccKLupump' or swap_from_mint = 'H8yTNoEFiPa9WBKWHxBUC9gRCYufdmcwafjccKLupump')
and block_timestamp BETWEEN '2024-10-17 05:25:00' and '2024-10-17 05:27:00'
order by block_timestamp;
)
select block_id, swapper, count(*)
from all_swaps
group by block_id, swapper
having sum(case when swap_from_mint = 'So11111111111111111111111111111111111111112' then 1 else 0 end) > 0 and
sum(case when swap_to_mint = 'So11111111111111111111111111111111111111112' then 1 else 0 end) > 0
order by block_id
QueryRunArchived: QueryRun has been archived