PREVIEW / stock_30min / 2017-12-01

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-01.parquet
  size:    1.7 MB
  rows:    83,751
  symbols: 2,941

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-01 04:00:00	AAPL	Stock	42.7375	42.7875	42.7375	42.7875	2136.0
2017-12-01 04:30:00	AAPL	Stock	42.7875	42.7875	42.7875	42.7875	400.0
2017-12-01 05:00:00	AAPL	Stock	42.755	42.8075	42.75	42.8	4000.0
2017-12-01 05:30:00	AAPL	Stock	42.775	42.775	42.675	42.675	10172.0
2017-12-01 06:00:00	AAPL	Stock	42.5775	42.6225	42.5	42.6	35652.0
2017-12-01 06:30:00	AAPL	Stock	42.585	42.6475	42.5775	42.5875	19600.0
2017-12-01 07:00:00	AAPL	Stock	42.595	42.7925	42.5625	42.5625	214396.0
2017-12-01 07:30:00	AAPL	Stock	42.5875	42.65	42.5125	42.65	192692.0
2017-12-01 08:00:00	AAPL	Stock	42.585	42.6975	42.57	42.62	684968.0
2017-12-01 08:30:00	AAPL	Stock	42.635	42.6875	42.58	42.595	397908.0
2017-12-01 09:00:00	AAPL	Stock	42.59	42.675	42.2875	42.5	704696.0
2017-12-01 09:30:00	AAPL	Stock	42.475	42.74	42.4075	42.5462	19067204.0
2017-12-01 10:00:00	AAPL	Stock	42.55	42.9175	42.51	42.865	12080744.0
2017-12-01 10:30:00	AAPL	Stock	42.8675	42.895	42.705	42.74	5864836.0
2017-12-01 11:00:00	AAPL	Stock	42.7375	42.8475	42.2625	42.35	14498848.0
2017-12-01 11:30:00	AAPL	Stock	42.34	42.55	42.125	42.4645	14762692.0
2017-12-01 12:00:00	AAPL	Stock	42.47	42.6625	42.3877	42.4925	9246900.0
2017-12-01 12:30:00	AAPL	Stock	42.495	42.6425	42.365	42.56	7868976.0
2017-12-01 13:00:00	AAPL	Stock	42.56	42.64	42.54	42.6213	3478252.0
2017-12-01 13:30:00	AAPL	Stock	42.6175	42.7075	42.58	42.615	3851616.0
2017-12-01 14:00:00	AAPL	Stock	42.6175	42.7575	42.568	42.745	4268012.0
2017-12-01 14:30:00	AAPL	Stock	42.7425	42.7675	42.57	42.6392	3840016.0
2017-12-01 15:00:00	AAPL	Stock	42.6375	42.7252	42.5575	42.6975	4651504.0
2017-12-01 15:30:00	AAPL	Stock	42.6975	42.8	42.6962	42.75	12266808.0
2017-12-01 16:00:00	AAPL	Stock	42.7625	42.785	42.4598	42.7625	15990704.0
2017-12-01 16:30:00	AAPL	Stock	42.7575	42.7775	42.7575	42.7725	16924.0
2017-12-01 17:00:00	AAPL	Stock	42.7875	42.81	42.7625	42.77	12272.0
2017-12-01 17:30:00	AAPL	Stock	42.78	42.79	42.7625	42.7625	10080.0
2017-12-01 18:00:00	AAPL	Stock	42.7625	42.7625	42.75	42.7525	20376.0
2017-12-01 18:30:00	AAPL	Stock	42.75	42.7675	42.75	42.7675	12456.0
2017-12-01 19:00:00	AAPL	Stock	42.7675	42.7675	42.75	42.7625	21540.0
2017-12-01 19:30:00	AAPL	Stock	42.7625	42.7725	42.75	42.75	11964.0
2017-12-01 06:00:00	MSFT	Stock	83.51	83.51	83.51	83.51	300.0
2017-12-01 07:00:00	MSFT	Stock	83.88	83.88	83.62	83.62	1390.0
2017-12-01 07:30:00	MSFT	Stock	83.65	83.65	83.63	83.63	1500.0
2017-12-01 08:00:00	MSFT	Stock	83.51	83.91	83.51	83.91	9618.0
2017-12-01 08:30:00	MSFT	Stock	83.89	83.93	83.8	83.82	10501.0
2017-12-01 09:00:00	MSFT	Stock	83.83	83.95	83.2	83.57	61958.0
2017-12-01 09:30:00	MSFT	Stock	83.55	84.42	83.5	84.3	2534667.0
2017-12-01 10:00:00	MSFT	Stock	84.31	84.81	84.22	84.45	1595426.0
2017-12-01 10:30:00	MSFT	Stock	84.45	84.5	84.18	84.39	1066048.0
2017-12-01 11:00:00	MSFT	Stock	84.39	84.58	83.46	83.64	3918535.0
2017-12-01 11:30:00	MSFT	Stock	83.64	84.24	83.22	83.935	3700260.0
2017-12-01 12:00:00	MSFT	Stock	83.93	83.96	83.37	83.49	2252222.0
2017-12-01 12:30:00	MSFT	Stock	83.49	83.93	83.29	83.87	1279476.0
2017-12-01 13:00:00	MSFT	Stock	83.86	83.95	83.74	83.75	803174.0
2017-12-01 13:30:00	MSFT	Stock	83.76	83.96	83.68	83.94	930478.0
2017-12-01 14:00:00	MSFT	Stock	83.94	84.118	83.85	84.085	684163.0
2017-12-01 14:30:00	MSFT	Stock	84.088	84.13	83.85	83.935	689352.0
2017-12-01 15:00:00	MSFT	Stock	83.93	84.08	83.83	84.055	959639.0

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

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