PREVIEW / stock_5min / 2012-09-06

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-09-06.parquet
  size:    4.9 MB
  rows:    332,044
  symbols: 3,480

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
2012-09-06 04:00:00	AAPL	Stock	23.9814	24.0304	23.9814	24.0304	53200.0
2012-09-06 04:05:00	AAPL	Stock	24.0357	24.0357	24.0357	24.0357	11200.0
2012-09-06 04:10:00	AAPL	Stock	24.0393	24.0393	24.0389	24.0389	8400.0
2012-09-06 04:30:00	AAPL	Stock	24.0486	24.0486	24.0486	24.0486	2800.0
2012-09-06 04:35:00	AAPL	Stock	24.0464	24.0464	24.0464	24.0464	10192.0
2012-09-06 05:00:00	AAPL	Stock	24.0629	24.0757	24.0629	24.0757	11200.0
2012-09-06 05:25:00	AAPL	Stock	24.0714	24.0714	24.0714	24.0714	2800.0
2012-09-06 05:30:00	AAPL	Stock	24.0668	24.0668	24.0668	24.0668	2800.0
2012-09-06 05:50:00	AAPL	Stock	24.0714	24.0714	24.0714	24.0714	6720.0
2012-09-06 06:10:00	AAPL	Stock	24.0714	24.0786	24.0714	24.0786	5600.0
2012-09-06 06:20:00	AAPL	Stock	24.0732	24.0732	24.0732	24.0732	2800.0
2012-09-06 06:50:00	AAPL	Stock	24.075	24.075	24.075	24.075	2800.0
2012-09-06 06:55:00	AAPL	Stock	24.0846	24.0846	24.0846	24.0846	2800.0
2012-09-06 07:00:00	AAPL	Stock	24.0714	24.0714	23.9846	24.0357	53284.0
2012-09-06 07:05:00	AAPL	Stock	24.0321	24.0357	24.0311	24.0339	22400.0
2012-09-06 07:10:00	AAPL	Stock	24.0357	24.0457	24.0236	24.045	44800.0
2012-09-06 07:15:00	AAPL	Stock	24.045	24.045	24.0432	24.0432	21000.0
2012-09-06 07:20:00	AAPL	Stock	24.0361	24.0429	24.0361	24.0364	8400.0
2012-09-06 07:25:00	AAPL	Stock	24.0254	24.0254	24.0254	24.0254	7812.0
2012-09-06 07:30:00	AAPL	Stock	24.0332	24.0332	24.0332	24.0332	8400.0
2012-09-06 07:35:00	AAPL	Stock	24.0221	24.0282	24.0039	24.005	50400.0
2012-09-06 07:40:00	AAPL	Stock	24.0107	24.0107	23.9821	24.0	50232.0
2012-09-06 07:45:00	AAPL	Stock	23.9975	24.0071	23.9975	24.0036	19768.0
2012-09-06 07:50:00	AAPL	Stock	24.0046	24.0136	24.0046	24.0136	41664.0
2012-09-06 07:55:00	AAPL	Stock	24.0186	24.0329	24.0186	24.0329	47600.0
2012-09-06 08:00:00	AAPL	Stock	24.0286	24.0336	24.0182	24.0254	215544.0
2012-09-06 08:05:00	AAPL	Stock	24.0221	24.0261	24.0082	24.0082	102760.0
2012-09-06 08:10:00	AAPL	Stock	24.0046	24.0046	23.9857	23.9929	106456.0
2012-09-06 08:15:00	AAPL	Stock	23.9993	24.0	23.9561	23.98	465360.0
2012-09-06 08:20:00	AAPL	Stock	23.9643	24.0071	23.9643	23.9918	162008.0
2012-09-06 08:25:00	AAPL	Stock	24.0018	24.0043	23.9825	23.9946	136976.0
2012-09-06 08:30:00	AAPL	Stock	23.99	24.02	23.9754	23.9843	482944.0
2012-09-06 08:35:00	AAPL	Stock	23.9889	24.0107	23.9679	24.0	457268.0
2012-09-06 08:40:00	AAPL	Stock	23.9946	24.0286	23.99	24.0107	293188.0
2012-09-06 08:45:00	AAPL	Stock	24.0089	24.0125	23.9964	23.9975	117600.0
2012-09-06 08:50:00	AAPL	Stock	23.9932	24.0	23.9861	23.9861	141400.0
2012-09-06 08:55:00	AAPL	Stock	23.9868	24.0125	23.9868	24.0071	177884.0
2012-09-06 09:00:00	AAPL	Stock	24.0071	24.0071	23.9964	23.9964	222012.0
2012-09-06 09:05:00	AAPL	Stock	23.9993	24.0054	23.9964	24.0054	108472.0
2012-09-06 09:10:00	AAPL	Stock	24.0129	24.0318	24.0118	24.0318	201432.0
2012-09-06 09:15:00	AAPL	Stock	24.0286	24.0314	24.0061	24.0061	181972.0
2012-09-06 09:20:00	AAPL	Stock	24.0132	24.0186	24.0107	24.0171	50232.0
2012-09-06 09:25:00	AAPL	Stock	24.0132	24.0439	24.0132	24.0436	567784.0
2012-09-06 09:30:00	AAPL	Stock	24.0454	24.0786	24.0089	24.073	19027344.0
2012-09-06 09:35:00	AAPL	Stock	24.0714	24.0743	24.0186	24.0218	8022756.0
2012-09-06 09:40:00	AAPL	Stock	24.0279	24.0357	23.9571	23.9846	12451376.0
2012-09-06 09:45:00	AAPL	Stock	23.985	24.0232	23.9789	24.0118	7136668.0
2012-09-06 09:50:00	AAPL	Stock	24.0089	24.0357	24.0007	24.0007	6141604.0
2012-09-06 09:55:00	AAPL	Stock	24.0036	24.0193	23.9829	23.9961	4205628.0
2012-09-06 10:00:00	AAPL	Stock	23.9961	24.06	23.9946	24.0379	7375620.0

> showing 50 of 332,044 rows — these rows as CSV

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