PREVIEW / stock_5min / 2012-01-26

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-01-26.parquet
  size:    4.9 MB
  rows:    327,971
  symbols: 3,520

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-01-26 04:00:00	AAPL	Stock	15.9754	15.9782	15.9729	15.9782	14000.0
2012-01-26 04:20:00	AAPL	Stock	16.0	16.0	16.0	16.0	33600.0
2012-01-26 04:30:00	AAPL	Stock	16.0	16.0	16.0	16.0	16800.0
2012-01-26 04:45:00	AAPL	Stock	16.0443	16.0443	16.0382	16.0382	8400.0
2012-01-26 04:50:00	AAPL	Stock	16.0468	16.0489	16.0439	16.0439	30800.0
2012-01-26 04:55:00	AAPL	Stock	16.0411	16.0411	16.0354	16.0382	36400.0
2012-01-26 05:00:00	AAPL	Stock	16.0304	16.0382	16.0304	16.0382	14000.0
2012-01-26 05:05:00	AAPL	Stock	16.0382	16.0382	16.0382	16.0382	11200.0
2012-01-26 05:10:00	AAPL	Stock	16.0461	16.0461	16.0321	16.0321	8400.0
2012-01-26 05:15:00	AAPL	Stock	16.0304	16.0304	16.0304	16.0304	8400.0
2012-01-26 05:20:00	AAPL	Stock	16.0268	16.0268	16.0268	16.0268	2800.0
2012-01-26 05:25:00	AAPL	Stock	16.0268	16.0321	16.0268	16.0268	11200.0
2012-01-26 05:40:00	AAPL	Stock	16.0321	16.0321	16.0321	16.0321	2800.0
2012-01-26 05:50:00	AAPL	Stock	16.0214	16.0214	16.0179	16.0179	11200.0
2012-01-26 05:55:00	AAPL	Stock	16.0179	16.0179	16.0179	16.0179	5600.0
2012-01-26 06:00:00	AAPL	Stock	16.0321	16.0321	16.0321	16.0321	8400.0
2012-01-26 06:05:00	AAPL	Stock	16.0321	16.0321	16.0321	16.0321	5600.0
2012-01-26 06:10:00	AAPL	Stock	16.0379	16.0379	16.0304	16.0304	11200.0
2012-01-26 06:15:00	AAPL	Stock	16.0304	16.0357	16.0304	16.0357	19600.0
2012-01-26 06:30:00	AAPL	Stock	16.0214	16.0214	16.0214	16.0214	14000.0
2012-01-26 06:35:00	AAPL	Stock	16.0179	16.0179	16.0179	16.0179	2800.0
2012-01-26 07:00:00	AAPL	Stock	16.0179	16.0179	16.0064	16.0107	27300.0
2012-01-26 07:05:00	AAPL	Stock	16.0171	16.0314	16.0154	16.0282	151200.0
2012-01-26 07:10:00	AAPL	Stock	16.0143	16.0143	16.0107	16.0107	53480.0
2012-01-26 07:15:00	AAPL	Stock	16.0111	16.0214	16.0089	16.0214	33152.0
2012-01-26 07:20:00	AAPL	Stock	16.0179	16.0214	16.0179	16.0214	16800.0
2012-01-26 07:25:00	AAPL	Stock	16.0179	16.0214	16.0125	16.0214	21560.0
2012-01-26 07:30:00	AAPL	Stock	16.0175	16.0179	16.0175	16.0179	6160.0
2012-01-26 07:35:00	AAPL	Stock	16.0132	16.0132	16.0132	16.0132	11144.0
2012-01-26 07:40:00	AAPL	Stock	16.0143	16.0171	16.0143	16.0171	33600.0
2012-01-26 07:45:00	AAPL	Stock	16.0125	16.0179	16.0043	16.0043	56700.0
2012-01-26 07:50:00	AAPL	Stock	16.0139	16.0357	16.0136	16.0357	452480.0
2012-01-26 07:55:00	AAPL	Stock	16.0196	16.03	16.0179	16.0214	146272.0
2012-01-26 08:00:00	AAPL	Stock	16.025	16.0321	16.0179	16.0214	183232.0
2012-01-26 08:05:00	AAPL	Stock	16.0214	16.0214	16.0143	16.0143	160468.0
2012-01-26 08:10:00	AAPL	Stock	16.0107	16.0232	16.0107	16.0196	55748.0
2012-01-26 08:15:00	AAPL	Stock	15.9514	16.025	15.9514	16.025	428792.0
2012-01-26 08:20:00	AAPL	Stock	16.0246	16.025	16.0179	16.0232	51996.0
2012-01-26 08:25:00	AAPL	Stock	16.0232	16.0286	16.0182	16.0182	48608.0
2012-01-26 08:30:00	AAPL	Stock	16.0186	16.035	16.0186	16.035	20608.0
2012-01-26 08:35:00	AAPL	Stock	16.0321	16.0321	16.0196	16.0214	57064.0
2012-01-26 08:40:00	AAPL	Stock	16.0207	16.0282	16.0179	16.0268	48412.0
2012-01-26 08:45:00	AAPL	Stock	16.0264	16.0264	16.0179	16.0179	18144.0
2012-01-26 08:50:00	AAPL	Stock	16.0179	16.0207	16.0118	16.0118	33600.0
2012-01-26 08:55:00	AAPL	Stock	16.0107	16.0118	15.9904	15.9929	276864.0
2012-01-26 09:00:00	AAPL	Stock	15.9929	15.9929	15.9696	15.9814	229600.0
2012-01-26 09:05:00	AAPL	Stock	15.9814	15.9821	15.9646	15.9757	128436.0
2012-01-26 09:10:00	AAPL	Stock	15.9754	15.9754	15.9404	15.9536	144256.0
2012-01-26 09:15:00	AAPL	Stock	15.9536	15.975	15.9536	15.975	182812.0
2012-01-26 09:20:00	AAPL	Stock	15.975	15.9786	15.9664	15.9707	120456.0

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

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