MostlyData_Solana MEV program data
Updated 2024-10-31
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 transfer_list as(
select
tx_id,
tx_to,
tx_from,
mint,
amount,
floor(index) as index_test,
index
from solana.core.fact_transfers
where
block_timestamp >= current_date() - interval '{{days}} days'
and block_timestamp < current_date()
),
ordered_transfers as(
select
tx_id,
tx_to,
tx_from,
mint,
amount,
index_test,
row_number() over (partition BY tx_id ORDER BY index_test asc,
(index - index_test) * power(10, len(cast(index as varchar)) - len(cast(index_test as varchar))) asc) AS row_number_asc,
row_number() over (partition BY tx_id ORDER BY index_test desc,
(index - index_test) * power(10, len(cast(index as varchar)) - len(cast(index_test as varchar))) desc) AS row_number_desc
from transfer_list
),
transaction_list_all as(
select
QueryRunArchived: QueryRun has been archived