freemartianPYTH sheet
Updated 2024-01-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- SELECT * FROM solana.core.fact_transfers
-- WHERE mint = 'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3'
-- -- AND tx_id = '5LTHa6d4sV8G2cxfbj1WRMZnaQYemRxTirgXQa3L57YQ878812bxaH3znpb5EHSPKnS8cEkCFn8Nt5meJEBALP7J'
-- AND block_timestamp::date = current_date
-- -- AND tx_to = 'E1ehCj5sZrnzCAT4qfsoxnVRsJSYX1dL69AXTH1h1hMB'
SELECT * FROM solana.defi.fact_stake_pool_actions
WHERE token ilike '%pyth%'
AND block_timestamp::date >= current_date - 1