date_trunc(hour, block_timestamp) as date,

case when tx_to = 'CugziSqZXcUStNPXbtRmq6atsrHqWY2fH2tAhsyApQrV' then 'ezSOL Vault'

when tx_to = 'CQpvXgoaaawDCLh8FwMZEwQqnPakRUZ5BnzhjnEBPJv' then 'kySOL Vault'

else 'Fragmetric Vault'

end as vault,

sum(AMOUNT) as Volume,

sum(volume) over(partition by vault order by date) as Cum,

count(DISTINCT tx_id) as N_Deposit,

sum(count(DISTINCT tx_id)) over(partition by vault order by date) as CUM_Deposits,

count(DISTINCT tx_from) as N_Depositors

from solana.core.fact_transfers

where tx_to in ('CugziSqZXcUStNPXbtRmq6atsrHqWY2fH2tAhsyApQrV', -- ezSOL Vault

'CQpvXgoaaawDCLh8FwMZEwQqnPakRUZ5BnzhjnEBPJv'--, -- kySOL Vault

--'FAqMViRRdfnhNxiuVw9SmJBeiwsXNLQkKQiy4AiC116G' -- fragSOL Vault

)

AND CONVERT_TIMEZONE('UTC', 'America/New_York', block_timestamp) BETWEEN '2024-10-30 10:00:00.000' AND '2024-10-30 16:00:00.000'

group by 1,2

CONVERT_TIMEZONE('UTC', 'America/New_York', date) AS timestamp_in_et,

vault,

Volume,

Cum,

N_Deposit,

CUM_Deposits,

from tab1