PREVIEW / stock_30min / 2010-01-07

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-07.parquet
  size:    1.4 MB
  rows:    74,167
  symbols: 3,444

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-01-07 06:30:00	AAPL	Stock	7.5357	7.5361	7.5357	7.5361	5600.0
2010-01-07 07:00:00	AAPL	Stock	7.5532	7.5532	7.5429	7.5482	54600.0
2010-01-07 07:30:00	AAPL	Stock	7.5518	7.5518	7.5414	7.5414	269920.0
2010-01-07 08:00:00	AAPL	Stock	7.5496	7.55	7.5354	7.55	870884.0
2010-01-07 08:30:00	AAPL	Stock	7.5468	7.5961	7.5464	7.5761	2236948.0
2010-01-07 09:00:00	AAPL	Stock	7.5754	7.5846	7.5607	7.5607	1275596.0
2010-01-07 09:30:00	AAPL	Stock	7.5625	7.5714	7.4836	7.5068	103311544.0
2010-01-07 10:00:00	AAPL	Stock	7.5093	7.5229	7.4743	7.4979	58525768.0
2010-01-07 10:30:00	AAPL	Stock	7.4984	7.5518	7.4875	7.5379	46291140.0
2010-01-07 11:00:00	AAPL	Stock	7.5382	7.5464	7.5146	7.5261	26888092.0
2010-01-07 11:30:00	AAPL	Stock	7.5265	7.5293	7.5071	7.5225	14309288.0
2010-01-07 12:00:00	AAPL	Stock	7.5232	7.5457	7.5207	7.5264	18319896.0
2010-01-07 12:30:00	AAPL	Stock	7.5257	7.5414	7.5129	7.515	14573916.0
2010-01-07 13:00:00	AAPL	Stock	7.5146	7.5154	7.495	7.5132	19835844.0
2010-01-07 13:30:00	AAPL	Stock	7.5132	7.5179	7.4821	7.4864	19636736.0
2010-01-07 14:00:00	AAPL	Stock	7.4854	7.5054	7.4729	7.4729	29115632.0
2010-01-07 14:30:00	AAPL	Stock	7.4743	7.5107	7.4661	7.5077	33865804.0
2010-01-07 15:00:00	AAPL	Stock	7.5079	7.5082	7.4843	7.49	25137168.0
2010-01-07 15:30:00	AAPL	Stock	7.4907	7.5218	7.4868	7.5207	45425408.0
2010-01-07 16:00:00	AAPL	Stock	7.5211	7.5243	7.5107	7.52	8889720.0
2010-01-07 16:30:00	AAPL	Stock	7.5207	7.5261	7.5156	7.5261	211400.0
2010-01-07 17:00:00	AAPL	Stock	7.5207	7.5207	7.5104	7.5104	250432.0
2010-01-07 17:30:00	AAPL	Stock	7.5161	7.5161	7.5071	7.5071	241948.0
2010-01-07 18:00:00	AAPL	Stock	7.5089	7.5186	7.5089	7.515	284312.0
2010-01-07 18:30:00	AAPL	Stock	7.5179	7.5243	7.5161	7.5161	95256.0
2010-01-07 19:00:00	AAPL	Stock	7.5143	7.5236	7.5143	7.5229	41524.0
2010-01-07 19:30:00	AAPL	Stock	7.5214	7.5239	7.5168	7.5239	101192.0
2010-01-07 07:00:00	MSFT	Stock	30.64	30.64	30.63	30.63	1100.0
2010-01-07 07:30:00	MSFT	Stock	30.69	30.69	30.69	30.69	1300.0
2010-01-07 08:00:00	MSFT	Stock	30.68	30.72	30.64	30.72	6175.0
2010-01-07 08:30:00	MSFT	Stock	30.71	30.71	30.66	30.67	4066.0
2010-01-07 09:00:00	MSFT	Stock	30.67	30.72	30.6	30.61	12084.0
2010-01-07 09:30:00	MSFT	Stock	30.61	30.7	30.4	30.42	5467459.0
2010-01-07 10:00:00	MSFT	Stock	30.43	30.51	30.41	30.46	3505115.0
2010-01-07 10:30:00	MSFT	Stock	30.47	30.58	30.45	30.49	3300294.0
2010-01-07 11:00:00	MSFT	Stock	30.49	30.51	30.41	30.43	2674529.0
2010-01-07 11:30:00	MSFT	Stock	30.43	30.44	30.19	30.21	5282806.0
2010-01-07 12:00:00	MSFT	Stock	30.21	30.35	30.19	30.28	3406563.0
2010-01-07 12:30:00	MSFT	Stock	30.29	30.31	30.21	30.268	2476498.0
2010-01-07 13:00:00	MSFT	Stock	30.265	30.44	30.26	30.4	2607026.0
2010-01-07 13:30:00	MSFT	Stock	30.39	30.44	30.36	30.385	1921320.0
2010-01-07 14:00:00	MSFT	Stock	30.39	30.4	30.26	30.31	3106207.0
2010-01-07 14:30:00	MSFT	Stock	30.31	30.38	30.3	30.305	2040783.0
2010-01-07 15:00:00	MSFT	Stock	30.3	30.42	30.21	30.384	3720046.0
2010-01-07 15:30:00	MSFT	Stock	30.385	30.48	30.38	30.48	5804150.0
2010-01-07 16:00:00	MSFT	Stock	30.48	30.5	30.241	30.5	4463133.0
2010-01-07 16:30:00	MSFT	Stock	30.397	30.46	30.396	30.45	53504.0
2010-01-07 17:00:00	MSFT	Stock	30.44	30.77	30.44	30.46	1000.0
2010-01-07 17:30:00	MSFT	Stock	30.46	30.5	30.46	30.5	4350.0
2010-01-07 18:00:00	MSFT	Stock	30.46	30.46	30.46	30.46	1833.0

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

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