PREVIEW / stock_30min / 2011-08-12

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-12.parquet
  size:    1.4 MB
  rows:    74,840
  symbols: 3,526

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-08-12 04:00:00	AAPL	Stock	13.2561	13.2561	13.2304	13.2304	22400.0
2011-08-12 04:30:00	AAPL	Stock	13.2839	13.3036	13.2839	13.3025	47600.0
2011-08-12 05:00:00	AAPL	Stock	13.3025	13.3025	13.3025	13.3025	2800.0
2011-08-12 05:30:00	AAPL	Stock	13.3893	13.3893	13.3893	13.3893	22400.0
2011-08-12 06:00:00	AAPL	Stock	13.4136	13.4136	13.3796	13.3796	14000.0
2011-08-12 06:30:00	AAPL	Stock	13.3546	13.3546	13.3546	13.3546	2800.0
2011-08-12 07:00:00	AAPL	Stock	13.3496	13.4093	13.3393	13.3929	484876.0
2011-08-12 07:30:00	AAPL	Stock	13.4061	13.4496	13.3789	13.4375	568876.0
2011-08-12 08:00:00	AAPL	Stock	13.4411	13.4411	13.3879	13.4	2473912.0
2011-08-12 08:30:00	AAPL	Stock	13.4168	13.485	13.4168	13.4696	3141740.0
2011-08-12 09:00:00	AAPL	Stock	13.4689	13.5357	13.4525	13.5	3357088.0
2011-08-12 09:30:00	AAPL	Stock	13.5	13.5268	13.3932	13.4293	94347176.0
2011-08-12 10:00:00	AAPL	Stock	13.4266	13.4804	13.3654	13.4643	63557760.0
2011-08-12 10:30:00	AAPL	Stock	13.4639	13.5279	13.4507	13.4686	55298488.0
2011-08-12 11:00:00	AAPL	Stock	13.4675	13.4975	13.4518	13.4854	25593288.0
2011-08-12 11:30:00	AAPL	Stock	13.485	13.5586	13.4754	13.5357	45688916.0
2011-08-12 12:00:00	AAPL	Stock	13.5361	13.5446	13.4864	13.51	24212776.0
2011-08-12 12:30:00	AAPL	Stock	13.5066	13.5125	13.4564	13.4864	22389276.0
2011-08-12 13:00:00	AAPL	Stock	13.4836	13.5139	13.4771	13.5	17058524.0
2011-08-12 13:30:00	AAPL	Stock	13.5	13.5265	13.4854	13.5082	17329060.0
2011-08-12 14:00:00	AAPL	Stock	13.5089	13.5179	13.4414	13.4654	30580424.0
2011-08-12 14:30:00	AAPL	Stock	13.4654	13.4821	13.4475	13.4607	27238932.0
2011-08-12 15:00:00	AAPL	Stock	13.4636	13.4807	13.4507	13.4597	25146156.0
2011-08-12 15:30:00	AAPL	Stock	13.4618	13.4689	13.4329	13.4593	52420368.0
2011-08-12 16:00:00	AAPL	Stock	13.4582	13.5	13.4518	13.4554	9874676.0
2011-08-12 16:30:00	AAPL	Stock	13.4582	13.4732	13.4557	13.4646	797888.0
2011-08-12 17:00:00	AAPL	Stock	13.4643	13.4679	13.4611	13.4646	144732.0
2011-08-12 17:30:00	AAPL	Stock	13.4675	13.4686	13.4646	13.4675	80808.0
2011-08-12 18:00:00	AAPL	Stock	13.4675	13.4714	13.4607	13.47	73080.0
2011-08-12 18:30:00	AAPL	Stock	13.4704	13.48	13.4643	13.4714	63196.0
2011-08-12 19:00:00	AAPL	Stock	13.4714	13.475	13.4682	13.4721	80892.0
2011-08-12 19:30:00	AAPL	Stock	13.4721	13.4821	13.4693	13.4821	166880.0
2011-08-12 08:00:00	MSFT	Stock	25.2	25.24	25.17	25.18	3071.0
2011-08-12 08:30:00	MSFT	Stock	25.25	25.25	25.19	25.22	17792.0
2011-08-12 09:00:00	MSFT	Stock	25.22	25.27	25.13	25.13	145870.0
2011-08-12 09:30:00	MSFT	Stock	25.14	25.16	24.74	24.85	10817177.0
2011-08-12 10:00:00	MSFT	Stock	24.86	25.035	24.65	25.01	10102278.0
2011-08-12 10:30:00	MSFT	Stock	25.0	25.1	24.92	25.01	4586530.0
2011-08-12 11:00:00	MSFT	Stock	25.02	25.11	24.94	25.096	2997379.0
2011-08-12 11:30:00	MSFT	Stock	25.1	25.27	25.07	25.245	2925318.0
2011-08-12 12:00:00	MSFT	Stock	25.245	25.265	25.08	25.13	2490994.0
2011-08-12 12:30:00	MSFT	Stock	25.13	25.21	25.1	25.18	2798833.0
2011-08-12 13:00:00	MSFT	Stock	25.18	25.23	25.15	25.164	2246267.0
2011-08-12 13:30:00	MSFT	Stock	25.17	25.28	25.12	25.269	2830059.0
2011-08-12 14:00:00	MSFT	Stock	25.27	25.335	25.08	25.18	3260141.0
2011-08-12 14:30:00	MSFT	Stock	25.18	25.22	25.09	25.145	3518198.0
2011-08-12 15:00:00	MSFT	Stock	25.145	25.25	25.14	25.18	3165111.0
2011-08-12 15:30:00	MSFT	Stock	25.18	25.19	25.04	25.09	8530286.0
2011-08-12 16:00:00	MSFT	Stock	25.09	25.2	25.034	25.12	4026962.0
2011-08-12 16:30:00	MSFT	Stock	25.1	25.17	25.1	25.16	100986.0

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

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