pinehearstAlameda Ethereum Wallets
    Updated 2022-11-13
    with
    base_table as (
    select
    block_timestamp:: date as balance_date,
    block_number,
    case
    when symbol = 'ETH' and contract_address is null then 'ETH'
    else contract_address
    end as contract_address,
    user_address, -- Do NOT replace this
    symbol,
    current_bal
    from
    ethereum.core.ez_balance_deltas
    where 1=1
    -- and block_timestamp:: date >= '' --user input
    and user_address IN (
    '0xe31a9498a22493ab922bc0eb240313a46525ee0a',
    '0x712d0f306956a6a4b4f9319ad9b9de48c5345996',
    '0x93c08a3168fc469f3fc165cd3a471d19a37ca19e',
    '0xca436e14855323927d6e6264470ded36455fc8bd',
    '0x83a127952d266a6ea306c40ac62a4a70668fe3bd',
    '0xc5ed2333f8a2c351fca35e5ebadb2a82f5d254c3',
    '0x89183c0a8965c0299997be9af700a801bdccc2da',
    '0xe5d0ef77aed07c302634dc370537126a2cd26590',
    '0x5d13f4bf21db713e17e04d711e0bf7eaf18540d6',
    '0x882a812d75aee53efb8a144f984b258b6c4807f0',
    '0xbefe4f86f189c1c817446b71eb6ac90e3cb68e60',
    '0xb78e90e2ec737a2c0a24d68a0e54b410fff3bd6b',
    '0x964d9d1a532b5a5daeacbac71d46320de313ae9c',
    '0xfa453aec042a837e4aebbadab9d4e25b15fad69d',
    '0x4deb3edd991cfd2fcdaa6dcfe5f1743f6e7d16a6',
    '0x477573f212a7bdd5f7c12889bd1ad0aa44fb82aa',
    '0xce31190a03fc3c5f23167e88e75066824823222d',
    '0x60009b78da046ac64ef789c29ca05b79cdf73c10',
    '0x73c0ae50756c7921d1f32ada71b8e50c5de7ff9c',
    Run a query to Download Data