mrwildcatstarknet: daily flows
Updated 2023-11-28
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT date_trunc( 'day', block_timestamp ) AS date,
sum (CASE WHEN eth_to_address = lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419') THEN amount END ) as eth_deposited,
sum (CASE WHEN eth_from_address = lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419') THEN amount * -1 END ) as eth_withdrawn,
sum (CASE
WHEN eth_to_address = lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419') THEN amount
WHEN eth_from_address = lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419') THEN amount * -1
END) as netflow
FROM ethereum.core.ez_eth_transfers
WHERE block_timestamp > CURRENT_DATE - INTERVAL '60 days'
GROUP BY date_trunc( 'day', block_timestamp )
Run a query to Download Data