shreexTEST
Updated 2023-01-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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