PREVIEW / stock_30min / 2016-11-21

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-21.parquet
  size:    1.6 MB
  rows:    83,129
  symbols: 3,179

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
2016-11-21 04:00:00	AAPL	Stock	27.55	27.55	27.5375	27.5375	1200.0
2016-11-21 04:30:00	AAPL	Stock	27.5325	27.5375	27.52	27.5375	18000.0
2016-11-21 05:00:00	AAPL	Stock	27.5975	27.5975	27.5975	27.5975	516.0
2016-11-21 05:30:00	AAPL	Stock	27.6	27.6	27.6	27.6	772.0
2016-11-21 06:30:00	AAPL	Stock	27.5525	27.6	27.5525	27.6	4360.0
2016-11-21 07:00:00	AAPL	Stock	27.6	27.6125	27.6	27.6	1944.0
2016-11-21 07:30:00	AAPL	Stock	27.585	27.585	27.575	27.5775	28056.0
2016-11-21 08:00:00	AAPL	Stock	27.5775	27.6	27.5625	27.575	115736.0
2016-11-21 08:30:00	AAPL	Stock	27.585	27.6425	27.58	27.58	167152.0
2016-11-21 09:00:00	AAPL	Stock	27.58	27.5925	27.5	27.52	180660.0
2016-11-21 09:30:00	AAPL	Stock	27.53	27.795	27.5025	27.7875	16907704.0
2016-11-21 10:00:00	AAPL	Stock	27.7875	27.79	27.6175	27.6728	7421652.0
2016-11-21 10:30:00	AAPL	Stock	27.6738	27.73	27.6262	27.725	5371064.0
2016-11-21 11:00:00	AAPL	Stock	27.7275	27.9125	27.7262	27.8838	9600776.0
2016-11-21 11:30:00	AAPL	Stock	27.8838	27.9725	27.8775	27.9225	6689256.0
2016-11-21 12:00:00	AAPL	Stock	27.9225	27.925	27.8375	27.8825	5249772.0
2016-11-21 12:30:00	AAPL	Stock	27.8825	27.9725	27.8825	27.95	4919204.0
2016-11-21 13:00:00	AAPL	Stock	27.9515	27.985	27.9125	27.93	4542140.0
2016-11-21 13:30:00	AAPL	Stock	27.93	27.94	27.8875	27.919	3109840.0
2016-11-21 14:00:00	AAPL	Stock	27.9175	27.925	27.88	27.8888	3148988.0
2016-11-21 14:30:00	AAPL	Stock	27.8875	27.91	27.865	27.875	4725372.0
2016-11-21 15:00:00	AAPL	Stock	27.8732	27.9675	27.8612	27.95	5845380.0
2016-11-21 15:30:00	AAPL	Stock	27.95	27.9975	27.9325	27.9325	14371864.0
2016-11-21 16:00:00	AAPL	Stock	27.9525	27.96	27.6365	27.9325	15858228.0
2016-11-21 16:30:00	AAPL	Stock	27.9375	27.94	27.9125	27.9325	56920.0
2016-11-21 17:00:00	AAPL	Stock	27.9475	27.9475	27.8875	27.9	56484.0
2016-11-21 17:30:00	AAPL	Stock	27.905	27.9175	27.9	27.915	44600.0
2016-11-21 18:00:00	AAPL	Stock	27.915	27.94	27.915	27.94	21764.0
2016-11-21 18:30:00	AAPL	Stock	27.9325	27.94	27.9275	27.9375	7812.0
2016-11-21 19:00:00	AAPL	Stock	27.93	27.94	27.9275	27.9275	82348.0
2016-11-21 19:30:00	AAPL	Stock	27.9375	27.95	27.9375	27.95	58632.0
2016-11-21 04:00:00	MSFT	Stock	60.64	60.64	60.64	60.64	100.0
2016-11-21 07:00:00	MSFT	Stock	60.65	60.65	60.65	60.65	100.0
2016-11-21 07:30:00	MSFT	Stock	60.65	60.65	60.59	60.59	1218.0
2016-11-21 08:00:00	MSFT	Stock	60.63	60.63	60.52	60.52	2453.0
2016-11-21 08:30:00	MSFT	Stock	60.65	60.65	60.6	60.6	887.0
2016-11-21 09:00:00	MSFT	Stock	60.35	60.65	60.35	60.5	5242.0
2016-11-21 09:30:00	MSFT	Stock	60.54	60.91	60.42	60.8	2422197.0
2016-11-21 10:00:00	MSFT	Stock	60.807	60.815	60.45	60.565	1281864.0
2016-11-21 10:30:00	MSFT	Stock	60.565	60.64	60.46	60.49	1270348.0
2016-11-21 11:00:00	MSFT	Stock	60.5	60.72	60.44	60.685	1229250.0
2016-11-21 11:30:00	MSFT	Stock	60.685	60.726	60.57	60.72	726261.0
2016-11-21 12:00:00	MSFT	Stock	60.73	60.75	60.58	60.59	820470.0
2016-11-21 12:30:00	MSFT	Stock	60.6	60.73	60.55	60.67	844505.0
2016-11-21 13:00:00	MSFT	Stock	60.67	60.72	60.6	60.685	566703.0
2016-11-21 13:30:00	MSFT	Stock	60.68	60.75	60.65	60.75	524965.0
2016-11-21 14:00:00	MSFT	Stock	60.75	60.75	60.65	60.725	672681.0
2016-11-21 14:30:00	MSFT	Stock	60.73	60.8	60.7	60.77	1150267.0
2016-11-21 15:00:00	MSFT	Stock	60.775	60.89	60.72	60.83	1202962.0
2016-11-21 15:30:00	MSFT	Stock	60.835	60.97	60.76	60.87	2810212.0

> showing 50 of 83,129 rows — these rows as CSV

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