PREVIEW / stock_5min / 2009-07-08

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-07-08.parquet
  size:    4.6 MB
  rows:    317,592
  symbols: 3,313

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-08 07:10:00	AAPL	Stock	4.85	4.85	4.85	4.85	11200.0
2009-07-08 07:15:00	AAPL	Stock	4.85	4.85	4.85	4.85	2800.0
2009-07-08 07:20:00	AAPL	Stock	4.85	4.85	4.85	4.85	16800.0
2009-07-08 07:25:00	AAPL	Stock	4.8568	4.8571	4.8568	4.8571	43036.0
2009-07-08 07:30:00	AAPL	Stock	4.8571	4.8571	4.8571	4.8571	8400.0
2009-07-08 07:35:00	AAPL	Stock	4.8475	4.8661	4.8475	4.8661	8400.0
2009-07-08 07:45:00	AAPL	Stock	4.8482	4.8482	4.8482	4.8482	2800.0
2009-07-08 07:50:00	AAPL	Stock	4.8571	4.8571	4.8571	4.8571	7392.0
2009-07-08 08:00:00	AAPL	Stock	4.8489	4.8571	4.8482	4.8568	49980.0
2009-07-08 08:05:00	AAPL	Stock	4.8493	4.8571	4.8454	4.8454	88788.0
2009-07-08 08:10:00	AAPL	Stock	4.84	4.84	4.8393	4.8393	18200.0
2009-07-08 08:15:00	AAPL	Stock	4.8421	4.8429	4.8421	4.8429	25480.0
2009-07-08 08:25:00	AAPL	Stock	4.8461	4.8525	4.8461	4.8525	61320.0
2009-07-08 08:30:00	AAPL	Stock	4.85	4.85	4.8454	4.8454	54600.0
2009-07-08 08:40:00	AAPL	Stock	4.8464	4.8464	4.8464	4.8464	2800.0
2009-07-08 08:45:00	AAPL	Stock	4.85	4.85	4.8457	4.8457	5600.0
2009-07-08 08:50:00	AAPL	Stock	4.8454	4.8454	4.8304	4.8339	143864.0
2009-07-08 08:55:00	AAPL	Stock	4.8304	4.8371	4.8286	4.8329	113708.0
2009-07-08 09:00:00	AAPL	Stock	4.8375	4.8443	4.8357	4.8379	195608.0
2009-07-08 09:05:00	AAPL	Stock	4.8446	4.8482	4.8446	4.8482	44744.0
2009-07-08 09:10:00	AAPL	Stock	4.8479	4.8482	4.8446	4.8482	33880.0
2009-07-08 09:15:00	AAPL	Stock	4.8446	4.8482	4.8429	4.8429	44800.0
2009-07-08 09:25:00	AAPL	Stock	4.8411	4.8493	4.8339	4.8446	75600.0
2009-07-08 09:30:00	AAPL	Stock	4.8543	4.8543	4.8111	4.8232	14260260.0
2009-07-08 09:35:00	AAPL	Stock	4.8232	4.8618	4.8214	4.8604	14296016.0
2009-07-08 09:40:00	AAPL	Stock	4.8589	4.8868	4.8511	4.8821	14166320.0
2009-07-08 09:45:00	AAPL	Stock	4.8821	4.8868	4.8729	4.8768	8073184.0
2009-07-08 09:50:00	AAPL	Stock	4.8771	4.8843	4.8475	4.8482	11516540.0
2009-07-08 09:55:00	AAPL	Stock	4.8493	4.8514	4.8368	4.8461	9395400.0
2009-07-08 10:00:00	AAPL	Stock	4.845	4.8696	4.8414	4.8668	9266012.0
2009-07-08 10:05:00	AAPL	Stock	4.8679	4.8843	4.8664	4.8736	10408692.0
2009-07-08 10:10:00	AAPL	Stock	4.8732	4.8779	4.8636	4.8729	5927488.0
2009-07-08 10:15:00	AAPL	Stock	4.8725	4.8818	4.8679	4.8782	6564684.0
2009-07-08 10:20:00	AAPL	Stock	4.8785	4.8857	4.8757	4.8796	7737632.0
2009-07-08 10:25:00	AAPL	Stock	4.8796	4.8807	4.8643	4.8652	5485256.0
2009-07-08 10:30:00	AAPL	Stock	4.8668	4.8743	4.8596	4.8707	4716320.0
2009-07-08 10:35:00	AAPL	Stock	4.8704	4.8746	4.8525	4.8561	7221256.0
2009-07-08 10:40:00	AAPL	Stock	4.8561	4.8618	4.8486	4.86	6125616.0
2009-07-08 10:45:00	AAPL	Stock	4.8593	4.87	4.8593	4.8607	4589116.0
2009-07-08 10:50:00	AAPL	Stock	4.8607	4.8679	4.8539	4.8557	4595696.0
2009-07-08 10:55:00	AAPL	Stock	4.8546	4.8564	4.8432	4.8432	4845148.0
2009-07-08 11:00:00	AAPL	Stock	4.8432	4.8441	4.8261	4.8336	10303244.0
2009-07-08 11:05:00	AAPL	Stock	4.8325	4.8332	4.815	4.8225	9175852.0
2009-07-08 11:10:00	AAPL	Stock	4.8225	4.8321	4.8204	4.8321	5031292.0
2009-07-08 11:15:00	AAPL	Stock	4.8321	4.8332	4.8107	4.8175	8328796.0
2009-07-08 11:20:00	AAPL	Stock	4.8175	4.8189	4.8007	4.8071	7825860.0
2009-07-08 11:25:00	AAPL	Stock	4.8079	4.8157	4.8071	4.8107	4125856.0
2009-07-08 11:30:00	AAPL	Stock	4.8107	4.8236	4.8097	4.8232	4181912.0
2009-07-08 11:35:00	AAPL	Stock	4.8225	4.835	4.8186	4.8307	6064912.0
2009-07-08 11:40:00	AAPL	Stock	4.8307	4.8518	4.8307	4.85	8101492.0

> showing 50 of 317,592 rows — these rows as CSV

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