PREVIEW / stock_30min / 2019-05-07

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-07.parquet
  size:    1.7 MB
  rows:    83,682
  symbols: 2,598

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-05-07 04:00:00	AAPL	Stock	51.9675	51.9925	51.925	51.9925	3200.0
2019-05-07 04:30:00	AAPL	Stock	51.95	51.97	51.9	51.9	7708.0
2019-05-07 05:00:00	AAPL	Stock	51.8875	51.8875	51.85	51.875	6956.0
2019-05-07 05:30:00	AAPL	Stock	51.85	51.85	51.83	51.85	3600.0
2019-05-07 06:00:00	AAPL	Stock	51.875	51.875	51.8425	51.8425	5972.0
2019-05-07 06:30:00	AAPL	Stock	51.8925	51.8925	51.81	51.8125	10744.0
2019-05-07 07:00:00	AAPL	Stock	51.81	51.81	51.6675	51.7725	92016.0
2019-05-07 07:30:00	AAPL	Stock	51.7725	51.845	51.635	51.6625	118576.0
2019-05-07 08:00:00	AAPL	Stock	51.7032	51.845	51.5575	51.75	221384.0
2019-05-07 08:30:00	AAPL	Stock	51.7375	51.7875	51.6625	51.6725	132912.0
2019-05-07 09:00:00	AAPL	Stock	51.6525	51.6725	51.4275	51.465	471932.0
2019-05-07 09:30:00	AAPL	Stock	51.4825	51.8545	51.3	51.45	16213244.0
2019-05-07 10:00:00	AAPL	Stock	51.4538	51.4538	51.1775	51.4425	11925176.0
2019-05-07 10:30:00	AAPL	Stock	51.44	51.4675	51.1	51.185	8122600.0
2019-05-07 11:00:00	AAPL	Stock	51.18	51.19	50.9475	51.0562	8804964.0
2019-05-07 11:30:00	AAPL	Stock	51.0575	51.18	50.921	50.975	6719364.0
2019-05-07 12:00:00	AAPL	Stock	50.975	51.2175	50.8825	51.195	5907992.0
2019-05-07 12:30:00	AAPL	Stock	51.1965	51.24	51.055	51.06	3559236.0
2019-05-07 13:00:00	AAPL	Stock	51.0575	51.08	50.45	50.6375	9638184.0
2019-05-07 13:30:00	AAPL	Stock	50.645	50.69	50.3675	50.5125	8821060.0
2019-05-07 14:00:00	AAPL	Stock	50.51	50.7025	50.4275	50.485	7496064.0
2019-05-07 14:30:00	AAPL	Stock	50.48	50.5325	50.2125	50.4378	9142912.0
2019-05-07 15:00:00	AAPL	Stock	50.4375	50.56	50.25	50.405	8795756.0
2019-05-07 15:30:00	AAPL	Stock	50.4025	50.7425	50.2062	50.715	16670288.0
2019-05-07 16:00:00	AAPL	Stock	50.7475	50.78	50.6925	50.75	12688104.0
2019-05-07 16:30:00	AAPL	Stock	50.7525	50.77	50.715	50.7575	62380.0
2019-05-07 17:00:00	AAPL	Stock	50.7575	50.7575	50.7375	50.75	36876.0
2019-05-07 17:30:00	AAPL	Stock	50.75	50.755	50.725	50.7475	42432.0
2019-05-07 18:00:00	AAPL	Stock	50.725	50.725	50.5525	50.66	45692.0
2019-05-07 18:30:00	AAPL	Stock	50.6775	50.735	50.675	50.735	16156.0
2019-05-07 19:00:00	AAPL	Stock	50.7225	50.7425	50.69	50.715	16576.0
2019-05-07 19:30:00	AAPL	Stock	50.69	50.715	50.625	50.6875	49292.0
2019-05-07 04:00:00	MSFT	Stock	127.9	127.94	127.84	127.84	1301.0
2019-05-07 04:30:00	MSFT	Stock	127.84	127.94	127.68	127.9	4799.0
2019-05-07 05:00:00	MSFT	Stock	127.8	127.8	127.64	127.64	1467.0
2019-05-07 06:00:00	MSFT	Stock	127.7	127.71	127.7	127.7	1100.0
2019-05-07 06:30:00	MSFT	Stock	127.65	127.65	127.18	127.2	5204.0
2019-05-07 07:00:00	MSFT	Stock	127.5	127.61	127.28	127.61	3681.0
2019-05-07 07:30:00	MSFT	Stock	127.76	127.76	127.0	127.13	18973.0
2019-05-07 08:00:00	MSFT	Stock	127.26	127.62	126.51	127.3	25678.0
2019-05-07 08:30:00	MSFT	Stock	127.4	127.44	127.15	127.15	10267.0
2019-05-07 09:00:00	MSFT	Stock	127.07	127.07	126.25	126.63	55972.0
2019-05-07 09:30:00	MSFT	Stock	126.57	127.18	126.07	126.25	2895171.0
2019-05-07 10:00:00	MSFT	Stock	126.25	126.293	125.76	126.22	2054102.0
2019-05-07 10:30:00	MSFT	Stock	126.2	126.28	125.227	125.41	2074905.0
2019-05-07 11:00:00	MSFT	Stock	125.4	125.76	124.91	125.72	2233350.0
2019-05-07 11:30:00	MSFT	Stock	125.73	125.9	125.26	125.481	1761727.0
2019-05-07 12:00:00	MSFT	Stock	125.485	125.925	125.28	125.9	1234039.0
2019-05-07 12:30:00	MSFT	Stock	125.9	125.965	125.455	125.46	908579.0
2019-05-07 13:00:00	MSFT	Stock	125.45	125.505	124.7	124.815	1694342.0

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

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