flipside

    Daily Revenue
    ArioDaily Revenue
    Updated 2025-03-18
    with change as (
    select
    date_trunc(day, block_timestamp) as date,
    sum(BALANCE - PRE_BALANCE) as Daily_change
    from solana.core.fact_sol_balances
    where owner in ('CebN5WGQ4jvEPvsVU4EoHEpgzq1VV7AbicfhtW4xC9iM', '62qc2CNXwrYqQScmEdiZFFAnJR262PxWEuNQtxfafNgV')
    and (BALANCE - PRE_BALANCE) > 0
    and SUCCEEDED
    and block_timestamp > current_date - 180
    group by 1
    )
    ,
    price as (
    select
    date_trunc(day, hour) as date,
    avg(price) as avg_price
    from solana.price.ez_prices_hourly
    where token_address = 'So11111111111111111111111111111111111111112'
    and hour > current_date - 180
    group by 1
    )
    select
    date,
    Daily_change as Revenue,
    avg(Revenue) over(order by date rows between 29 preceding and current row) as "30D MA $SOL",
    sum(Revenue) over(order by date) as "Cum Revenue $SOL",
    Revenue * avg_price as Revenue_USD,
    avg(Revenue_USD) over(order by date rows between 29 preceding and current row) as "30D MA USD",
    sum(Revenue_USD) over(order by date) as "Cum Revenue USD"
    from change a join price using(date)
    where date > current_date - 180
    and date < current_date
    order by date desc
    Last run: 15 days ago
    DATE
    REVENUE
    30D MA $SOL
    Cum Revenue $SOL
    REVENUE_USD
    30D MA USD
    Cum Revenue USD
    1
    		2025-03-17 00:00:00.00093023.57250820812270.0132769782510417.973510411937404.98140331864835.8058303469805128.285211
    2
    		2025-03-16 00:00:00.0005539.8592656479543.6334592842417394.40100219731386.069898881532581.07072786457867723.303807
    3
    		2025-03-15 00:00:00.0006017.2430670549761.7145290112411854.54173654807784.7955366661578829.71793087457136337.233908
    4
    		2025-03-14 00:00:00.0007058.89792469110025.5377655612405837.29866949903159.5185969951633344.03889924456328552.438372
    5
    		2025-03-13 00:00:00.0006932.89231460411075.7493120812398778.4007448863667.9487969231828675.52391742455425392.919775
    6
    		2025-03-12 00:00:00.0007214.07317176111381.7849696982391845.5084302899796.3173946431894082.28946533454561724.970978
    7
    		2025-03-11 00:00:00.00021047.83715676811680.0259075812384631.435258432587059.824395541958561.50223523453661928.653583
    8
    		2025-03-10 00:00:00.0006910.61411746111433.325913022363583.59810167862764.2577620661952100.05979624451074868.829188
    9
    		2025-03-09 00:00:00.0006252.36734766211600.8016068492356672.98398421841784.8726994121993107.75579769450212104.571426
    10
    		2025-03-08 00:00:00.0006309.68957735111868.0096276062350420.61663654873473.9895286142048456.76453439449370319.698726
    11
    		2025-03-07 00:00:00.0009103.38565340212107.6984281582344110.927059191304913.437254842098258.56537672448496845.709198
    12
    		2025-03-06 00:00:00.0009538.62501954312290.8580419212335007.541405791406768.341163482140096.46524256447191932.271943
    13
    		2025-03-05 00:00:00.0009371.18400695112452.3059390472325468.916386251449656.887085092177275.89762431445785163.930779
    14
    		2025-03-04 00:00:00.0007640.15272125713231.2635918392316097.73237931339837.173825172320338.27906377444335507.043694
    15
    		2025-03-03 00:00:00.0008138.14999320513402.0190287092308457.579658041427169.885848462350283.29329285442995669.869869
    16
    		2025-03-02 00:00:00.0008924.34895602113633.0294753162300319.429664831565043.9094232390795.09916876441568499.984021
    17
    		2025-03-01 00:00:00.0006452.98744976713949.3855087352291395.080708811131646.549861462446273.77730557440003456.074598
    18
    		2025-02-28 00:00:00.0007442.35176777914376.9829141582284942.093259051305149.245434612521260.61593555438871809.524736
    19
    		2025-02-27 00:00:00.0008570.81572846914673.8310517322277499.741491271503045.546597262573318.23627559437566660.279301
    20
    		2025-02-26 00:00:00.0007745.77952880815741.3470501632268928.92576281358360.720208682760526.22419581436063614.732704
    ...
    179
    22KB
    412s