N° of Sandwiches | Sandwich PnL [USD] | |
|---|---|---|
1 | 15838 | 306977.062259859 |
MostlyData_Solana Sandwich Analysis - Summary copy
Updated 2025-03-11
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 date_filter as (
select
dateadd(day, -30, current_date()) as start_date, -- defaulting to last 30 days
current_date() as end_date
),
tx_list as(
select
ft.tx_id,
ft.block_id,
ft.block_timestamp,
ft.tx_index
from solana.core.fact_transactions ft
join date_filter df
on ft.block_timestamp between df.start_date and df.end_date
where
ft.succeeded = true
),
price_data as(
select
hour,
token_address,
symbol,
price
from solana.price.ez_prices_hourly ph
join date_filter df
on ph.hour between df.start_date and df.end_date
where
ph.blockchain = 'solana'
),
swap_list as(
select
fs.block_timestamp,
fs.tx_id,
Last run: about 1 month ago
1
26B
536s