PREVIEW / stock_30min / 2010-06-28

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-28.parquet
  size:    1.4 MB
  rows:    74,099
  symbols: 3,458

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-06-28 04:00:00	AAPL	Stock	9.5289	9.5289	9.5289	9.5289	2800.0
2010-06-28 04:30:00	AAPL	Stock	9.5646	9.5646	9.5536	9.5536	5600.0
2010-06-28 05:00:00	AAPL	Stock	9.5571	9.5571	9.5571	9.5571	32760.0
2010-06-28 06:00:00	AAPL	Stock	9.5893	9.5893	9.5893	9.5893	13048.0
2010-06-28 06:30:00	AAPL	Stock	9.5786	9.5786	9.5786	9.5786	8344.0
2010-06-28 07:00:00	AAPL	Stock	9.5625	9.5679	9.5196	9.5629	67116.0
2010-06-28 07:30:00	AAPL	Stock	9.5625	9.5625	9.5446	9.5525	119420.0
2010-06-28 08:00:00	AAPL	Stock	9.5521	9.5618	9.5018	9.5179	989716.0
2010-06-28 08:30:00	AAPL	Stock	9.5161	9.5571	9.5143	9.5143	3967208.0
2010-06-28 09:00:00	AAPL	Stock	9.5168	9.5471	9.5143	9.5336	2373840.0
2010-06-28 09:30:00	AAPL	Stock	9.5332	9.6054	9.4857	9.5611	105379232.0
2010-06-28 10:00:00	AAPL	Stock	9.5621	9.5625	9.4471	9.5	79143932.0
2010-06-28 10:30:00	AAPL	Stock	9.5	9.5439	9.4736	9.5357	42423500.0
2010-06-28 11:00:00	AAPL	Stock	9.5362	9.5761	9.5321	9.5721	39679808.0
2010-06-28 11:30:00	AAPL	Stock	9.5729	9.5929	9.5543	9.5618	29450904.0
2010-06-28 12:00:00	AAPL	Stock	9.5611	9.5832	9.5479	9.5802	21670992.0
2010-06-28 12:30:00	AAPL	Stock	9.5804	9.5861	9.5554	9.572	18872588.0
2010-06-28 13:00:00	AAPL	Stock	9.5736	9.5754	9.5268	9.5368	23854992.0
2010-06-28 13:30:00	AAPL	Stock	9.5379	9.5736	9.5211	9.5614	19342008.0
2010-06-28 14:00:00	AAPL	Stock	9.5614	9.5925	9.5461	9.5671	25962328.0
2010-06-28 14:30:00	AAPL	Stock	9.5657	9.6071	9.5493	9.5882	42039480.0
2010-06-28 15:00:00	AAPL	Stock	9.5879	9.6339	9.5779	9.5929	54455800.0
2010-06-28 15:30:00	AAPL	Stock	9.5946	9.6289	9.5789	9.5821	62057884.0
2010-06-28 16:00:00	AAPL	Stock	9.5821	9.5932	9.5393	9.585	8226372.0
2010-06-28 16:30:00	AAPL	Stock	9.5832	9.6228	9.5514	9.5786	400232.0
2010-06-28 17:00:00	AAPL	Stock	9.5786	9.5929	9.4926	9.5893	480172.0
2010-06-28 17:30:00	AAPL	Stock	9.5911	9.5911	9.5796	9.5807	132608.0
2010-06-28 18:00:00	AAPL	Stock	9.5821	9.5886	9.5786	9.5821	104272.0
2010-06-28 18:30:00	AAPL	Stock	9.5882	9.5911	9.5879	9.5879	154812.0
2010-06-28 19:00:00	AAPL	Stock	9.5825	9.5929	9.5825	9.5929	96600.0
2010-06-28 19:30:00	AAPL	Stock	9.5929	9.6036	9.5893	9.5964	187992.0
2010-06-28 04:00:00	MSFT	Stock	24.53	24.53	24.53	24.53	200.0
2010-06-28 06:30:00	MSFT	Stock	24.55	24.55	24.55	24.55	500.0
2010-06-28 07:00:00	MSFT	Stock	24.53	24.58	24.53	24.58	11200.0
2010-06-28 07:30:00	MSFT	Stock	24.58	24.58	24.56	24.57	8100.0
2010-06-28 08:00:00	MSFT	Stock	24.57	24.57	24.5	24.5	38819.0
2010-06-28 08:30:00	MSFT	Stock	24.54	24.55	24.47	24.52	58576.0
2010-06-28 09:00:00	MSFT	Stock	24.52	24.56	24.39	24.5	241425.0
2010-06-28 09:30:00	MSFT	Stock	24.5	24.52	24.12	24.15	11406665.0
2010-06-28 10:00:00	MSFT	Stock	24.15	24.46	24.14	24.4	7596823.0
2010-06-28 10:30:00	MSFT	Stock	24.4	24.52	24.34	24.49	4429876.0
2010-06-28 11:00:00	MSFT	Stock	24.485	24.6	24.48	24.58	3858880.0
2010-06-28 11:30:00	MSFT	Stock	24.58	24.61	24.49	24.535	4268685.0
2010-06-28 12:00:00	MSFT	Stock	24.53	24.56	24.39	24.465	4267618.0
2010-06-28 12:30:00	MSFT	Stock	24.47	24.515	24.405	24.501	2189527.0
2010-06-28 13:00:00	MSFT	Stock	24.509	24.53	24.45	24.5	2841050.0
2010-06-28 13:30:00	MSFT	Stock	24.5	24.5	24.43	24.46	3493363.0
2010-06-28 14:00:00	MSFT	Stock	24.455	24.46	24.37	24.39	3935382.0
2010-06-28 14:30:00	MSFT	Stock	24.39	24.43	24.34	24.4	4016801.0
2010-06-28 15:00:00	MSFT	Stock	24.4	24.46	24.27	24.27	4887461.0

> showing 50 of 74,099 rows — these rows as CSV

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