PREVIEW / stock_5min / 2011-06-22

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-06-22.parquet
  size:    4.8 MB
  rows:    330,595
  symbols: 3,541

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
2011-06-22 06:05:00	AAPL	Stock	11.5939	11.5939	11.5939	11.5939	2800.0
2011-06-22 06:35:00	AAPL	Stock	11.6054	11.6054	11.6054	11.6054	2800.0
2011-06-22 06:55:00	AAPL	Stock	11.5825	11.5825	11.5821	11.5821	28000.0
2011-06-22 07:00:00	AAPL	Stock	11.5825	11.5825	11.57	11.5714	72436.0
2011-06-22 07:05:00	AAPL	Stock	11.5804	11.5814	11.5754	11.5754	69020.0
2011-06-22 07:10:00	AAPL	Stock	11.5771	11.5771	11.5714	11.5714	14000.0
2011-06-22 07:15:00	AAPL	Stock	11.5571	11.5571	11.5571	11.5571	10080.0
2011-06-22 07:20:00	AAPL	Stock	11.5543	11.5543	11.5532	11.5536	22400.0
2011-06-22 07:25:00	AAPL	Stock	11.555	11.555	11.5521	11.5521	18200.0
2011-06-22 07:30:00	AAPL	Stock	11.5607	11.5643	11.5571	11.5571	28000.0
2011-06-22 07:35:00	AAPL	Stock	11.5571	11.5571	11.5554	11.5571	33600.0
2011-06-22 07:40:00	AAPL	Stock	11.5675	11.5675	11.5661	11.5661	19600.0
2011-06-22 07:45:00	AAPL	Stock	11.5661	11.5857	11.5661	11.5843	148176.0
2011-06-22 07:50:00	AAPL	Stock	11.5832	11.6007	11.5832	11.5929	95200.0
2011-06-22 07:55:00	AAPL	Stock	11.5929	11.6007	11.5929	11.6007	56000.0
2011-06-22 08:00:00	AAPL	Stock	11.5968	11.6007	11.5836	11.6007	109648.0
2011-06-22 08:05:00	AAPL	Stock	11.6025	11.6143	11.6025	11.6125	144760.0
2011-06-22 08:10:00	AAPL	Stock	11.6143	11.6146	11.6018	11.6071	214200.0
2011-06-22 08:15:00	AAPL	Stock	11.6071	11.6071	11.5936	11.6004	52192.0
2011-06-22 08:20:00	AAPL	Stock	11.6018	11.6057	11.5964	11.6032	82040.0
2011-06-22 08:25:00	AAPL	Stock	11.5968	11.6011	11.5964	11.6011	38360.0
2011-06-22 08:30:00	AAPL	Stock	11.6	11.6036	11.5857	11.5857	98280.0
2011-06-22 08:35:00	AAPL	Stock	11.5832	11.5893	11.5714	11.5714	164724.0
2011-06-22 08:40:00	AAPL	Stock	11.5718	11.5825	11.5696	11.5696	29400.0
2011-06-22 08:45:00	AAPL	Stock	11.575	11.5811	11.575	11.5811	5600.0
2011-06-22 08:50:00	AAPL	Stock	11.5818	11.5818	11.5689	11.575	82964.0
2011-06-22 08:55:00	AAPL	Stock	11.5718	11.5807	11.5714	11.5796	109396.0
2011-06-22 09:00:00	AAPL	Stock	11.58	11.5832	11.5729	11.5821	277676.0
2011-06-22 09:05:00	AAPL	Stock	11.585	11.5893	11.5825	11.5825	61600.0
2011-06-22 09:10:00	AAPL	Stock	11.5843	11.5868	11.5839	11.5868	44940.0
2011-06-22 09:15:00	AAPL	Stock	11.5868	11.5929	11.5821	11.5821	84196.0
2011-06-22 09:20:00	AAPL	Stock	11.5914	11.5914	11.5914	11.5914	2800.0
2011-06-22 09:25:00	AAPL	Stock	11.5857	11.6161	11.5839	11.6107	427476.0
2011-06-22 09:30:00	AAPL	Stock	11.6121	11.6614	11.5768	11.6604	14793184.0
2011-06-22 09:35:00	AAPL	Stock	11.6618	11.6864	11.6389	11.6847	10590412.0
2011-06-22 09:40:00	AAPL	Stock	11.6832	11.7389	11.6714	11.7329	16975588.0
2011-06-22 09:45:00	AAPL	Stock	11.7314	11.7464	11.7107	11.7393	14651644.0
2011-06-22 09:50:00	AAPL	Stock	11.7364	11.7414	11.7025	11.7132	12107060.0
2011-06-22 09:55:00	AAPL	Stock	11.7129	11.7389	11.7107	11.721	7312592.0
2011-06-22 10:00:00	AAPL	Stock	11.7211	11.7229	11.6929	11.7011	10593464.0
2011-06-22 10:05:00	AAPL	Stock	11.7016	11.7219	11.7011	11.7139	5596780.0
2011-06-22 10:10:00	AAPL	Stock	11.7141	11.7214	11.7036	11.7089	5254424.0
2011-06-22 10:15:00	AAPL	Stock	11.7086	11.7118	11.6986	11.7039	4364864.0
2011-06-22 10:20:00	AAPL	Stock	11.7036	11.7071	11.6793	11.6985	7400680.0
2011-06-22 10:25:00	AAPL	Stock	11.6986	11.7036	11.6814	11.6875	2723840.0
2011-06-22 10:30:00	AAPL	Stock	11.6907	11.7082	11.6896	11.6966	3633364.0
2011-06-22 10:35:00	AAPL	Stock	11.6936	11.6958	11.6614	11.6632	8123248.0
2011-06-22 10:40:00	AAPL	Stock	11.6653	11.6911	11.6607	11.6911	5299700.0
2011-06-22 10:45:00	AAPL	Stock	11.6911	11.6982	11.6825	11.6861	3592344.0
2011-06-22 10:50:00	AAPL	Stock	11.687	11.6936	11.6804	11.6893	3564456.0

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

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