PREVIEW / stock_30min / 2019-12-06

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-06.parquet
  size:    1.8 MB
  rows:    86,054
  symbols: 2,485

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
2019-12-06 04:00:00	AAPL	Stock	66.5	66.6825	66.5	66.6225	13836.0
2019-12-06 04:30:00	AAPL	Stock	66.65	66.65	66.6475	66.65	5972.0
2019-12-06 06:30:00	AAPL	Stock	66.625	66.65	66.6225	66.65	7620.0
2019-12-06 07:00:00	AAPL	Stock	66.62	66.63	66.4775	66.48	85040.0
2019-12-06 07:30:00	AAPL	Stock	66.48	66.575	66.4375	66.5325	69424.0
2019-12-06 08:00:00	AAPL	Stock	66.5275	66.6375	66.475	66.5225	144524.0
2019-12-06 08:30:00	AAPL	Stock	66.5375	66.825	66.48	66.7725	843812.0
2019-12-06 09:00:00	AAPL	Stock	66.775	66.88	66.75	66.8775	389020.0
2019-12-06 09:30:00	AAPL	Stock	66.8775	67.2975	66.825	67.2745	15405388.0
2019-12-06 10:00:00	AAPL	Stock	67.2725	67.34	67.165	67.2375	6823608.0
2019-12-06 10:30:00	AAPL	Stock	67.24	67.4075	67.215	67.354	5407492.0
2019-12-06 11:00:00	AAPL	Stock	67.3525	67.475	67.3275	67.4555	4552292.0
2019-12-06 11:30:00	AAPL	Stock	67.4575	67.6175	67.43	67.555	7693692.0
2019-12-06 12:00:00	AAPL	Stock	67.55	67.75	67.5425	67.7175	6644384.0
2019-12-06 12:30:00	AAPL	Stock	67.7182	67.7262	67.6145	67.6972	3887752.0
2019-12-06 13:00:00	AAPL	Stock	67.6975	67.7125	67.6175	67.635	3599492.0
2019-12-06 13:30:00	AAPL	Stock	67.6375	67.6378	67.49	67.52	4152936.0
2019-12-06 14:00:00	AAPL	Stock	67.5225	67.6	67.47	67.5948	3727964.0
2019-12-06 14:30:00	AAPL	Stock	67.5925	67.6675	67.5525	67.5988	2774292.0
2019-12-06 15:00:00	AAPL	Stock	67.5988	67.6025	67.495	67.53	3006424.0
2019-12-06 15:30:00	AAPL	Stock	67.5325	67.7	67.5175	67.675	10963092.0
2019-12-06 16:00:00	AAPL	Stock	67.6775	67.6775	67.6	67.625	8736180.0
2019-12-06 16:30:00	AAPL	Stock	67.6175	67.6775	67.6125	67.6175	170848.0
2019-12-06 17:00:00	AAPL	Stock	67.6225	67.6375	67.615	67.635	50348.0
2019-12-06 17:30:00	AAPL	Stock	67.6275	67.65	67.625	67.64	17328.0
2019-12-06 18:00:00	AAPL	Stock	67.6625	67.6625	67.6325	67.64	20316.0
2019-12-06 18:30:00	AAPL	Stock	67.65	67.6575	67.6275	67.6275	15736.0
2019-12-06 19:00:00	AAPL	Stock	67.65	67.65	67.6275	67.6375	29616.0
2019-12-06 19:30:00	AAPL	Stock	67.6375	67.6725	67.6275	67.6525	46964.0
2019-12-06 04:00:00	MSFT	Stock	150.38	150.65	150.38	150.65	1375.0
2019-12-06 04:30:00	MSFT	Stock	150.55	150.55	150.55	150.55	120.0
2019-12-06 05:00:00	MSFT	Stock	150.27	150.27	150.27	150.27	188.0
2019-12-06 05:30:00	MSFT	Stock	150.4	150.4	150.4	150.4	109.0
2019-12-06 06:30:00	MSFT	Stock	150.59	150.59	150.45	150.45	306.0
2019-12-06 07:00:00	MSFT	Stock	150.4	150.4	150.28	150.37	4230.0
2019-12-06 07:30:00	MSFT	Stock	150.2	150.29	150.2	150.28	657.0
2019-12-06 08:00:00	MSFT	Stock	150.28	150.5	150.02	150.1	3193.0
2019-12-06 08:30:00	MSFT	Stock	150.2	150.9	150.2	150.8	86505.0
2019-12-06 09:00:00	MSFT	Stock	150.8	151.08	150.75	151.01	33012.0
2019-12-06 09:30:00	MSFT	Stock	151.01	151.1	150.27	150.65	1812716.0
2019-12-06 10:00:00	MSFT	Stock	150.63	150.81	150.4	150.77	1267595.0
2019-12-06 10:30:00	MSFT	Stock	150.77	151.3	150.69	151.02	1141306.0
2019-12-06 11:00:00	MSFT	Stock	151.01	151.271	150.94	151.24	599886.0
2019-12-06 11:30:00	MSFT	Stock	151.23	151.5	151.18	151.26	751532.0
2019-12-06 12:00:00	MSFT	Stock	151.26	151.39	151.23	151.32	488115.0
2019-12-06 12:30:00	MSFT	Stock	151.325	151.345	151.06	151.175	509629.0
2019-12-06 13:00:00	MSFT	Stock	151.18	151.37	151.15	151.35	305793.0
2019-12-06 13:30:00	MSFT	Stock	151.35	151.5	151.33	151.396	573513.0
2019-12-06 14:00:00	MSFT	Stock	151.39	151.55	151.39	151.53	587612.0
2019-12-06 14:30:00	MSFT	Stock	151.54	151.64	151.452	151.508	671684.0

> showing 50 of 86,054 rows — these rows as CSV

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