PREVIEW / stock_30min / 2023-10-24

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-10-24.parquet
  size:    2.0 MB
  rows:    96,570
  symbols: 1,335

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
2023-10-24 04:00:00	AAPL	Stock	173.76	173.76	173.33	173.35	5522.0
2023-10-24 04:30:00	AAPL	Stock	173.3	173.45	173.07	173.45	5724.0
2023-10-24 05:00:00	AAPL	Stock	173.44	173.5	173.39	173.5	2077.0
2023-10-24 05:30:00	AAPL	Stock	173.55	173.96	173.55	173.75	3563.0
2023-10-24 06:00:00	AAPL	Stock	173.78	173.78	173.31	173.36	2884.0
2023-10-24 06:30:00	AAPL	Stock	173.49	173.55	173.42	173.42	1437.0
2023-10-24 07:00:00	AAPL	Stock	173.41	173.59	173.3	173.45	25736.0
2023-10-24 07:30:00	AAPL	Stock	173.4	173.4	173.22	173.3	16036.0
2023-10-24 08:00:00	AAPL	Stock	173.57	173.74	173.0099	173.38	63880.0
2023-10-24 08:30:00	AAPL	Stock	173.34	173.39	173.15	173.3	22696.0
2023-10-24 09:00:00	AAPL	Stock	173.32	173.34	172.36	173.0	88521.0
2023-10-24 09:30:00	AAPL	Stock	173.0	173.31	171.96	172.76	5187909.0
2023-10-24 10:00:00	AAPL	Stock	172.755	172.84	171.81	172.83	3781464.0
2023-10-24 10:30:00	AAPL	Stock	172.8249	172.89	172.28	172.53	2498667.0
2023-10-24 11:00:00	AAPL	Stock	172.5302	172.66	172.13	172.305	2068689.0
2023-10-24 11:30:00	AAPL	Stock	172.31	172.78	172.26	172.7402	1763608.0
2023-10-24 12:00:00	AAPL	Stock	172.76	173.02	171.9828	172.08	2017395.0
2023-10-24 12:30:00	AAPL	Stock	172.1	172.138	171.45	171.76	1794836.0
2023-10-24 13:00:00	AAPL	Stock	171.76	172.2	171.7	172.19	1442234.0
2023-10-24 13:30:00	AAPL	Stock	172.1999	172.365	171.92	172.1	1437854.0
2023-10-24 14:00:00	AAPL	Stock	172.1	172.76	172.06	172.76	1467048.0
2023-10-24 14:30:00	AAPL	Stock	172.75	173.175	172.68	173.12	1992308.0
2023-10-24 15:00:00	AAPL	Stock	173.12	173.67	173.035	173.585	2596349.0
2023-10-24 15:30:00	AAPL	Stock	173.585	173.665	173.23	173.39	3911054.0
2023-10-24 16:00:00	AAPL	Stock	173.39	173.93	173.1	173.23	4197739.0
2023-10-24 16:30:00	AAPL	Stock	173.28	173.44	173.16	173.3	44555.0
2023-10-24 17:00:00	AAPL	Stock	173.24	173.35	173.1	173.13	33791.0
2023-10-24 17:30:00	AAPL	Stock	173.15	173.17	173.01	173.04	21163.0
2023-10-24 18:00:00	AAPL	Stock	173.17	173.33	173.0	173.24	18191.0
2023-10-24 18:30:00	AAPL	Stock	173.34	173.38	173.0	173.02	11132.0
2023-10-24 19:00:00	AAPL	Stock	173.02	173.1499	173.0	173.05	6118.0
2023-10-24 19:30:00	AAPL	Stock	173.08	173.2	172.9	172.9	12572.0
2023-10-24 04:00:00	MSFT	Stock	331.69	332.0	331.25	331.52	5312.0
2023-10-24 04:30:00	MSFT	Stock	330.45	331.35	330.45	331.35	1052.0
2023-10-24 05:00:00	MSFT	Stock	331.59	331.85	331.51	331.84	1582.0
2023-10-24 05:30:00	MSFT	Stock	331.88	332.91	331.88	332.23	2880.0
2023-10-24 06:00:00	MSFT	Stock	332.15	332.15	331.78	332.0	1726.0
2023-10-24 06:30:00	MSFT	Stock	332.16	332.16	331.93	331.93	622.0
2023-10-24 07:00:00	MSFT	Stock	331.92	332.4	331.88	332.4	18876.0
2023-10-24 07:30:00	MSFT	Stock	332.4	332.4	331.95	332.2	4723.0
2023-10-24 08:00:00	MSFT	Stock	332.08	332.7	330.72	332.0	47111.0
2023-10-24 08:30:00	MSFT	Stock	331.85	332.0	331.0	331.35	13106.0
2023-10-24 09:00:00	MSFT	Stock	331.339	331.6	330.46	331.33	55810.0
2023-10-24 09:30:00	MSFT	Stock	331.23	331.58	328.69	330.5921	2154290.0
2023-10-24 10:00:00	MSFT	Stock	330.59	331.35	329.65	330.8701	1088814.0
2023-10-24 10:30:00	MSFT	Stock	330.875	331.84	330.31	330.775	967020.0
2023-10-24 11:00:00	MSFT	Stock	330.78	331.34	330.06	330.09	723670.0
2023-10-24 11:30:00	MSFT	Stock	330.06	330.5	329.23	330.42	857178.0
2023-10-24 12:00:00	MSFT	Stock	330.43	330.62	328.55	328.8	741534.0
2023-10-24 12:30:00	MSFT	Stock	328.77	328.94	327.9	328.0967	775250.0

> showing 50 of 96,570 rows — these rows as CSV

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