home / daily

dailytx (view)

30 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

date transactions
2026-09-30 5794
2026-09-29 7800
2026-09-28 7998
2026-09-27 7215
2026-09-26 7597
2026-09-25 8336
2026-09-24 8802
2026-09-23 9033
2026-09-22 8604
2026-09-21 8274
2026-09-20 8143
2026-09-19 7814
2026-09-18 11026
2026-09-17 9952
2026-09-16 16003
2026-09-15 15456
2026-09-14 12538
2026-09-13 12493
2026-09-12 13083
2026-09-11 14084
2026-09-10 12687
2026-09-09 14334
2026-09-08 13986
2026-09-07 15144
2026-09-06 12780
2026-09-05 11767
2026-09-04 15408
2026-09-03 13703
2026-09-02 14355
2026-09-01 14064

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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;
Powered by Datasette · Queries took 8.489ms