marquSolana Network Revenue - Transaction Fees and MEV Tips
    Updated 2024-11-26
    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