PREVIEW / stock_5min / 2009-06-19

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-06-19.parquet
  size:    4.6 MB
  rows:    314,313
  symbols: 3,331

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-19 04:30:00	AAPL	Stock	4.8871	4.8871	4.8871	4.8871	2800.0
2009-06-19 07:05:00	AAPL	Stock	4.9207	4.9207	4.9207	4.9207	8400.0
2009-06-19 07:10:00	AAPL	Stock	4.9218	4.9218	4.8843	4.8843	6300.0
2009-06-19 07:25:00	AAPL	Stock	4.9075	4.9107	4.9075	4.9107	96600.0
2009-06-19 07:30:00	AAPL	Stock	4.9036	4.9107	4.9036	4.9071	83300.0
2009-06-19 07:35:00	AAPL	Stock	4.9104	4.9104	4.9104	4.9104	5600.0
2009-06-19 07:40:00	AAPL	Stock	4.91	4.9107	4.91	4.9107	22400.0
2009-06-19 07:45:00	AAPL	Stock	4.9086	4.9193	4.9086	4.9118	54600.0
2009-06-19 07:50:00	AAPL	Stock	4.9121	4.9121	4.9121	4.9121	137200.0
2009-06-19 07:55:00	AAPL	Stock	4.9132	4.9161	4.9129	4.9132	227780.0
2009-06-19 08:00:00	AAPL	Stock	4.9132	4.9236	4.9132	4.9154	448728.0
2009-06-19 08:05:00	AAPL	Stock	4.9154	4.9214	4.9143	4.9179	484428.0
2009-06-19 08:10:00	AAPL	Stock	4.9196	4.9236	4.9196	4.9214	226940.0
2009-06-19 08:15:00	AAPL	Stock	4.9204	4.9229	4.9171	4.9221	92400.0
2009-06-19 08:20:00	AAPL	Stock	4.9196	4.9286	4.9196	4.9282	756420.0
2009-06-19 08:25:00	AAPL	Stock	4.9286	4.935	4.925	4.9321	426720.0
2009-06-19 08:30:00	AAPL	Stock	4.9268	4.9282	4.9229	4.9282	158004.0
2009-06-19 08:35:00	AAPL	Stock	4.9271	4.9321	4.9243	4.9321	238000.0
2009-06-19 08:40:00	AAPL	Stock	4.9304	4.9304	4.9286	4.9304	383264.0
2009-06-19 08:45:00	AAPL	Stock	4.93	4.9357	4.9286	4.9357	411740.0
2009-06-19 08:50:00	AAPL	Stock	4.9346	4.9429	4.9329	4.9396	550424.0
2009-06-19 08:55:00	AAPL	Stock	4.9411	4.9411	4.9321	4.9375	205800.0
2009-06-19 09:00:00	AAPL	Stock	4.9371	4.9429	4.9339	4.9429	473620.0
2009-06-19 09:05:00	AAPL	Stock	4.9425	4.9429	4.9343	4.9357	485632.0
2009-06-19 09:10:00	AAPL	Stock	4.9332	4.9332	4.9229	4.9321	651560.0
2009-06-19 09:15:00	AAPL	Stock	4.9318	4.9321	4.9243	4.9268	183876.0
2009-06-19 09:20:00	AAPL	Stock	4.9268	4.9268	4.9214	4.9214	308000.0
2009-06-19 09:25:00	AAPL	Stock	4.9196	4.9321	4.9196	4.9293	799736.0
2009-06-19 09:30:00	AAPL	Stock	4.9289	4.9357	4.9143	4.9279	23117556.0
2009-06-19 09:35:00	AAPL	Stock	4.9282	4.9361	4.9025	4.917	20232772.0
2009-06-19 09:40:00	AAPL	Stock	4.9171	4.9393	4.9157	4.9393	17406956.0
2009-06-19 09:45:00	AAPL	Stock	4.9379	4.9429	4.9307	4.9346	13375712.0
2009-06-19 09:50:00	AAPL	Stock	4.9343	4.9561	4.9325	4.9443	22312276.0
2009-06-19 09:55:00	AAPL	Stock	4.9439	4.9575	4.9379	4.9518	14103264.0
2009-06-19 10:00:00	AAPL	Stock	4.9514	4.96	4.9504	4.9554	11045412.0
2009-06-19 10:05:00	AAPL	Stock	4.9554	4.9586	4.9429	4.9568	8992844.0
2009-06-19 10:10:00	AAPL	Stock	4.9564	4.9568	4.9468	4.9518	8253504.0
2009-06-19 10:15:00	AAPL	Stock	4.9521	4.9693	4.9511	4.9679	16259180.0
2009-06-19 10:20:00	AAPL	Stock	4.9682	4.9689	4.9593	4.9664	10049872.0
2009-06-19 10:25:00	AAPL	Stock	4.9654	4.9657	4.95	4.9504	7467796.0
2009-06-19 10:30:00	AAPL	Stock	4.9507	4.9643	4.9504	4.9582	5611872.0
2009-06-19 10:35:00	AAPL	Stock	4.9575	4.9582	4.9511	4.9511	4248468.0
2009-06-19 10:40:00	AAPL	Stock	4.9511	4.9611	4.9464	4.9607	7392056.0
2009-06-19 10:45:00	AAPL	Stock	4.9606	4.9632	4.9593	4.9632	3604160.0
2009-06-19 10:50:00	AAPL	Stock	4.9632	4.9632	4.9554	4.9607	4761064.0
2009-06-19 10:55:00	AAPL	Stock	4.9604	4.9614	4.9536	4.9552	3667020.0
2009-06-19 11:00:00	AAPL	Stock	4.9557	4.9564	4.9496	4.9529	5248376.0
2009-06-19 11:05:00	AAPL	Stock	4.9529	4.9532	4.9439	4.9495	7896812.0
2009-06-19 11:10:00	AAPL	Stock	4.949	4.9532	4.9457	4.9464	3879848.0
2009-06-19 11:15:00	AAPL	Stock	4.9466	4.9475	4.9443	4.9464	4820620.0

> showing 50 of 314,313 rows — these rows as CSV

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