flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
OP vs other l2 4
Ranjit-Yadav
OP vs other l2 4
Updated 2022-10-19
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
date_trunc
(
'WEEK'
,
block_timestamp
)
as
WEEK
,
PROJECT_NAME
,
COUNT
(
DISTINCT
tx_hash
)
FROM
optimism
.
core
.
fact_event_logs
LEFT
outer
JOIN
arbitrum
.
core
.
dim_labels
ON
address
=
contract_address
where
project_name
IS
NOT
NULL
GROUP
BY
1
,
2
Results
Run a query to Download Data