PREVIEW / stock_30min / 2022-11-17

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-11-17.parquet
  size:    2.1 MB
  rows:    102,741
  symbols: 2,083

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-11-17 04:00:00	AAPL	Stock	148.98	149.26	148.9	148.98	8729.0
2022-11-17 04:30:00	AAPL	Stock	148.98	148.98	148.21	148.34	13105.0
2022-11-17 05:00:00	AAPL	Stock	148.49	148.68	148.41	148.68	3448.0
2022-11-17 05:30:00	AAPL	Stock	148.51	148.51	147.65	147.75	15601.0
2022-11-17 06:00:00	AAPL	Stock	147.73	148.15	147.72	147.76	7382.0
2022-11-17 06:30:00	AAPL	Stock	147.83	147.87	147.41	147.8	17680.0
2022-11-17 07:00:00	AAPL	Stock	147.87	147.87	147.36	147.56	16182.0
2022-11-17 07:30:00	AAPL	Stock	147.45	147.48	146.72	147.0	75154.0
2022-11-17 08:00:00	AAPL	Stock	147.85	149.97	146.2	146.5	167664.0
2022-11-17 08:30:00	AAPL	Stock	146.5	146.9	145.81	145.88	247438.0
2022-11-17 09:00:00	AAPL	Stock	145.87	146.62	145.66	146.56	205279.0
2022-11-17 09:30:00	AAPL	Stock	146.56	148.0399	146.15	147.49	6439963.0
2022-11-17 10:00:00	AAPL	Stock	147.4891	148.81	147.3204	148.7412	4604112.0
2022-11-17 10:30:00	AAPL	Stock	148.74	148.79	148.01	148.15	3059448.0
2022-11-17 11:00:00	AAPL	Stock	148.14	148.98	148.09	148.81	3810987.0
2022-11-17 11:30:00	AAPL	Stock	148.819	150.0554	148.6804	149.995	4880918.0
2022-11-17 12:00:00	AAPL	Stock	149.9901	150.03	149.61	149.725	2996224.0
2022-11-17 12:30:00	AAPL	Stock	149.73	151.3499	149.61	151.16	5163095.0
2022-11-17 13:00:00	AAPL	Stock	151.1582	151.48	150.91	151.29	3663637.0
2022-11-17 13:30:00	AAPL	Stock	151.3	151.48	150.7908	151.085	3038173.0
2022-11-17 14:00:00	AAPL	Stock	151.085	151.17	149.81	150.0	5263561.0
2022-11-17 14:30:00	AAPL	Stock	149.99	150.44	149.555	150.2208	4831387.0
2022-11-17 15:00:00	AAPL	Stock	150.2104	150.345	149.53	149.935	4746796.0
2022-11-17 15:30:00	AAPL	Stock	149.93	150.85	149.85	150.75	6640301.0
2022-11-17 16:00:00	AAPL	Stock	150.72	150.97	150.25	150.97	12277644.0
2022-11-17 16:30:00	AAPL	Stock	150.97	151.14	150.72	151.08	72615.0
2022-11-17 17:00:00	AAPL	Stock	151.0801	151.17	150.72	151.03	87132.0
2022-11-17 17:30:00	AAPL	Stock	151.0111	151.09	151.0	151.03	17096.0
2022-11-17 18:00:00	AAPL	Stock	151.05	151.17	151.02	151.07	19592.0
2022-11-17 18:30:00	AAPL	Stock	151.07	151.08	150.73	150.74	26652.0
2022-11-17 19:00:00	AAPL	Stock	150.72	150.85	150.7	150.79	26393.0
2022-11-17 19:30:00	AAPL	Stock	150.78	151.07	150.76	150.9	16122.0
2022-11-17 04:00:00	MSFT	Stock	242.0	242.0	241.53	241.74	8228.0
2022-11-17 04:30:00	MSFT	Stock	241.56	241.56	240.58	240.7	10240.0
2022-11-17 05:00:00	MSFT	Stock	240.76	241.2	240.76	241.2	12495.0
2022-11-17 05:30:00	MSFT	Stock	240.88	241.02	239.82	240.0	5684.0
2022-11-17 06:00:00	MSFT	Stock	240.0	240.25	239.5	239.8	3342.0
2022-11-17 06:30:00	MSFT	Stock	239.8	240.57	239.48	240.45	4518.0
2022-11-17 07:00:00	MSFT	Stock	240.49	240.53	239.96	240.2	4970.0
2022-11-17 07:30:00	MSFT	Stock	240.49	240.49	239.12	239.12	13430.0
2022-11-17 08:00:00	MSFT	Stock	240.5944	240.5944	238.4	238.7	26000.0
2022-11-17 08:30:00	MSFT	Stock	238.4401	239.0	237.8	237.9	40589.0
2022-11-17 09:00:00	MSFT	Stock	237.7	238.37	237.33	238.23	30929.0
2022-11-17 09:30:00	MSFT	Stock	237.85	240.58	237.63	239.83	2165052.0
2022-11-17 10:00:00	MSFT	Stock	239.775	241.53	239.31	240.86	1025536.0
2022-11-17 10:30:00	MSFT	Stock	240.84	241.135	240.06	240.22	757171.0
2022-11-17 11:00:00	MSFT	Stock	240.22	240.7	239.92	240.66	850275.0
2022-11-17 11:30:00	MSFT	Stock	240.665	242.6532	240.56	242.58	1076620.0
2022-11-17 12:00:00	MSFT	Stock	242.63	243.15	241.86	242.025	1076196.0
2022-11-17 12:30:00	MSFT	Stock	242.04	242.69	241.52	242.59	1001537.0

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

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