PREVIEW / etf_1min / 2009-11-06

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-11-06.parquet
  size:    1.6 MB
  rows:    87,686

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-11-06 04:15:00	SPY	ETF	106.98	106.98	106.97	106.97	1500.0
2009-11-06 04:16:00	SPY	ETF	106.98	106.98	106.98	106.98	400.0
2009-11-06 04:37:00	SPY	ETF	106.87	106.87	106.87	106.87	1100.0
2009-11-06 05:16:00	SPY	ETF	106.72	106.72	106.72	106.72	100.0
2009-11-06 05:21:00	SPY	ETF	106.68	106.68	106.68	106.68	200.0
2009-11-06 05:59:00	SPY	ETF	106.84	106.84	106.84	106.84	1000.0
2009-11-06 06:04:00	SPY	ETF	107.0	107.0	107.0	107.0	2000.0
2009-11-06 06:05:00	SPY	ETF	106.98	106.98	106.98	106.98	200.0
2009-11-06 06:06:00	SPY	ETF	106.98	106.98	106.98	106.98	2000.0
2009-11-06 06:07:00	SPY	ETF	106.93	106.93	106.93	106.93	2000.0
2009-11-06 06:12:00	SPY	ETF	106.84	106.84	106.84	106.84	100.0
2009-11-06 06:17:00	SPY	ETF	106.84	106.84	106.84	106.84	100.0
2009-11-06 06:38:00	SPY	ETF	106.94	106.94	106.94	106.94	3000.0
2009-11-06 06:45:00	SPY	ETF	106.88	106.88	106.88	106.88	1000.0
2009-11-06 06:51:00	SPY	ETF	106.88	106.9	106.88	106.9	300.0
2009-11-06 06:53:00	SPY	ETF	106.88	106.88	106.88	106.88	1400.0
2009-11-06 06:56:00	SPY	ETF	106.9	106.9	106.9	106.9	200.0
2009-11-06 06:59:00	SPY	ETF	106.9	106.9	106.9	106.9	400.0
2009-11-06 07:00:00	SPY	ETF	106.87	106.87	106.84	106.84	1100.0
2009-11-06 07:01:00	SPY	ETF	106.88	106.88	106.87	106.87	19000.0
2009-11-06 07:03:00	SPY	ETF	106.86	106.89	106.86	106.89	2900.0
2009-11-06 07:04:00	SPY	ETF	106.89	106.89	106.89	106.89	100.0
2009-11-06 07:06:00	SPY	ETF	106.9	106.91	106.9	106.91	300.0
2009-11-06 07:07:00	SPY	ETF	106.91	106.91	106.91	106.91	140.0
2009-11-06 07:08:00	SPY	ETF	106.89	106.94	106.89	106.94	920.0
2009-11-06 07:09:00	SPY	ETF	106.95	106.97	106.95	106.95	700.0
2009-11-06 07:11:00	SPY	ETF	106.96	106.98	106.96	106.98	2200.0
2009-11-06 07:12:00	SPY	ETF	106.96	106.96	106.96	106.96	160.0
2009-11-06 07:13:00	SPY	ETF	106.96	106.96	106.93	106.93	1100.0
2009-11-06 07:15:00	SPY	ETF	106.96	106.96	106.96	106.96	4500.0
2009-11-06 07:17:00	SPY	ETF	106.93	106.93	106.93	106.93	970.0
2009-11-06 07:18:00	SPY	ETF	106.93	106.94	106.93	106.94	1072.0
2009-11-06 07:19:00	SPY	ETF	106.95	106.95	106.95	106.95	100.0
2009-11-06 07:20:00	SPY	ETF	106.96	106.96	106.96	106.96	800.0
2009-11-06 07:22:00	SPY	ETF	106.95	106.95	106.95	106.95	200.0
2009-11-06 07:23:00	SPY	ETF	106.96	106.96	106.95	106.95	2731.0
2009-11-06 07:25:00	SPY	ETF	106.92	106.92	106.92	106.92	146.0
2009-11-06 07:26:00	SPY	ETF	106.9	106.9	106.9	106.9	1900.0
2009-11-06 07:28:00	SPY	ETF	106.9	106.9	106.86	106.86	50700.0
2009-11-06 07:29:00	SPY	ETF	106.86	106.86	106.85	106.86	50000.0
2009-11-06 07:30:00	SPY	ETF	106.91	106.91	106.91	106.91	2407.0
2009-11-06 07:31:00	SPY	ETF	106.88	106.88	106.88	106.88	100.0
2009-11-06 07:34:00	SPY	ETF	106.85	106.85	106.85	106.85	1300.0
2009-11-06 07:35:00	SPY	ETF	106.85	106.86	106.85	106.86	24800.0
2009-11-06 07:36:00	SPY	ETF	106.91	106.91	106.89	106.89	4902.0
2009-11-06 07:37:00	SPY	ETF	106.91	106.91	106.91	106.91	500.0
2009-11-06 07:38:00	SPY	ETF	106.91	106.91	106.91	106.91	1000.0
2009-11-06 07:40:00	SPY	ETF	106.9	106.94	106.9	106.94	22201.0
2009-11-06 07:41:00	SPY	ETF	106.94	107.0	106.94	107.0	90458.0
2009-11-06 07:42:00	SPY	ETF	107.02	107.03	107.02	107.03	15000.0

> showing 50 of 87,686 rows — these rows as CSV

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