PREVIEW / stock_1min / 2017-04-07

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-04-07.parquet
  size:    14.2 MB
  rows:    1,047,468
  symbols: 2,506

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
2017-04-07 04:00:00	AAPL	Stock	35.8775	35.8775	35.8775	35.8775	3600.0
2017-04-07 04:01:00	AAPL	Stock	35.845	35.845	35.845	35.845	800.0
2017-04-07 04:02:00	AAPL	Stock	35.825	35.825	35.825	35.825	848.0
2017-04-07 04:32:00	AAPL	Stock	35.87	35.87	35.87	35.87	420.0
2017-04-07 05:45:00	AAPL	Stock	35.87	35.87	35.87	35.87	400.0
2017-04-07 06:03:00	AAPL	Stock	35.8525	35.8525	35.8525	35.8525	536.0
2017-04-07 06:41:00	AAPL	Stock	35.87	35.87	35.87	35.87	3200.0
2017-04-07 06:43:00	AAPL	Stock	35.87	35.87	35.87	35.87	1664.0
2017-04-07 06:44:00	AAPL	Stock	35.875	35.875	35.875	35.875	400.0
2017-04-07 07:03:00	AAPL	Stock	35.875	35.8875	35.875	35.8875	1600.0
2017-04-07 07:07:00	AAPL	Stock	35.87	35.87	35.87	35.87	800.0
2017-04-07 07:27:00	AAPL	Stock	35.9125	35.9125	35.9125	35.9125	3900.0
2017-04-07 07:28:00	AAPL	Stock	35.925	35.925	35.925	35.925	400.0
2017-04-07 07:32:00	AAPL	Stock	35.95	35.95	35.95	35.95	4000.0
2017-04-07 07:33:00	AAPL	Stock	35.9375	35.9375	35.9375	35.9375	400.0
2017-04-07 07:34:00	AAPL	Stock	35.935	35.9375	35.935	35.9375	1540.0
2017-04-07 07:37:00	AAPL	Stock	35.9125	35.9125	35.9125	35.9125	2000.0
2017-04-07 07:46:00	AAPL	Stock	35.8975	35.8975	35.8975	35.8975	600.0
2017-04-07 07:47:00	AAPL	Stock	35.88	35.88	35.88	35.88	3400.0
2017-04-07 07:50:00	AAPL	Stock	35.88	35.88	35.88	35.88	1600.0
2017-04-07 07:58:00	AAPL	Stock	35.9	35.9	35.9	35.9	3700.0
2017-04-07 08:00:00	AAPL	Stock	35.8875	35.935	35.8525	35.9	11720.0
2017-04-07 08:01:00	AAPL	Stock	35.905	35.905	35.895	35.895	3440.0
2017-04-07 08:07:00	AAPL	Stock	35.895	35.895	35.895	35.895	1600.0
2017-04-07 08:13:00	AAPL	Stock	35.8925	35.8925	35.8925	35.8925	1200.0
2017-04-07 08:16:00	AAPL	Stock	35.8875	35.8875	35.8875	35.8875	4000.0
2017-04-07 08:17:00	AAPL	Stock	35.8875	35.8875	35.875	35.875	6460.0
2017-04-07 08:18:00	AAPL	Stock	35.8775	35.8775	35.8775	35.8775	2000.0
2017-04-07 08:20:00	AAPL	Stock	35.8775	35.8775	35.8775	35.8775	1756.0
2017-04-07 08:22:00	AAPL	Stock	35.8825	35.8825	35.8825	35.8825	3000.0
2017-04-07 08:23:00	AAPL	Stock	35.8875	35.8875	35.8775	35.8775	5140.0
2017-04-07 08:24:00	AAPL	Stock	35.8875	35.8875	35.8875	35.8875	556.0
2017-04-07 08:25:00	AAPL	Stock	35.895	35.895	35.895	35.895	400.0
2017-04-07 08:30:00	AAPL	Stock	35.89	35.89	35.805	35.815	56708.0
2017-04-07 08:31:00	AAPL	Stock	35.8225	35.8225	35.8175	35.8175	4000.0
2017-04-07 08:32:00	AAPL	Stock	35.86	35.86	35.8125	35.8125	5000.0
2017-04-07 08:33:00	AAPL	Stock	35.8325	35.8325	35.8125	35.8125	4532.0
2017-04-07 08:34:00	AAPL	Stock	35.8125	35.8125	35.8125	35.8125	9668.0
2017-04-07 08:36:00	AAPL	Stock	35.8275	35.8275	35.8275	35.8275	4000.0
2017-04-07 08:39:00	AAPL	Stock	35.8475	35.8625	35.8475	35.8575	4668.0
2017-04-07 08:40:00	AAPL	Stock	35.8575	35.8575	35.855	35.855	1676.0
2017-04-07 08:42:00	AAPL	Stock	35.8375	35.8375	35.8375	35.8375	800.0
2017-04-07 08:43:00	AAPL	Stock	35.83	35.84	35.83	35.84	4200.0
2017-04-07 08:44:00	AAPL	Stock	35.835	35.835	35.835	35.835	960.0
2017-04-07 08:46:00	AAPL	Stock	35.8375	35.8375	35.8375	35.8375	800.0
2017-04-07 08:47:00	AAPL	Stock	35.8375	35.8375	35.8375	35.8375	4000.0
2017-04-07 08:48:00	AAPL	Stock	35.86	35.8625	35.8375	35.8375	6200.0
2017-04-07 08:49:00	AAPL	Stock	35.8375	35.8375	35.8375	35.8375	2408.0
2017-04-07 08:52:00	AAPL	Stock	35.8375	35.8375	35.8375	35.8375	400.0
2017-04-07 08:53:00	AAPL	Stock	35.84	35.84	35.84	35.84	400.0

> showing 50 of 1,047,468 rows — these rows as CSV

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