granadohoTotal Unique Wallets that have Claimed WLUNA Shares
    Updated 2022-02-21
    select
    count(distinct value:owner) as total_unique_wallets
    from solana.events, lateral flatten(input => posttokenbalances)
    where block_timestamp::date >= '2022-02-04'
    and (inner_instruction:instructions[0]:parsed:info:authority = 'FzJ3VxEBuKxpX6meAWtFeAmoGjN8xw8fVNnArKwDp4os' and value:mint = '3JU8iPVMrrhmct4RP7rTSBFwStv6oksEsSj4C6mkk2Yg')
    and event_type is null
    and value:owner != 'FzJ3VxEBuKxpX6meAWtFeAmoGjN8xw8fVNnArKwDp4os'


    Run a query to Download Data