PREVIEW / stock_5min / 2012-08-02

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-08-02.parquet
  size:    4.7 MB
  rows:    318,109
  symbols: 3,454

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-08-02 04:00:00	AAPL	Stock	21.7071	21.7071	21.7071	21.7071	2800.0
2012-08-02 04:05:00	AAPL	Stock	21.7	21.7	21.7	21.7	8400.0
2012-08-02 04:10:00	AAPL	Stock	21.7143	21.7143	21.7143	21.7143	4200.0
2012-08-02 05:55:00	AAPL	Stock	21.7321	21.75	21.7321	21.75	24360.0
2012-08-02 06:45:00	AAPL	Stock	21.7429	21.7429	21.7429	21.7429	7000.0
2012-08-02 06:55:00	AAPL	Stock	21.75	21.75	21.75	21.75	24528.0
2012-08-02 07:00:00	AAPL	Stock	21.7321	21.775	21.7321	21.75	42000.0
2012-08-02 07:05:00	AAPL	Stock	21.7643	21.7643	21.75	21.7639	19348.0
2012-08-02 07:10:00	AAPL	Stock	21.7675	21.7675	21.75	21.75	47600.0
2012-08-02 07:15:00	AAPL	Stock	21.7504	21.7504	21.7321	21.7321	50400.0
2012-08-02 07:25:00	AAPL	Stock	21.7143	21.7143	21.7075	21.7075	8960.0
2012-08-02 07:30:00	AAPL	Stock	21.7143	21.7171	21.7143	21.7171	11200.0
2012-08-02 07:35:00	AAPL	Stock	21.7407	21.7407	21.74	21.74	5600.0
2012-08-02 07:40:00	AAPL	Stock	21.7321	21.7429	21.7321	21.7396	173600.0
2012-08-02 07:45:00	AAPL	Stock	21.7396	21.7396	21.7143	21.7321	87920.0
2012-08-02 07:50:00	AAPL	Stock	21.7407	21.7768	21.7325	21.7643	66696.0
2012-08-02 07:55:00	AAPL	Stock	21.7707	21.7846	21.7686	21.7732	39480.0
2012-08-02 08:00:00	AAPL	Stock	21.7679	21.7946	21.7657	21.7939	342272.0
2012-08-02 08:05:00	AAPL	Stock	21.7911	21.7925	21.7768	21.78	200172.0
2012-08-02 08:10:00	AAPL	Stock	21.7761	21.7779	21.7575	21.7714	39480.0
2012-08-02 08:15:00	AAPL	Stock	21.7779	21.7782	21.7679	21.775	102004.0
2012-08-02 08:20:00	AAPL	Stock	21.7679	21.7832	21.7679	21.7711	109228.0
2012-08-02 08:25:00	AAPL	Stock	21.7732	21.7918	21.7679	21.7686	123564.0
2012-08-02 08:30:00	AAPL	Stock	21.7768	21.8071	21.7714	21.7732	350364.0
2012-08-02 08:35:00	AAPL	Stock	21.7857	21.7921	21.6921	21.7093	921340.0
2012-08-02 08:40:00	AAPL	Stock	21.6918	21.7018	21.6143	21.6596	563612.0
2012-08-02 08:45:00	AAPL	Stock	21.645	21.6764	21.6275	21.65	457632.0
2012-08-02 08:50:00	AAPL	Stock	21.6454	21.66	21.5704	21.5704	454300.0
2012-08-02 08:55:00	AAPL	Stock	21.57	21.58	21.5357	21.5625	676480.0
2012-08-02 09:00:00	AAPL	Stock	21.5532	21.5646	21.5275	21.5293	316540.0
2012-08-02 09:05:00	AAPL	Stock	21.5346	21.55	21.5243	21.5254	599116.0
2012-08-02 09:10:00	AAPL	Stock	21.525	21.5661	21.5182	21.5525	502432.0
2012-08-02 09:15:00	AAPL	Stock	21.5446	21.5593	21.5429	21.5457	170996.0
2012-08-02 09:20:00	AAPL	Stock	21.5446	21.5461	21.5264	21.535	167748.0
2012-08-02 09:25:00	AAPL	Stock	21.5357	21.5536	21.5261	21.5289	220052.0
2012-08-02 09:30:00	AAPL	Stock	21.53	21.5525	21.4375	21.5247	18188940.0
2012-08-02 09:35:00	AAPL	Stock	21.5257	21.5782	21.5	21.5446	10943464.0
2012-08-02 09:40:00	AAPL	Stock	21.5446	21.6396	21.5407	21.6355	8374604.0
2012-08-02 09:45:00	AAPL	Stock	21.6346	21.6691	21.6143	21.6168	6941200.0
2012-08-02 09:50:00	AAPL	Stock	21.6204	21.6607	21.5961	21.6561	5736248.0
2012-08-02 09:55:00	AAPL	Stock	21.6564	21.6946	21.6411	21.6829	6700792.0
2012-08-02 10:00:00	AAPL	Stock	21.6829	21.6836	21.6	21.6025	6128892.0
2012-08-02 10:05:00	AAPL	Stock	21.6054	21.7143	21.6004	21.7125	5127500.0
2012-08-02 10:10:00	AAPL	Stock	21.7118	21.7429	21.7105	21.7332	6082580.0
2012-08-02 10:15:00	AAPL	Stock	21.7321	21.7679	21.7275	21.7561	7343560.0
2012-08-02 10:20:00	AAPL	Stock	21.7546	21.7732	21.7279	21.7361	6167560.0
2012-08-02 10:25:00	AAPL	Stock	21.7357	21.7786	21.7257	21.7746	4531184.0
2012-08-02 10:30:00	AAPL	Stock	21.7686	21.805	21.7579	21.7693	7015232.0
2012-08-02 10:35:00	AAPL	Stock	21.7693	21.8036	21.75	21.7511	5540276.0
2012-08-02 10:40:00	AAPL	Stock	21.7539	21.7743	21.7361	21.7421	4129972.0

> showing 50 of 318,109 rows — these rows as CSV

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