PREVIEW / stock_30min / 2011-09-09

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-09.parquet
  size:    1.4 MB
  rows:    73,991
  symbols: 3,490

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
2011-09-09 04:30:00	AAPL	Stock	13.6732	13.6732	13.6732	13.6732	4200.0
2011-09-09 05:00:00	AAPL	Stock	13.7046	13.7046	13.7046	13.7046	5600.0
2011-09-09 05:30:00	AAPL	Stock	13.7021	13.7054	13.6786	13.6786	61600.0
2011-09-09 06:00:00	AAPL	Stock	13.7211	13.7211	13.7211	13.7211	2800.0
2011-09-09 06:30:00	AAPL	Stock	13.6818	13.7046	13.6679	13.6679	67760.0
2011-09-09 07:00:00	AAPL	Stock	13.6682	13.7004	13.6607	13.6929	161448.0
2011-09-09 07:30:00	AAPL	Stock	13.6825	13.6893	13.6721	13.6893	205800.0
2011-09-09 08:00:00	AAPL	Stock	13.6893	13.8032	13.6875	13.7975	1816024.0
2011-09-09 08:30:00	AAPL	Stock	13.805	13.805	13.755	13.755	580580.0
2011-09-09 09:00:00	AAPL	Stock	13.7514	13.7536	13.6846	13.7218	2452016.0
2011-09-09 09:30:00	AAPL	Stock	13.715	13.7586	13.6654	13.7129	74546780.0
2011-09-09 10:00:00	AAPL	Stock	13.715	13.7768	13.7064	13.7739	36602468.0
2011-09-09 10:30:00	AAPL	Stock	13.7746	13.7857	13.7251	13.7296	36756356.0
2011-09-09 11:00:00	AAPL	Stock	13.7293	13.7389	13.625	13.6386	41231092.0
2011-09-09 11:30:00	AAPL	Stock	13.6389	13.6685	13.5236	13.5343	50378580.0
2011-09-09 12:00:00	AAPL	Stock	13.5329	13.5625	13.5104	13.5386	39010216.0
2011-09-09 12:30:00	AAPL	Stock	13.5379	13.5543	13.4707	13.5489	34734728.0
2011-09-09 13:00:00	AAPL	Stock	13.5496	13.5543	13.4971	13.5168	24525872.0
2011-09-09 13:30:00	AAPL	Stock	13.5168	13.5179	13.4196	13.4343	30011100.0
2011-09-09 14:00:00	AAPL	Stock	13.4321	13.4761	13.4196	13.4418	28840504.0
2011-09-09 14:30:00	AAPL	Stock	13.4411	13.4821	13.4196	13.4554	31750180.0
2011-09-09 15:00:00	AAPL	Stock	13.4518	13.4625	13.3936	13.3964	43749300.0
2011-09-09 15:30:00	AAPL	Stock	13.3971	13.4961	13.3957	13.4664	69084596.0
2011-09-09 16:00:00	AAPL	Stock	13.4682	13.7233	13.4682	13.5079	13062308.0
2011-09-09 16:30:00	AAPL	Stock	13.5011	13.5089	13.4087	13.4843	312312.0
2011-09-09 17:00:00	AAPL	Stock	13.4879	13.4929	13.4771	13.4771	160048.0
2011-09-09 17:30:00	AAPL	Stock	13.4854	13.4857	13.4771	13.4771	45080.0
2011-09-09 18:00:00	AAPL	Stock	13.4818	13.4818	13.4725	13.4732	115332.0
2011-09-09 18:30:00	AAPL	Stock	13.4743	13.475	13.465	13.465	40292.0
2011-09-09 19:00:00	AAPL	Stock	13.4643	13.4643	13.45	13.4554	81424.0
2011-09-09 19:30:00	AAPL	Stock	13.4564	13.4643	13.4489	13.4643	91308.0
2011-09-09 06:30:00	MSFT	Stock	26.0	26.01	26.0	26.01	500.0
2011-09-09 07:00:00	MSFT	Stock	26.18	26.18	26.18	26.18	100.0
2011-09-09 07:30:00	MSFT	Stock	26.11	26.12	26.11	26.12	678.0
2011-09-09 08:00:00	MSFT	Stock	26.19	26.22	26.11	26.22	8406.0
2011-09-09 08:30:00	MSFT	Stock	26.22	26.28	26.19	26.19	2628.0
2011-09-09 09:00:00	MSFT	Stock	26.18	26.18	25.96	26.02	67672.0
2011-09-09 09:30:00	MSFT	Stock	26.03	26.18	25.8	25.94	5401907.0
2011-09-09 10:00:00	MSFT	Stock	25.94	26.1	25.91	26.03	4154257.0
2011-09-09 10:30:00	MSFT	Stock	26.03	26.05	25.88	25.94	4367086.0
2011-09-09 11:00:00	MSFT	Stock	25.94	26.01	25.68	25.71	7043147.0
2011-09-09 11:30:00	MSFT	Stock	25.718	25.73	25.5	25.58	4834361.0
2011-09-09 12:00:00	MSFT	Stock	25.59	25.68	25.55	25.64	2858896.0
2011-09-09 12:30:00	MSFT	Stock	25.64	25.76	25.58	25.73	3841762.0
2011-09-09 13:00:00	MSFT	Stock	25.722	25.8	25.63	25.67	2230682.0
2011-09-09 13:30:00	MSFT	Stock	25.67	25.68	25.58	25.63	2203845.0
2011-09-09 14:00:00	MSFT	Stock	25.63	25.73	25.62	25.64	2136139.0
2011-09-09 14:30:00	MSFT	Stock	25.64	25.75	25.58	25.6	3256371.0
2011-09-09 15:00:00	MSFT	Stock	25.6	25.7	25.55	25.64	3336733.0
2011-09-09 15:30:00	MSFT	Stock	25.64	25.88	25.63	25.73	13170062.0

> showing 50 of 73,991 rows — these rows as CSV

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