flipside

    daily activity
    elsinadaily activity
    Updated 2025-03-28
    SELECT
    date_trunc('day', block_timestamp) as date,
    count(DISTINCT from_address) as user_count,
    count(DISTINCT tx_id) as tx_count,
    count(distinct pool_name) as pool_count,
    sum(from_amount_usd) as total_vol,
    avg(from_amount_usd) as avg_tx_vol,

    sum(total_vol) over (order by date) as cum_total_vol,
    sum(tx_count) over (order by date) as cum_tx_count
    from
    thorchain.defi.fact_swaps
    where
    date >= '2025-01-01'
    group by
    date
    order by
    date asc


    Last run: 17 days ago
    DATE
    USER_COUNT
    TX_COUNT
    POOL_COUNT
    TOTAL_VOL
    AVG_TX_VOL
    CUM_TOTAL_VOL
    CUM_TX_COUNT
    1
    		2025-01-01 00:00:00.0001712107803060115699.0920573018.61406437660115699.09205710780
    2
    		2025-01-02 00:00:00.0002035151513072645295.36485182668.722507066132760994.45690925931
    3
    		2025-01-03 00:00:00.0002310146863181509331.97059472921.690872844214270326.42750440617
    4
    		2025-01-04 00:00:00.0002246122943081738096.20581453229.223143403296008422.63331852911
    5
    		2025-01-05 00:00:00.0001994124562865349100.12921182723.560062066361357522.7625365367
    6
    		2025-01-06 00:00:00.00023782054430113046911.8408562433.104727322474404434.60338685911
    7
    		2025-01-07 00:00:00.00023091882929113518733.7845423092.816417408587923168.387928104740
    8
    		2025-01-08 00:00:00.00021142304529124994884.2383493085.531578335712918052.626277127785
    9
    		2025-01-09 00:00:00.00024283147133218437726.9348863512.481740097931355779.561162159256
    10
    		2025-01-10 00:00:00.00024183824332225325286.3675023484.6631153921156681065.92866197499
    11
    		2025-01-11 00:00:00.00019071948532104651003.5676443055.0577599661261332069.49631216984
    12
    		2025-01-12 00:00:00.0001836159803177219291.83092942415.5183881051338551361.32724232964
    13
    		2025-01-13 00:00:00.00021673368533168833576.1197742842.9382881741507384937.44701266649
    14
    		2025-01-14 00:00:00.00024102342433125455516.628972927.0319551331632840454.07598290073
    15
    		2025-01-15 00:00:00.00025292718135174457777.370713197.5399078211807298231.44669317254
    16
    		2025-01-16 00:00:00.00026952934334175969122.691892788.2038707681983267354.13858346597
    17
    		2025-01-17 00:00:00.00031373713434244698463.6853812913.4584729592227965817.82396383731
    18
    		2025-01-18 00:00:00.00031773024835170970238.936352600.6638009212398936056.76031413979
    19
    		2025-01-19 00:00:00.00044534120234208259693.2646322258.8064215952607195750.02495455181
    20
    		2025-01-20 00:00:00.00038165049733218913989.9323441506.9767389182826109739.95729505678
    87
    8KB
    10s