boomer77Burn tx and address count feb
Updated 2022-05-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with burn as (select date_trunc('day', block_timestamp) as dt, sum(offer_amount) as luna_b, (luna_b*-1) as luna_burned,
count(distinct tx_id) as burntx_count, count(distinct trader) as trader_count, case
when dt between '2022-02-21' and '2022-02-27' then 'Top Burned Week'
else 'normal' end as yess
from terra.swaps
where offer_currency = 'LUNA' and tx_status = 'SUCCEEDED' and year(block_timestamp) = '2022' and month(block_timestamp) = '2'
group by 1),
price as (select date_trunc('day',block_timestamp) as dt, avg(price_usd) as luna_price
from terra.oracle_prices
where symbol = 'LUNA'
group by 1)
select a.dt, a.luna_burned, a.yess, b.luna_price, a.burntx_count, a.trader_count
from burn a
left join price b on a.dt = b.dt
Run a query to Download Data