AndyCoolTotal Sale Amount
Updated 2022-05-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
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