PREVIEW / stock_1min / 2009-06-23

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-06-23.parquet
  size:    12.8 MB
  rows:    981,970
  symbols: 2,722

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-06-23 04:16:00	AAPL	Stock	4.9061	4.9061	4.9061	4.9061	2800.0
2009-06-23 05:11:00	AAPL	Stock	4.9268	4.9268	4.9268	4.9268	5012.0
2009-06-23 06:40:00	AAPL	Stock	4.9268	4.9268	4.9268	4.9268	21392.0
2009-06-23 06:50:00	AAPL	Stock	4.9279	4.9279	4.9279	4.9279	4200.0
2009-06-23 06:51:00	AAPL	Stock	4.9279	4.9279	4.9279	4.9279	26208.0
2009-06-23 07:09:00	AAPL	Stock	4.9139	4.9139	4.9139	4.9139	2800.0
2009-06-23 07:10:00	AAPL	Stock	4.9132	4.9132	4.9082	4.9082	19320.0
2009-06-23 07:13:00	AAPL	Stock	4.9068	4.9068	4.9061	4.9061	22400.0
2009-06-23 07:23:00	AAPL	Stock	4.91	4.91	4.91	4.91	5600.0
2009-06-23 07:26:00	AAPL	Stock	4.9107	4.9107	4.9107	4.9107	2800.0
2009-06-23 07:40:00	AAPL	Stock	4.9129	4.9129	4.9129	4.9129	2800.0
2009-06-23 07:46:00	AAPL	Stock	4.9157	4.9161	4.9157	4.9161	11200.0
2009-06-23 07:51:00	AAPL	Stock	4.9171	4.9171	4.9171	4.9171	5600.0
2009-06-23 07:52:00	AAPL	Stock	4.9129	4.9132	4.9125	4.9125	36400.0
2009-06-23 07:53:00	AAPL	Stock	4.9164	4.9164	4.9089	4.9089	22400.0
2009-06-23 07:55:00	AAPL	Stock	4.9125	4.9125	4.9125	4.9125	8400.0
2009-06-23 07:56:00	AAPL	Stock	4.9107	4.9107	4.9107	4.9107	2800.0
2009-06-23 07:57:00	AAPL	Stock	4.9071	4.9071	4.9071	4.9071	4900.0
2009-06-23 08:00:00	AAPL	Stock	4.9114	4.9114	4.88	4.8925	321888.0
2009-06-23 08:02:00	AAPL	Stock	4.8896	4.8896	4.8896	4.8896	2800.0
2009-06-23 08:03:00	AAPL	Stock	4.8929	4.8929	4.8929	4.8929	2800.0
2009-06-23 08:04:00	AAPL	Stock	4.8961	4.8964	4.8929	4.8957	32676.0
2009-06-23 08:05:00	AAPL	Stock	4.8896	4.8896	4.8889	4.8889	24472.0
2009-06-23 08:06:00	AAPL	Stock	4.8857	4.8857	4.8857	4.8857	28000.0
2009-06-23 08:09:00	AAPL	Stock	4.8889	4.8939	4.8889	4.8939	82992.0
2009-06-23 08:10:00	AAPL	Stock	4.8939	4.8975	4.8939	4.8975	87024.0
2009-06-23 08:11:00	AAPL	Stock	4.8982	4.9004	4.8982	4.9004	22400.0
2009-06-23 08:12:00	AAPL	Stock	4.8996	4.8996	4.8964	4.8975	16800.0
2009-06-23 08:13:00	AAPL	Stock	4.8964	4.8964	4.8964	4.8964	47600.0
2009-06-23 08:14:00	AAPL	Stock	4.8996	4.8996	4.8996	4.8996	11900.0
2009-06-23 08:15:00	AAPL	Stock	4.8982	4.9014	4.8982	4.9014	16100.0
2009-06-23 08:16:00	AAPL	Stock	4.9018	4.905	4.9014	4.9014	173488.0
2009-06-23 08:17:00	AAPL	Stock	4.9004	4.9011	4.9	4.9	25900.0
2009-06-23 08:20:00	AAPL	Stock	4.8932	4.8932	4.8893	4.8893	36400.0
2009-06-23 08:23:00	AAPL	Stock	4.8868	4.8868	4.8861	4.8861	12600.0
2009-06-23 08:24:00	AAPL	Stock	4.8864	4.8864	4.8821	4.8821	53200.0
2009-06-23 08:25:00	AAPL	Stock	4.8854	4.8907	4.8854	4.8854	67004.0
2009-06-23 08:28:00	AAPL	Stock	4.8911	4.8932	4.8911	4.8932	29932.0
2009-06-23 08:29:00	AAPL	Stock	4.895	4.895	4.895	4.895	2800.0
2009-06-23 08:31:00	AAPL	Stock	4.8921	4.8954	4.8904	4.8954	78400.0
2009-06-23 08:33:00	AAPL	Stock	4.8921	4.8921	4.8921	4.8921	2800.0
2009-06-23 08:34:00	AAPL	Stock	4.8904	4.8904	4.8861	4.8861	24500.0
2009-06-23 08:35:00	AAPL	Stock	4.8914	4.8918	4.8857	4.8918	61768.0
2009-06-23 08:36:00	AAPL	Stock	4.8893	4.89	4.8893	4.89	59444.0
2009-06-23 08:38:00	AAPL	Stock	4.8861	4.89	4.8861	4.8893	11200.0
2009-06-23 08:39:00	AAPL	Stock	4.8868	4.8893	4.8868	4.8893	5600.0
2009-06-23 08:41:00	AAPL	Stock	4.8864	4.8864	4.8796	4.8836	147168.0
2009-06-23 08:42:00	AAPL	Stock	4.8836	4.8836	4.8836	4.8836	16800.0
2009-06-23 08:43:00	AAPL	Stock	4.8825	4.8825	4.8825	4.8825	2800.0
2009-06-23 08:44:00	AAPL	Stock	4.8821	4.8821	4.8786	4.8786	14000.0

> showing 50 of 981,970 rows — these rows as CSV

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