select date_event,ORIGIN_FROM_ADDRESS, count(tx_hash)::string as n_txn, sum(ETH_staked) as tot_staked

from (select ROW_NUMBER() OVER(ORDER BY RAW_AMOUNT desc)::string AS num_row, ORIGIN_FROM_ADDRESS, RAW_AMOUNT/10e17 as ETH_staked, block_timestamp, tx_hash, case when block_timestamp>='2022-03-15' and block_timestamp<'2022-03-16' then 'March 15th'

when block_timestamp>='2022-05-11' and block_timestamp<'2022-05-14' then 'May 11th,12th,13th'

when block_timestamp>='2022-05-02' and block_timestamp<'2022-05-04' then 'May 2nd & 3rd'

when block_timestamp>='2022-06-07' and block_timestamp<'2022-06-10' then 'June 7th,8th,9th'

else null end as date_event

from ethereum.core.fact_token_transfers

where --tx_hash='0xf472b1a9283b863c5b8e7e01751603acd703e03cc04f105477aa92a3cf0145a0' and

origin_to_address='0xae7ab96520de3a18e5e111b5eaab095312d7fe84' and contract_address='0xae7ab96520de3a18e5e111b5eaab095312d7fe84' and

block_timestamp>='2022-03-01'

--group by 1 order by 1

order by 3 desc

limit 30)

--where date_event is not null

group by 1,2 order by 4 desc