PREVIEW / stock_30min / 2017-12-04

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-04.parquet
  size:    1.7 MB
  rows:    85,740
  symbols: 2,937

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-04 04:00:00	AAPL	Stock	43.0575	43.125	43.0575	43.095	6000.0
2017-12-04 04:30:00	AAPL	Stock	43.0775	43.0775	43.0425	43.0425	4668.0
2017-12-04 05:00:00	AAPL	Stock	43.0425	43.095	43.0425	43.095	6196.0
2017-12-04 05:30:00	AAPL	Stock	43.095	43.095	43.095	43.095	400.0
2017-12-04 06:00:00	AAPL	Stock	43.095	43.1725	43.08	43.0925	24352.0
2017-12-04 06:30:00	AAPL	Stock	43.1675	43.18	43.13	43.15	7364.0
2017-12-04 07:00:00	AAPL	Stock	43.1375	43.1825	43.09	43.1125	115252.0
2017-12-04 07:30:00	AAPL	Stock	43.1325	43.17	43.0925	43.125	126372.0
2017-12-04 08:00:00	AAPL	Stock	43.1	43.17	43.05	43.055	253000.0
2017-12-04 08:30:00	AAPL	Stock	43.0825	43.1375	43.0825	43.1125	115428.0
2017-12-04 09:00:00	AAPL	Stock	43.1225	43.14	43.0875	43.11	254404.0
2017-12-04 09:30:00	AAPL	Stock	43.1175	43.155	42.8632	42.9075	15056408.0
2017-12-04 10:00:00	AAPL	Stock	42.91	42.9675	42.6005	42.945	13539636.0
2017-12-04 10:30:00	AAPL	Stock	42.945	42.9725	42.5325	42.6275	10374064.0
2017-12-04 11:00:00	AAPL	Stock	42.625	42.8575	42.52	42.785	8377048.0
2017-12-04 11:30:00	AAPL	Stock	42.7875	42.92	42.73	42.8725	5440760.0
2017-12-04 12:00:00	AAPL	Stock	42.8715	43.0475	42.775	42.8375	6561476.0
2017-12-04 12:30:00	AAPL	Stock	42.8375	42.9	42.7575	42.87	4257028.0
2017-12-04 13:00:00	AAPL	Stock	42.87	42.9388	42.8	42.8125	3654376.0
2017-12-04 13:30:00	AAPL	Stock	42.815	42.8725	42.775	42.87	2985100.0
2017-12-04 14:00:00	AAPL	Stock	42.8725	42.8725	42.625	42.6325	4865192.0
2017-12-04 14:30:00	AAPL	Stock	42.6375	42.765	42.58	42.725	5645328.0
2017-12-04 15:00:00	AAPL	Stock	42.725	42.745	42.64	42.665	4640308.0
2017-12-04 15:30:00	AAPL	Stock	42.6625	42.6875	42.4075	42.44	14071172.0
2017-12-04 16:00:00	AAPL	Stock	42.45	42.7348	42.435	42.45	15914140.0
2017-12-04 16:30:00	AAPL	Stock	42.4425	42.6625	42.34	42.435	84100.0
2017-12-04 17:00:00	AAPL	Stock	42.435	42.4375	42.38	42.4175	15420.0
2017-12-04 17:30:00	AAPL	Stock	42.4475	42.4475	42.4025	42.4225	9616.0
2017-12-04 18:00:00	AAPL	Stock	42.425	42.4425	42.4075	42.4425	21088.0
2017-12-04 18:30:00	AAPL	Stock	42.4275	42.475	42.4075	42.435	47660.0
2017-12-04 19:00:00	AAPL	Stock	42.435	42.455	42.4225	42.455	9736.0
2017-12-04 19:30:00	AAPL	Stock	42.45	42.46	42.4	42.4	13476.0
2017-12-04 06:30:00	MSFT	Stock	84.95	85.03	84.95	85.03	540.0
2017-12-04 07:00:00	MSFT	Stock	84.91	84.91	84.67	84.87	6290.0
2017-12-04 07:30:00	MSFT	Stock	84.8	84.87	84.67	84.7	7244.0
2017-12-04 08:00:00	MSFT	Stock	84.8	84.88	84.51	84.52	11645.0
2017-12-04 08:30:00	MSFT	Stock	84.6	84.7	84.56	84.62	11397.0
2017-12-04 09:00:00	MSFT	Stock	84.56	84.62	84.35	84.35	25497.0
2017-12-04 09:30:00	MSFT	Stock	84.36	84.42	83.36	83.475	3269456.0
2017-12-04 10:00:00	MSFT	Stock	83.485	83.555	82.59	83.07	2682074.0
2017-12-04 10:30:00	MSFT	Stock	83.088	83.19	82.45	82.47	2119785.0
2017-12-04 11:00:00	MSFT	Stock	82.47	82.59	82.29	82.45	1970234.0
2017-12-04 11:30:00	MSFT	Stock	82.45	82.46	81.743	81.87	2439993.0
2017-12-04 12:00:00	MSFT	Stock	81.87	82.18	81.86	81.954	1673189.0
2017-12-04 12:30:00	MSFT	Stock	81.95	82.25	81.83	82.24	1357919.0
2017-12-04 13:00:00	MSFT	Stock	82.235	82.295	82.055	82.07	1252053.0
2017-12-04 13:30:00	MSFT	Stock	82.07	82.27	82.05	82.23	1031302.0
2017-12-04 14:00:00	MSFT	Stock	82.23	82.236	81.595	81.63	1660205.0
2017-12-04 14:30:00	MSFT	Stock	81.62	81.64	80.86	81.0	3074753.0
2017-12-04 15:00:00	MSFT	Stock	81.005	81.06	80.71	81.025	3292676.0

> showing 50 of 85,740 rows — these rows as CSV

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