MadiAlameda Inflow 28/09
Updated 2022-11-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select date_trunc('day', BLOCK_TIMESTAMP) as date, TX_HASH, ORIGIN_FROM_ADDRESS as sender, symbol as token, sum(amount_usd) as amount_usd
from(
select * FROM ethereum.core.ez_token_transfers
where TO_ADDRESS in (lower('0x882a812d75aee53efb8a144f984b258b6c4807f0'), lower('0x97137466bc8018531795217f0ecc4ba24dcba5c1'), lower('0xe5d0ef77aed07c302634dc370537126a2cd26590'), lower('0xe31a9498a22493ab922bc0eb240313a46525ee0a'),lower('0xc5ed2333f8a2c351fca35e5ebadb2a82f5d254c3'),
lower('0x345c9ae61ff6e68b319d61082a017ba854892488'), lower('0x93c08a3168fc469f3fc165cd3a471d19a37ca19e'),lower('0x0f4ee9631f4be0a63756515141281a3e2b293bbe'), lower('0xca436e14855323927d6e6264470ded36455fc8bd'), lower('0xfa453aec042a837e4aebbadab9d4e25b15fad69d'),lower('0x4c8cfe078a5b989cea4b330197246ced82764c63'),
lower('0x964d9d1a532b5a5daeacbac71d46320de313ae9c'), lower('0x5d13f4bf21db713e17e04d711e0bf7eaf18540d6'),lower('0xa726c00cda1f60aaab19bc095d02a46556837f31'), lower('0xb78e90e2ec737a2c0a24d68a0e54b410fff3bd6b'), lower('0x477573f212a7bdd5f7c12889bd1ad0aa44fb82aa'),lower('0x78835265ac857bf3420830c71987b1a55f73c2dc'),
lower('0xce31190a03fc3c5f23167e88e75066824823222d'), lower('0x712d0f306956a6a4b4f9319ad9b9de48c5345996'),lower('0x84d34f4f83a87596cd3fb6887cff8f17bf5a7b83'), lower('0xbefe4f86f189c1c817446b71eb6ac90e3cb68e60'), lower('0x60ae578abdfded1fb0555f54148fdd7b400a34ed'),lower('0x4deb3edd991cfd2fcdaa6dcfe5f1743f6e7d16a6'),
lower('0x60009b78da046ac64ef789c29ca05b79cdf73c10')) and
symbol = 'FTX Token')
Where date = '2022-09-28'
group by 1, 2, 3,4
Run a query to Download Data