date_trunc('hour', block_timestamp) as date,

250134638 as total_pyth_claimable,

90000 as total_elegible_users,

count(DISTINCT TX_ID) as txs,

sum(txs) over (order by date) as total_txs,

count(DISTINCT TX_TO) as users,

sum(users) over (order by date) as total_users,

(total_users/total_elegible_users)*100 as pcg_users_claiming,

sum(amount) as pyth_claimed,

sum(pyth_claimed) over (order by date) as total_pyth_claimed,

(total_pyth_claimed/total_pyth_claimable)*100 as pcg_pyth_claimed

FROM solana.core.fact_transfers

WHERE TX_FROM = '75WTeS4ZKruLJH4mz6omtbMNz8H9HEG1kY4G6VNQLX5i'

AND mint = 'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3'

AND BLOCK_TIMESTAMP >= '2023-08-17'

GROUP by 1,2,3 order by 1 desc