-- forked from ethereum basic activity @ https://flipsidecrypto.xyz/edit/queries/f1f0012c-a4a9-470d-a9bb-65c65b567a67

SELECT FROM_ADDRESS as user_address,

COUNT(1) as n_txn,

count(DISTINCT(date_trunc('DAY', block_timestamp))) as n_days_active,

DATEDIFF(day, MAX(BLOCK_TIMESTAMP),'{{end_date}}') as days_since_last_txn,

-- a complex tx is any tx that is NOT a simple ETH transfer; i.e., has input data!

count_if(INPUT_DATA != '0x') as n_complex_txn,

COUNT (DISTINCT CASE WHEN INPUT_DATA != '0x' THEN TO_ADDRESS END) as n_contracts

FROM arbitrum.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= '{{start_date}}'

AND BLOCK_TIMESTAMP <= '{{end_date}}'

GROUP BY FROM_ADDRESS;