dailytx (view)

30 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

CREATE VIEW dailytx as SELECT date(datetime(("daily_tx"."tx_date" / 1000), 'unixepoch')) AS "date", tx_count AS "transactions" from daily_tx order by tx_date desc limit 30;