flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
LAAF Development 4
mattkstew
LAAF Development 4
Updated 2023-01-25
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with
tab1
as
(
select
message_value
:
contract
,
min
(
BLOCK_TIMESTAMP
)
as
date1
from
terra
.
core
.
ez_messages
where
message_type
like
'%Contract%'
group
by
1
)
select
count
(
*
)
/
11
as
Average_daily
from
tab1
where
date1
>
'2023-01-14'
order
by
1
Results
Run a query to Download Data