PREVIEW / stock_5min / 2010-09-13

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-09-13.parquet
  size:    4.8 MB
  rows:    333,448
  symbols: 3,492

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
2010-09-13 04:00:00	AAPL	Stock	9.4214	9.425	9.4214	9.425	5600.0
2010-09-13 04:25:00	AAPL	Stock	9.4464	9.4464	9.4464	9.4464	2800.0
2010-09-13 05:35:00	AAPL	Stock	9.4664	9.4664	9.4664	9.4664	2800.0
2010-09-13 05:40:00	AAPL	Stock	9.4479	9.4479	9.4479	9.4479	2800.0
2010-09-13 06:25:00	AAPL	Stock	9.4607	9.4607	9.4607	9.4607	2800.0
2010-09-13 06:30:00	AAPL	Stock	9.4679	9.4679	9.4679	9.4679	11200.0
2010-09-13 07:00:00	AAPL	Stock	9.4814	9.4814	9.4804	9.4804	11200.0
2010-09-13 07:05:00	AAPL	Stock	9.4804	9.4807	9.4804	9.4804	51800.0
2010-09-13 07:25:00	AAPL	Stock	9.4821	9.4893	9.4821	9.4893	70420.0
2010-09-13 07:30:00	AAPL	Stock	9.4843	9.4875	9.4843	9.4875	5600.0
2010-09-13 07:35:00	AAPL	Stock	9.4893	9.4893	9.4875	9.4875	28000.0
2010-09-13 07:40:00	AAPL	Stock	9.4886	9.4961	9.4886	9.4929	36400.0
2010-09-13 07:45:00	AAPL	Stock	9.4857	9.4857	9.4857	9.4857	12600.0
2010-09-13 07:50:00	AAPL	Stock	9.4857	9.4889	9.4843	9.4889	14000.0
2010-09-13 07:55:00	AAPL	Stock	9.475	9.475	9.4732	9.475	25900.0
2010-09-13 08:00:00	AAPL	Stock	9.4732	9.4925	9.4725	9.4868	360052.0
2010-09-13 08:05:00	AAPL	Stock	9.4921	9.4939	9.4825	9.4939	279664.0
2010-09-13 08:10:00	AAPL	Stock	9.4954	9.5136	9.4954	9.5086	391972.0
2010-09-13 08:15:00	AAPL	Stock	9.5057	9.5057	9.4986	9.5036	118916.0
2010-09-13 08:20:00	AAPL	Stock	9.5036	9.5057	9.4929	9.4929	173376.0
2010-09-13 08:25:00	AAPL	Stock	9.4929	9.4996	9.4821	9.4896	142380.0
2010-09-13 08:30:00	AAPL	Stock	9.4975	9.5054	9.4857	9.4929	286244.0
2010-09-13 08:35:00	AAPL	Stock	9.4979	9.505	9.4964	9.505	119000.0
2010-09-13 08:40:00	AAPL	Stock	9.505	9.5068	9.5	9.5043	84924.0
2010-09-13 08:45:00	AAPL	Stock	9.5043	9.505	9.4968	9.5	168700.0
2010-09-13 08:50:00	AAPL	Stock	9.5	9.5	9.4929	9.4932	153944.0
2010-09-13 08:55:00	AAPL	Stock	9.4921	9.4946	9.4911	9.4936	67200.0
2010-09-13 09:00:00	AAPL	Stock	9.4914	9.4946	9.4911	9.4911	50792.0
2010-09-13 09:05:00	AAPL	Stock	9.4911	9.5018	9.4911	9.4968	182952.0
2010-09-13 09:10:00	AAPL	Stock	9.4961	9.4989	9.4961	9.4964	110152.0
2010-09-13 09:15:00	AAPL	Stock	9.4961	9.4961	9.4836	9.4836	156520.0
2010-09-13 09:20:00	AAPL	Stock	9.4836	9.4893	9.475	9.4768	128044.0
2010-09-13 09:25:00	AAPL	Stock	9.4857	9.5054	9.4857	9.4982	615636.0
2010-09-13 09:30:00	AAPL	Stock	9.4982	9.5171	9.4914	9.5136	18339720.0
2010-09-13 09:35:00	AAPL	Stock	9.5136	9.5393	9.5075	9.5371	16899316.0
2010-09-13 09:40:00	AAPL	Stock	9.5368	9.5711	9.5368	9.5543	18932116.0
2010-09-13 09:45:00	AAPL	Stock	9.5554	9.5714	9.5475	9.5479	14039340.0
2010-09-13 09:50:00	AAPL	Stock	9.5486	9.5611	9.5429	9.5546	7832860.0
2010-09-13 09:55:00	AAPL	Stock	9.5543	9.5554	9.5386	9.5457	6733916.0
2010-09-13 10:00:00	AAPL	Stock	9.545	9.5636	9.545	9.5611	6856584.0
2010-09-13 10:05:00	AAPL	Stock	9.5618	9.5714	9.5594	9.5661	11078704.0
2010-09-13 10:10:00	AAPL	Stock	9.5658	9.5707	9.5561	9.5593	5244764.0
2010-09-13 10:15:00	AAPL	Stock	9.5597	9.565	9.5589	9.5625	4236232.0
2010-09-13 10:20:00	AAPL	Stock	9.5625	9.5664	9.5589	9.5644	3918712.0
2010-09-13 10:25:00	AAPL	Stock	9.5657	9.5657	9.5589	9.5625	3064488.0
2010-09-13 10:30:00	AAPL	Stock	9.5629	9.5693	9.5607	9.5679	8089844.0
2010-09-13 10:35:00	AAPL	Stock	9.5679	9.5771	9.5632	9.5739	9233532.0
2010-09-13 10:40:00	AAPL	Stock	9.5742	9.5814	9.5693	9.5788	8883896.0
2010-09-13 10:45:00	AAPL	Stock	9.5779	9.5793	9.5696	9.5754	4909016.0
2010-09-13 10:50:00	AAPL	Stock	9.5754	9.5768	9.5657	9.5684	4424896.0

> showing 50 of 333,448 rows — these rows as CSV

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