PREVIEW / stock_30min / 2017-12-20

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-20.parquet
  size:    1.7 MB
  rows:    84,909
  symbols: 2,930

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-20 04:30:00	AAPL	Stock	43.775	43.775	43.775	43.775	1200.0
2017-12-20 05:00:00	AAPL	Stock	43.8	43.8125	43.8	43.8075	13624.0
2017-12-20 06:00:00	AAPL	Stock	43.8	43.8	43.7525	43.775	1800.0
2017-12-20 06:30:00	AAPL	Stock	43.775	43.795	43.75	43.7675	12588.0
2017-12-20 07:00:00	AAPL	Stock	43.7625	43.795	43.75	43.78	118740.0
2017-12-20 07:30:00	AAPL	Stock	43.765	43.775	43.75	43.755	44124.0
2017-12-20 08:00:00	AAPL	Stock	43.8	43.8	43.7225	43.7525	191372.0
2017-12-20 08:30:00	AAPL	Stock	43.77	43.775	43.7375	43.75	167632.0
2017-12-20 09:00:00	AAPL	Stock	43.7425	43.7625	43.675	43.725	134260.0
2017-12-20 09:30:00	AAPL	Stock	43.72	43.855	43.355	43.5075	18827944.0
2017-12-20 10:00:00	AAPL	Stock	43.51	43.5725	43.4	43.4675	7816836.0
2017-12-20 10:30:00	AAPL	Stock	43.4675	43.47	43.3125	43.3875	6174516.0
2017-12-20 11:00:00	AAPL	Stock	43.385	43.5175	43.375	43.5142	5184620.0
2017-12-20 11:30:00	AAPL	Stock	43.5175	43.61	43.4625	43.5775	4427652.0
2017-12-20 12:00:00	AAPL	Stock	43.575	43.675	43.525	43.63	4077924.0
2017-12-20 12:30:00	AAPL	Stock	43.6275	43.6575	43.5625	43.635	3146416.0
2017-12-20 13:00:00	AAPL	Stock	43.635	43.6838	43.605	43.6625	2848824.0
2017-12-20 13:30:00	AAPL	Stock	43.66	43.705	43.6125	43.685	2703752.0
2017-12-20 14:00:00	AAPL	Stock	43.685	43.6925	43.53	43.5625	3510648.0
2017-12-20 14:30:00	AAPL	Stock	43.565	43.5825	43.49	43.5475	3434404.0
2017-12-20 15:00:00	AAPL	Stock	43.5475	43.625	43.5325	43.6025	2937164.0
2017-12-20 15:30:00	AAPL	Stock	43.6025	43.66	43.57	43.59	6373292.0
2017-12-20 16:00:00	AAPL	Stock	43.5875	43.6025	43.58	43.585	10951484.0
2017-12-20 16:30:00	AAPL	Stock	43.5875	43.5875	43.57	43.5875	241080.0
2017-12-20 17:00:00	AAPL	Stock	43.575	43.5825	43.5625	43.5625	3392.0
2017-12-20 17:30:00	AAPL	Stock	43.5625	43.5825	43.5625	43.5825	20940.0
2017-12-20 18:00:00	AAPL	Stock	43.5825	43.585	43.5825	43.585	15236.0
2017-12-20 18:30:00	AAPL	Stock	43.5875	43.5875	43.5675	43.5675	17544.0
2017-12-20 19:00:00	AAPL	Stock	43.59	43.59	43.5675	43.5675	7820.0
2017-12-20 19:30:00	AAPL	Stock	43.5675	43.5675	43.56	43.56	14832.0
2017-12-20 07:00:00	MSFT	Stock	86.15	86.35	86.15	86.23	1026.0
2017-12-20 07:30:00	MSFT	Stock	86.25	86.3	86.25	86.3	1600.0
2017-12-20 08:00:00	MSFT	Stock	86.34	86.47	86.31	86.47	10618.0
2017-12-20 08:30:00	MSFT	Stock	86.37	86.47	86.37	86.4	3981.0
2017-12-20 09:00:00	MSFT	Stock	86.39	86.47	86.1	86.19	14134.0
2017-12-20 09:30:00	MSFT	Stock	86.2	86.3	85.08	85.25	2591530.0
2017-12-20 10:00:00	MSFT	Stock	85.25	85.28	85.03	85.16	1179664.0
2017-12-20 10:30:00	MSFT	Stock	85.16	85.2	84.81	84.91	1098458.0
2017-12-20 11:00:00	MSFT	Stock	84.91	85.06	84.71	84.975	1280984.0
2017-12-20 11:30:00	MSFT	Stock	84.98	85.11	84.95	85.08	1120314.0
2017-12-20 12:00:00	MSFT	Stock	85.075	85.3	85.075	85.18	1108729.0
2017-12-20 12:30:00	MSFT	Stock	85.185	85.185	85.02	85.1	605641.0
2017-12-20 13:00:00	MSFT	Stock	85.11	85.515	85.09	85.485	987971.0
2017-12-20 13:30:00	MSFT	Stock	85.49	85.56	85.43	85.44	583891.0
2017-12-20 14:00:00	MSFT	Stock	85.45	85.48	85.26	85.355	653096.0
2017-12-20 14:30:00	MSFT	Stock	85.36	85.52	85.36	85.52	696320.0
2017-12-20 15:00:00	MSFT	Stock	85.52	85.595	85.47	85.475	1017511.0
2017-12-20 15:30:00	MSFT	Stock	85.47	85.7	85.47	85.59	2191147.0
2017-12-20 16:00:00	MSFT	Stock	85.52	85.56	85.47	85.47	3783139.0
2017-12-20 16:30:00	MSFT	Stock	85.53	85.57	85.52	85.57	14086.0

> showing 50 of 84,909 rows — these rows as CSV

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