PREVIEW / stock_5min / 2009-07-09

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-07-09.parquet
  size:    4.4 MB
  rows:    306,104
  symbols: 3,328

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-09 07:45:00	AAPL	Stock	4.9286	4.9318	4.9286	4.9318	8736.0
2009-07-09 07:50:00	AAPL	Stock	4.9286	4.9286	4.9286	4.9286	6664.0
2009-07-09 08:00:00	AAPL	Stock	4.9089	4.9179	4.9089	4.9161	25200.0
2009-07-09 08:05:00	AAPL	Stock	4.9171	4.9268	4.9171	4.9204	159264.0
2009-07-09 08:10:00	AAPL	Stock	4.9229	4.9229	4.9229	4.9229	60620.0
2009-07-09 08:15:00	AAPL	Stock	4.9207	4.9239	4.9207	4.9214	50792.0
2009-07-09 08:20:00	AAPL	Stock	4.9214	4.9214	4.9214	4.9214	41720.0
2009-07-09 08:25:00	AAPL	Stock	4.92	4.9286	4.9196	4.9268	72884.0
2009-07-09 08:30:00	AAPL	Stock	4.9286	4.9339	4.9268	4.9321	208600.0
2009-07-09 08:35:00	AAPL	Stock	4.9286	4.9286	4.925	4.9286	131684.0
2009-07-09 08:40:00	AAPL	Stock	4.9286	4.9389	4.9282	4.9307	420840.0
2009-07-09 08:45:00	AAPL	Stock	4.9357	4.9393	4.9357	4.9393	105504.0
2009-07-09 08:50:00	AAPL	Stock	4.9393	4.9457	4.9386	4.9436	278656.0
2009-07-09 08:55:00	AAPL	Stock	4.9436	4.9464	4.9396	4.9404	167076.0
2009-07-09 09:00:00	AAPL	Stock	4.9446	4.9446	4.9289	4.9329	151424.0
2009-07-09 09:05:00	AAPL	Stock	4.9318	4.9339	4.9275	4.9279	253624.0
2009-07-09 09:10:00	AAPL	Stock	4.9279	4.9286	4.9279	4.9286	69300.0
2009-07-09 09:15:00	AAPL	Stock	4.9268	4.9268	4.9214	4.9268	21280.0
2009-07-09 09:20:00	AAPL	Stock	4.9254	4.9254	4.9246	4.9254	57400.0
2009-07-09 09:25:00	AAPL	Stock	4.925	4.9254	4.9143	4.9211	194964.0
2009-07-09 09:30:00	AAPL	Stock	4.9225	4.9225	4.875	4.9189	19378464.0
2009-07-09 09:35:00	AAPL	Stock	4.9182	4.9282	4.8929	4.8946	16480072.0
2009-07-09 09:40:00	AAPL	Stock	4.8937	4.8971	4.8796	4.8864	12105296.0
2009-07-09 09:45:00	AAPL	Stock	4.8879	4.9014	4.8814	4.8861	8838676.0
2009-07-09 09:50:00	AAPL	Stock	4.8864	4.8932	4.8679	4.8932	12288612.0
2009-07-09 09:55:00	AAPL	Stock	4.8936	4.9086	4.8882	4.8979	9039100.0
2009-07-09 10:00:00	AAPL	Stock	4.8968	4.8982	4.8757	4.8946	9898476.0
2009-07-09 10:05:00	AAPL	Stock	4.8939	4.9071	4.8893	4.9039	7249368.0
2009-07-09 10:10:00	AAPL	Stock	4.9042	4.905	4.8868	4.8939	5063268.0
2009-07-09 10:15:00	AAPL	Stock	4.8946	4.8968	4.8839	4.885	4570104.0
2009-07-09 10:20:00	AAPL	Stock	4.886	4.8925	4.8821	4.8875	3499972.0
2009-07-09 10:25:00	AAPL	Stock	4.8871	4.8871	4.8661	4.8786	7684600.0
2009-07-09 10:30:00	AAPL	Stock	4.8779	4.88	4.8664	4.88	6351716.0
2009-07-09 10:35:00	AAPL	Stock	4.8804	4.8875	4.8736	4.8736	5004916.0
2009-07-09 10:40:00	AAPL	Stock	4.8736	4.8864	4.8729	4.8848	4206216.0
2009-07-09 10:45:00	AAPL	Stock	4.8846	4.8864	4.8625	4.8636	5725860.0
2009-07-09 10:50:00	AAPL	Stock	4.8639	4.8811	4.8636	4.8775	4084892.0
2009-07-09 10:55:00	AAPL	Stock	4.8775	4.8843	4.8736	4.8804	2137268.0
2009-07-09 11:00:00	AAPL	Stock	4.8804	4.8807	4.8686	4.8796	3272836.0
2009-07-09 11:05:00	AAPL	Stock	4.88	4.8807	4.8682	4.8732	2496564.0
2009-07-09 11:10:00	AAPL	Stock	4.8726	4.8807	4.8701	4.8736	2196208.0
2009-07-09 11:15:00	AAPL	Stock	4.8739	4.8821	4.8679	4.8757	4212852.0
2009-07-09 11:20:00	AAPL	Stock	4.875	4.8868	4.875	4.8839	3470488.0
2009-07-09 11:25:00	AAPL	Stock	4.8839	4.8854	4.8775	4.8804	2233000.0
2009-07-09 11:30:00	AAPL	Stock	4.8802	4.8875	4.8721	4.8868	3945424.0
2009-07-09 11:35:00	AAPL	Stock	4.8864	4.8929	4.885	4.8896	3809596.0
2009-07-09 11:40:00	AAPL	Stock	4.8889	4.9018	4.8889	4.9	4058712.0
2009-07-09 11:45:00	AAPL	Stock	4.8989	4.905	4.8986	4.9014	4767196.0
2009-07-09 11:50:00	AAPL	Stock	4.9011	4.9018	4.8961	4.8986	1630300.0
2009-07-09 11:55:00	AAPL	Stock	4.8993	4.9014	4.8907	4.8939	2396436.0

> showing 50 of 306,104 rows — these rows as CSV

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