PREVIEW / stock_30min / 2019-10-31

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-31.parquet
  size:    1.7 MB
  rows:    85,963
  symbols: 2,503

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-10-31 04:00:00	AAPL	Stock	62.3225	62.45	62.2575	62.3925	39488.0
2019-10-31 04:30:00	AAPL	Stock	62.41	62.41	62.3	62.3275	57080.0
2019-10-31 05:00:00	AAPL	Stock	62.325	62.3425	61.88	62.05	61172.0
2019-10-31 05:30:00	AAPL	Stock	62.05	62.05	61.6525	61.76	71784.0
2019-10-31 06:00:00	AAPL	Stock	61.8125	62.06	61.8125	62.05	50044.0
2019-10-31 06:30:00	AAPL	Stock	62.0275	62.2	62.025	62.1175	55104.0
2019-10-31 07:00:00	AAPL	Stock	62.1175	62.1225	61.81	61.9025	218256.0
2019-10-31 07:30:00	AAPL	Stock	61.9525	61.9525	61.675	61.855	293916.0
2019-10-31 08:00:00	AAPL	Stock	62.0975	62.1125	61.6275	61.8475	722544.0
2019-10-31 08:30:00	AAPL	Stock	61.8375	61.95	61.5875	61.935	597848.0
2019-10-31 09:00:00	AAPL	Stock	61.935	61.9725	61.625	61.77	696708.0
2019-10-31 09:30:00	AAPL	Stock	61.7975	62.2925	61.475	61.7035	21931264.0
2019-10-31 10:00:00	AAPL	Stock	61.72	62.0975	59.315	61.6008	12255472.0
2019-10-31 10:30:00	AAPL	Stock	61.6075	61.875	61.4	61.83	8285636.0
2019-10-31 11:00:00	AAPL	Stock	61.825	62.1875	61.725	62.1175	8122932.0
2019-10-31 11:30:00	AAPL	Stock	62.11	62.2425	62.0175	62.0522	5946052.0
2019-10-31 12:00:00	AAPL	Stock	62.055	62.115	61.935	61.965	5698156.0
2019-10-31 12:30:00	AAPL	Stock	61.9625	62.05	61.7425	61.9075	4586740.0
2019-10-31 13:00:00	AAPL	Stock	61.9075	62.035	61.8775	61.9725	3187236.0
2019-10-31 13:30:00	AAPL	Stock	61.9692	62.045	61.87	61.95	2790908.0
2019-10-31 14:00:00	AAPL	Stock	61.95	61.9675	61.775	61.8365	3419332.0
2019-10-31 14:30:00	AAPL	Stock	61.8388	61.95	61.6625	61.9375	4088684.0
2019-10-31 15:00:00	AAPL	Stock	61.945	62.165	61.9025	61.9725	7154884.0
2019-10-31 15:30:00	AAPL	Stock	61.975	62.235	61.905	62.21	12698524.0
2019-10-31 16:00:00	AAPL	Stock	62.205	62.25	61.9548	62.1125	11373636.0
2019-10-31 16:30:00	AAPL	Stock	62.125	62.19	62.1025	62.125	187164.0
2019-10-31 17:00:00	AAPL	Stock	62.1375	62.1625	62.125	62.125	10292.0
2019-10-31 17:30:00	AAPL	Stock	62.125	62.125	62.105	62.105	21280.0
2019-10-31 18:00:00	AAPL	Stock	62.1125	62.125	62.0725	62.125	23024.0
2019-10-31 18:30:00	AAPL	Stock	62.1375	62.1375	62.105	62.125	8956.0
2019-10-31 19:00:00	AAPL	Stock	62.11	62.1625	62.11	62.1625	9200.0
2019-10-31 19:30:00	AAPL	Stock	62.15	62.15	62.11	62.14	48700.0
2019-10-31 04:00:00	MSFT	Stock	144.61	145.0	144.61	144.7	3288.0
2019-10-31 04:30:00	MSFT	Stock	144.93	144.93	144.75	144.75	2303.0
2019-10-31 05:00:00	MSFT	Stock	144.7	144.7	143.83	144.17	4797.0
2019-10-31 05:30:00	MSFT	Stock	144.02	144.31	143.8	144.13	7972.0
2019-10-31 06:00:00	MSFT	Stock	144.0	144.09	144.0	144.09	300.0
2019-10-31 06:30:00	MSFT	Stock	143.79	144.38	143.38	144.36	4849.0
2019-10-31 07:00:00	MSFT	Stock	144.36	144.36	144.02	144.02	4533.0
2019-10-31 07:30:00	MSFT	Stock	144.04	144.15	143.8	144.15	9079.0
2019-10-31 08:00:00	MSFT	Stock	144.0	144.39	143.86	144.1	8938.0
2019-10-31 08:30:00	MSFT	Stock	144.24	144.44	144.03	144.34	18730.0
2019-10-31 09:00:00	MSFT	Stock	144.38	144.95	144.1	144.83	37563.0
2019-10-31 09:30:00	MSFT	Stock	144.72	144.97	143.9	144.09	2333207.0
2019-10-31 10:00:00	MSFT	Stock	144.08	144.125	143.61	144.0	1153012.0
2019-10-31 10:30:00	MSFT	Stock	143.993	144.24	143.55	144.21	1077978.0
2019-10-31 11:00:00	MSFT	Stock	144.22	144.52	143.98	144.0	898213.0
2019-10-31 11:30:00	MSFT	Stock	143.99	144.13	143.765	143.88	759428.0
2019-10-31 12:00:00	MSFT	Stock	143.87	144.06	143.723	143.92	755385.0
2019-10-31 12:30:00	MSFT	Stock	143.92	143.926	143.46	143.575	766067.0

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

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