flipside

    Over Time
    0xHaM-dOver Time
    Updated 2025-03-27
    with priceTB as (
    select
    HOUR::date as p_date,
    SYMBOL,
    avg(PRICE) as price
    from ronin.price.ez_prices_hourly
    group by 1,2
    )
    , swap_from as (
    SELECT
    BLOCK_TIMESTAMP,
    'Swap From' as swap_type,
    TX_HASH,
    ORIGIN_FROM_ADDRESS as trader,
    t.SYMBOL as SYMBOL_in,
    AMOUNT_USD,
    AMOUNT*price as AMOUNT_USD_IN
    FROM ronin.core.ez_token_transfers t
    LEFT JOIN priceTB p on t.SYMBOL=p.SYMBOL and trunc(t.BLOCK_TIMESTAMP, 'd')=p.p_date
    where ORIGIN_TO_ADDRESS in (
    '0x30a6a80fed6d0d6c7412b82ef0ad03343f76b45f'
    ,'0xa35a88753a6a32fde5738c26644a383d29684b03'
    ,'0x41c7778f7472c0f3177732a1d71c3f0613074401'
    ,'0xa650570c41ee2f8448a40e2b45c92f5d2ba13d2f'
    ,'0xc99a6a985ed2cac1ef41640596c5a5f9f4e19ef5'
    ,'0x69e2099fbc9020f8dd29c2d959ca15e5d529f041'
    ,'0xca11bde05977b3631167028862be2a173976ca11'
    ,'0x77f96cf7b98b963fb8a9b84787806d396d953b2b'
    ,'0x8417ac6838be147ab0e201496b2e5edf90a48cc5'
    ,'0xf8cdefa80fa07e0f38dad87cb8c2679d3e00b227'
    ,'0x3bf61bac291e999813332340947942b74ab0dd92'
    ,'0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3'
    ,'0x9d381565d0bfe916360a7e92f1cb686fb67f8902'
    ,'0x133fa77dea36b311292201efddfc58cbe3a140b7'
    ,'0x3f85806aebb32c7404b4fb606413434cd830d7e1'
    ,'0x53085f09d0ae92d20c175ccc3c7a6545eeaccabb'
    Last run: 27 days ago
    DATE
    N_TRADES
    N_TRADERS
    N_PAIRS
    VOLUME_IN
    VOLUME_OUT
    AVG_VOL_PER_TRADER
    FEE_AMOUNT_USD
    AVG_FEE_PER_SWAP_USD
    TOTAL_N_TRADES
    TOTAL_VOLUME
    TOTAL_FEE_AMOUNT_USD
    1
    		2025-03-27 00:00:00.00042902334150336078.32784889257651.050575987143.992428384167.9739163910.039154759072059268478470777.408904345542.375077929
    2
    		2025-03-26 00:00:00.0002005690153292780044.443174992348458.47623311308.379860585362.9859389980.018098620812054978478134699.081055345374.401161538
    3
    		2025-03-25 00:00:00.0001930894093401465125.447143051021932.57654631155.715320134815.7407446870.042248847352034922475354654.63788345011.415222539
    4
    		2025-03-24 00:00:00.0001999589304012275331.936024411575293.66512287254.79640940928663.7779663971.4335472852015614473889529.190737344195.674477852
    5
    		2025-03-23 00:00:00.000147876852301948495.581422952745903.523759518138.42609186320.7006913980.021688015921995619471614197.254712315531.896511455
    6
    		2025-03-22 00:00:00.0001441468033741001563.12987743664454.427709998147.2237439181259.6475993880.087390564691980832470665701.673289315211.195820057
    7
    		2025-03-21 00:00:00.0001554171494131714247.442944331373634.08567925239.788423968489.1420030.0314742941966418469664138.543412313951.54822067
    8
    		2025-03-20 00:00:00.0001648275354611183421.5915318730881.513726424157.0566146694239.5983942820.25722596741950877467949891.100467313462.406217669
    9
    		2025-03-19 00:00:00.0001736179854842319418.378908861358982.25508899290.4719322373078.3761008320.17731559821934395466766469.508936309222.807823387
    10
    		2025-03-18 00:00:00.0001539070004161484405.617626271087518.43438457212.057945375876.2099305250.056933718681917034464447051.130027306144.431722555
    11
    		2025-03-17 00:00:00.0001671074215362485154.085805431746818.26402983334.881294408412.5748622850.024690296971901644462962645.512401305268.22179203
    12
    		2025-03-16 00:00:00.0001511066713921360286.584460671080304.4718009203.910445879345.2669218610.022850226461884934460477491.426595304855.646929745
    13
    		2025-03-15 00:00:00.0001716871645502136417.006989431532807.45423572298.215662617295.8695312310.017233779781869824459117204.842134304510.380007884
    14
    		2025-03-14 00:00:00.0001844280955441962294.401643651601308.14866003242.408202797849.2343880790.046048931141852656456980787.835145304214.510476652
    15
    		2025-03-13 00:00:00.00025937133055884241096.649661252527320.26744662318.7596129021964.2209563840.075730460591834214455018493.433501303365.276088573
    16
    		2025-03-12 00:00:00.0002500584695285512184.249896455111559.94286332650.866011323519.6152279250.020780453031808277450777396.78384301401.055132189
    17
    		2025-03-11 00:00:00.0002326076274955042720.603065243141504.1374031661.1669861111615.8147102440.069467528391783272445265212.533944300881.439904264
    18
    		2025-03-10 00:00:00.0002484080865815651130.01019074769375.34281319698.8783094473887.7673230180.15651237211760012440222491.930878299265.62519402
    19
    		2025-03-09 00:00:00.0002099774676402640755.692842842343787.11654308353.6568491822355.206202390.11216870041735172434571361.920688295377.857871002
    20
    		2025-03-08 00:00:00.0001832268365051731665.846288751392835.23501551253.3156592605.478986630.033046555321714175431930606.227845293022.651668611
    86
    13KB
    27s