damidezover all trend
    Updated 2024-11-20

    WITH ETHprice AS (
    SELECT
    TRUNC(hour, 'day') AS day,
    AVG(price) AS price
    FROM ethereum.price.ez_prices_hourly
    WHERE token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    GROUP BY day
    ),

    BridgeData AS (
    SELECT
    TRUNC(block_timestamp, 'day') AS day,
    tx_id,
    amount / POW(10, decimal) * ep.price AS amount_usd,
    CASE
    WHEN tx_from = 'F7p3dFrjRTbtRp8FRF6qHLomXbKRBzpvBLjtQcfcgmNe' THEN 'deposit'
    WHEN tx_to = 'F7p3dFrjRTbtRp8FRF6qHLomXbKRBzpvBLjtQcfcgmNe' THEN 'withdraw'
    END AS transaction_type
    FROM eclipse.core.fact_transfers ft
    JOIN ETHprice ep ON TRUNC(ft.block_timestamp, 'day') = ep.day
    WHERE (tx_to = 'F7p3dFrjRTbtRp8FRF6qHLomXbKRBzpvBLjtQcfcgmNe'
    OR tx_from = 'F7p3dFrjRTbtRp8FRF6qHLomXbKRBzpvBLjtQcfcgmNe')
    AND succeeded = 'TRUE'
    AND ft.block_timestamp >= '2024-10-31'
    )


    SELECT day, count(DISTINCT tx_id) AS transaction,
    SUM(transaction) OVER (ORDER BY DAY) AS cum_tx,
    sum(amount_usd) as amountUsd,
    SUM(amountUsd) OVER (ORDER BY DAY) AS cum_usd,
    FROM BridgeData
    GROUP by day
    order by day desc

    Last run: 3 months ago
    DAY
    TRANSACTION
    CUM_TX
    AMOUNTUSD
    CUM_USD
    1
    2024-11-20 00:00:00.00067210866124941.3125633411509754.68135213
    2
    2024-11-19 00:00:00.00098110194115788.9801447431384813.36878879
    3
    2024-11-18 00:00:00.00018439213301444.8764639011269024.38864405
    4
    2024-11-17 00:00:00.00012617370112888.720371167967579.512180149
    5
    2024-11-16 00:00:00.0001257610994699.419947928854690.791808983
    6
    2024-11-15 00:00:00.0008464852131711.345027582759991.371861054
    7
    2024-11-14 00:00:00.000415400681433.138762718628280.026833472
    8
    2024-11-13 00:00:00.0006183591158283.024310071546846.888070753
    9
    2024-11-12 00:00:00.000616297358673.401537524388563.863760682
    10
    2024-11-11 00:00:00.000743235767271.184199598329890.462223158
    11
    2024-11-10 00:00:00.0007761614102401.378862059262619.27802356
    12
    2024-11-09 00:00:00.00043083887099.133692609160217.899161501
    13
    2024-11-08 00:00:00.00037540873056.8557110373118.765468892
    14
    2024-11-07 00:00:00.000193337.17732336761.909757862
    15
    2024-11-06 00:00:00.000121419.67254159324.732434495
    16
    2024-11-01 00:00:00.000122.5144958335.059892902
    17
    2024-10-31 00:00:00.000112.5453970692.545397069
    17
    1KB
    2s