Sbhn_NPtotal axl stats
Updated 2024-07-20Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with price as (
select date_trunc('day',recorded_at) as date,
avg (price) as AXLPrice
from osmosis.price.dim_prices
where symbol = 'AXL'
group by 1)
select count (distinct tx_id) as txs,
count (distinct trader) as Users,
sum (to_amount/pow(10,to_decimal)) as AXL_Amount,
sum ((to_amount*axlprice)/pow(10,to_decimal)) as USD_Amount
from osmosis.defi.fact_swaps a
join price b on a.block_timestamp::date = b.date
where TX_SUCCEEDED
and to_currency = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
QueryRunArchived: QueryRun has been archived