date_trunc(hour, BLOCK_TIMESTAMP) hour

-- , BLOCK_TIMESTAMP

, case

when hour = '2022-10-11 19:00:00' then 'Hackers transferred fund from FTX'

when hour < '2022-10-11 22:00:00' then 'Before the hack'

when hour > '2022-10-11 22:00:00' then 'After the hack'

else 'The hack'

end period

, count(distinct tx_id) tx_count

, count(distinct signers[0]) user_count

from solana.core.ez_staking_lp_actions

where 1=1

and succeeded

AND block_timestamp >= '2022-10-08 21:00:00'

AND block_timestamp::date <= '2022-10-14'

group by 1,2