where tx_hash = '0x4b572a5e098eb018d7ae9acb42f87785f88db89129c8b4c907be8772dac8bfd9'

SELECT

tx_id

FROM flipside_prod_db.aave.withdraws

WHERE aave_token = '0xffc97d72e13e01096502cb8eb52dee56f74dad7b'

and block_timestamp > CURRENT_DATE - 365

limit 10

WITH price AS (

SELECT HOUR::date AS day, AVG(price) AS price

FROM ethereum.core.fact_hourly_token_prices

WHERE symbol = 'AAVE'

GROUP BY 1

ORDER BY 1

select

tx_hash,

count(distinct origin_from_address) as depositors_count,

sum(amount_usd) as amount_usd,

block_timestamp::date as TIME

from ethereum.core.ez_token_transfers

where origin_to_address in ('0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9', '0x135896de8421be2ec868e0b811006171d9df802a')

and to_address = '0x0000000000000000000000000000000000000000'

and contract_address = '0xffc97d72e13e01096502cb8eb52dee56f74dad7b'

and block_timestamp > CURRENT_DATE -365

group by TIME, tx_hash