freemartianHourly Tokens Deposited
    Updated 2024-01-29
    SELECT
    date_trunc('hour',block_timestamp) AS hour,
    'ETH' AS symbol,
    COUNT(tx_hash) AS tx_count,
    SUM(amount) AS token_amount,
    SUM(amount_usd) AS usd_amount
    FROM ethereum.core.ez_eth_transfers
    WHERE eth_to_address = lower('0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d')
    AND origin_function_signature = '0xf6326fb3'
    AND block_timestamp::date >= '2023-11-20'
    AND block_timestamp < CURRENT_TIMESTAMP() - INTERVAL '2 HOUR'
    AND eth_from_address <> '0x0000000000000000000000000000000000000000'

    GROUP BY 1,2

    UNION

    SELECT
    date_trunc('hour',block_timestamp) AS hour,
    symbol,
    COUNT(tx_hash) AS tx_count,
    SUM(amount) AS token_amount,
    SUM(amount_usd) AS usd_amount
    FROM ethereum.core.ez_token_transfers t
    WHERE to_address = lower('0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d')
    AND origin_function_signature IN ('0x0a553dcb','0x3265aead','0xf688bcfb','0x365833e1')
    AND block_timestamp::date >= '2023-11-20'
    AND block_timestamp < CURRENT_TIMESTAMP() - INTERVAL '2 HOUR'
    AND from_address <> '0x0000000000000000000000000000000000000000'
    GROUP BY 1,2
    ORDER BY 1 DESC




    Last run: over 1 year agoAuto-refreshes every 3 hours
    HOUR
    SYMBOL
    TX_COUNT
    TOKEN_AMOUNT
    USD_AMOUNT
    1
    2024-01-29 09:00:00.000ETH41.40796
    2
    2024-01-29 08:00:00.000USDC2159114.521752159158.256214595
    3
    2024-01-29 08:00:00.000ETH12952.03985836117713.32
    4
    2024-01-29 08:00:00.000USDT415873.3029715872.806357374
    5
    2024-01-29 08:00:00.000DAI415868.29844683115870.220980272
    6
    2024-01-29 07:00:00.000ETH19877.476658039175452.73
    7
    2024-01-29 07:00:00.000USDT319501.30456319500.392176774
    8
    2024-01-29 07:00:00.000USDC222612.2944822617.838919448
    9
    2024-01-29 07:00:00.000DAI319495.16337845419496.90421466
    10
    2024-01-29 06:00:00.000stETH310.58178291123988.196332286
    11
    2024-01-29 06:00:00.000ETH224287.4189177651469.82
    12
    2024-01-29 06:00:00.000USDC1200000200018.757759556
    13
    2024-01-29 05:00:00.000USDT1250.506789250.4620176
    14
    2024-01-29 05:00:00.000DAI1250.438531185250.470512541
    15
    2024-01-29 05:00:00.000USDC1247524.592204247555.832786629
    16
    2024-01-29 05:00:00.000stETH3715854.214654186
    17
    2024-01-29 05:00:00.000ETH13928.54998861964705.77
    18
    2024-01-29 04:00:00.000ETH11735.01179377279438.04
    19
    2024-01-29 04:00:00.000DAI21109.6960639121109.775631447
    20
    2024-01-29 04:00:00.000stETH22147679.291573923
    ...
    5346
    313KB
    23s