PREVIEW / stock_5min / 2012-06-20

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-06-20.parquet
  size:    4.8 MB
  rows:    327,908
  symbols: 3,489

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-20 06:20:00	AAPL	Stock	20.9732	20.9732	20.9732	20.9732	2800.0
2012-06-20 07:00:00	AAPL	Stock	20.9989	20.9989	20.9911	20.9911	8400.0
2012-06-20 07:05:00	AAPL	Stock	21.0	21.0	21.0	21.0	2800.0
2012-06-20 07:10:00	AAPL	Stock	21.0039	21.0114	21.0039	21.0114	14000.0
2012-06-20 07:15:00	AAPL	Stock	21.0007	21.0007	21.0	21.0	39200.0
2012-06-20 07:20:00	AAPL	Stock	21.0171	21.0214	21.0171	21.0214	19600.0
2012-06-20 07:25:00	AAPL	Stock	21.0179	21.025	21.0179	21.025	16800.0
2012-06-20 07:30:00	AAPL	Stock	21.0268	21.0311	21.0268	21.0311	12180.0
2012-06-20 07:35:00	AAPL	Stock	21.0275	21.0275	21.0275	21.0275	2800.0
2012-06-20 07:40:00	AAPL	Stock	21.0271	21.0271	21.0271	21.0271	2800.0
2012-06-20 07:50:00	AAPL	Stock	21.0107	21.0107	21.0107	21.0107	11200.0
2012-06-20 07:55:00	AAPL	Stock	21.0139	21.0143	21.0039	21.0039	19600.0
2012-06-20 08:00:00	AAPL	Stock	21.0	21.0321	20.9646	20.9711	133672.0
2012-06-20 08:05:00	AAPL	Stock	20.9543	20.9643	20.9507	20.9643	34244.0
2012-06-20 08:10:00	AAPL	Stock	20.9679	20.9786	20.9679	20.9768	44212.0
2012-06-20 08:15:00	AAPL	Stock	20.9768	20.9821	20.9761	20.9821	57316.0
2012-06-20 08:20:00	AAPL	Stock	20.9818	20.9846	20.9807	20.9846	30240.0
2012-06-20 08:25:00	AAPL	Stock	20.9957	20.9964	20.9882	20.9946	19600.0
2012-06-20 08:30:00	AAPL	Stock	20.9868	20.9868	20.975	20.9786	38080.0
2012-06-20 08:35:00	AAPL	Stock	20.9786	20.9886	20.9786	20.9886	33600.0
2012-06-20 08:40:00	AAPL	Stock	20.9882	20.9932	20.9882	20.9889	22400.0
2012-06-20 08:45:00	AAPL	Stock	20.9846	20.9946	20.9846	20.9939	93212.0
2012-06-20 08:50:00	AAPL	Stock	20.9889	20.9893	20.9857	20.9857	35280.0
2012-06-20 08:55:00	AAPL	Stock	20.9857	20.9911	20.9857	20.9911	16520.0
2012-06-20 09:00:00	AAPL	Stock	20.9914	20.9914	20.9875	20.99	125356.0
2012-06-20 09:05:00	AAPL	Stock	20.9896	21.0143	20.9896	21.0136	359828.0
2012-06-20 09:10:00	AAPL	Stock	21.0132	21.0139	20.9982	20.9982	110684.0
2012-06-20 09:15:00	AAPL	Stock	20.9946	20.9986	20.9925	20.9954	58548.0
2012-06-20 09:20:00	AAPL	Stock	21.0004	21.0046	20.9996	20.9996	12600.0
2012-06-20 09:25:00	AAPL	Stock	21.0036	21.0211	20.9964	21.0032	237188.0
2012-06-20 09:30:00	AAPL	Stock	21.0075	21.0446	20.9543	20.9742	9998212.0
2012-06-20 09:35:00	AAPL	Stock	20.97	20.9786	20.9325	20.9611	7353584.0
2012-06-20 09:40:00	AAPL	Stock	20.9721	20.9907	20.9546	20.9725	5533220.0
2012-06-20 09:45:00	AAPL	Stock	20.9725	20.9793	20.9304	20.9393	5848528.0
2012-06-20 09:50:00	AAPL	Stock	20.9418	20.9725	20.9371	20.96	4296740.0
2012-06-20 09:55:00	AAPL	Stock	20.9556	20.9732	20.9504	20.9589	3434676.0
2012-06-20 10:00:00	AAPL	Stock	20.9589	20.966	20.9382	20.9518	3043684.0
2012-06-20 10:05:00	AAPL	Stock	20.9521	20.9534	20.9046	20.9181	6839924.0
2012-06-20 10:10:00	AAPL	Stock	20.92	20.9525	20.9039	20.9321	5188232.0
2012-06-20 10:15:00	AAPL	Stock	20.9379	20.9589	20.9321	20.9375	3181220.0
2012-06-20 10:20:00	AAPL	Stock	20.9361	20.9529	20.9121	20.9207	2784264.0
2012-06-20 10:25:00	AAPL	Stock	20.9217	20.9396	20.9179	20.9256	1907192.0
2012-06-20 10:30:00	AAPL	Stock	20.9236	20.9321	20.8868	20.8893	5707464.0
2012-06-20 10:35:00	AAPL	Stock	20.8879	20.9104	20.8729	20.8866	4669140.0
2012-06-20 10:40:00	AAPL	Stock	20.8814	20.8814	20.8311	20.8389	8121960.0
2012-06-20 10:45:00	AAPL	Stock	20.84	20.8607	20.8339	20.8519	4956280.0
2012-06-20 10:50:00	AAPL	Stock	20.8511	20.8689	20.8318	20.8532	4368840.0
2012-06-20 10:55:00	AAPL	Stock	20.8561	20.8771	20.8536	20.87	5776512.0
2012-06-20 11:00:00	AAPL	Stock	20.8696	20.8757	20.8542	20.8679	3098172.0
2012-06-20 11:05:00	AAPL	Stock	20.8684	20.8707	20.8357	20.8404	3509744.0

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

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