PREVIEW / stock_30min / 2010-03-31

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-31.parquet
  size:    1.4 MB
  rows:    75,604
  symbols: 3,479

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-03-31 04:00:00	AAPL	Stock	8.4446	8.4546	8.4446	8.4546	8400.0
2010-03-31 04:30:00	AAPL	Stock	8.4543	8.4546	8.4471	8.4518	17920.0
2010-03-31 05:00:00	AAPL	Stock	8.4546	8.4618	8.4546	8.4618	27160.0
2010-03-31 05:30:00	AAPL	Stock	8.4618	8.4618	8.4618	8.4618	3220.0
2010-03-31 06:30:00	AAPL	Stock	8.445	8.4618	8.4396	8.4568	29680.0
2010-03-31 07:00:00	AAPL	Stock	8.4611	8.4614	8.44	8.4407	84392.0
2010-03-31 07:30:00	AAPL	Stock	8.4393	8.45	8.4393	8.4496	29400.0
2010-03-31 08:00:00	AAPL	Stock	8.4475	8.4475	8.3879	8.3929	1638728.0
2010-03-31 08:30:00	AAPL	Stock	8.3925	8.3968	8.3764	8.3968	1014524.0
2010-03-31 09:00:00	AAPL	Stock	8.3964	8.4175	8.3929	8.4125	1013376.0
2010-03-31 09:30:00	AAPL	Stock	8.4104	8.4504	8.3946	8.42	73252732.0
2010-03-31 10:00:00	AAPL	Stock	8.4196	8.4268	8.3986	8.4211	39819976.0
2010-03-31 10:30:00	AAPL	Stock	8.42	8.4361	8.4036	8.4186	32841480.0
2010-03-31 11:00:00	AAPL	Stock	8.4179	8.4204	8.4071	8.4136	13910652.0
2010-03-31 11:30:00	AAPL	Stock	8.4125	8.4282	8.4111	8.4196	15400924.0
2010-03-31 12:00:00	AAPL	Stock	8.4196	8.4273	8.415	8.4196	8360492.0
2010-03-31 12:30:00	AAPL	Stock	8.4196	8.4275	8.4154	8.4193	7460460.0
2010-03-31 13:00:00	AAPL	Stock	8.42	8.4354	8.4157	8.4346	11403812.0
2010-03-31 13:30:00	AAPL	Stock	8.435	8.4357	8.4232	8.4289	10920560.0
2010-03-31 14:00:00	AAPL	Stock	8.4285	8.4411	8.4275	8.4373	11303236.0
2010-03-31 14:30:00	AAPL	Stock	8.4371	8.4393	8.4	8.4075	23945012.0
2010-03-31 15:00:00	AAPL	Stock	8.4062	8.4125	8.3882	8.4025	31397968.0
2010-03-31 15:30:00	AAPL	Stock	8.4025	8.4057	8.3736	8.39	48097756.0
2010-03-31 16:00:00	AAPL	Stock	8.39	8.4145	8.3661	8.4064	20282752.0
2010-03-31 16:30:00	AAPL	Stock	8.4064	8.4225	8.3904	8.4043	3623424.0
2010-03-31 17:00:00	AAPL	Stock	8.3904	8.4089	8.3904	8.3982	1048908.0
2010-03-31 17:30:00	AAPL	Stock	8.4057	8.4096	8.4	8.4071	239932.0
2010-03-31 18:00:00	AAPL	Stock	8.4071	8.4089	8.3929	8.4089	216020.0
2010-03-31 18:30:00	AAPL	Stock	8.4089	8.4125	8.4043	8.4125	157080.0
2010-03-31 19:00:00	AAPL	Stock	8.4107	8.4107	8.4	8.4029	65940.0
2010-03-31 19:30:00	AAPL	Stock	8.4018	8.4043	8.4	8.4043	225708.0
2010-03-31 08:00:00	MSFT	Stock	29.64	29.84	29.64	29.77	5918.0
2010-03-31 08:30:00	MSFT	Stock	29.72	29.73	29.7	29.7	6211.0
2010-03-31 09:00:00	MSFT	Stock	29.69	29.7	29.61	29.65	20396.0
2010-03-31 09:30:00	MSFT	Stock	29.65	29.72	29.43	29.48	4722288.0
2010-03-31 10:00:00	MSFT	Stock	29.48	29.61	29.48	29.56	2689030.0
2010-03-31 10:30:00	MSFT	Stock	29.56	29.645	29.54	29.64	2259258.0
2010-03-31 11:00:00	MSFT	Stock	29.64	29.66	29.52	29.535	1854313.0
2010-03-31 11:30:00	MSFT	Stock	29.53	29.61	29.53	29.55	1693481.0
2010-03-31 12:00:00	MSFT	Stock	29.55	29.56	29.48	29.495	4078804.0
2010-03-31 12:30:00	MSFT	Stock	29.499	29.53	29.46	29.49	3525261.0
2010-03-31 13:00:00	MSFT	Stock	29.48	29.5	29.43	29.45	2042235.0
2010-03-31 13:30:00	MSFT	Stock	29.449	29.48	29.42	29.46	1942007.0
2010-03-31 14:00:00	MSFT	Stock	29.45	29.48	29.36	29.405	10576136.0
2010-03-31 14:30:00	MSFT	Stock	29.405	29.42	29.23	29.25	3824825.0
2010-03-31 15:00:00	MSFT	Stock	29.249	29.28	29.17	29.26	6474589.0
2010-03-31 15:30:00	MSFT	Stock	29.255	29.33	29.23	29.26	8878259.0
2010-03-31 16:00:00	MSFT	Stock	29.26	29.461	29.2	29.272	6457276.0
2010-03-31 16:30:00	MSFT	Stock	29.268	29.77	29.268	29.27	551898.0
2010-03-31 17:00:00	MSFT	Stock	29.27	29.37	29.27	29.37	210175.0

> showing 50 of 75,604 rows — these rows as CSV

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