binhachonCopy of Untitled Query
    Updated 2022-05-04
    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