flipside

    daily
    ellerydurwindaily
    Updated 2025-04-01
    WITH
    transactions AS (
    SELECT
    block_timestamp,
    tx_hash,
    contract_address,
    event_name,
    CASE
    WHEN event_name = 'Deposit' THEN decoded_log:assets::int
    WHEN event_name = 'Withdraw' THEN decoded_log:assets::int
    END AS amount,
    origin_from_address AS user_address
    FROM ronin.core.ez_decoded_event_logs
    WHERE
    contract_address = LOWER('0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2')
    AND event_name IN ('Deposit', 'Withdraw')
    ),

    wron_prices AS (
    SELECT
    wron_price
    FROM (
    SELECT
    hour::date AS date,
    median(price) AS wron_price,
    ROW_NUMBER() OVER (ORDER BY hour::date DESC) as rn
    FROM
    ronin.price.ez_prices_hourly
    WHERE
    SYMBOL = 'RON'
    GROUP BY
    hour::date
    )
    WHERE rn = 1
    ),

    Last run: 13 days ago
    DATE
    EVENT_NAME
    TRANSACTION_AMOUNT
    CUMULATIVE_AMOUNT
    UNIQUE_USERS
    CUMULATIVE_UNIQUE_USERS
    NUMBER_OF_TRANSACTIONS
    CUMULATIVE_TRANSACTIONS
    AMOUNT_USD
    CUMULATIVE_AMOUNT_USD
    1
    		2025-03-15 00:00:00.000Deposit100100111170.553470.5534
    2
    		2025-03-20 00:00:00.000Deposit2320732321737889163735.391982163805.945382
    3
    		2025-03-20 00:00:00.000Withdraw2211111.4110681.411068
    4
    		2025-03-21 00:00:00.000Deposit513645.035745818.035253261324333362394.03612369526199.98150569
    5
    		2025-03-21 00:00:00.000Withdraw17765.60717767.6073435505112534.23976913812535.650837138
    6
    		2025-03-22 00:00:00.000Deposit22111.854767929.889553166039315600.664800036541800.646305726
    7
    		2025-03-22 00:00:00.000Withdraw2443.77120211.378175219701724.16352871414259.814365852
    8
    		2025-03-23 00:00:00.000Deposit29025.69796955.579383544744020478.61116846562279.257474186
    9
    		2025-03-23 00:00:00.000Withdraw1052730738.378156717877427.15641821686.970783852
    10
    		2025-03-24 00:00:00.000Deposit454448.8138721251404.392872387741433873320629.089446368882908.346920554
    11
    		2025-03-24 00:00:00.000Withdraw3577.78434316.1621986211082524.24825665624211.219040508
    12
    		2025-03-25 00:00:00.000Deposit387228.6548431638633.0477152499902701143273202.9817660011156111.32868655
    13
    		2025-03-25 00:00:00.000Withdraw32790.89467107.056201062513323135.09060739647346.309647904
    14
    		2025-03-26 00:00:00.000Deposit40331.9081678964.9557151111101122126528455.5323788721184566.86106543
    15
    		2025-03-26 00:00:00.000Withdraw23584.471590691.5275181241915216639.64651528163985.956163185
    16
    		2025-03-27 00:00:00.000Deposit2703957.4914382922.4467155711586213271907733.944455193092300.80552062
    17
    		2025-03-27 00:00:00.000Withdraw4251.38854394942.91604315139161682999.49916429766985.455327482
    18
    		2025-03-28 00:00:00.000Deposit268257.2067364651179.65345113412921591486189264.5800972773281565.3856179
    19
    		2025-03-28 00:00:00.000Withdraw10587.791442105530.70748516155161847470.0468472474455.502174722
    20
    		2025-03-29 00:00:00.000Deposit27670.2864678849.93945137132944153019522.3275627243301087.71318062
    27
    3KB
    2s