flipside

    daily activity
    elsinadaily activity
    Updated 9 days ago
    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: 9 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.0001712107803060011185.99300763013.36610559960011185.993007610780
    2
    		2025-01-02 00:00:00.0002035151513072538385.78575972664.795040071132549571.77876725931
    3
    		2025-01-03 00:00:00.0002310146863181395733.07266382917.618935861213945304.85143140617
    4
    		2025-01-04 00:00:00.0002246122943081625864.23643573224.789200238295571169.08786752911
    5
    		2025-01-05 00:00:00.0001994124562865255359.2118332719.653213796360826528.299765367
    6
    		2025-01-06 00:00:00.00023782054430112899504.5506192429.932085373473726032.85031985911
    7
    		2025-01-07 00:00:00.00023091882929113366959.824043088.681337839587092992.674359104740
    8
    		2025-01-08 00:00:00.00021142304529124818432.2064513081.175813539711911424.88081127785
    9
    		2025-01-09 00:00:00.00024283147133216295383.569233478.032828462928206808.450041159256
    10
    		2025-01-10 00:00:00.00024183824332220442558.2322613409.1515609211148649366.6823197499
    11
    		2025-01-11 00:00:00.00019071948532102355321.1088972988.0403184611251004687.7912216984
    12
    		2025-01-12 00:00:00.0001836159803175506000.06141992361.9244263461326510687.85262232964
    13
    		2025-01-13 00:00:00.00021673368533165135741.8825082780.6715591381491646429.73513266649
    14
    		2025-01-14 00:00:00.00024102342433122559843.239082859.4723230691614206272.97421290073
    15
    		2025-01-15 00:00:00.00025292718135170493014.788373124.8719719281784699287.76258317254
    16
    		2025-01-16 00:00:00.00026952934334172004293.3122832725.3817548531956703581.07486346597
    17
    		2025-01-17 00:00:00.00031373713434239550899.1200192852.1699165372196254480.19488383731
    18
    		2025-01-18 00:00:00.00031773024835167410861.7200262546.5213750942363665341.9149413979
    19
    		2025-01-19 00:00:00.00044534120234203814864.5033992210.5973438262567480206.4183455181
    20
    		2025-01-20 00:00:00.00038165049733214280351.886621475.0793496572781760558.30492505678
    ...
    135
    13KB
    7s