flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
BECOME A PARTNER
flipside
Luna staked on weekly basis(Distribution of Luna staked amount based on action Distribution of Luna staked count based on action Weekly Luna staked amount based on action Weekly Luna staked count based on action)
superfly
Luna staked on weekly basis(Distribution of Luna staked amount based on action Distribution of Luna staked count based on action Weekly Luna staked amount based on action Weekly Luna staked count based on action)
Updated 2022-12-26
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
with
luna_staking_daily
as
(
select
date_trunc
(
'week'
,
block_timestamp
)
as
week
,
sum
(
AMOUNT
)
as
total_amount_staked
,
count
(
*
)
as
total_count
,
action
from
terra
.
core
.
ez_staking
group
by
action
,
week
)
select
*
from
luna_staking_daily
Results
Run a query to Download Data