shreexTEST
    Updated 2023-01-20
    select * from solana.core.fact_transactions--solana.core.fact_transactions -- t
    -- where tx_id='64No7m35P3mwF3mgxCyG6FmFjA7Wr6j1xNmBGU8vFNb2qs5SfVRqPJta5Uf6GgQCVk9E8sHJLUPdoNiwPPAkN1cA'
    where tx_id='2kDXiFb9jzmvofhDBgbWFXgUdZFHEXErS3j21GvbkjjoQMCehZKEo3K3N7A313b5sAdQTwY8eoa683R51e89RLVW'
    --left join solana.core.fact_events e on e.tx_id=t.tx_id
    -- where program_id='hadeK9DLv9eA7ya5KCTqSvSvRZeJC3JgD5a9Y3CNbvu' LIMIT 10
    select
    block_timestamp::Date as date,
    log_messages[1] as type,
    count(*) as txs
    from solana.core.fact_transactions where log_messages[0]='Program hadeK9DLv9eA7ya5KCTqSvSvRZeJC3JgD5a9Y3CNbvu invoke [1]'
    GROUP BY 1 ,2
    ORDER BY 1

    Run a query to Download Data