PREVIEW / stock_30min / 2014-04-24

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-24.parquet
  size:    1.6 MB
  rows:    82,284
  symbols: 3,539

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
2014-04-24 04:00:00	AAPL	Stock	20.1411	20.1629	20.1071	20.1143	227836.0
2014-04-24 04:30:00	AAPL	Stock	20.1121	20.125	20.095	20.095	70084.0
2014-04-24 05:00:00	AAPL	Stock	20.1143	20.1218	20.1143	20.1218	11200.0
2014-04-24 05:30:00	AAPL	Stock	20.1071	20.1439	20.1071	20.1325	138068.0
2014-04-24 06:00:00	AAPL	Stock	20.1325	20.1714	20.1325	20.1607	222068.0
2014-04-24 06:30:00	AAPL	Stock	20.1568	20.2411	20.1568	20.2411	336728.0
2014-04-24 07:00:00	AAPL	Stock	20.2143	20.2757	20.1786	20.2454	931588.0
2014-04-24 07:30:00	AAPL	Stock	20.2675	20.4375	20.25	20.3564	4428564.0
2014-04-24 08:00:00	AAPL	Stock	20.355	20.4282	20.2821	20.3036	5728380.0
2014-04-24 08:30:00	AAPL	Stock	20.31	20.3661	20.2904	20.3325	5502168.0
2014-04-24 09:00:00	AAPL	Stock	20.3321	20.375	20.2925	20.3068	15323028.0
2014-04-24 09:30:00	AAPL	Stock	20.2932	20.3157	20.0261	20.1464	182647388.0
2014-04-24 10:00:00	AAPL	Stock	20.1411	20.2093	20.0407	20.2093	75961508.0
2014-04-24 10:30:00	AAPL	Stock	20.2096	20.2446	20.1704	20.2207	49721140.0
2014-04-24 11:00:00	AAPL	Stock	20.2206	20.2389	20.1843	20.2364	25769016.0
2014-04-24 11:30:00	AAPL	Stock	20.2368	20.2657	20.235	20.2607	28324548.0
2014-04-24 12:00:00	AAPL	Stock	20.2611	20.2718	20.2107	20.248	20633340.0
2014-04-24 12:30:00	AAPL	Stock	20.2463	20.2743	20.2368	20.2661	18756752.0
2014-04-24 13:00:00	AAPL	Stock	20.2654	20.2811	20.245	20.2729	15662808.0
2014-04-24 13:30:00	AAPL	Stock	20.2723	20.2782	20.2429	20.2607	21682108.0
2014-04-24 14:00:00	AAPL	Stock	20.26	20.2857	20.2421	20.2814	23031456.0
2014-04-24 14:30:00	AAPL	Stock	20.2814	20.2923	20.2646	20.2907	24578568.0
2014-04-24 15:00:00	AAPL	Stock	20.2893	20.3511	20.2871	20.345	34008548.0
2014-04-24 15:30:00	AAPL	Stock	20.345	20.355	20.265	20.2775	52549392.0
2014-04-24 16:00:00	AAPL	Stock	20.2779	20.304	20.22	20.25	14140140.0
2014-04-24 16:30:00	AAPL	Stock	20.2571	20.2816	20.2043	20.2586	648228.0
2014-04-24 17:00:00	AAPL	Stock	20.25	20.2775	20.2304	20.2354	1797992.0
2014-04-24 17:30:00	AAPL	Stock	20.2775	20.2775	20.2275	20.2275	181356.0
2014-04-24 18:00:00	AAPL	Stock	20.2307	20.2775	20.2204	20.2339	442820.0
2014-04-24 18:30:00	AAPL	Stock	20.2339	20.2339	20.2143	20.2189	165172.0
2014-04-24 19:00:00	AAPL	Stock	20.2239	20.2464	20.2239	20.2375	364364.0
2014-04-24 19:30:00	AAPL	Stock	20.2375	20.25	20.2329	20.2432	118916.0
2014-04-24 06:00:00	MSFT	Stock	40.0	40.0	40.0	40.0	100.0
2014-04-24 06:30:00	MSFT	Stock	40.19	40.19	39.98	40.0	1450.0
2014-04-24 07:00:00	MSFT	Stock	39.98	40.0	39.95	40.0	4714.0
2014-04-24 07:30:00	MSFT	Stock	40.0	40.09	40.0	40.05	16676.0
2014-04-24 08:00:00	MSFT	Stock	40.0	40.1	39.9	40.05	52234.0
2014-04-24 08:30:00	MSFT	Stock	40.0	40.12	40.0	40.02	26337.0
2014-04-24 09:00:00	MSFT	Stock	40.01	40.05	39.62	39.77	169200.0
2014-04-24 09:30:00	MSFT	Stock	39.74	39.97	39.55	39.56	5363796.0
2014-04-24 10:00:00	MSFT	Stock	39.56	39.56	39.3	39.466	4393183.0
2014-04-24 10:30:00	MSFT	Stock	39.463	39.48	39.3	39.33	2949426.0
2014-04-24 11:00:00	MSFT	Stock	39.33	39.48	39.3	39.397	2006909.0
2014-04-24 11:30:00	MSFT	Stock	39.4	39.45	39.37	39.395	987703.0
2014-04-24 12:00:00	MSFT	Stock	39.4	39.4	39.34	39.36	1600480.0
2014-04-24 12:30:00	MSFT	Stock	39.35	39.41	39.35	39.406	915901.0
2014-04-24 13:00:00	MSFT	Stock	39.41	39.51	39.39	39.5	741484.0
2014-04-24 13:30:00	MSFT	Stock	39.495	39.617	39.47	39.55	2523749.0
2014-04-24 14:00:00	MSFT	Stock	39.55	39.66	39.54	39.6	2529849.0
2014-04-24 14:30:00	MSFT	Stock	39.6	39.71	39.6	39.655	1696158.0

> showing 50 of 82,284 rows — these rows as CSV

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