PREVIEW / etf_1min / 2009-07-07

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-07-07.parquet
  size:    1.6 MB
  rows:    86,967

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2009-07-07 04:32:00	SPY	ETF	89.82	89.82	89.82	89.82	500.0
2009-07-07 04:35:00	SPY	ETF	89.85	89.85	89.85	89.85	500.0
2009-07-07 04:59:00	SPY	ETF	90.03	90.03	90.03	90.03	100.0
2009-07-07 06:01:00	SPY	ETF	90.15	90.15	90.15	90.15	15000.0
2009-07-07 06:05:00	SPY	ETF	90.18	90.18	90.18	90.18	1000.0
2009-07-07 06:18:00	SPY	ETF	90.24	90.24	90.24	90.24	200.0
2009-07-07 06:28:00	SPY	ETF	90.17	90.17	90.17	90.17	100.0
2009-07-07 06:37:00	SPY	ETF	90.12	90.12	90.12	90.12	100.0
2009-07-07 06:43:00	SPY	ETF	90.1	90.1	90.1	90.1	100.0
2009-07-07 06:45:00	SPY	ETF	90.1	90.1	90.1	90.1	200.0
2009-07-07 06:47:00	SPY	ETF	90.07	90.07	90.07	90.07	1200.0
2009-07-07 06:53:00	SPY	ETF	90.11	90.16	90.11	90.16	2200.0
2009-07-07 06:55:00	SPY	ETF	90.15	90.15	90.15	90.15	200.0
2009-07-07 06:56:00	SPY	ETF	90.16	90.17	90.16	90.17	10000.0
2009-07-07 06:59:00	SPY	ETF	90.15	90.15	90.15	90.15	100.0
2009-07-07 07:00:00	SPY	ETF	90.17	90.17	90.17	90.17	200.0
2009-07-07 07:03:00	SPY	ETF	90.17	90.17	90.17	90.17	500.0
2009-07-07 07:04:00	SPY	ETF	90.15	90.15	90.15	90.15	100.0
2009-07-07 07:05:00	SPY	ETF	90.09	90.09	90.08	90.08	2800.0
2009-07-07 07:09:00	SPY	ETF	90.11	90.15	90.11	90.15	3500.0
2009-07-07 07:11:00	SPY	ETF	90.11	90.11	90.11	90.11	600.0
2009-07-07 07:12:00	SPY	ETF	90.16	90.16	90.16	90.16	15000.0
2009-07-07 07:16:00	SPY	ETF	90.18	90.18	90.18	90.18	15300.0
2009-07-07 07:17:00	SPY	ETF	90.2	90.2	90.2	90.2	3000.0
2009-07-07 07:20:00	SPY	ETF	90.17	90.17	90.16	90.16	8200.0
2009-07-07 07:21:00	SPY	ETF	90.16	90.16	90.16	90.16	1800.0
2009-07-07 07:24:00	SPY	ETF	90.21	90.21	90.21	90.21	1000.0
2009-07-07 07:25:00	SPY	ETF	90.23	90.24	90.21	90.21	25000.0
2009-07-07 07:26:00	SPY	ETF	90.19	90.19	90.19	90.19	200.0
2009-07-07 07:28:00	SPY	ETF	90.22	90.22	90.18	90.2	2700.0
2009-07-07 07:31:00	SPY	ETF	90.18	90.18	90.18	90.18	1000.0
2009-07-07 07:32:00	SPY	ETF	90.18	90.18	90.18	90.18	100.0
2009-07-07 07:33:00	SPY	ETF	90.19	90.2	90.19	90.2	4000.0
2009-07-07 07:34:00	SPY	ETF	90.17	90.22	90.16	90.22	53000.0
2009-07-07 07:35:00	SPY	ETF	90.22	90.22	90.22	90.22	50000.0
2009-07-07 07:38:00	SPY	ETF	90.19	90.19	90.19	90.19	1400.0
2009-07-07 07:40:00	SPY	ETF	90.2	90.2	90.19	90.19	500.0
2009-07-07 07:41:00	SPY	ETF	90.17	90.17	90.11	90.11	2700.0
2009-07-07 07:42:00	SPY	ETF	90.12	90.12	90.12	90.12	2000.0
2009-07-07 07:43:00	SPY	ETF	90.12	90.12	90.12	90.12	100.0
2009-07-07 07:45:00	SPY	ETF	90.12	90.12	90.12	90.12	1100.0
2009-07-07 07:46:00	SPY	ETF	90.12	90.12	90.12	90.12	300.0
2009-07-07 07:47:00	SPY	ETF	90.11	90.11	90.11	90.11	1300.0
2009-07-07 07:48:00	SPY	ETF	90.11	90.12	90.1	90.12	1100.0
2009-07-07 07:49:00	SPY	ETF	90.13	90.13	90.12	90.12	2500.0
2009-07-07 07:50:00	SPY	ETF	90.13	90.13	90.11	90.11	2700.0
2009-07-07 07:55:00	SPY	ETF	90.13	90.13	90.13	90.13	400.0
2009-07-07 07:56:00	SPY	ETF	90.13	90.15	90.13	90.15	900.0
2009-07-07 07:57:00	SPY	ETF	90.15	90.15	90.15	90.15	2800.0
2009-07-07 07:58:00	SPY	ETF	90.15	90.15	90.12	90.12	1689.0

> showing 50 of 86,967 rows — these rows as CSV

> unlock the full archive -- $79 one-time