alleriaFlipside Algorand Wallet Behavior 6
    Updated 2022-04-07
    WITH
    wallets as (
    SELECT
    receiver,
    COUNT(amount) as no_of_tx,
    SUM(amount) as total_ALGO_received
    FROM algorand.payment_transaction
    WHERE sender = 'TLR47MQCEIC6HSSYLXEI7NJIINWJESIT3XROAYC2DUEFMSRQ6HBVJ3ZWLE'
    AND amount < 10000
    GROUP BY receiver
    ),

    wallets_dates as (
    SELECT
    date(block_timestamp) as dates,
    block_timestamp,
    block_id,
    address,
    balance,
    wallet_type,
    no_of_tx,
    total_ALGO_received
    FROM algorand.account
    INNER JOIN algorand.block ON (block_id = created_at)
    INNER JOIN wallets ON (receiver = address)
    WHERE address in (SELECT receiver FROM wallets)
    )

    SELECT
    COUNT(DISTINCT sender) as unique_wallets
    FROM algorand.application_call_transaction
    WHERE sender in (SELECT receiver FROM wallets)
    Run a query to Download Data