PREVIEW / stock_30min / 2013-04-04

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-04.parquet
  size:    1.5 MB
  rows:    77,425
  symbols: 3,454

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-04-04 04:00:00	AAPL	Stock	15.4893	15.4893	15.4893	15.4893	8400.0
2013-04-04 05:00:00	AAPL	Stock	15.5	15.5	15.5	15.5	5600.0
2013-04-04 06:00:00	AAPL	Stock	15.5336	15.5336	15.5268	15.5268	16688.0
2013-04-04 06:30:00	AAPL	Stock	15.5357	15.5357	15.5343	15.5343	14000.0
2013-04-04 07:00:00	AAPL	Stock	15.5325	15.5625	15.5325	15.5607	156492.0
2013-04-04 07:30:00	AAPL	Stock	15.5571	15.5571	15.5182	15.5182	100352.0
2013-04-04 08:00:00	AAPL	Stock	15.5343	15.5607	15.3929	15.5232	912912.0
2013-04-04 08:30:00	AAPL	Stock	15.5186	15.5186	15.4143	15.4161	1322412.0
2013-04-04 09:00:00	AAPL	Stock	15.4268	15.4961	15.4236	15.4914	1431612.0
2013-04-04 09:30:00	AAPL	Stock	15.49	15.5357	15.2729	15.3071	71736812.0
2013-04-04 10:00:00	AAPL	Stock	15.3161	15.4004	15.2556	15.2764	41215636.0
2013-04-04 10:30:00	AAPL	Stock	15.2761	15.3325	15.2707	15.2968	26031516.0
2013-04-04 11:00:00	AAPL	Stock	15.2971	15.3214	15.2589	15.2714	20846224.0
2013-04-04 11:30:00	AAPL	Stock	15.2686	15.2993	15.2557	15.2666	17538220.0
2013-04-04 12:00:00	AAPL	Stock	15.2662	15.2711	15.1875	15.2361	32292820.0
2013-04-04 12:30:00	AAPL	Stock	15.2386	15.3304	15.2375	15.2904	29493380.0
2013-04-04 13:00:00	AAPL	Stock	15.2946	15.3696	15.2509	15.3311	22617364.0
2013-04-04 13:30:00	AAPL	Stock	15.3311	15.3632	15.3214	15.3218	16025296.0
2013-04-04 14:00:00	AAPL	Stock	15.325	15.3321	15.2982	15.3214	12473832.0
2013-04-04 14:30:00	AAPL	Stock	15.3211	15.3268	15.2607	15.2811	12391960.0
2013-04-04 15:00:00	AAPL	Stock	15.2782	15.2946	15.2329	15.2329	15671236.0
2013-04-04 15:30:00	AAPL	Stock	15.2349	15.28	15.2343	15.2721	23415308.0
2013-04-04 16:00:00	AAPL	Stock	15.275	15.3368	15.2532	15.2675	8239196.0
2013-04-04 16:30:00	AAPL	Stock	15.2757	15.2816	15.2333	15.2643	145264.0
2013-04-04 17:00:00	AAPL	Stock	15.2668	15.2768	15.2539	15.2539	154812.0
2013-04-04 17:30:00	AAPL	Stock	15.2707	15.2707	15.2504	15.2536	58128.0
2013-04-04 18:00:00	AAPL	Stock	15.2539	15.2607	15.2529	15.2529	88984.0
2013-04-04 18:30:00	AAPL	Stock	15.2571	15.2607	15.2536	15.2607	30296.0
2013-04-04 19:00:00	AAPL	Stock	15.255	15.2675	15.255	15.2607	85400.0
2013-04-04 19:30:00	AAPL	Stock	15.2575	15.2611	15.2525	15.2571	96544.0
2013-04-04 04:00:00	MSFT	Stock	28.27	28.48	28.27	28.37	1947.0
2013-04-04 04:30:00	MSFT	Stock	28.37	28.37	28.37	28.37	500.0
2013-04-04 05:00:00	MSFT	Stock	28.37	28.37	28.37	28.37	300.0
2013-04-04 05:30:00	MSFT	Stock	28.38	28.38	28.34	28.34	980.0
2013-04-04 06:00:00	MSFT	Stock	28.38	28.38	28.38	28.38	100.0
2013-04-04 06:30:00	MSFT	Stock	28.36	28.36	28.34	28.35	2562.0
2013-04-04 07:00:00	MSFT	Stock	28.36	28.53	28.35	28.5	78003.0
2013-04-04 07:30:00	MSFT	Stock	28.45	28.49	28.4	28.4	43400.0
2013-04-04 08:00:00	MSFT	Stock	28.45	28.5	28.35	28.4	192541.0
2013-04-04 08:30:00	MSFT	Stock	28.37	28.45	28.37	28.42	962395.0
2013-04-04 09:00:00	MSFT	Stock	28.42	28.43	28.34	28.4	1402745.0
2013-04-04 09:30:00	MSFT	Stock	28.39	28.46	28.27	28.38	7233475.0
2013-04-04 10:00:00	MSFT	Stock	28.375	28.49	28.36	28.415	6369574.0
2013-04-04 10:30:00	MSFT	Stock	28.41	28.49	28.4	28.405	4267967.0
2013-04-04 11:00:00	MSFT	Stock	28.404	28.45	28.37	28.435	3187641.0
2013-04-04 11:30:00	MSFT	Stock	28.43	28.47	28.41	28.42	1724623.0
2013-04-04 12:00:00	MSFT	Stock	28.425	28.425	28.37	28.41	2743200.0
2013-04-04 12:30:00	MSFT	Stock	28.41	28.45	28.4	28.412	1764795.0
2013-04-04 13:00:00	MSFT	Stock	28.415	28.45	28.38	28.43	1969082.0
2013-04-04 13:30:00	MSFT	Stock	28.43	28.495	28.41	28.479	1816556.0

> showing 50 of 77,425 rows — these rows as CSV

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