flipside

    Overtime (Deposit)
    Afonso_DiazOvertime (Deposit)
    Updated 2025-04-22
    with

    main as (
    select
    tx_id,
    block_timestamp,
    pool_address,
    provider_address as user,
    pool_name,
    platform,
    nvl(token_a_amount_usd, 0) + nvl(token_b_amount_usd, 0) as amount_usd,
    action_type as event_name
    from
    solana.marinade.ez_liquidity_pool_actions
    )

    select
    date_trunc('{{ period }}', block_timestamp) as date,
    pool_name,
    count(distinct tx_id) as transactions,
    count(distinct user) as users,
    sum(amount_usd) as volume_usd,
    avg(amount_usd) as average_amount_usd,
    sum(volume_usd) over (partition by pool_name order by date) as cumulative_volume_usd
    from
    main
    where
    event_name = 'deposit'
    group by 1, 2
    order by 1, 2
    Last run: about 1 month ago
    DATE
    POOL_NAME
    TRANSACTIONS
    USERS
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    CUMULATIVE_VOLUME_USD
    1
    		2021-08-01 00:00:00.000MSOL-SOL349241828930.611201742375.159344417593828930.61120174
    2
    		2021-08-01 00:00:00.000MSOL-USDC2522342077814.513709988245.2956893253182077814.51370998
    3
    		2021-09-01 00:00:00.000MSOL-SOL2332219817967177.191167757704.62143703591318796107.80236949
    4
    		2021-09-01 00:00:00.000MSOL-USDC69968317696309.6681950625316.6089673749119774124.18190504
    5
    		2021-09-01 00:00:00.000ORCA-MSOL9179172698592.947878022942.8494524296842698592.94787802
    6
    		2021-10-01 00:00:00.000MNDE-MSOL8211500225895907.292647933148.0558342630625895907.29264793
    7
    		2021-10-01 00:00:00.000MSOL-ETH177296948627173.6571361527242.11409363369648627173.65713615
    8
    		2021-10-01 00:00:00.000MSOL-RAY219382324251588.3610051811058.63582353177524251588.36100518
    9
    		2021-10-01 00:00:00.000MSOL-SOL85566365143601153.0566128516726.983466116813162397260.85898235
    10
    		2021-10-01 00:00:00.000MSOL-USDC93093407552087265.20418559274.99089587556571861389.38609
    11
    		2021-10-01 00:00:00.000MSOL-USDT70051099433778791.3718152661915.32848584289433778791.37181526
    12
    		2021-10-01 00:00:00.000ORCA-MSOL6714359424343069.560105473616.02340465024827041662.50798349
    13
    		2021-10-01 00:00:00.000SOBTC-MSOL5511133389329143.7229303316197.48752908981389329143.72293033
    14
    		2021-10-01 00:00:00.000SOETH-MSOL198746739348469.9299890619802.95416708055639348469.92998906
    15
    		2021-10-01 00:00:00.000SOL-MSOL2788141667278957.7195440524131.6204159053367278957.71954405
    16
    		2021-11-01 00:00:00.000MNDE-MSOL335618395729375.541654271668.426191512631625282.8343022
    17
    		2021-11-01 00:00:00.000MSOL-ETH511554323592981.985580494539.73099587848672220155.64271665
    18
    		2021-11-01 00:00:00.000MSOL-RAY14402771040389.15075815722.49246580427125291977.51176333
    19
    		2021-11-01 00:00:00.000MSOL-SOL7818213329189518.448665652597.16331067405191586779.307648
    20
    		2021-11-01 00:00:00.000MSOL-USDC662047721158870.253540773184.658376511254593020259.6396308
    ...
    915
    83KB
    6s