PREVIEW / stock_30min / 2013-02-07

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-07.parquet
  size:    1.4 MB
  rows:    74,509
  symbols: 3,467

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
2013-02-07 04:30:00	AAPL	Stock	16.2964	16.2964	16.2964	16.2964	13944.0
2013-02-07 05:00:00	AAPL	Stock	16.2957	16.2982	16.2957	16.2982	14560.0
2013-02-07 06:30:00	AAPL	Stock	16.3296	16.33	16.2857	16.3286	45360.0
2013-02-07 07:00:00	AAPL	Stock	16.3036	16.3036	16.2643	16.2643	38472.0
2013-02-07 07:30:00	AAPL	Stock	16.2679	16.2679	16.2411	16.2411	134652.0
2013-02-07 08:00:00	AAPL	Stock	16.2493	16.2896	16.1964	16.2286	1212092.0
2013-02-07 08:30:00	AAPL	Stock	16.2286	16.645	16.2179	16.5814	20504260.0
2013-02-07 09:00:00	AAPL	Stock	16.5736	16.6071	16.5039	16.545	7649068.0
2013-02-07 09:30:00	AAPL	Stock	16.5471	16.5629	16.2965	16.3446	86836036.0
2013-02-07 10:00:00	AAPL	Stock	16.345	16.4054	16.2389	16.2996	52746512.0
2013-02-07 10:30:00	AAPL	Stock	16.2996	16.3254	16.2186	16.2843	37312072.0
2013-02-07 11:00:00	AAPL	Stock	16.2843	16.3864	16.2611	16.3557	35312536.0
2013-02-07 11:30:00	AAPL	Stock	16.3529	16.365	16.2871	16.3144	21170604.0
2013-02-07 12:00:00	AAPL	Stock	16.3146	16.4321	16.3079	16.4233	28686812.0
2013-02-07 12:30:00	AAPL	Stock	16.4268	16.4614	16.3871	16.4157	29412208.0
2013-02-07 13:00:00	AAPL	Stock	16.4136	16.4257	16.3421	16.3804	17423980.0
2013-02-07 13:30:00	AAPL	Stock	16.3839	16.3839	16.3232	16.3571	16817556.0
2013-02-07 14:00:00	AAPL	Stock	16.3571	16.3857	16.2996	16.3206	16898364.0
2013-02-07 14:30:00	AAPL	Stock	16.3214	16.3693	16.3114	16.361	15900472.0
2013-02-07 15:00:00	AAPL	Stock	16.3607	16.3696	16.3161	16.3232	16715888.0
2013-02-07 15:30:00	AAPL	Stock	16.325	16.7857	16.275	16.7232	256643576.0
2013-02-07 16:00:00	AAPL	Stock	16.7221	16.7464	16.3059	16.6679	19948096.0
2013-02-07 16:30:00	AAPL	Stock	16.6686	16.7215	16.3229	16.6936	1687280.0
2013-02-07 17:00:00	AAPL	Stock	16.6936	16.7339	16.6936	16.7068	1299032.0
2013-02-07 17:30:00	AAPL	Stock	16.7107	16.7268	16.7107	16.7264	220948.0
2013-02-07 18:00:00	AAPL	Stock	16.7279	16.7321	16.6932	16.7104	464968.0
2013-02-07 18:30:00	AAPL	Stock	16.7121	16.7146	16.6989	16.7143	467684.0
2013-02-07 19:00:00	AAPL	Stock	16.7136	16.7404	16.7129	16.7257	508564.0
2013-02-07 19:30:00	AAPL	Stock	16.7296	16.7411	16.725	16.7411	380688.0
2013-02-07 07:00:00	MSFT	Stock	27.33	27.33	27.26	27.26	739.0
2013-02-07 08:00:00	MSFT	Stock	27.37	27.38	27.37	27.38	10622.0
2013-02-07 08:30:00	MSFT	Stock	27.38	27.4	27.38	27.38	34256.0
2013-02-07 09:00:00	MSFT	Stock	27.38	27.39	27.37	27.37	8400.0
2013-02-07 09:30:00	MSFT	Stock	27.35	27.39	27.25	27.305	3970190.0
2013-02-07 10:00:00	MSFT	Stock	27.31	27.32	27.1	27.175	5229153.0
2013-02-07 10:30:00	MSFT	Stock	27.18	27.2	27.12	27.168	3699166.0
2013-02-07 11:00:00	MSFT	Stock	27.17	27.2	27.11	27.14	2402197.0
2013-02-07 11:30:00	MSFT	Stock	27.135	27.17	27.12	27.145	2195431.0
2013-02-07 12:00:00	MSFT	Stock	27.15	27.2	27.14	27.186	1619104.0
2013-02-07 12:30:00	MSFT	Stock	27.19	27.22	27.17	27.2	1185998.0
2013-02-07 13:00:00	MSFT	Stock	27.195	27.25	27.16	27.244	1703723.0
2013-02-07 13:30:00	MSFT	Stock	27.25	27.28	27.2	27.26	1390414.0
2013-02-07 14:00:00	MSFT	Stock	27.265	27.29	27.19	27.228	1820185.0
2013-02-07 14:30:00	MSFT	Stock	27.228	27.23	27.175	27.225	1380692.0
2013-02-07 15:00:00	MSFT	Stock	27.226	27.24	27.16	27.175	2117401.0
2013-02-07 15:30:00	MSFT	Stock	27.18	27.29	27.15	27.29	5265954.0
2013-02-07 16:00:00	MSFT	Stock	27.28	27.46	27.168	27.39	3055897.0
2013-02-07 16:30:00	MSFT	Stock	27.39	27.42	27.17	27.37	47044.0
2013-02-07 17:00:00	MSFT	Stock	27.39	27.4	27.31	27.32	16300.0
2013-02-07 17:30:00	MSFT	Stock	27.31	27.33	27.29	27.33	11559.0

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

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