PREVIEW / stock_30min / 2022-10-27

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-10-27.parquet
  size:    2.1 MB
  rows:    102,484
  symbols: 2,122

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
2022-10-27 04:00:00	AAPL	Stock	148.94	149.1	148.65	149.0	29463.0
2022-10-27 04:30:00	AAPL	Stock	148.94	149.06	148.74	148.8	5435.0
2022-10-27 05:00:00	AAPL	Stock	148.75	148.76	148.39	148.44	13677.0
2022-10-27 05:30:00	AAPL	Stock	148.6	148.61	148.32	148.32	14434.0
2022-10-27 06:00:00	AAPL	Stock	148.32	148.47	148.25	148.25	8287.0
2022-10-27 06:30:00	AAPL	Stock	148.34	148.46	148.0	148.17	44287.0
2022-10-27 07:00:00	AAPL	Stock	148.15	148.39	147.92	148.33	58295.0
2022-10-27 07:30:00	AAPL	Stock	148.35	148.36	147.97	147.97	40876.0
2022-10-27 08:00:00	AAPL	Stock	148.0535	149.5	147.5	147.91	224889.0
2022-10-27 08:30:00	AAPL	Stock	147.93	148.7	147.79	148.61	224821.0
2022-10-27 09:00:00	AAPL	Stock	148.61	148.69	147.88	148.07	188369.0
2022-10-27 09:30:00	AAPL	Stock	148.07	149.046	145.54	146.31	10206726.0
2022-10-27 10:00:00	AAPL	Stock	146.32	148.3	146.17	147.97	6649947.0
2022-10-27 10:30:00	AAPL	Stock	147.9692	148.24	146.52	146.53	4177133.0
2022-10-27 11:00:00	AAPL	Stock	146.525	147.27	146.2	146.28	3768973.0
2022-10-27 11:30:00	AAPL	Stock	146.25	146.69	145.8	146.1465	3686768.0
2022-10-27 12:00:00	AAPL	Stock	146.15	146.69	145.385	145.39	3771920.0
2022-10-27 12:30:00	AAPL	Stock	145.38	145.75	145.18	145.29	3267540.0
2022-10-27 13:00:00	AAPL	Stock	145.295	145.8042	144.875	145.13	4690633.0
2022-10-27 13:30:00	AAPL	Stock	145.134	145.37	144.56	144.6637	3756015.0
2022-10-27 14:00:00	AAPL	Stock	144.66	144.755	144.13	144.585	4084266.0
2022-10-27 14:30:00	AAPL	Stock	144.585	144.6	144.21	144.5182	3818299.0
2022-10-27 15:00:00	AAPL	Stock	144.51	145.12	144.28	145.1102	5320921.0
2022-10-27 15:30:00	AAPL	Stock	145.11	145.38	144.5	145.0	9826240.0
2022-10-27 16:00:00	AAPL	Stock	144.97	145.1	141.11	142.0111	12041035.0
2022-10-27 16:30:00	AAPL	Stock	142.0	145.9	136.0	143.17	6728252.0
2022-10-27 17:00:00	AAPL	Stock	143.2999	148.25	139.4	140.75	2706044.0
2022-10-27 17:30:00	AAPL	Stock	140.79	146.32	140.0	145.85	2546700.0
2022-10-27 18:00:00	AAPL	Stock	145.9799	147.34	145.45	145.82	631486.0
2022-10-27 18:30:00	AAPL	Stock	145.82	146.2	144.72	145.2	224766.0
2022-10-27 19:00:00	AAPL	Stock	145.3	145.99	145.16	145.25	131775.0
2022-10-27 19:30:00	AAPL	Stock	145.2	145.87	145.1	145.3499	126621.0
2022-10-27 04:00:00	MSFT	Stock	232.44	232.72	231.6	232.28	15693.0
2022-10-27 04:30:00	MSFT	Stock	232.2	232.47	232.0	232.0	2555.0
2022-10-27 05:00:00	MSFT	Stock	231.75	231.75	231.01	231.05	10069.0
2022-10-27 05:30:00	MSFT	Stock	231.2	231.4	231.0	231.05	4831.0
2022-10-27 06:00:00	MSFT	Stock	231.04	231.04	230.53	230.53	1779.0
2022-10-27 06:30:00	MSFT	Stock	230.96	230.96	230.0	230.12	11368.0
2022-10-27 07:00:00	MSFT	Stock	230.34	230.89	230.0	230.79	19642.0
2022-10-27 07:30:00	MSFT	Stock	230.78	230.95	230.24	230.3	10395.0
2022-10-27 08:00:00	MSFT	Stock	230.05	232.0	230.01	230.7	53115.0
2022-10-27 08:30:00	MSFT	Stock	230.8	232.21	230.5	232.2	85474.0
2022-10-27 09:00:00	MSFT	Stock	232.0	232.0	230.86	231.0	68430.0
2022-10-27 09:30:00	MSFT	Stock	231.04	233.69	226.81	227.29	5426401.0
2022-10-27 10:00:00	MSFT	Stock	227.275	230.62	226.87	230.2001	3220667.0
2022-10-27 10:30:00	MSFT	Stock	230.2	230.73	227.85	227.941	1755715.0
2022-10-27 11:00:00	MSFT	Stock	227.91	229.06	227.53	227.78	1450648.0
2022-10-27 11:30:00	MSFT	Stock	227.77	228.37	227.05	227.28	1486939.0
2022-10-27 12:00:00	MSFT	Stock	227.29	227.57	225.82	225.83	1839742.0
2022-10-27 12:30:00	MSFT	Stock	225.8199	226.85	225.78	226.61	1204278.0

> showing 50 of 102,484 rows — these rows as CSV

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