PREVIEW / stock_5min / 2009-07-06

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-07-06.parquet
  size:    4.6 MB
  rows:    319,515
  symbols: 3,341

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-06 08:00:00	AAPL	Stock	4.9679	4.9814	4.9607	4.965	271292.0
2009-07-06 08:05:00	AAPL	Stock	4.9661	4.9661	4.9614	4.9614	8400.0
2009-07-06 08:10:00	AAPL	Stock	4.9632	4.9632	4.9607	4.9621	47600.0
2009-07-06 08:15:00	AAPL	Stock	4.96	4.96	4.9532	4.9532	160860.0
2009-07-06 08:20:00	AAPL	Stock	4.9518	4.9532	4.9436	4.9436	402780.0
2009-07-06 08:25:00	AAPL	Stock	4.9432	4.9486	4.9375	4.9429	215432.0
2009-07-06 08:30:00	AAPL	Stock	4.9425	4.9521	4.9418	4.95	85120.0
2009-07-06 08:35:00	AAPL	Stock	4.95	4.9536	4.95	4.9532	37072.0
2009-07-06 08:40:00	AAPL	Stock	4.9518	4.9518	4.9507	4.9507	11200.0
2009-07-06 08:45:00	AAPL	Stock	4.9511	4.9518	4.95	4.9518	72800.0
2009-07-06 08:50:00	AAPL	Stock	4.9532	4.9532	4.9532	4.9532	2800.0
2009-07-06 08:55:00	AAPL	Stock	4.95	4.955	4.95	4.9536	37380.0
2009-07-06 09:00:00	AAPL	Stock	4.9536	4.9675	4.9536	4.9636	118020.0
2009-07-06 09:05:00	AAPL	Stock	4.9636	4.9639	4.9614	4.9614	51380.0
2009-07-06 09:10:00	AAPL	Stock	4.9643	4.9739	4.9625	4.9625	92064.0
2009-07-06 09:15:00	AAPL	Stock	4.9614	4.9614	4.9554	4.9589	294224.0
2009-07-06 09:20:00	AAPL	Stock	4.9643	4.9679	4.9629	4.9636	41300.0
2009-07-06 09:25:00	AAPL	Stock	4.9625	4.9625	4.9529	4.9529	288204.0
2009-07-06 09:30:00	AAPL	Stock	4.9546	4.9639	4.9286	4.9307	21453432.0
2009-07-06 09:35:00	AAPL	Stock	4.9304	4.9339	4.9075	4.92	23606352.0
2009-07-06 09:40:00	AAPL	Stock	4.9189	4.9329	4.9136	4.9204	14235368.0
2009-07-06 09:45:00	AAPL	Stock	4.9196	4.9286	4.9179	4.9239	17182088.0
2009-07-06 09:50:00	AAPL	Stock	4.9243	4.9271	4.8879	4.8921	19619040.0
2009-07-06 09:55:00	AAPL	Stock	4.8918	4.8921	4.875	4.8771	14489832.0
2009-07-06 10:00:00	AAPL	Stock	4.8775	4.8904	4.8661	4.8746	24309348.0
2009-07-06 10:05:00	AAPL	Stock	4.8746	4.8886	4.8668	4.8871	12649728.0
2009-07-06 10:10:00	AAPL	Stock	4.8871	4.8979	4.8829	4.8925	16045344.0
2009-07-06 10:15:00	AAPL	Stock	4.8925	4.8982	4.8889	4.8893	7165648.0
2009-07-06 10:20:00	AAPL	Stock	4.8889	4.8893	4.8686	4.8789	11630864.0
2009-07-06 10:25:00	AAPL	Stock	4.8793	4.8889	4.8725	4.8882	6951672.0
2009-07-06 10:30:00	AAPL	Stock	4.8886	4.8957	4.8843	4.895	7950068.0
2009-07-06 10:35:00	AAPL	Stock	4.895	4.8957	4.8861	4.8921	6366780.0
2009-07-06 10:40:00	AAPL	Stock	4.8921	4.8975	4.8918	4.895	6124776.0
2009-07-06 10:45:00	AAPL	Stock	4.895	4.9032	4.8946	4.8975	4854108.0
2009-07-06 10:50:00	AAPL	Stock	4.8975	4.8993	4.8929	4.8962	7973532.0
2009-07-06 10:55:00	AAPL	Stock	4.8965	4.9064	4.8955	4.9057	5976348.0
2009-07-06 11:00:00	AAPL	Stock	4.9057	4.91	4.9039	4.9086	4754120.0
2009-07-06 11:05:00	AAPL	Stock	4.9086	4.9143	4.9071	4.9086	6391980.0
2009-07-06 11:10:00	AAPL	Stock	4.9089	4.9107	4.9054	4.9061	3353812.0
2009-07-06 11:15:00	AAPL	Stock	4.9068	4.9104	4.9061	4.91	2419144.0
2009-07-06 11:20:00	AAPL	Stock	4.91	4.9136	4.9057	4.9096	3855348.0
2009-07-06 11:25:00	AAPL	Stock	4.9096	4.9104	4.9018	4.9043	2679824.0
2009-07-06 11:30:00	AAPL	Stock	4.9039	4.9107	4.8982	4.9011	3407404.0
2009-07-06 11:35:00	AAPL	Stock	4.9007	4.9043	4.8982	4.9018	2282756.0
2009-07-06 11:40:00	AAPL	Stock	4.9014	4.9025	4.8939	4.8964	3648512.0
2009-07-06 11:45:00	AAPL	Stock	4.8971	4.905	4.8971	4.9043	2051896.0
2009-07-06 11:50:00	AAPL	Stock	4.9036	4.9054	4.8957	4.8969	4399052.0
2009-07-06 11:55:00	AAPL	Stock	4.8964	4.8968	4.8864	4.8889	6006812.0
2009-07-06 12:00:00	AAPL	Stock	4.8886	4.8914	4.8814	4.8861	5015892.0
2009-07-06 12:05:00	AAPL	Stock	4.8864	4.8882	4.885	4.8864	1608264.0

> showing 50 of 319,515 rows — these rows as CSV

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