PREVIEW / stock_5min / 2013-04-03

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-04-03.parquet
  size:    5.1 MB
  rows:    336,264
  symbols: 3,484

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
2013-04-03 04:00:00	AAPL	Stock	15.4	15.4	15.4	15.4	5488.0
2013-04-03 04:20:00	AAPL	Stock	15.4107	15.4107	15.4107	15.4107	5600.0
2013-04-03 06:50:00	AAPL	Stock	15.4	15.4	15.4	15.4	8344.0
2013-04-03 06:55:00	AAPL	Stock	15.3964	15.3993	15.3929	15.3929	8400.0
2013-04-03 07:00:00	AAPL	Stock	15.3929	15.3929	15.3929	15.3929	2800.0
2013-04-03 07:10:00	AAPL	Stock	15.3929	15.3932	15.3929	15.3929	11200.0
2013-04-03 07:15:00	AAPL	Stock	15.4018	15.4018	15.4018	15.4018	2800.0
2013-04-03 07:25:00	AAPL	Stock	15.4036	15.4036	15.4036	15.4036	2800.0
2013-04-03 07:30:00	AAPL	Stock	15.4211	15.4214	15.4211	15.4214	5600.0
2013-04-03 07:35:00	AAPL	Stock	15.4189	15.4214	15.4018	15.4036	33600.0
2013-04-03 07:40:00	AAPL	Stock	15.4054	15.4054	15.4054	15.4054	6720.0
2013-04-03 07:50:00	AAPL	Stock	15.41	15.4386	15.41	15.4386	114100.0
2013-04-03 07:55:00	AAPL	Stock	15.4357	15.4425	15.4357	15.4389	77616.0
2013-04-03 08:00:00	AAPL	Stock	15.4321	15.4425	15.3982	15.4421	203168.0
2013-04-03 08:05:00	AAPL	Stock	15.25	15.4418	15.25	15.4121	213304.0
2013-04-03 08:10:00	AAPL	Stock	15.4129	15.4204	15.4025	15.4118	165732.0
2013-04-03 08:15:00	AAPL	Stock	15.4107	15.4121	15.3497	15.3957	275548.0
2013-04-03 08:20:00	AAPL	Stock	15.3936	15.4286	15.3929	15.4164	159236.0
2013-04-03 08:25:00	AAPL	Stock	15.4018	15.4136	15.3929	15.3929	116480.0
2013-04-03 08:30:00	AAPL	Stock	15.3932	15.3971	15.3893	15.3893	12600.0
2013-04-03 08:35:00	AAPL	Stock	15.3929	15.4132	15.3929	15.4043	89684.0
2013-04-03 08:40:00	AAPL	Stock	15.4114	15.4129	15.4114	15.4129	17976.0
2013-04-03 08:45:00	AAPL	Stock	15.4129	15.4129	15.4054	15.4093	74760.0
2013-04-03 08:50:00	AAPL	Stock	15.4036	15.4036	15.3929	15.3929	122640.0
2013-04-03 08:55:00	AAPL	Stock	15.3932	15.3993	15.3821	15.3821	130452.0
2013-04-03 09:00:00	AAPL	Stock	15.3921	15.3921	15.3829	15.3829	18368.0
2013-04-03 09:05:00	AAPL	Stock	15.3804	15.3882	15.3771	15.3882	50484.0
2013-04-03 09:10:00	AAPL	Stock	15.3886	15.4014	15.3886	15.3961	101892.0
2013-04-03 09:15:00	AAPL	Stock	15.3982	15.4	15.3911	15.3911	42560.0
2013-04-03 09:20:00	AAPL	Stock	15.3986	15.4086	15.3968	15.4071	108920.0
2013-04-03 09:25:00	AAPL	Stock	15.3497	15.4207	15.3497	15.4207	450828.0
2013-04-03 09:30:00	AAPL	Stock	15.4143	15.5418	15.3793	15.5007	17906924.0
2013-04-03 09:35:00	AAPL	Stock	15.5014	15.5144	15.4164	15.4753	9243976.0
2013-04-03 09:40:00	AAPL	Stock	15.4761	15.5286	15.4525	15.4993	8043504.0
2013-04-03 09:45:00	AAPL	Stock	15.4971	15.5589	15.4914	15.5479	10403092.0
2013-04-03 09:50:00	AAPL	Stock	15.5489	15.561	15.5054	15.5212	6879152.0
2013-04-03 09:55:00	AAPL	Stock	15.5226	15.5354	15.4761	15.5354	5520060.0
2013-04-03 10:00:00	AAPL	Stock	15.5321	15.5429	15.4762	15.4936	6671784.0
2013-04-03 10:05:00	AAPL	Stock	15.4979	15.5171	15.4936	15.5109	4594996.0
2013-04-03 10:10:00	AAPL	Stock	15.5091	15.5557	15.4968	15.5375	6921460.0
2013-04-03 10:15:00	AAPL	Stock	15.5396	15.5743	15.5161	15.5719	7900592.0
2013-04-03 10:20:00	AAPL	Stock	15.5704	15.6079	15.5454	15.59	9584988.0
2013-04-03 10:25:00	AAPL	Stock	15.5934	15.6075	15.5743	15.6029	4825576.0
2013-04-03 10:30:00	AAPL	Stock	15.6029	15.6171	15.58	15.595	6251280.0
2013-04-03 10:35:00	AAPL	Stock	15.5943	15.6043	15.5643	15.5696	6055252.0
2013-04-03 10:40:00	AAPL	Stock	15.5746	15.5786	15.5446	15.5614	6501992.0
2013-04-03 10:45:00	AAPL	Stock	15.5611	15.5818	15.555	15.575	3574368.0
2013-04-03 10:50:00	AAPL	Stock	15.5763	15.5786	15.5554	15.5582	2851016.0
2013-04-03 10:55:00	AAPL	Stock	15.5596	15.5804	15.5454	15.5464	6551160.0
2013-04-03 11:00:00	AAPL	Stock	15.55	15.5604	15.5054	15.525	7450912.0

> showing 50 of 336,264 rows — these rows as CSV

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