flipside

    wallets fees(failed transactions)
    lagandispenserwallets fees(failed transactions)
    Updated 2022-07-13
    select signers[0], sum(fee/1e9) as amountfee
    from solana.core.fact_transactions
    where block_timestamp >= '2022-01-01' and SUCCEEDED ='FALSE'
    group by 1
    order by 2 DESC
    limit 10

    Run a query to Download Data