PREVIEW / stock_30min / 2019-10-17

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-17.parquet
  size:    1.7 MB
  rows:    82,547
  symbols: 2,507

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-17 04:00:00	AAPL	Stock	58.6925	58.6925	58.6225	58.65	2664.0
2019-10-17 04:30:00	AAPL	Stock	58.7075	58.7925	58.7	58.7	8180.0
2019-10-17 05:00:00	AAPL	Stock	58.6875	58.72	58.6875	58.72	2000.0
2019-10-17 05:30:00	AAPL	Stock	58.7975	58.965	58.7975	58.9375	27020.0
2019-10-17 06:00:00	AAPL	Stock	58.925	58.96	58.925	58.95	20428.0
2019-10-17 06:30:00	AAPL	Stock	58.935	58.935	58.89	58.9125	20004.0
2019-10-17 07:00:00	AAPL	Stock	58.9725	58.9775	58.8275	58.955	120392.0
2019-10-17 07:30:00	AAPL	Stock	58.94	58.9975	58.92	58.9775	95724.0
2019-10-17 08:00:00	AAPL	Stock	58.9	58.99	58.8125	58.85	202420.0
2019-10-17 08:30:00	AAPL	Stock	58.875	58.9175	58.83	58.8975	91140.0
2019-10-17 09:00:00	AAPL	Stock	58.8775	58.8775	58.7375	58.78	156424.0
2019-10-17 09:30:00	AAPL	Stock	58.7725	59.0375	58.6812	58.9608	8304808.0
2019-10-17 10:00:00	AAPL	Stock	58.965	59.01	58.8375	58.8758	4808384.0
2019-10-17 10:30:00	AAPL	Stock	58.885	58.9	58.555	58.6175	5383244.0
2019-10-17 11:00:00	AAPL	Stock	58.6218	58.655	58.388	58.5875	4673556.0
2019-10-17 11:30:00	AAPL	Stock	58.595	58.61	58.405	58.48	3481152.0
2019-10-17 12:00:00	AAPL	Stock	58.48	58.5462	58.38	58.535	2858184.0
2019-10-17 12:30:00	AAPL	Stock	58.53	58.605	58.5125	58.5995	2029044.0
2019-10-17 13:00:00	AAPL	Stock	58.597	58.6668	58.5575	58.645	2024900.0
2019-10-17 13:30:00	AAPL	Stock	58.645	58.8125	58.6425	58.7275	2890768.0
2019-10-17 14:00:00	AAPL	Stock	58.73	58.735	58.5908	58.6925	2534584.0
2019-10-17 14:30:00	AAPL	Stock	58.6975	58.7875	58.625	58.7775	2672892.0
2019-10-17 15:00:00	AAPL	Stock	58.7825	58.8225	58.7125	58.755	2110132.0
2019-10-17 15:30:00	AAPL	Stock	58.755	58.875	58.725	58.8225	6137596.0
2019-10-17 16:00:00	AAPL	Stock	58.82	58.8725	58.82	58.8475	4596524.0
2019-10-17 16:30:00	AAPL	Stock	58.8475	58.85	58.82	58.845	40764.0
2019-10-17 17:00:00	AAPL	Stock	58.8475	58.8475	58.835	58.8375	3228.0
2019-10-17 17:30:00	AAPL	Stock	58.8425	58.8425	58.82	58.8375	12720.0
2019-10-17 18:00:00	AAPL	Stock	58.825	58.8275	58.7875	58.7875	5184.0
2019-10-17 18:30:00	AAPL	Stock	58.81	58.825	58.8	58.8	19836.0
2019-10-17 19:00:00	AAPL	Stock	58.8125	58.82	58.7875	58.82	37412.0
2019-10-17 19:30:00	AAPL	Stock	58.8225	58.8375	58.8	58.8025	9656.0
2019-10-17 04:00:00	MSFT	Stock	140.43	140.69	140.43	140.69	400.0
2019-10-17 04:30:00	MSFT	Stock	140.8	140.8	140.8	140.8	100.0
2019-10-17 05:00:00	MSFT	Stock	140.62	140.62	140.57	140.6	3690.0
2019-10-17 05:30:00	MSFT	Stock	140.69	141.05	140.2	141.0	35668.0
2019-10-17 06:00:00	MSFT	Stock	141.09	141.15	140.9	140.97	9315.0
2019-10-17 06:30:00	MSFT	Stock	140.84	140.98	140.84	140.98	400.0
2019-10-17 07:00:00	MSFT	Stock	140.9	141.18	140.72	141.18	46275.0
2019-10-17 07:30:00	MSFT	Stock	141.15	141.15	140.98	141.15	8764.0
2019-10-17 08:00:00	MSFT	Stock	140.85	141.198	140.75	141.0	30381.0
2019-10-17 08:30:00	MSFT	Stock	141.0	141.15	141.0	141.12	6530.0
2019-10-17 09:00:00	MSFT	Stock	141.08	141.15	140.86	140.94	19623.0
2019-10-17 09:30:00	MSFT	Stock	140.95	141.42	140.59	140.96	1902464.0
2019-10-17 10:00:00	MSFT	Stock	140.95	140.97	139.66	139.84	2226617.0
2019-10-17 10:30:00	MSFT	Stock	139.85	139.97	139.47	139.62	1682371.0
2019-10-17 11:00:00	MSFT	Stock	139.62	139.8	139.37	139.55	1440548.0
2019-10-17 11:30:00	MSFT	Stock	139.555	139.567	139.05	139.31	1381077.0
2019-10-17 12:00:00	MSFT	Stock	139.32	139.51	139.02	139.42	1045527.0
2019-10-17 12:30:00	MSFT	Stock	139.415	139.54	139.35	139.49	650150.0

> showing 50 of 82,547 rows — these rows as CSV

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