nitsFriktion Crab Startegy - 1
    Updated 2022-05-01
    SELECT date(block_timestamp) as day, count(DISTINCT tx_id) as total_txs,
    count(DISTINCT inner_instruction:instructions[0]:parsed:info:source) as participants
    from solana.fact_events
    where
    instruction:accounts[3] ilike '86nx2WyrdC6VuWyfdG1gMLiiBduktBTJgToKZAYwcbct'
    -- program_id ilike 'VoLT1mJz1sbnxwq5Fv2SXjdVDgPXrb9tJyC8WpMDkSp'
    GROUP by 1
    limit 1000
    Run a query to Download Data