flipside

    thoughtless-cyan
    superflythoughtless-cyan
    Updated 2025-04-01
    WITH
    daily_deposits AS (
    SELECT
    date_trunc('day', block_timestamp) as date,
    SUM(decoded_log:assets::int / 1e18) as daily_deposit_amount,
    COUNT(*) as daily_deposit_count
    FROM ronin.core.ez_decoded_event_logs
    WHERE
    contract_address = LOWER('0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2')
    AND event_name = 'Deposit'
    GROUP BY 1
    ),
    daily_withdrawals AS (
    SELECT
    date_trunc('day', block_timestamp) as date,
    SUM(decoded_log:assets::int / 1e18) as daily_withdraw_amount,
    COUNT(*) as daily_withdraw_count
    FROM ronin.core.ez_decoded_event_logs
    WHERE
    contract_address = LOWER('0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2')
    AND event_name = 'Withdraw'
    GROUP BY 1
    ),
    daily_prices AS (
    SELECT
    hour::date AS date,
    price AS token_price_usd
    FROM
    ronin.price.ez_prices_hourly
    WHERE
    token_address IN ('0xe514d9deb7966c8be0ca922de8a064264ea6bcd4')
    ),
    cumulative_supply AS (
    SELECT
    date,
    SUM(daily_deposit_amount) OVER (ORDER BY date) as cumulative_deposits,
    Last run: 13 days ago
    DATE
    Daily Deposits (LRON)
    Daily Withdrawals (LRON)
    Daily Deposit Count
    Daily Withdrawal Count
    Daily Deposits (USD)
    Daily Withdrawals (USD)
    Cumulative LRON Supply
    Net Staking Value (USD)
    Daily Change %
    1
    		2025-04-01 00:00:00.0004514.5477941094.09442831103214.759824082779.092607144592401.3077223270198.454814450.074480715791
    2
    		2025-04-01 00:00:00.0004514.5477941094.09442831103178.986547362770.4230028934592401.3077223233808.266852060.074480715791
    3
    		2025-04-01 00:00:00.0004514.5477941094.09442831103234.944367269783.9843033284592401.3077223290731.081061280.074480715791
    4
    		2025-04-01 00:00:00.0004514.5477941094.09442831103225.928815324781.7993967554592401.3077223281560.055649760.074480715791
    5
    		2025-04-01 00:00:00.0004514.5477941094.09442831103301.068948807800.0095044154592401.3077223357995.983015480.074480715791
    6
    		2025-04-01 00:00:00.0004514.5477941094.09442831103177.243931914770.0006824434592401.3077223232035.599947280.074480715791
    7
    		2025-04-01 00:00:00.0004514.5477941094.09442831103246.447435048786.772055934592401.3077223302432.519593350.074480715791
    8
    		2025-04-01 00:00:00.0004514.5477941094.09442831103137.533969518760.3770278554592401.3077223191640.838044560.074480715791
    9
    		2025-04-01 00:00:00.0004514.5477941094.09442831103189.93884031773.0772759754592401.3077223244949.43242460.074480715791
    10
    		2025-04-01 00:00:00.0004514.5477941094.09442831103185.166963292771.9208181654592401.3077223240095.264242330.074480715791
    11
    		2025-04-01 00:00:00.0004514.5477941094.09442831103212.028522666778.4306800114592401.3077223267420.052023280.074480715791
    12
    		2025-04-01 00:00:00.0004514.5477941094.09442831103249.413492948787.4908759694592401.3077223305449.727252530.074480715791
    13
    		2025-04-01 00:00:00.0004514.5477941094.09442831103136.716836367760.1789967634592401.3077223190809.613407860.074480715791
    14
    		2025-04-01 00:00:00.0004514.5477941094.09442831103233.937623111783.740320274592401.3077223289706.975569650.074480715791
    15
    		2025-04-01 00:00:00.0004514.5477941094.09442831103157.027786892765.1013275954592401.3077223211470.82689130.074480715791
    16
    		2025-04-01 00:00:00.0004514.5477941094.09442831103242.239876504785.7523599234592401.3077223298152.401574560.074480715791
    17
    		2025-04-01 00:00:00.0004514.5477941094.09442831103256.596138489789.2315802044592401.3077223312756.237733110.074480715791
    18
    		2025-04-01 00:00:00.0004514.5477941094.09442831103246.433891404786.7687736474592401.3077223302418.742389430.074480715791
    19
    		2025-04-01 00:00:00.0004514.5477941094.09442831103128.003759124758.0673945174592401.3077223181946.278883960.074480715791
    20
    		2025-04-01 00:00:00.0004514.5477941094.09442831103263.36796018790.8727218464592401.3077223319644.839694690.074480715791
    ...
    336
    42KB
    1s