PREVIEW / stock_30min / 2019-05-23

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-23.parquet
  size:    1.7 MB
  rows:    86,157
  symbols: 2,605

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-23 04:00:00	AAPL	Stock	44.875	45.035	44.815	44.875	71564.0
2019-05-23 04:30:00	AAPL	Stock	44.87	44.87	44.8125	44.8125	40872.0
2019-05-23 05:00:00	AAPL	Stock	44.825	44.9125	44.745	44.7575	17712.0
2019-05-23 05:30:00	AAPL	Stock	44.725	44.725	44.675	44.725	11100.0
2019-05-23 06:00:00	AAPL	Stock	44.68	44.75	44.5875	44.725	69896.0
2019-05-23 06:30:00	AAPL	Stock	44.7375	44.845	44.6925	44.75	45016.0
2019-05-23 07:00:00	AAPL	Stock	44.75	44.95	44.75	44.9125	225148.0
2019-05-23 07:30:00	AAPL	Stock	44.925	44.9975	44.7975	44.8625	205604.0
2019-05-23 08:00:00	AAPL	Stock	44.85	44.987	44.75	44.875	329000.0
2019-05-23 08:30:00	AAPL	Stock	44.8775	45.0475	44.8625	44.9425	487644.0
2019-05-23 09:00:00	AAPL	Stock	44.9378	45.0475	44.835	44.95	510756.0
2019-05-23 09:30:00	AAPL	Stock	44.9625	45.0642	44.4775	44.4988	27072036.0
2019-05-23 10:00:00	AAPL	Stock	44.5	44.8738	44.4525	44.79	13284160.0
2019-05-23 10:30:00	AAPL	Stock	44.7875	45.03	44.7525	44.9678	8493044.0
2019-05-23 11:00:00	AAPL	Stock	44.9725	45.135	44.825	45.0475	6675228.0
2019-05-23 11:30:00	AAPL	Stock	45.05	45.0725	44.7325	44.74	6451100.0
2019-05-23 12:00:00	AAPL	Stock	44.7475	44.805	44.5725	44.63	6634800.0
2019-05-23 12:30:00	AAPL	Stock	44.63	44.7925	44.5925	44.7675	6283992.0
2019-05-23 13:00:00	AAPL	Stock	44.765	44.94	44.7275	44.86	5394520.0
2019-05-23 13:30:00	AAPL	Stock	44.8575	44.9692	44.7725	44.83	3856104.0
2019-05-23 14:00:00	AAPL	Stock	44.83	44.8925	44.7162	44.8225	3891892.0
2019-05-23 14:30:00	AAPL	Stock	44.82	44.9075	44.6925	44.7425	4430012.0
2019-05-23 15:00:00	AAPL	Stock	44.7425	45.0575	44.615	44.96	7231888.0
2019-05-23 15:30:00	AAPL	Stock	44.955	45.045	44.7575	44.9175	9993376.0
2019-05-23 16:00:00	AAPL	Stock	44.915	45.075	44.88	44.9625	17163020.0
2019-05-23 16:30:00	AAPL	Stock	44.9625	45.02	44.915	44.96	183684.0
2019-05-23 17:00:00	AAPL	Stock	44.975	45.0	44.9625	44.9775	21068.0
2019-05-23 17:30:00	AAPL	Stock	44.9775	44.9975	44.9	44.9575	34832.0
2019-05-23 18:00:00	AAPL	Stock	44.9375	44.9875	44.9375	44.95	22104.0
2019-05-23 18:30:00	AAPL	Stock	44.95	44.9725	44.905	44.905	14380.0
2019-05-23 19:00:00	AAPL	Stock	44.9	44.925	44.9	44.9025	22936.0
2019-05-23 19:30:00	AAPL	Stock	44.9	44.975	44.88	44.975	36828.0
2019-05-23 04:00:00	MSFT	Stock	126.55	126.94	126.51	126.51	2439.0
2019-05-23 04:30:00	MSFT	Stock	126.35	126.51	126.18	126.4	3450.0
2019-05-23 05:00:00	MSFT	Stock	126.39	126.4	126.14	126.14	1110.0
2019-05-23 05:30:00	MSFT	Stock	126.07	126.11	125.83	125.91	4136.0
2019-05-23 06:00:00	MSFT	Stock	125.81	126.38	125.81	126.38	1651.0
2019-05-23 06:30:00	MSFT	Stock	126.16	126.16	126.12	126.12	1081.0
2019-05-23 07:00:00	MSFT	Stock	126.33	126.44	126.3	126.44	5811.0
2019-05-23 07:30:00	MSFT	Stock	126.47	126.5	126.34	126.38	7966.0
2019-05-23 08:00:00	MSFT	Stock	126.32	126.5	126.12	126.35	35882.0
2019-05-23 08:30:00	MSFT	Stock	126.35	126.51	126.26	126.36	29881.0
2019-05-23 09:00:00	MSFT	Stock	126.38	126.5	126.2	126.27	20359.0
2019-05-23 09:30:00	MSFT	Stock	126.24	126.29	125.53	125.93	2733342.0
2019-05-23 10:00:00	MSFT	Stock	125.93	126.195	125.43	125.895	1282960.0
2019-05-23 10:30:00	MSFT	Stock	125.89	126.09	125.74	125.91	1145754.0
2019-05-23 11:00:00	MSFT	Stock	125.92	125.93	125.36	125.62	1200414.0
2019-05-23 11:30:00	MSFT	Stock	125.63	125.775	125.19	125.216	944486.0
2019-05-23 12:00:00	MSFT	Stock	125.22	125.4	124.74	125.112	1546114.0
2019-05-23 12:30:00	MSFT	Stock	125.11	125.2	124.74	124.825	866331.0

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

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