PREVIEW / stock_30min / 2023-01-24

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-24.parquet
  size:    2.1 MB
  rows:    102,348
  symbols: 1,920

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-01-24 04:00:00	AAPL	Stock	141.21	141.21	140.92	140.92	6301.0
2023-01-24 04:30:00	AAPL	Stock	140.88	141.11	140.6	141.11	14159.0
2023-01-24 05:00:00	AAPL	Stock	141.1	141.17	140.84	140.9	10519.0
2023-01-24 05:30:00	AAPL	Stock	140.95	141.07	140.89	141.0	3512.0
2023-01-24 06:00:00	AAPL	Stock	140.96	140.96	140.7	140.78	4194.0
2023-01-24 06:30:00	AAPL	Stock	140.74	140.8	140.5	140.5	6886.0
2023-01-24 07:00:00	AAPL	Stock	140.5	140.65	140.3	140.4	30655.0
2023-01-24 07:30:00	AAPL	Stock	140.4	140.6	140.35	140.44	22574.0
2023-01-24 08:00:00	AAPL	Stock	140.44	140.59	140.23	140.35	88851.0
2023-01-24 08:30:00	AAPL	Stock	140.37	140.39	139.59	139.85	136691.0
2023-01-24 09:00:00	AAPL	Stock	139.85	140.5	139.72	140.2	110450.0
2023-01-24 09:30:00	AAPL	Stock	140.305	142.13	140.3	141.445	7188475.0
2023-01-24 10:00:00	AAPL	Stock	141.46	142.27	141.09	141.91	4661061.0
2023-01-24 10:30:00	AAPL	Stock	141.905	142.31	141.2857	142.255	3578019.0
2023-01-24 11:00:00	AAPL	Stock	142.26	142.47	141.76	142.4535	3317280.0
2023-01-24 11:30:00	AAPL	Stock	142.46	142.498	141.91	142.1	2222544.0
2023-01-24 12:00:00	AAPL	Stock	142.095	142.87	141.81	142.705	3197227.0
2023-01-24 12:30:00	AAPL	Stock	142.7	142.7	142.29	142.47	1970039.0
2023-01-24 13:00:00	AAPL	Stock	142.47	142.92	142.048	142.91	2472325.0
2023-01-24 13:30:00	AAPL	Stock	142.92	143.16	142.6401	142.655	3005595.0
2023-01-24 14:00:00	AAPL	Stock	142.65	142.71	142.2	142.6601	2736469.0
2023-01-24 14:30:00	AAPL	Stock	142.67	142.8	142.3	142.445	2242150.0
2023-01-24 15:00:00	AAPL	Stock	142.45	142.56	142.19	142.4202	2431902.0
2023-01-24 15:30:00	AAPL	Stock	142.43	142.72	141.905	142.5	5278659.0
2023-01-24 16:00:00	AAPL	Stock	142.53	143.41	142.52	142.9	4883709.0
2023-01-24 16:30:00	AAPL	Stock	142.87	143.16	142.53	142.84	214534.0
2023-01-24 17:00:00	AAPL	Stock	142.89	143.02	142.8	142.93	74955.0
2023-01-24 17:30:00	AAPL	Stock	142.93	142.98	142.65	142.73	84041.0
2023-01-24 18:00:00	AAPL	Stock	142.76	142.86	141.9	142.03	181272.0
2023-01-24 18:30:00	AAPL	Stock	142.01	142.19	141.69	142.0	65641.0
2023-01-24 19:00:00	AAPL	Stock	142.0	142.33	141.9001	142.2	78358.0
2023-01-24 19:30:00	AAPL	Stock	142.11	142.15	141.81	141.82	54675.0
2023-01-24 04:00:00	MSFT	Stock	243.23	243.23	242.7	243.0	1671.0
2023-01-24 04:30:00	MSFT	Stock	242.89	242.9	242.71	242.85	4016.0
2023-01-24 05:00:00	MSFT	Stock	242.66	242.68	242.5	242.68	2768.0
2023-01-24 05:30:00	MSFT	Stock	242.56	242.73	242.56	242.65	1012.0
2023-01-24 06:00:00	MSFT	Stock	242.61	242.61	242.39	242.58	5598.0
2023-01-24 06:30:00	MSFT	Stock	242.59	242.61	242.1	242.1	6429.0
2023-01-24 07:00:00	MSFT	Stock	242.21	242.58	242.1	242.58	4897.0
2023-01-24 07:30:00	MSFT	Stock	242.5	242.76	242.27	242.71	4138.0
2023-01-24 08:00:00	MSFT	Stock	242.3334	243.28	242.1551	242.3	23941.0
2023-01-24 08:30:00	MSFT	Stock	242.38	242.5	241.5	241.94	32429.0
2023-01-24 09:00:00	MSFT	Stock	241.97	243.21	241.97	242.48	51837.0
2023-01-24 09:30:00	MSFT	Stock	242.5	242.78	240.89	241.92	3123757.0
2023-01-24 10:00:00	MSFT	Stock	241.93	243.95	241.62	243.125	1709003.0
2023-01-24 10:30:00	MSFT	Stock	243.11	243.47	242.02	242.93	1380670.0
2023-01-24 11:00:00	MSFT	Stock	242.93	242.96	241.8	242.425	905526.0
2023-01-24 11:30:00	MSFT	Stock	242.44	242.64	241.705	242.0632	822403.0
2023-01-24 12:00:00	MSFT	Stock	242.0674	242.48	241.48	242.12	807128.0
2023-01-24 12:30:00	MSFT	Stock	242.115	242.15	241.53	241.8	794013.0

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

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