gergabyteUntitled Query
    Updated 2022-12-19
    SELECT TOP 100 * FROM ethereum.core.fact_transactions WHERE to_address = lower('0xbEae5b147D0F416492bA0D95B6d08Bf2928E754c')
    -- SELECT TOP 200 block_timestamp, to_address, amount, symbol, event_name, event_type
    -- FROM ethereum.udm_events WHERE to_address = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF')

    -- zkSync - 0xaBEA9132b05A70803a4E85094fD0e1800777fBEF
    -- WITH NATIVE_ETH_DEPOSITS AS (
    -- SELECT sum(amount) AS totaleth
    -- FROM ethereum.udm_events WHERE to_address = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF') and amount > 0 and event_type = 'native_eth'
    -- )

    -- SELECT * FROM ethereum.events_emitted WHERE contract_address = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF')

    -- SELECT balance, symbol FROM ethereum.erc20_balances
    -- WHERE user_address = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF')

    -- SELECT sum(amount) AS totaleth
    -- FROM NATIVE_ETH_WITHDRAWLS

    -- WITH NATIVE_ETH_WITHDRAWLS AS (
    -- SELECT block_timestamp, from_address, amount, symbol, event_name, event_type
    -- FROM ethereum.udm_events WHERE from_address = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF') and amount > 0 and event_type = 'native_eth'
    -- )

    -- WITH NATIVE_ETH_DEPOSITS AS (
    -- SELECT TOP 200 block_timestamp, contract_address, to_address, amount, symbol, event_name, event_type
    -- FROM ethereum.udm_events WHERE to_address = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF') and amount > 0 and event_type = 'native_eth'
    -- )