PREVIEW / stock_30min / 2012-11-13

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-13.parquet
  size:    1.4 MB
  rows:    73,533
  symbols: 3,457

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
2012-11-13 04:00:00	AAPL	Stock	19.2957	19.2957	19.2696	19.2857	14000.0
2012-11-13 04:30:00	AAPL	Stock	19.2696	19.2696	19.2696	19.2696	7616.0
2012-11-13 05:00:00	AAPL	Stock	19.2696	19.2821	19.2679	19.2821	11200.0
2012-11-13 05:30:00	AAPL	Stock	19.2821	19.2857	19.2679	19.2857	28000.0
2012-11-13 06:00:00	AAPL	Stock	19.2714	19.2714	19.2214	19.2464	47600.0
2012-11-13 06:30:00	AAPL	Stock	19.2857	19.3071	19.2857	19.3036	24640.0
2012-11-13 07:00:00	AAPL	Stock	19.3143	19.3554	19.2918	19.2918	138628.0
2012-11-13 07:30:00	AAPL	Stock	19.2868	19.3071	19.25	19.2954	343476.0
2012-11-13 08:00:00	AAPL	Stock	19.2946	19.3282	19.2625	19.3036	516040.0
2012-11-13 08:30:00	AAPL	Stock	19.2914	19.3	19.2564	19.2682	778736.0
2012-11-13 09:00:00	AAPL	Stock	19.2675	19.2764	19.2321	19.2589	1535688.0
2012-11-13 09:30:00	AAPL	Stock	19.2511	19.4818	19.1557	19.4629	88392332.0
2012-11-13 10:00:00	AAPL	Stock	19.4629	19.5461	19.3757	19.4525	50353492.0
2012-11-13 10:30:00	AAPL	Stock	19.4518	19.5296	19.2857	19.5048	53590964.0
2012-11-13 11:00:00	AAPL	Stock	19.5054	19.5329	19.4479	19.5	27727336.0
2012-11-13 11:30:00	AAPL	Stock	19.5032	19.6211	19.4679	19.6107	37899876.0
2012-11-13 12:00:00	AAPL	Stock	19.6089	19.6239	19.5064	19.5343	23775024.0
2012-11-13 12:30:00	AAPL	Stock	19.5343	19.5675	19.4789	19.5107	20859608.0
2012-11-13 13:00:00	AAPL	Stock	19.5168	19.5771	19.4929	19.5329	16857456.0
2012-11-13 13:30:00	AAPL	Stock	19.5407	19.6339	19.5129	19.6297	20615616.0
2012-11-13 14:00:00	AAPL	Stock	19.6321	19.66	19.5557	19.5846	28494172.0
2012-11-13 14:30:00	AAPL	Stock	19.5846	19.6136	19.5021	19.525	24174304.0
2012-11-13 15:00:00	AAPL	Stock	19.5279	19.56	19.4107	19.4275	33142844.0
2012-11-13 15:30:00	AAPL	Stock	19.4214	19.4857	19.3571	19.3793	49654164.0
2012-11-13 16:00:00	AAPL	Stock	19.3786	19.4614	19.3763	19.4179	30228660.0
2012-11-13 16:30:00	AAPL	Stock	19.4232	19.4504	19.4214	19.4314	481740.0
2012-11-13 17:00:00	AAPL	Stock	19.4321	19.4604	19.3782	19.4461	7888580.0
2012-11-13 17:30:00	AAPL	Stock	19.4368	19.4464	19.4357	19.4357	80388.0
2012-11-13 18:00:00	AAPL	Stock	19.435	19.4446	19.435	19.4368	49840.0
2012-11-13 18:30:00	AAPL	Stock	19.4393	19.4393	19.4286	19.4321	60200.0
2012-11-13 19:00:00	AAPL	Stock	19.4393	19.4393	19.4286	19.4357	90440.0
2012-11-13 19:30:00	AAPL	Stock	19.4321	19.4593	19.4321	19.4504	116368.0
2012-11-13 04:00:00	MSFT	Stock	27.99	27.99	27.99	27.99	300.0
2012-11-13 05:30:00	MSFT	Stock	27.81	27.81	27.7	27.7	1050.0
2012-11-13 06:00:00	MSFT	Stock	27.7	27.7	27.7	27.7	2000.0
2012-11-13 06:30:00	MSFT	Stock	27.72	27.77	27.38	27.38	93740.0
2012-11-13 07:00:00	MSFT	Stock	27.45	27.6	27.23	27.3	332459.0
2012-11-13 07:30:00	MSFT	Stock	27.3	27.35	27.14	27.18	1042953.0
2012-11-13 08:00:00	MSFT	Stock	27.18	27.44	27.05	27.15	2135978.0
2012-11-13 08:30:00	MSFT	Stock	27.15	27.15	26.87	26.95	1983973.0
2012-11-13 09:00:00	MSFT	Stock	26.96	27.04	26.91	27.02	2941175.0
2012-11-13 09:30:00	MSFT	Stock	27.02	27.25	26.75	27.17	29177827.0
2012-11-13 10:00:00	MSFT	Stock	27.17	27.23	27.06	27.102	10886285.0
2012-11-13 10:30:00	MSFT	Stock	27.1	27.14	27.02	27.1	9471592.0
2012-11-13 11:00:00	MSFT	Stock	27.09	27.27	27.09	27.21	9211783.0
2012-11-13 11:30:00	MSFT	Stock	27.21	27.3	27.13	27.25	8402113.0
2012-11-13 12:00:00	MSFT	Stock	27.26	27.29	27.11	27.152	5550197.0
2012-11-13 12:30:00	MSFT	Stock	27.16	27.22	27.11	27.19	3803220.0
2012-11-13 13:00:00	MSFT	Stock	27.19	27.24	27.135	27.23	3702639.0
2012-11-13 13:30:00	MSFT	Stock	27.23	27.29	27.19	27.245	5573432.0

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

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