shreextest2 hade
    Updated 2023-01-20
    -- select * from solana.core.fact_transactions--solana.core.fact_transactions -- t
    -- -- where tx_id='64No7m35P3mwF3mgxCyG6FmFjA7Wr6j1xNmBGU8vFNb2qs5SfVRqPJta5Uf6GgQCVk9E8sHJLUPdoNiwPPAkN1cA'
    -- where tx_id='2kDXiFb9jzmvofhDBgbWFXgUdZFHEXErS3j21GvbkjjoQMCehZKEo3K3N7A313b5sAdQTwY8eoa683R51e89RLVW' example txs for liquidity
    -- --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,
    distinct log_messages[1] as type,
    count(*) AS txs
    -- count(*) as txs
    from solana.core.fact_transactions where log_messages[0] ilike '%hadeK9DLv9eA7ya5KCTqSvSvRZeJC3JgD5a9Y3CNbvu%' and block_timestamp >= '2022-10-01'
    GROUP BY 1
    ORDER BY 2 DESC


    Run a query to Download Data