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