PREVIEW / stock_30min / 2023-01-26

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-26.parquet
  size:    2.1 MB
  rows:    103,356
  symbols: 1,900

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-26 04:00:00	AAPL	Stock	142.9	142.95	142.58	142.58	8495.0
2023-01-26 04:30:00	AAPL	Stock	142.28	142.43	142.21	142.32	6177.0
2023-01-26 05:00:00	AAPL	Stock	142.31	142.55	142.29	142.49	1380.0
2023-01-26 05:30:00	AAPL	Stock	142.48	142.65	142.48	142.61	2237.0
2023-01-26 06:00:00	AAPL	Stock	142.63	142.74	142.63	142.63	3913.0
2023-01-26 06:30:00	AAPL	Stock	142.63	142.67	142.49	142.55	6485.0
2023-01-26 07:00:00	AAPL	Stock	142.59	142.63	142.44	142.44	17920.0
2023-01-26 07:30:00	AAPL	Stock	142.45	143.42	142.45	143.31	39164.0
2023-01-26 08:00:00	AAPL	Stock	142.6	143.4	142.2915	142.7	175427.0
2023-01-26 08:30:00	AAPL	Stock	142.7	143.25	142.1	143.07	240317.0
2023-01-26 09:00:00	AAPL	Stock	143.05	143.35	143.0	143.15	197123.0
2023-01-26 09:30:00	AAPL	Stock	143.17	144.25	142.78	143.25	7067072.0
2023-01-26 10:00:00	AAPL	Stock	143.26	143.99	142.67	143.525	4641400.0
2023-01-26 10:30:00	AAPL	Stock	143.525	143.65	142.26	142.39	2999708.0
2023-01-26 11:00:00	AAPL	Stock	142.39	142.86	141.9	142.36	3129225.0
2023-01-26 11:30:00	AAPL	Stock	142.35	142.79	142.19	142.6799	2169914.0
2023-01-26 12:00:00	AAPL	Stock	142.68	143.27	142.66	142.87	2096559.0
2023-01-26 12:30:00	AAPL	Stock	142.86	143.08	142.59	142.81	1729950.0
2023-01-26 13:00:00	AAPL	Stock	142.82	143.0	142.49	142.86	1529366.0
2023-01-26 13:30:00	AAPL	Stock	142.87	143.43	142.87	143.15	2068162.0
2023-01-26 14:00:00	AAPL	Stock	143.15	143.8325	142.93	143.5301	2572259.0
2023-01-26 14:30:00	AAPL	Stock	143.535	143.76	143.28	143.5204	2166862.0
2023-01-26 15:00:00	AAPL	Stock	143.53	143.71	143.25	143.52	2137997.0
2023-01-26 15:30:00	AAPL	Stock	143.515	144.04	143.32	143.92	5629489.0
2023-01-26 16:00:00	AAPL	Stock	143.93	144.0	143.7188	143.76	6312498.0
2023-01-26 16:30:00	AAPL	Stock	143.77	143.96	143.54	143.64	83138.0
2023-01-26 17:00:00	AAPL	Stock	143.65	143.66	143.6	143.61	17723.0
2023-01-26 17:30:00	AAPL	Stock	143.63	143.96	143.41	143.48	227201.0
2023-01-26 18:00:00	AAPL	Stock	143.48	143.6	143.45	143.47	8458.0
2023-01-26 18:30:00	AAPL	Stock	143.46	143.55	143.41	143.45	20676.0
2023-01-26 19:00:00	AAPL	Stock	143.44	143.72	143.43	143.7	21723.0
2023-01-26 19:30:00	AAPL	Stock	143.72	143.77	143.62	143.69	30628.0
2023-01-26 04:00:00	MSFT	Stock	240.6	242.22	240.6	241.78	8958.0
2023-01-26 04:30:00	MSFT	Stock	241.65	241.65	241.33	241.33	2256.0
2023-01-26 05:00:00	MSFT	Stock	241.22	241.48	241.15	241.43	1732.0
2023-01-26 05:30:00	MSFT	Stock	241.51	241.72	241.51	241.7	3021.0
2023-01-26 06:00:00	MSFT	Stock	241.9	241.9	241.7	241.7	1506.0
2023-01-26 06:30:00	MSFT	Stock	241.7	241.79	241.57	241.62	4003.0
2023-01-26 07:00:00	MSFT	Stock	241.67	241.75	241.59	241.62	8220.0
2023-01-26 07:30:00	MSFT	Stock	241.75	241.76	241.3	241.33	35732.0
2023-01-26 08:00:00	MSFT	Stock	241.61	242.37	240.009	241.56	70000.0
2023-01-26 08:30:00	MSFT	Stock	241.5	241.971	240.59	241.7	65616.0
2023-01-26 09:00:00	MSFT	Stock	241.64	243.58	241.64	243.58	62825.0
2023-01-26 09:30:00	MSFT	Stock	243.63	246.06	242.39	243.1328	4481885.0
2023-01-26 10:00:00	MSFT	Stock	243.2	245.4629	242.8	244.89	1829480.0
2023-01-26 10:30:00	MSFT	Stock	244.91	245.14	242.0	242.495	1860285.0
2023-01-26 11:00:00	MSFT	Stock	242.52	243.935	242.24	243.83	1276841.0
2023-01-26 11:30:00	MSFT	Stock	243.81	244.73	243.68	244.6193	937328.0
2023-01-26 12:00:00	MSFT	Stock	244.62	245.715	244.48	245.14	1184288.0
2023-01-26 12:30:00	MSFT	Stock	245.14	245.34	244.28	244.3	908687.0

> showing 50 of 103,356 rows — these rows as CSV

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