saeedmzn[Orca DEX] - Overtime
    Updated 4 days ago
    with swap_txns as (
    select
    tx_id,
    signers [0] trader,
    block_timestamp :: date date,
    from
    eclipse.core.fact_events
    where
    program_id = 'whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc'
    and SUCCEEDED = true
    ),
    indexes as (
    select
    tx_id,
    CAST(index || '.' || inner_index AS FLOAT) combined_index
    from
    swap_txns
    left join eclipse.core.fact_transfers using (tx_id)
    ),
    min_max_index as (
    select
    tx_id,
    min (combined_index) min_index,
    max (combined_index) max_index
    from
    indexes
    group by 1
    ),
    swap_from as (
    select
    tx_id,
    trader,
    date,
    mint from_token,
    CAST(index || '.' || inner_index AS FLOAT) combined_index,
    max (amount / pow(10, DECIMAL)) from_amount
    Last run: 4 days ago
    DATE
    NUM_TRADES
    CUM_TRADES
    NUM_TRADERS
    TRADED_VOLUME
    CUM_TRADED_VOLUME
    AVG_TRADED_VOLUME
    MEDIAN_TRADED_VOLUME
    AVG_TRADES_PER_TRADER
    1
    2024-12-15 00:00:00.0001680730071935662306899.4005208958555156.5978922137.4954941322.067541424.713124
    2
    2024-12-07 00:00:00.000751820334617181184023.8813596443274959.9199349157.72264304859.5528577794.376019
    3
    2024-12-12 00:00:00.0001049825898426301841412.1370520451966668.6154345175.94230241351.6325757553.991635
    4
    2024-10-30 00:00:00.0001735197465770126.81881502377212.73762812540.4655619247.9906652.640791
    5
    2024-12-26 00:00:00.0003221652164962367801770.50163295102866999.624979242.50188056826.949965.166132
    6
    2025-01-03 00:00:00.00041575869955113494284753.89805449148999749.07666103.29935384313.3012257913.663318
    7
    2024-12-10 00:00:00.0001601823491916742443547.0719078548552495.1982626152.8841313844.1276679.568698
    8
    2024-11-22 00:00:00.000479210651910961865468.8645272421328521.5839549389.93914392367.0259344.372263
    9
    2025-01-01 00:00:00.0003182179015288813997775.3392444140712373.523091125.92608244126.5184078183.583042
    10
    2024-12-01 00:00:00.00049921605531359809813.31478421634508370.8294999162.25472145539.3946202923.673289
    11
    2024-11-18 00:00:00.00063378566619601587569.6492964214663634.3785943251.91520934634.2837553.233163
    12
    2024-11-15 00:00:00.0003789697231080897734.14925553510449917.9498197237.99950934734.5055462513.508333
    13
    2024-11-05 00:00:00.0003693237941203131832.456756829778639.00023936436.0493455724.6767773.069825
    14
    2024-12-21 00:00:00.0001954039222144962634306.0055046675293978.6915642135.09261566734.5924.346085
    15
    2024-12-11 00:00:00.0001356724848625651572761.2801198250125256.4783825116.19099291721.0390117115.289279
    16
    2024-11-24 00:00:00.000528911626611781751925.3674812223895955.3846259331.6784111177.4039283024.489813
    17
    2024-12-03 00:00:00.000710017376612781512471.9572869637295194.3405738213.114267618115.6640460715.555556
    18
    2024-12-08 00:00:00.000638120972717801116112.2488971144391072.168832175.24136424843.867453.584831
    19
    2024-12-06 00:00:00.000728219582816491298795.3596334742090936.0385752178.55311515466.184914.41601
    20
    2024-11-19 00:00:00.00051319079712392437248.9733304817100883.3519248475.93223458946.1619357244.141243
    69
    8KB
    8s