flipside

    Total Numbers II
    MasiTotal Numbers II
    Updated 2025-04-10
    with tb1 as ( select block_timestamp,
    tx_id,
    SIGNERS[0] as wallet
    from eclipse.core.fact_transactions t
    where t.block_timestamp >= '2024-12-09'
    and (t.log_messages[0] LIKE '%turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN%' or t.log_messages[2] LIKE '%turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN%')
    and (t.log_messages[1] = 'Program log: Instruction: Click' or t.log_messages[3] = 'Program log: Instruction: Click')
    )

    select
    count(tx_id) as "Tap",
    count(DISTINCT wallet) as "Wallets",
    "Tap"/"Wallets" as "Avg Tap Per Wallet"
    from tb1
    Last run: 2 months ago
    Tap
    Wallets
    Avg Tap Per Wallet
    1
    		895333774228280731658.826486
    1
    34B
    511s