saadiqZachXBT Donations Per Day
    Updated 2023-06-23
    WITH
    txns AS (
    SELECT
    block_timestamp,
    eth_from_address AS from_address,
    eth_to_address AS to_address,
    amount,
    amount_usd,
    'ETH' AS symbol
    FROM
    ethereum.core.ez_eth_transfers
    WHERE
    eth_to_address = lower('0x6eA158145907a1fAc74016087611913A96d96624')
    UNION
    SELECT
    block_timestamp,
    from_address,
    to_address,
    amount,
    amount_usd,
    symbol
    FROM
    ethereum.core.ez_token_transfers
    WHERE
    to_address = lower('0x6eA158145907a1fAc74016087611913A96d96624')
    )
    SELECT
    left(block_timestamp, 13) as hour,
    count(1) as num_txns
    FROM
    txns t
    group by
    left(block_timestamp, 13)
    order by left(block_timestamp, 13) DESC
    Run a query to Download Data