jackguyArbitrum 2 copy
Updated 2023-05-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
-- forked from 4c0e783a-d313-4967-8e93-297ada92154f
with defi_contracts as (
SELECT
project_name,
address
FROM arbitrum.core.dim_labels
WHERE label_type LIKE 'defi'
)
SELECT
date_trunc('day', block_timestamp) as day,
count(DISTINCT tx_hash),
count(DISTINCT ORIGIN_FROM_ADDRESS)
-- count(DISTINCT ORIGIN_FROM_ADDRESS),
-- count(DISTINCT tx_hash)
FROM arbitrum.core.fact_event_logs
-- LEFT outer JOIN defi_contracts
-- ON address = contract_address
GROUP BY 1
Run a query to Download Data