uni checks

Updated 2024-08-12

-- with addresses as (

-- select lower(address) as address from (

-- values

-- ('0x27213e28d7fda5c57fe9e5dd923818dbccf71c47')

-- ,('0x163c5e051049e92915017fe7bb9b8ce6182bcbb1')

-- ,('0x37a8f295612602f2774d331e562be9e61b83a327')

-- ,('0x7ffc3dbf3b2b50ff3a1d5523bc24bb5043837b14')

-- ,('0x067170777ba8027ced27e034102d54074d062d71')

-- ,('0x34ecdad9090cd133e63cf6670f3a03aa7f04fa74')

-- ,('0x5a509e3fbf5efcdfe9c3e9a0eb56b1a036ab8e23')

-- ,('0xe9f2dcfdbb31149b02a520f8babd89227a0c6568')

-- ,('0xd4ce1f1b8640c1988360a6729d9a73c85a0c80a3')

-- ,('0xce946931adf7afc0797de2a76270a28458f487ed')

-- ,('0x000000fee13a103a10d593b9ae06b3e05f2e7e1c')

-- ) as t(address)

-- )

-- select block_timestamp, amount_usd, origin_to_address, 'ETH' as chain, tx_hash

-- from ethereum.core.ez_token_transfers

-- where to_address in (select address from addresses)

-- and origin_from_address not in (select address from addresses)

-- and block_timestamp::date > '2024-08-05'

-- and symbol not in ('Shiba 2.0', 'INNBC','Lisa')

-- and origin_to_address = '0x23b5aa437cfdaf03235d78961e032dba549dfc06'

-- union all

-- select block_timestamp, amount_usd, origin_to_address, 'ETH' as chain, tx_hash

-- from ethereum.core.ez_native_transfers

-- where to_address in (select address from addresses)

-- and origin_from_address not in (select address from addresses)

-- and block_timestamp::date > '2024-08-05'

-- -- and origin_to_address = '0x23b5aa437cfdaf03235d78961e032dba549dfc06'

-- order by amount_usd desc

-- limit 1000

QueryRunArchived: QueryRun has been archived

flipside