PREVIEW / stock_5min / 2012-09-25

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-09-25.parquet
  size:    5.0 MB
  rows:    330,123
  symbols: 3,501

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-25 04:00:00	AAPL	Stock	24.5625	24.5893	24.5539	24.575	437472.0
2012-09-25 04:15:00	AAPL	Stock	24.5718	24.5718	24.5718	24.5718	2800.0
2012-09-25 04:30:00	AAPL	Stock	24.5464	24.5464	24.5464	24.5464	11200.0
2012-09-25 04:35:00	AAPL	Stock	24.5536	24.5536	24.5536	24.5536	28000.0
2012-09-25 04:45:00	AAPL	Stock	24.5571	24.5679	24.5571	24.5679	5600.0
2012-09-25 05:45:00	AAPL	Stock	24.515	24.5161	24.515	24.5161	16800.0
2012-09-25 06:00:00	AAPL	Stock	24.5357	24.5357	24.5357	24.5357	27860.0
2012-09-25 06:10:00	AAPL	Stock	24.5629	24.5679	24.5629	24.5679	12740.0
2012-09-25 06:15:00	AAPL	Stock	24.5679	24.5679	24.5679	24.5679	5600.0
2012-09-25 06:25:00	AAPL	Stock	24.5679	24.5679	24.5679	24.5679	2800.0
2012-09-25 06:40:00	AAPL	Stock	24.5675	24.5714	24.5675	24.5714	36400.0
2012-09-25 07:00:00	AAPL	Stock	24.5714	24.5714	24.5357	24.5357	61600.0
2012-09-25 07:05:00	AAPL	Stock	24.5446	24.5446	24.5264	24.5275	61600.0
2012-09-25 07:10:00	AAPL	Stock	24.5143	24.5461	24.5143	24.545	80892.0
2012-09-25 07:15:00	AAPL	Stock	24.545	24.56	24.5411	24.56	33600.0
2012-09-25 07:20:00	AAPL	Stock	24.5661	24.5893	24.5661	24.5821	59304.0
2012-09-25 07:25:00	AAPL	Stock	24.5811	24.5811	24.5657	24.5657	48720.0
2012-09-25 07:30:00	AAPL	Stock	24.5804	24.5854	24.5804	24.5839	53200.0
2012-09-25 07:35:00	AAPL	Stock	24.5771	24.5771	24.5679	24.5679	19600.0
2012-09-25 07:40:00	AAPL	Stock	24.5707	24.5707	24.5446	24.5446	11200.0
2012-09-25 07:45:00	AAPL	Stock	24.5446	24.5446	24.5271	24.5321	72800.0
2012-09-25 07:50:00	AAPL	Stock	24.5357	24.5464	24.5357	24.5464	25200.0
2012-09-25 07:55:00	AAPL	Stock	24.5393	24.5393	24.5179	24.5321	33600.0
2012-09-25 08:00:00	AAPL	Stock	24.5357	24.55	24.5093	24.5268	297584.0
2012-09-25 08:05:00	AAPL	Stock	24.5268	24.5368	24.5225	24.5354	212716.0
2012-09-25 08:10:00	AAPL	Stock	24.5354	24.5518	24.5354	24.5464	110264.0
2012-09-25 08:15:00	AAPL	Stock	24.5464	24.5571	24.5368	24.5571	240520.0
2012-09-25 08:20:00	AAPL	Stock	24.5593	24.5761	24.5536	24.5679	418628.0
2012-09-25 08:25:00	AAPL	Stock	24.5679	24.5836	24.5679	24.5814	196336.0
2012-09-25 08:30:00	AAPL	Stock	24.5836	24.6021	24.5836	24.6007	141540.0
2012-09-25 08:35:00	AAPL	Stock	24.6064	24.6071	24.5846	24.5904	263592.0
2012-09-25 08:40:00	AAPL	Stock	24.5846	24.6029	24.5839	24.6018	196392.0
2012-09-25 08:45:00	AAPL	Stock	24.6018	24.6314	24.6018	24.6311	310856.0
2012-09-25 08:50:00	AAPL	Stock	24.6332	24.6568	24.6254	24.6332	496468.0
2012-09-25 08:55:00	AAPL	Stock	24.6339	24.6493	24.625	24.6425	100212.0
2012-09-25 09:00:00	AAPL	Stock	24.6418	24.6429	24.6214	24.6214	184884.0
2012-09-25 09:05:00	AAPL	Stock	24.6236	24.6286	24.6011	24.6161	120400.0
2012-09-25 09:10:00	AAPL	Stock	24.6082	24.6082	24.5857	24.5864	138936.0
2012-09-25 09:15:00	AAPL	Stock	24.5814	24.5964	24.5696	24.5696	304640.0
2012-09-25 09:20:00	AAPL	Stock	24.5679	24.5982	24.5679	24.5982	106960.0
2012-09-25 09:25:00	AAPL	Stock	24.5925	24.5986	24.5646	24.5718	306516.0
2012-09-25 09:30:00	AAPL	Stock	24.5807	24.6	24.5	24.5171	14430024.0
2012-09-25 09:35:00	AAPL	Stock	24.5118	24.6404	24.5118	24.6404	14900312.0
2012-09-25 09:40:00	AAPL	Stock	24.6361	24.7421	24.6361	24.7046	20449268.0
2012-09-25 09:45:00	AAPL	Stock	24.7036	24.7102	24.6514	24.6736	8503516.0
2012-09-25 09:50:00	AAPL	Stock	24.6736	24.7061	24.6311	24.6325	6694240.0
2012-09-25 09:55:00	AAPL	Stock	24.6325	24.6618	24.6075	24.6129	6196652.0
2012-09-25 10:00:00	AAPL	Stock	24.6171	24.6557	24.5468	24.5979	12982788.0
2012-09-25 10:05:00	AAPL	Stock	24.5996	24.6143	24.5714	24.5796	5466608.0
2012-09-25 10:10:00	AAPL	Stock	24.5796	24.6564	24.5796	24.6536	6847904.0

> showing 50 of 330,123 rows — these rows as CSV

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