maybeyonasalgo_octo_sale_vol_daily
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
›
⌄
with
sale_txs as (
select
tx_group_id,
case when receiver = 'UFFXUBZ5DFRLOQOB4LOC7GA3HTWMEEE54U3DJRTL27RKKV4UWOIID3I4FU' then 'Gen 2' else 'Gen 1' end as type
from algorand.payment_transaction
where receiver in (
'X5YPUJ2HTFBY66WKWZOAA75WST5V7HWAGS2346SQFK622VNIRQ5ASXHTGA', -- Gen 1
'UFFXUBZ5DFRLOQOB4LOC7GA3HTWMEEE54U3DJRTL27RKKV4UWOIID3I4FU' -- Gen 2
)
and tx_group_id is not null
),
sale_data as (
select
block_timestamp,
s.tx_group_id,
type,
sum(amount) as algo_paid
from algorand.payment_transaction p join sale_txs s on p.tx_group_id=s.tx_group_id
group by 1,2,3
)
select
date(block_timestamp) as date,
type,
count(tx_group_id) as sales,
sum(algo_paid) as algo_vol
from sale_data
group by 1,2
limit 100
Run a query to Download Data