AndyCoolTotal Sale Amount
    Updated 2022-05-26
    with goanna_asset_id as (
    select distinct asset_id
    from flipside_prod_db.algorand.asset
    where creator_address = 'D5J7H7PIYKLY2U6A5OFUAC7GQHTHSXXNX65DSD3CJYPBV2MVK6NTNW44CA'
    and (asset_name like 'Al Goanna 82'
    or asset_name like 'Al Goanan 217'
    or asset_name like 'Al Goanna%'
    or asset_name like 'Al Goanna 401'
    or asset_name like 'AL Goanna 400')
    and asset_name != 'Al Goanna Space Monkey #190'
    and asset_name != 'Al Goanna Space Monkey #191'
    and closed_at is null
    ),
    sales as (
    select max(tx_message:txn:amt)/1000000 as amount, tx_group_id, block_timestamp::date as DATE
    from flipside_prod_db.algorand.payment_transaction pt
    where tx_group_id in (
    select distinct tx_group_id
    from flipside_prod_db.algorand.asset_transfer_transaction a
    inner join goanna_asset_id g on g.asset_id = a.asset_transferred
    )
    and tx_message:txn:amt is not null
    group by tx_group_id, DATE
    order by amount desc
    )
    select sum(amount)
    from sales
    where amount >200
    Run a query to Download Data