arbitrum by actions

Madiarbitrum by actions

Updated 2023-01-19

select date_trunc('day',BLOCK_TIMESTAMP) as date,

EVENT_NAME,

count(DISTINCT concat(tx_hash,'+',EVENT_INDEX)) as count_txs

from arbitrum.core.fact_event_logs where TX_STATUS = 'SUCCESS' and date >= '2022-06-17' and date != CURRENT_DATE

and EVENT_NAME in ('Swap', 'Transfer', 'Withdraw', 'Deposit')

group by 1,2

Run a query to Download Data

flipside