PREVIEW / stock_30min / 2017-12-27

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-27.parquet
  size:    1.6 MB
  rows:    83,630
  symbols: 2,918

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
2017-12-27 04:00:00	AAPL	Stock	42.7775	42.7775	42.725	42.725	4376.0
2017-12-27 04:30:00	AAPL	Stock	42.725	42.725	42.725	42.725	7088.0
2017-12-27 05:30:00	AAPL	Stock	42.6875	42.7	42.6875	42.7	7272.0
2017-12-27 06:00:00	AAPL	Stock	42.7	42.7	42.7	42.7	800.0
2017-12-27 06:30:00	AAPL	Stock	42.675	42.675	42.6375	42.6375	3388.0
2017-12-27 07:00:00	AAPL	Stock	42.6625	42.7	42.6525	42.6775	48120.0
2017-12-27 07:30:00	AAPL	Stock	42.675	42.675	42.5975	42.6425	68292.0
2017-12-27 08:00:00	AAPL	Stock	42.6375	42.6975	42.545	42.65	164852.0
2017-12-27 08:30:00	AAPL	Stock	42.675	42.685	42.6125	42.6425	122576.0
2017-12-27 09:00:00	AAPL	Stock	42.6625	42.675	42.5075	42.5225	860060.0
2017-12-27 09:30:00	AAPL	Stock	42.525	42.695	42.4275	42.5305	16388268.0
2017-12-27 10:00:00	AAPL	Stock	42.5325	42.5775	42.4975	42.5325	7478924.0
2017-12-27 10:30:00	AAPL	Stock	42.535	42.55	42.46	42.482	7106184.0
2017-12-27 11:00:00	AAPL	Stock	42.485	42.585	42.485	42.56	4785096.0
2017-12-27 11:30:00	AAPL	Stock	42.5625	42.6312	42.5275	42.5975	4461220.0
2017-12-27 12:00:00	AAPL	Stock	42.5975	42.6228	42.575	42.595	2244276.0
2017-12-27 12:30:00	AAPL	Stock	42.5925	42.6475	42.5825	42.6325	2549512.0
2017-12-27 13:00:00	AAPL	Stock	42.6325	42.6475	42.5958	42.6025	2283732.0
2017-12-27 13:30:00	AAPL	Stock	42.6025	42.6325	42.5625	42.595	2074712.0
2017-12-27 14:00:00	AAPL	Stock	42.5925	42.6	42.5375	42.5468	2341384.0
2017-12-27 14:30:00	AAPL	Stock	42.5452	42.5575	42.4975	42.545	3059604.0
2017-12-27 15:00:00	AAPL	Stock	42.5475	42.5625	42.5325	42.56	2135940.0
2017-12-27 15:30:00	AAPL	Stock	42.5598	42.6575	42.5275	42.645	8949852.0
2017-12-27 16:00:00	AAPL	Stock	42.6475	42.6725	42.6025	42.65	8711132.0
2017-12-27 16:30:00	AAPL	Stock	42.65	42.6675	42.6475	42.65	711336.0
2017-12-27 17:00:00	AAPL	Stock	42.6375	42.675	42.6375	42.6575	46528.0
2017-12-27 17:30:00	AAPL	Stock	42.6575	42.6575	42.645	42.65	8736.0
2017-12-27 18:00:00	AAPL	Stock	42.65	42.6675	42.65	42.66	12160.0
2017-12-27 18:30:00	AAPL	Stock	42.6625	42.6625	42.6625	42.6625	26636.0
2017-12-27 19:00:00	AAPL	Stock	42.6675	42.67	42.6625	42.67	10136.0
2017-12-27 19:30:00	AAPL	Stock	42.6675	42.675	42.655	42.6625	17696.0
2017-12-27 07:00:00	MSFT	Stock	85.58	85.58	85.5	85.5	1066.0
2017-12-27 07:30:00	MSFT	Stock	85.45	85.45	85.42	85.42	600.0
2017-12-27 08:00:00	MSFT	Stock	85.52	85.55	85.4	85.55	3699.0
2017-12-27 08:30:00	MSFT	Stock	85.53	85.53	85.5	85.53	425.0
2017-12-27 09:00:00	MSFT	Stock	85.55	85.7	85.5	85.7	10424.0
2017-12-27 09:30:00	MSFT	Stock	85.69	85.69	85.215	85.26	1235878.0
2017-12-27 10:00:00	MSFT	Stock	85.27	85.58	85.265	85.555	1380983.0
2017-12-27 10:30:00	MSFT	Stock	85.55	85.94	85.5	85.91	866268.0
2017-12-27 11:00:00	MSFT	Stock	85.915	85.98	85.78	85.84	817716.0
2017-12-27 11:30:00	MSFT	Stock	85.84	85.89	85.49	85.5	757692.0
2017-12-27 12:00:00	MSFT	Stock	85.5	85.69	85.46	85.645	491315.0
2017-12-27 12:30:00	MSFT	Stock	85.65	85.68	85.42	85.42	429109.0
2017-12-27 13:00:00	MSFT	Stock	85.42	85.45	85.366	85.415	362668.0
2017-12-27 13:30:00	MSFT	Stock	85.42	85.55	85.385	85.545	370756.0
2017-12-27 14:00:00	MSFT	Stock	85.54	85.556	85.44	85.51	513279.0
2017-12-27 14:30:00	MSFT	Stock	85.51	85.55	85.435	85.505	500770.0
2017-12-27 15:00:00	MSFT	Stock	85.505	85.6	85.49	85.535	438765.0
2017-12-27 15:30:00	MSFT	Stock	85.54	85.71	85.47	85.69	1540257.0
2017-12-27 16:00:00	MSFT	Stock	85.7	85.75	85.65	85.71	2040368.0

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

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