binhachonCopy of Untitled Query
Updated 2022-05-04
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with transactions as (
select
array_size(instructions) as len,
instructions[5]:programId::string as programID,
instructions[5]:accounts[0]::string as account0,
*
from solana.fact_transactions
where 1=1 --instructions[5]:programId::string = 'metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s'
and instructions[5]:accounts[0]::string = '5T4reQScZBDXbGRuf3WGWUVmPTCxsYCnG7HH1wUmYEhV'
)
select count(*) from transactions
Run a query to Download Data