PREVIEW / stock_30min / 2023-01-31

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-31.parquet
  size:    2.1 MB
  rows:    104,834
  symbols: 1,935

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-31 04:00:00	AAPL	Stock	142.67	142.67	142.05	142.23	19409.0
2023-01-31 04:30:00	AAPL	Stock	142.11	142.29	142.1	142.2	5467.0
2023-01-31 05:00:00	AAPL	Stock	142.08	142.12	141.94	141.97	4240.0
2023-01-31 05:30:00	AAPL	Stock	142.06	142.06	141.58	141.61	22560.0
2023-01-31 06:00:00	AAPL	Stock	141.56	141.82	141.52	141.52	11661.0
2023-01-31 06:30:00	AAPL	Stock	141.52	141.94	141.45	141.93	13940.0
2023-01-31 07:00:00	AAPL	Stock	141.95	142.39	141.95	142.21	36287.0
2023-01-31 07:30:00	AAPL	Stock	142.31	142.58	142.21	142.48	24819.0
2023-01-31 08:00:00	AAPL	Stock	142.32	142.648	141.6515	142.45	104588.0
2023-01-31 08:30:00	AAPL	Stock	142.45	143.6398	142.4	143.26	234357.0
2023-01-31 09:00:00	AAPL	Stock	143.3	143.44	142.5	142.54	131479.0
2023-01-31 09:30:00	AAPL	Stock	142.69	143.75	142.28	142.6456	7217505.0
2023-01-31 10:00:00	AAPL	Stock	142.65	143.34	142.41	143.17	3976230.0
2023-01-31 10:30:00	AAPL	Stock	143.19	143.35	142.8	143.16	2614703.0
2023-01-31 11:00:00	AAPL	Stock	143.17	143.59	142.99	143.525	2295637.0
2023-01-31 11:30:00	AAPL	Stock	143.535	143.64	143.16	143.2583	1814374.0
2023-01-31 12:00:00	AAPL	Stock	143.26	143.64	142.98	143.535	1903774.0
2023-01-31 12:30:00	AAPL	Stock	143.52	143.66	143.4	143.535	1221636.0
2023-01-31 13:00:00	AAPL	Stock	143.54	143.6071	143.16	143.415	1662552.0
2023-01-31 13:30:00	AAPL	Stock	143.42	143.74	143.2999	143.63	1520348.0
2023-01-31 14:00:00	AAPL	Stock	143.625	143.91	143.53	143.825	1656220.0
2023-01-31 14:30:00	AAPL	Stock	143.83	144.0	143.79	143.86	1709069.0
2023-01-31 15:00:00	AAPL	Stock	143.87	144.04	143.26	143.305	2615957.0
2023-01-31 15:30:00	AAPL	Stock	143.3	144.34	143.12	144.3	7577384.0
2023-01-31 16:00:00	AAPL	Stock	144.3	144.43	143.84	143.97	18844137.0
2023-01-31 16:30:00	AAPL	Stock	143.97	144.29	143.69	143.73	70666.0
2023-01-31 17:00:00	AAPL	Stock	143.73	144.0	143.72	143.85	23658.0
2023-01-31 17:30:00	AAPL	Stock	143.92	144.08	143.8	143.8801	25630.0
2023-01-31 18:00:00	AAPL	Stock	143.91	143.91	143.77	143.86	13759.0
2023-01-31 18:30:00	AAPL	Stock	143.85	143.88	143.77	143.81	12688.0
2023-01-31 19:00:00	AAPL	Stock	143.81	143.94	143.7	143.74	16447.0
2023-01-31 19:30:00	AAPL	Stock	143.71	143.8	143.64	143.8	22514.0
2023-01-31 04:00:00	MSFT	Stock	242.05	242.39	241.52	241.69	3487.0
2023-01-31 04:30:00	MSFT	Stock	241.84	241.89	241.79	241.89	3094.0
2023-01-31 05:00:00	MSFT	Stock	241.7	241.75	241.45	241.45	2874.0
2023-01-31 05:30:00	MSFT	Stock	241.4	241.4	241.0	241.33	2626.0
2023-01-31 06:00:00	MSFT	Stock	241.36	241.36	241.29	241.29	1600.0
2023-01-31 06:30:00	MSFT	Stock	241.23	241.84	241.23	241.84	797.0
2023-01-31 07:00:00	MSFT	Stock	241.76	242.33	241.64	241.88	9686.0
2023-01-31 07:30:00	MSFT	Stock	241.94	242.36	241.91	242.36	19277.0
2023-01-31 08:00:00	MSFT	Stock	242.14	243.33	241.63	242.45	36661.0
2023-01-31 08:30:00	MSFT	Stock	242.48	244.52	242.48	243.9	32142.0
2023-01-31 09:00:00	MSFT	Stock	243.96	244.3895	243.35	243.35	16999.0
2023-01-31 09:30:00	MSFT	Stock	243.45	244.75	242.945	243.77	1873363.0
2023-01-31 10:00:00	MSFT	Stock	243.85	245.2575	243.62	245.19	1247276.0
2023-01-31 10:30:00	MSFT	Stock	245.23	245.555	244.54	244.71	755415.0
2023-01-31 11:00:00	MSFT	Stock	244.7	246.06	244.69	245.97	729716.0
2023-01-31 11:30:00	MSFT	Stock	245.96	246.38	245.78	245.88	712134.0
2023-01-31 12:00:00	MSFT	Stock	245.89	246.16	245.28	245.745	545863.0
2023-01-31 12:30:00	MSFT	Stock	245.73	246.47	245.67	246.18	413876.0

> showing 50 of 104,834 rows — these rows as CSV

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