Pmisha-bmlMdxmaker.1
Updated 2022-04-25
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
date_trunc(day,BLOCK_TIMESTAMP) as dt,
COUNT(distinct EVENT_INPUTS:solver) as total_users,
COUNT(TX_HASH) as total_transactions
from ethereum_core.fact_event_logs
where contract_address = lower('0x9008D19f58AAbD9eD0D60971565AA8510560ab41') and EVENT_NAME = 'Settlement'
and BLOCK_TIMESTAMP>='2022-01-01'
group by 1
Run a query to Download Data