pinehearstAlameda Ethereum Wallets
Updated 2022-11-13
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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