freemartianWayfinder Daily Deposit & Withdraw
    Updated 7 days ago
    WITH prices AS(
    SELECT
    hour::date AS price_day,
    AVG(price) AS price
    FROM ethereum.price.ez_prices_hourly
    WHERE token_address = '0xb23d80f5fefcddaa212212f028021b41ded428cf'
    AND hour::date >= '2024-06-01'
    GROUP BY 1
    ),

    deposits AS (
    SELECT
    block_timestamp,
    tx_hash,
    decoded_log:user AS user,
    decoded_log:amount / pow(10,18) AS amount,
    price * (decoded_log:amount / pow(10,18)) AS amount_usd,
    'Deposit' AS label
    FROM ethereum.core.ez_decoded_event_logs
    INNER JOIN prices ON (block_timestamp::date = price_day)

    WHERE contract_address = '0x4a3826bd2e8a31956ad0397a49efde5e0d825238'
    AND event_name = 'DepositCreated'
    AND block_timestamp::date >= '2024-06-01'

    ),

    withdraws AS (
    SELECT
    block_timestamp,
    tx_hash,
    decoded_log:user AS user,
    decoded_log:totalAmount / pow(10,18) AS amount,
    price * (decoded_log:totalAmount / pow(10,18)) AS amount_usd,
    'Withdraw' AS label
    Last run: 7 days agoAuto-refreshes every 1 hour
    TIME
    DEPOSIT_TX
    WITHDRAW_TX
    DEPOSITORS
    WITHDRAWERS
    DEPOSIT_AMOUNT
    DEPOSIT_AMOUNT_USD
    WITHDRAW_AMOUNT
    WITHDRAW_AMOUNT_USD
    NET_PRIME_AMOUNT
    NET_USD_AMOUNT
    1
    2024-06-04 00:00:00.0004030302650590.937500302650590.9375
    2
    2024-06-05 00:00:00.00033202050399933770821592.708333300399933770821592.7083333
    3
    2024-06-06 00:00:00.00087105640307400854283138.7700307400854283138.77
    4
    2024-06-07 00:00:00.0003450253082431413400941.39083330082431413400941.3908333
    5
    2024-06-08 00:00:00.000214015204422566669220.48004422566669220.48
    6
    2024-06-09 00:00:00.000242017005189687351830.43005189687351830.43
    7
    2024-06-10 00:00:00.000232016205314786922943.84833333005314786922943.84833333
    8
    2024-06-11 00:00:00.0002150135081557810716015.27166670081557810716015.2716667
    9
    2024-06-12 00:00:00.00015209501546782039364.98083333001546782039364.98083333
    10
    2024-06-13 00:00:00.00013209603722334422593.33125003722334422593.33125
    11
    2024-06-14 00:00:00.00015101170127674014104253.17500127674014104253.175
    12
    2024-06-15 00:00:00.00010407301552151613071.8875001552151613071.8875
    13
    2024-06-16 00:00:00.00012307401785211795549.34125001785211795549.34125
    14
    2024-06-17 00:00:00.0001360940151040814377196.1500151040814377196.15
    15
    2024-06-18 00:00:00.000168010501835331685903.54916667001835331685903.54916667
    16
    2024-06-19 00:00:00.00031702100195527919319785.919166700195527919319785.9191667
    17
    2024-06-20 00:00:00.0009807803406753514062.625003406753514062.625
    18
    2024-06-21 00:00:00.0005504801891201980638001891201980638
    19
    2024-06-22 00:00:00.00036032065734685824.7333333330065734685824.733333333
    20
    2024-06-23 00:00:00.0004403401264851327565.47916667001264851327565.47916667
    ...
    336
    32KB
    47s