marquSolana Network Revenue - Transaction Fees and MEV Tips
Updated 2024-11-26
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
jito_tip_txs as (
select
tx_id
, sum(amount) as amount_tip_sol
, sum(amount * price) as amount_tip_usd
from solana.core.fact_transfers
left join solana.price.ez_prices_hourly
on date_trunc('hour', fact_transfers.block_timestamp) = ez_prices_hourly.hour
and ez_prices_hourly.token_address = 'So11111111111111111111111111111111111111112'
where mint in (
'So11111111111111111111111111111111111111111' -- SOL
, 'So11111111111111111111111111111111111111112' -- wSOL
)
and tx_to in ( -- Jito Tip Payment Addresses https://jito-foundation.gitbook.io/mev/mev-payment-and-distribution/on-chain-addresses#mainnet
'96gYZGLnJYVFmbjzopPSU6QiEV5fGqZNyN9nmNhvrZU5'
, 'HFqU5x63VTqvQss8hp11i4wVV8bD44PvwucfZ2bU7gRe'
, 'Cw8CFyM9FkoMi7K7Crf6HNQqf4uEMzpKw6QNghXLvLkY'
, 'ADaUMid9yfUytqMBgopwjb2DTLSokTSzL1zt6iGPaS49'
, 'DfXygSm4jCyNCybVYYK6DwvWqjKee8pbDmJGcLWNDXjh'
, 'ADuUkR4vqLUMWXxW9gh6D6L8pMSawimctcNZ5pGwDcEt'
, 'DttWaMuVvTiduZRnguLF7jNxTgiMBZ1hyAumKUiL2KRL'
, '3AVi9Tg9Uo68tJfuvoKvqKNWKkC5wPdSSdeBnizKZ6jT'
)
and block_timestamp ::date > current_date() - interval '90 days'
group by tx_id
),
non_vote_txs as (
select
QueryRunArchived: QueryRun has been archived