marquHealthy DeFi KPIs - Solana: fees_emissions
    Updated 2024-11-26
    with

    jito_tip_txs as (

    select

    tx_id
    , sum(amount) as amount_tip_sol

    from solana.core.fact_transfers
    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 '30 days'
    group by tx_id
    ),

    non_vote_txs as (

    select

    block_timestamp
    , tx_id
    , succeeded
    , array_size(signers) * 5000 / pow(10, 9) as base_fee_sol
    Last run: 3 months ago
    CHAIN
    DATE
    SYMBOL
    TOKEN_CONTRACT
    FEES_TOKEN
    VOTE_FEE_SOL
    BASE_FEE_SOL
    PRIORITY_FEE_SOL
    JITO_TIP_SOL
    1
    Solana2024-12-07 00:00:00.000SOLSo111111111111111111111111111111111111111126063.704686423630.06084232.1269255201.5169214235567.602339685
    2
    Solana2024-12-06 00:00:00.000SOLSo1111111111111111111111111111111111111111218334.4762111171370.0889512.4303516451.95696111717978.773117711
    3
    Solana2024-12-05 00:00:00.000SOLSo1111111111111111111111111111111111111111218688.1908207831354.09928514.2191116819.87243078319190.471552248
    4
    Solana2024-12-04 00:00:00.000SOLSo1111111111111111111111111111111111111111219488.4303118081363.243765516.1295617609.05698680820799.180761192
    5
    Solana2024-12-03 00:00:00.000SOLSo1111111111111111111111111111111111111111221336.7581012131313.615985537.0920519486.05006621323899.46797144
    6
    Solana2024-12-02 00:00:00.000SOLSo1111111111111111111111111111111111111111221420.2682020811337.148045506.2796419576.84051708124451.918312449
    7
    Solana2024-12-01 00:00:00.000SOLSo1111111111111111111111111111111111111111219545.7420238021358.421615511.8604217675.45998880219897.910883358
    8
    Solana2024-11-30 00:00:00.000SOLSo1111111111111111111111111111111111111111219195.0413055311361.773425498.6380117334.62987053119196.993622559
    9
    Solana2024-11-29 00:00:00.000SOLSo1111111111111111111111111111111111111111222958.633081751339.38879504.8166421114.4276517525651.157339707
    10
    Solana2024-11-28 00:00:00.000SOLSo1111111111111111111111111111111111111111226973.2364322821303.647745533.0073925136.58129728229053.427921216
    11
    Solana2024-11-27 00:00:00.000SOLSo1111111111111111111111111111111111111111230361.4845590391280.851275510.3933228570.23996403932427.913588923
    12
    Solana2024-11-26 00:00:00.000SOLSo1111111111111111111111111111111111111111229433.3968893131298.83362498.1762127636.38705931328406.465034255
    13
    Solana2024-11-25 00:00:00.000SOLSo1111111111111111111111111111111111111111231229.5194533031314.491705494.0069929421.02075830331951.938253827
    14
    Solana2024-11-24 00:00:00.000SOLSo1111111111111111111111111111111111111111228947.0434139711302.848615487.7187327156.47606897131502.040385352
    15
    Solana2024-11-23 00:00:00.000SOLSo1111111111111111111111111111111111111111234045.1457353231315.032825459.46964532270.64326532331758.02467895
    16
    Solana2024-11-22 00:00:00.000SOLSo1111111111111111111111111111111111111111242237.0722203281305.82273465.510840465.73869032839312.493382208
    17
    Solana2024-11-21 00:00:00.000SOLSo1111111111111111111111111111111111111111252719.903660371311.120065459.8315250948.9520753750506.570679383
    18
    Solana2024-11-20 00:00:00.000SOLSo1111111111111111111111111111111111111111256311.8644959011295.29277445.7326954570.83903590160636.671864733
    19
    Solana2024-11-19 00:00:00.000SOLSo1111111111111111111111111111111111111111246530.7559296091280.15761441.78506544808.81325460960793.964854472
    20
    Solana2024-11-18 00:00:00.000SOLSo1111111111111111111111111111111111111111249178.1875952861286.509905424.74396547466.93372528650837.903571963
    30
    5KB
    332s