PREVIEW / stock_30min / 2015-04-14

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-14.parquet
  size:    1.6 MB
  rows:    81,842
  symbols: 3,514

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
2015-04-14 04:00:00	AAPL	Stock	31.8375	31.8675	31.83	31.85	10752.0
2015-04-14 04:30:00	AAPL	Stock	31.845	31.845	31.8275	31.8275	10164.0
2015-04-14 05:00:00	AAPL	Stock	31.7775	31.7775	31.7175	31.7175	12832.0
2015-04-14 05:30:00	AAPL	Stock	31.7025	31.7025	31.6775	31.69	11104.0
2015-04-14 06:00:00	AAPL	Stock	31.6975	31.7175	31.6975	31.7175	4800.0
2015-04-14 06:30:00	AAPL	Stock	31.785	31.785	31.725	31.725	4600.0
2015-04-14 07:00:00	AAPL	Stock	31.7475	31.825	31.7475	31.8	65696.0
2015-04-14 07:30:00	AAPL	Stock	31.7875	31.7925	31.75	31.75	22596.0
2015-04-14 08:00:00	AAPL	Stock	31.75	31.825	31.7175	31.78	153156.0
2015-04-14 08:30:00	AAPL	Stock	31.7825	31.7875	31.745	31.785	92368.0
2015-04-14 09:00:00	AAPL	Stock	31.7875	31.7875	31.7275	31.7475	431592.0
2015-04-14 09:30:00	AAPL	Stock	31.7525	31.8225	31.5275	31.56	18009292.0
2015-04-14 10:00:00	AAPL	Stock	31.56	31.61	31.4775	31.5715	11782488.0
2015-04-14 10:30:00	AAPL	Stock	31.57	31.6	31.4875	31.545	7359720.0
2015-04-14 11:00:00	AAPL	Stock	31.545	31.6625	31.5225	31.575	6954148.0
2015-04-14 11:30:00	AAPL	Stock	31.575	31.5975	31.525	31.5625	4661756.0
2015-04-14 12:00:00	AAPL	Stock	31.5625	31.6275	31.5575	31.6062	4513756.0
2015-04-14 12:30:00	AAPL	Stock	31.605	31.6875	31.6	31.6025	5157492.0
2015-04-14 13:00:00	AAPL	Stock	31.6025	31.6425	31.59	31.6225	2873896.0
2015-04-14 13:30:00	AAPL	Stock	31.625	31.635	31.5788	31.6125	2575268.0
2015-04-14 14:00:00	AAPL	Stock	31.61	31.6148	31.57	31.59	3292152.0
2015-04-14 14:30:00	AAPL	Stock	31.5892	31.6102	31.5375	31.6028	5120900.0
2015-04-14 15:00:00	AAPL	Stock	31.605	31.635	31.5675	31.57	6649852.0
2015-04-14 15:30:00	AAPL	Stock	31.57	31.62	31.5288	31.575	9643904.0
2015-04-14 16:00:00	AAPL	Stock	31.575	31.6	31.5375	31.5975	4781408.0
2015-04-14 16:30:00	AAPL	Stock	31.5875	31.6	31.575	31.5775	333336.0
2015-04-14 17:00:00	AAPL	Stock	31.575	31.585	31.575	31.585	50588.0
2015-04-14 17:30:00	AAPL	Stock	31.5825	31.585	31.5775	31.585	26276.0
2015-04-14 18:00:00	AAPL	Stock	31.585	31.59	31.585	31.585	19968.0
2015-04-14 18:30:00	AAPL	Stock	31.585	31.5925	31.585	31.5875	23888.0
2015-04-14 19:00:00	AAPL	Stock	31.5875	31.5925	31.58	31.5828	28808.0
2015-04-14 19:30:00	AAPL	Stock	31.585	31.5925	31.58	31.5925	56720.0
2015-04-14 04:30:00	MSFT	Stock	41.93	41.93	41.93	41.93	100.0
2015-04-14 05:30:00	MSFT	Stock	41.68	41.68	41.68	41.68	100.0
2015-04-14 08:00:00	MSFT	Stock	41.7	41.74	41.7	41.74	900.0
2015-04-14 08:30:00	MSFT	Stock	41.64	41.64	41.63	41.63	360.0
2015-04-14 09:00:00	MSFT	Stock	41.61	41.8	41.61	41.7	29682.0
2015-04-14 09:30:00	MSFT	Stock	41.8	42.03	41.71	41.77	3640803.0
2015-04-14 10:00:00	MSFT	Stock	41.77	41.81	41.55	41.58	3035110.0
2015-04-14 10:30:00	MSFT	Stock	41.58	41.58	41.41	41.425	1823898.0
2015-04-14 11:00:00	MSFT	Stock	41.416	41.57	41.39	41.44	1794043.0
2015-04-14 11:30:00	MSFT	Stock	41.45	41.49	41.42	41.428	906115.0
2015-04-14 12:00:00	MSFT	Stock	41.429	41.51	41.42	41.49	860339.0
2015-04-14 12:30:00	MSFT	Stock	41.495	41.655	41.495	41.54	1023098.0
2015-04-14 13:00:00	MSFT	Stock	41.54	41.56	41.48	41.497	591409.0
2015-04-14 13:30:00	MSFT	Stock	41.5	41.55	41.47	41.48	694685.0
2015-04-14 14:00:00	MSFT	Stock	41.48	41.53	41.46	41.46	777943.0
2015-04-14 14:30:00	MSFT	Stock	41.465	41.58	41.45	41.563	1437118.0
2015-04-14 15:00:00	MSFT	Stock	41.565	41.69	41.56	41.67	1143824.0
2015-04-14 15:30:00	MSFT	Stock	41.665	41.73	41.55	41.65	3179243.0

> showing 50 of 81,842 rows — these rows as CSV

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