PREVIEW / stock_5min / 2012-06-25

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-06-25.parquet
  size:    4.8 MB
  rows:    327,018
  symbols: 3,517

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-06-25 04:00:00	AAPL	Stock	20.7893	20.7893	20.6607	20.6607	27580.0
2012-06-25 04:35:00	AAPL	Stock	20.6964	20.6964	20.6964	20.6964	2800.0
2012-06-25 05:15:00	AAPL	Stock	20.6611	20.6611	20.6611	20.6611	5600.0
2012-06-25 05:45:00	AAPL	Stock	20.6611	20.6611	20.6611	20.6611	7840.0
2012-06-25 07:00:00	AAPL	Stock	20.6729	20.6764	20.6729	20.6764	5600.0
2012-06-25 07:05:00	AAPL	Stock	20.6786	20.6786	20.6696	20.6696	11200.0
2012-06-25 07:15:00	AAPL	Stock	20.6696	20.6696	20.6518	20.6539	11200.0
2012-06-25 07:20:00	AAPL	Stock	20.6607	20.6607	20.6607	20.6607	2800.0
2012-06-25 07:25:00	AAPL	Stock	20.6625	20.6625	20.6607	20.6607	15400.0
2012-06-25 07:30:00	AAPL	Stock	20.6536	20.6536	20.6536	20.6536	2800.0
2012-06-25 07:35:00	AAPL	Stock	20.66	20.66	20.66	20.66	2800.0
2012-06-25 07:40:00	AAPL	Stock	20.6575	20.6579	20.6575	20.6579	5600.0
2012-06-25 07:50:00	AAPL	Stock	20.6686	20.6696	20.6686	20.6696	16800.0
2012-06-25 07:55:00	AAPL	Stock	20.6786	20.6786	20.6743	20.6768	19600.0
2012-06-25 08:00:00	AAPL	Stock	20.6764	20.6764	20.6507	20.6507	253260.0
2012-06-25 08:05:00	AAPL	Stock	20.6475	20.6475	20.6171	20.6257	233324.0
2012-06-25 08:10:00	AAPL	Stock	20.6321	20.6468	20.6211	20.6218	105000.0
2012-06-25 08:15:00	AAPL	Stock	20.6343	20.6343	20.6182	20.6254	48160.0
2012-06-25 08:20:00	AAPL	Stock	20.6318	20.65	20.6271	20.6429	67200.0
2012-06-25 08:25:00	AAPL	Stock	20.6361	20.6493	20.6357	20.6425	42168.0
2012-06-25 08:30:00	AAPL	Stock	20.6429	20.6514	20.6393	20.6393	21700.0
2012-06-25 08:35:00	AAPL	Stock	20.6407	20.6468	20.6339	20.6339	68516.0
2012-06-25 08:40:00	AAPL	Stock	20.6379	20.65	20.6375	20.65	21700.0
2012-06-25 08:45:00	AAPL	Stock	20.65	20.6554	20.6475	20.6554	27720.0
2012-06-25 08:50:00	AAPL	Stock	20.6554	20.6607	20.645	20.6571	138600.0
2012-06-25 08:55:00	AAPL	Stock	20.6496	20.6607	20.645	20.6589	42700.0
2012-06-25 09:00:00	AAPL	Stock	20.6557	20.6693	20.6504	20.6671	73220.0
2012-06-25 09:05:00	AAPL	Stock	20.6629	20.6671	20.6571	20.6671	16800.0
2012-06-25 09:10:00	AAPL	Stock	20.6632	20.6664	20.6607	20.6643	22960.0
2012-06-25 09:15:00	AAPL	Stock	20.655	20.6554	20.6532	20.6536	37464.0
2012-06-25 09:20:00	AAPL	Stock	20.6468	20.6536	20.6468	20.6536	31500.0
2012-06-25 09:25:00	AAPL	Stock	20.6518	20.6521	20.6179	20.6179	463904.0
2012-06-25 09:30:00	AAPL	Stock	20.6196	20.6857	20.6179	20.6436	6805372.0
2012-06-25 09:35:00	AAPL	Stock	20.6482	20.7071	20.6429	20.7036	6477828.0
2012-06-25 09:40:00	AAPL	Stock	20.7067	20.7068	20.6268	20.6539	6142332.0
2012-06-25 09:45:00	AAPL	Stock	20.6501	20.6732	20.6414	20.6711	3581340.0
2012-06-25 09:50:00	AAPL	Stock	20.6657	20.675	20.5714	20.5918	7832524.0
2012-06-25 09:55:00	AAPL	Stock	20.5914	20.6154	20.5821	20.6114	3977932.0
2012-06-25 10:00:00	AAPL	Stock	20.6087	20.6339	20.5996	20.6025	4395524.0
2012-06-25 10:05:00	AAPL	Stock	20.6029	20.6243	20.5736	20.5771	3502660.0
2012-06-25 10:10:00	AAPL	Stock	20.5789	20.6161	20.5768	20.61	3374084.0
2012-06-25 10:15:00	AAPL	Stock	20.6057	20.6057	20.5511	20.5754	5927292.0
2012-06-25 10:20:00	AAPL	Stock	20.5779	20.58	20.5132	20.5211	8772512.0
2012-06-25 10:25:00	AAPL	Stock	20.5211	20.5406	20.5046	20.5318	6087424.0
2012-06-25 10:30:00	AAPL	Stock	20.5296	20.5607	20.5193	20.5375	3929884.0
2012-06-25 10:35:00	AAPL	Stock	20.5325	20.5357	20.5018	20.5317	4012428.0
2012-06-25 10:40:00	AAPL	Stock	20.5321	20.5321	20.4911	20.5179	4929344.0
2012-06-25 10:45:00	AAPL	Stock	20.5179	20.55	20.5018	20.5304	3572940.0
2012-06-25 10:50:00	AAPL	Stock	20.5371	20.5625	20.5314	20.5603	2759316.0
2012-06-25 10:55:00	AAPL	Stock	20.5561	20.5611	20.5289	20.5401	2521064.0

> showing 50 of 327,018 rows — these rows as CSV

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