PREVIEW / stock_30min / 2019-02-01

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-01.parquet
  size:    1.7 MB
  rows:    84,365
  symbols: 2,667

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-02-01 04:00:00	AAPL	Stock	41.6875	41.74	41.6875	41.725	4644.0
2019-02-01 04:30:00	AAPL	Stock	41.7325	41.74	41.7325	41.74	5324.0
2019-02-01 05:00:00	AAPL	Stock	41.6475	41.685	41.6475	41.685	2164.0
2019-02-01 05:30:00	AAPL	Stock	41.6775	41.755	41.65	41.65	8688.0
2019-02-01 06:30:00	AAPL	Stock	41.59	41.6475	41.59	41.6475	5780.0
2019-02-01 07:00:00	AAPL	Stock	41.645	41.645	41.5825	41.625	46908.0
2019-02-01 07:30:00	AAPL	Stock	41.6425	41.6625	41.625	41.625	32300.0
2019-02-01 08:00:00	AAPL	Stock	41.63	41.6618	41.5275	41.5875	183024.0
2019-02-01 08:30:00	AAPL	Stock	41.5975	41.8	41.5975	41.7675	395536.0
2019-02-01 09:00:00	AAPL	Stock	41.7825	41.8125	41.6675	41.735	168868.0
2019-02-01 09:30:00	AAPL	Stock	41.7325	42.035	41.6725	41.7775	15112088.0
2019-02-01 10:00:00	AAPL	Stock	41.775	42.245	41.7475	42.1425	11640304.0
2019-02-01 10:30:00	AAPL	Stock	42.1475	42.225	42.0	42.01	9035528.0
2019-02-01 11:00:00	AAPL	Stock	42.0075	42.0825	41.8875	41.91	6606688.0
2019-02-01 11:30:00	AAPL	Stock	41.91	42.03	41.8825	41.9725	4573568.0
2019-02-01 12:00:00	AAPL	Stock	41.9715	41.9775	41.75	41.798	5432884.0
2019-02-01 12:30:00	AAPL	Stock	41.7925	41.8575	41.76	41.795	4260956.0
2019-02-01 13:00:00	AAPL	Stock	41.7975	41.825	41.595	41.6795	5187136.0
2019-02-01 13:30:00	AAPL	Stock	41.6775	41.77	41.6375	41.7575	4510824.0
2019-02-01 14:00:00	AAPL	Stock	41.7572	41.7638	41.4975	41.5375	6242256.0
2019-02-01 14:30:00	AAPL	Stock	41.5375	41.58	41.4825	41.5375	4853892.0
2019-02-01 15:00:00	AAPL	Stock	41.535	41.6	41.49	41.5985	4884520.0
2019-02-01 15:30:00	AAPL	Stock	41.5988	41.69	41.56	41.6325	11187792.0
2019-02-01 16:00:00	AAPL	Stock	41.63	41.71	41.63	41.65	24539620.0
2019-02-01 16:30:00	AAPL	Stock	41.63	41.67	41.63	41.6625	159484.0
2019-02-01 17:00:00	AAPL	Stock	41.6525	41.6675	41.65	41.6575	26432.0
2019-02-01 17:30:00	AAPL	Stock	41.665	41.665	41.65	41.665	2876.0
2019-02-01 18:00:00	AAPL	Stock	41.6425	41.6625	41.6425	41.6425	12352.0
2019-02-01 18:30:00	AAPL	Stock	41.6425	41.65	41.635	41.65	16524.0
2019-02-01 19:00:00	AAPL	Stock	41.6375	41.6475	41.63	41.635	15056.0
2019-02-01 19:30:00	AAPL	Stock	41.635	41.65	41.625	41.6375	27480.0
2019-02-01 04:00:00	MSFT	Stock	104.52	104.52	104.5	104.5	795.0
2019-02-01 04:30:00	MSFT	Stock	104.44	104.5	104.44	104.5	6300.0
2019-02-01 05:00:00	MSFT	Stock	104.44	104.44	104.44	104.44	1973.0
2019-02-01 05:30:00	MSFT	Stock	104.16	104.18	104.02	104.04	6516.0
2019-02-01 06:00:00	MSFT	Stock	104.06	104.21	104.06	104.21	200.0
2019-02-01 06:30:00	MSFT	Stock	104.24	104.24	104.21	104.21	1576.0
2019-02-01 07:00:00	MSFT	Stock	104.25	104.25	104.1	104.1	6435.0
2019-02-01 07:30:00	MSFT	Stock	104.15	104.2	104.12	104.12	3554.0
2019-02-01 08:00:00	MSFT	Stock	104.35	104.69	104.01	104.08	12253.0
2019-02-01 08:30:00	MSFT	Stock	104.19	104.68	104.19	104.48	20071.0
2019-02-01 09:00:00	MSFT	Stock	104.42	104.57	103.61	103.89	46990.0
2019-02-01 09:30:00	MSFT	Stock	103.9	104.07	103.45	103.534	4143398.0
2019-02-01 10:00:00	MSFT	Stock	103.54	104.1	103.54	103.905	2343769.0
2019-02-01 10:30:00	MSFT	Stock	103.905	103.93	103.55	103.6	1707336.0
2019-02-01 11:00:00	MSFT	Stock	103.59	103.71	103.48	103.5	1380296.0
2019-02-01 11:30:00	MSFT	Stock	103.51	103.665	103.38	103.65	1196520.0
2019-02-01 12:00:00	MSFT	Stock	103.65	103.682	103.28	103.363	1382369.0
2019-02-01 12:30:00	MSFT	Stock	103.36	103.45	103.18	103.21	1204329.0
2019-02-01 13:00:00	MSFT	Stock	103.205	103.205	102.77	102.93	1548931.0

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

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