ACTIVE_DAYS | ACTIVE_WEEKS | ACTIVE_MONTH | NUMBER_OF_TX | |
|---|---|---|---|---|
1 | 0 | 0 | 0 | 0 |
mmdrezabeneficial-chocolate
Updated 7 hours ago
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
count(distinct date_trunc('day',block_timestamp)) as Active_days,
count(distinct date_trunc('week',block_timestamp)) as Active_weeks,
count(distinct date_trunc('month',block_timestamp)) as Active_month,
count(tx_id) as Number_of_tx
FROM eclipse.core.fact_transactions
WHERE signers[0] = '{{Address}}'
Last run: about 7 hours ago
1
11B
1s