flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
7
avaema
7
Updated 2022-11-13
Copy Reference
Fork
9
1
2
3
›
⌄
select
TRANSFER_TYPE
,
count
(
1
)
,
sum
(
AMOUNT
/
1e6
)
from
osmosis
.
core
.
fact_transfers
where
date_trunc
(
'day'
,
block_timestamp
)
>
current_date
-
interval
'15 days'
and
CURRENCY
=
'uosmo'
group
by
1
Results
Run a query to Download Data