PREVIEW / stock_30min / 2012-06-28

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-28.parquet
  size:    1.4 MB
  rows:    75,259
  symbols: 3,506

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-06-28 04:00:00	AAPL	Stock	20.4643	20.4643	20.4021	20.4021	32200.0
2012-06-28 07:00:00	AAPL	Stock	20.4443	20.5	20.4443	20.4821	115080.0
2012-06-28 07:30:00	AAPL	Stock	20.4654	20.4654	20.4286	20.4286	86800.0
2012-06-28 08:00:00	AAPL	Stock	20.4596	20.4643	20.4107	20.4293	323652.0
2012-06-28 08:30:00	AAPL	Stock	20.4286	20.45	20.42	20.4207	233744.0
2012-06-28 09:00:00	AAPL	Stock	20.4239	20.4286	20.4104	20.4229	497112.0
2012-06-28 09:30:00	AAPL	Stock	20.4168	20.5	20.3786	20.4368	33137412.0
2012-06-28 10:00:00	AAPL	Stock	20.4393	20.4561	20.3861	20.3928	22045184.0
2012-06-28 10:30:00	AAPL	Stock	20.3893	20.3911	20.3093	20.35	27688752.0
2012-06-28 11:00:00	AAPL	Stock	20.3521	20.3521	20.3046	20.3318	17847144.0
2012-06-28 11:30:00	AAPL	Stock	20.3321	20.3704	20.3125	20.331	13906760.0
2012-06-28 12:00:00	AAPL	Stock	20.3257	20.3571	20.2886	20.3014	8629208.0
2012-06-28 12:30:00	AAPL	Stock	20.2996	20.3318	20.2832	20.3218	11621008.0
2012-06-28 13:00:00	AAPL	Stock	20.3212	20.3225	20.2621	20.2637	10651872.0
2012-06-28 13:30:00	AAPL	Stock	20.2625	20.2893	20.2243	20.2843	21763952.0
2012-06-28 14:00:00	AAPL	Stock	20.285	20.2986	20.2164	20.2182	16443588.0
2012-06-28 14:30:00	AAPL	Stock	20.2182	20.2429	20.2004	20.2221	16703708.0
2012-06-28 15:00:00	AAPL	Stock	20.2221	20.2857	20.2175	20.2454	18464208.0
2012-06-28 15:30:00	AAPL	Stock	20.2457	20.3393	20.2418	20.3129	47683216.0
2012-06-28 16:00:00	AAPL	Stock	20.3218	20.5035	20.2964	20.3068	8738352.0
2012-06-28 16:30:00	AAPL	Stock	20.3232	20.3232	20.2502	20.2946	830144.0
2012-06-28 17:00:00	AAPL	Stock	20.2993	20.3232	20.2857	20.2857	469644.0
2012-06-28 17:30:00	AAPL	Stock	20.2993	20.3214	20.2679	20.2757	160496.0
2012-06-28 18:00:00	AAPL	Stock	20.2739	20.2786	20.2189	20.2218	386764.0
2012-06-28 18:30:00	AAPL	Stock	20.2289	20.2371	20.2271	20.2321	64400.0
2012-06-28 19:00:00	AAPL	Stock	20.2321	20.2475	20.2286	20.2361	62412.0
2012-06-28 19:30:00	AAPL	Stock	20.2293	20.2293	20.2196	20.2196	79884.0
2012-06-28 07:00:00	MSFT	Stock	30.15	30.17	30.14	30.17	5052.0
2012-06-28 07:30:00	MSFT	Stock	30.17	30.18	30.12	30.12	3948.0
2012-06-28 08:00:00	MSFT	Stock	30.11	30.11	30.05	30.05	3505.0
2012-06-28 08:30:00	MSFT	Stock	30.01	30.17	30.0	30.0	44663.0
2012-06-28 09:00:00	MSFT	Stock	30.0	30.17	29.91	30.0	41172.0
2012-06-28 09:30:00	MSFT	Stock	30.0	30.05	29.59	29.782	4363047.0
2012-06-28 10:00:00	MSFT	Stock	29.79	29.82	29.59	29.63	6177544.0
2012-06-28 10:30:00	MSFT	Stock	29.63	29.63	29.42	29.53	4889628.0
2012-06-28 11:00:00	MSFT	Stock	29.535	29.59	29.495	29.57	2286346.0
2012-06-28 11:30:00	MSFT	Stock	29.565	29.64	29.56	29.6	1730756.0
2012-06-28 12:00:00	MSFT	Stock	29.605	29.67	29.542	29.56	1267801.0
2012-06-28 12:30:00	MSFT	Stock	29.56	29.56	29.48	29.51	1900372.0
2012-06-28 13:00:00	MSFT	Stock	29.51	29.57	29.462	29.51	2127551.0
2012-06-28 13:30:00	MSFT	Stock	29.51	29.615	29.48	29.6	2305083.0
2012-06-28 14:00:00	MSFT	Stock	29.6	29.605	29.49	29.51	2123613.0
2012-06-28 14:30:00	MSFT	Stock	29.515	29.61	29.5	29.605	1875848.0
2012-06-28 15:00:00	MSFT	Stock	29.61	29.68	29.6	29.67	2292539.0
2012-06-28 15:30:00	MSFT	Stock	29.67	29.95	29.65	29.905	8553604.0
2012-06-28 16:00:00	MSFT	Stock	29.91	30.191	29.51	29.582	2247884.0
2012-06-28 16:30:00	MSFT	Stock	29.91	29.91	29.675	29.87	137282.0
2012-06-28 17:00:00	MSFT	Stock	29.91	29.91	29.81	29.85	84672.0
2012-06-28 17:30:00	MSFT	Stock	29.85	29.86	29.84	29.84	2065.0
2012-06-28 18:00:00	MSFT	Stock	29.84	29.84	29.84	29.84	200.0

> showing 50 of 75,259 rows — these rows as CSV

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