flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
3_2_Daily net Volume: https://app.flipsidecrypto.com/velocity/queries/0b61e465-6d46-4280-ab8b-c1666894719f
Elprognerd
3_2_Daily net Volume: https://app.flipsidecrypto.com/velocity/queries/0b61e465-6d46-4280-ab8b-c1666894719f
Updated 2023-01-04
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
SELECT
date_trunc
(
'day'
,
block_timestamp
)
as
day
,
sum
(
case
WHEN
action
=
'Stake'
then
stake_amount
/
pow
(
10
,
24
)
else
-
1
*
stake_amount
/
pow
(
10
,
24
)
end
)
as
"Total Daily Net Volume"
FROM
near
.
core
.
dim_staking_actions
WHERE
action
in
(
'Stake'
,
'Unstake'
)
group
by
1
order
by
1
Results
Run a query to Download Data