flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Contracts-Eth-Fact
larrypenguin
Contracts-Eth-Fact
Updated 2023-03-22
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
CONTRACT_ADDRESS
,
trunc
(
BLOCK_TIMESTAMP
,
'day'
)
as
time
,
COUNT
(
DISTINCT
TX_HASH
)
as
transactions
FROM
ethereum
.
core
.
fact_decoded_event_logs
WHERE
time
=
'2023-03-22'
GROUP
BY
CONTRACT_ADDRESS
,
time
ORDER
BY
transactions
DESC
;
Results
Run a query to Download Data