PREVIEW / stock_30min / 2023-11-17

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-11-17.parquet
  size:    2.0 MB
  rows:    99,078
  symbols: 1,289

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-11-17 04:00:00	AAPL	Stock	189.8	190.3	189.8	190.1	9075.0
2023-11-17 04:30:00	AAPL	Stock	190.1	190.21	190.05	190.05	5764.0
2023-11-17 05:00:00	AAPL	Stock	190.06	190.21	190.06	190.21	3203.0
2023-11-17 05:30:00	AAPL	Stock	190.22	190.31	190.15	190.15	8786.0
2023-11-17 06:00:00	AAPL	Stock	190.15	190.18	190.08	190.1	5280.0
2023-11-17 06:30:00	AAPL	Stock	190.06	190.06	189.82	190.0	3612.0
2023-11-17 07:00:00	AAPL	Stock	190.08	190.19	190.0	190.05	19156.0
2023-11-17 07:30:00	AAPL	Stock	190.08	190.29	190.08	190.1	10469.0
2023-11-17 08:00:00	AAPL	Stock	190.15	190.39	189.63	190.28	69237.0
2023-11-17 08:30:00	AAPL	Stock	190.24	190.33	189.87	189.95	74920.0
2023-11-17 09:00:00	AAPL	Stock	189.91	190.4	189.52	190.29	559029.0
2023-11-17 09:30:00	AAPL	Stock	190.25	190.38	189.14	189.77	7111778.0
2023-11-17 10:00:00	AAPL	Stock	189.77	189.78	188.57	189.58	4556451.0
2023-11-17 10:30:00	AAPL	Stock	189.585	189.76	189.26	189.5709	2356902.0
2023-11-17 11:00:00	AAPL	Stock	189.57	189.6	188.87	189.0515	2293297.0
2023-11-17 11:30:00	AAPL	Stock	189.06	189.27	188.82	189.245	1527018.0
2023-11-17 12:00:00	AAPL	Stock	189.245	189.46	188.89	188.9676	1474726.0
2023-11-17 12:30:00	AAPL	Stock	188.965	189.2778	188.9	189.25	1138176.0
2023-11-17 13:00:00	AAPL	Stock	189.25	189.61	189.085	189.485	1407645.0
2023-11-17 13:30:00	AAPL	Stock	189.49	189.7401	189.35	189.5386	1354943.0
2023-11-17 14:00:00	AAPL	Stock	189.54	189.9	189.535	189.735	1702043.0
2023-11-17 14:30:00	AAPL	Stock	189.735	189.97	189.58	189.97	1436202.0
2023-11-17 15:00:00	AAPL	Stock	189.97	190.18	189.8102	189.888	2459788.0
2023-11-17 15:30:00	AAPL	Stock	189.885	189.96	189.52	189.71	4529445.0
2023-11-17 16:00:00	AAPL	Stock	189.69	189.9	189.6	189.78	7361286.0
2023-11-17 16:30:00	AAPL	Stock	189.77	189.97	189.68	189.95	135712.0
2023-11-17 17:00:00	AAPL	Stock	189.88	190.04	189.69	189.87	42918.0
2023-11-17 17:30:00	AAPL	Stock	189.82	190.02	189.82	189.93	13907.0
2023-11-17 18:00:00	AAPL	Stock	189.9	189.97	189.88	189.88	3128.0
2023-11-17 18:30:00	AAPL	Stock	189.78	189.95	189.78	189.95	1213.0
2023-11-17 19:00:00	AAPL	Stock	189.9	189.9	189.83	189.85	2523.0
2023-11-17 19:30:00	AAPL	Stock	189.85	189.9	189.69	189.69	5298.0
2023-11-17 04:00:00	MSFT	Stock	377.54	377.75	377.29	377.29	4822.0
2023-11-17 04:30:00	MSFT	Stock	377.35	377.57	377.31	377.31	1041.0
2023-11-17 05:00:00	MSFT	Stock	377.28	377.35	377.0	377.0	3471.0
2023-11-17 05:30:00	MSFT	Stock	377.0	377.53	376.73	376.73	3864.0
2023-11-17 06:00:00	MSFT	Stock	376.82	376.95	376.33	376.33	1494.0
2023-11-17 06:30:00	MSFT	Stock	376.52	376.52	376.15	376.25	4345.0
2023-11-17 07:00:00	MSFT	Stock	376.4	376.6	376.26	376.6	7611.0
2023-11-17 07:30:00	MSFT	Stock	376.59	376.6	375.35	375.74	38113.0
2023-11-17 08:00:00	MSFT	Stock	376.6	377.6	375.03	375.45	45410.0
2023-11-17 08:30:00	MSFT	Stock	375.45	375.45	373.91	374.07	50278.0
2023-11-17 09:00:00	MSFT	Stock	374.07	376.17	372.66	373.79	268270.0
2023-11-17 09:30:00	MSFT	Stock	373.76	374.37	370.4435	371.57	4574422.0
2023-11-17 10:00:00	MSFT	Stock	371.55	371.876	370.58	371.46	1366092.0
2023-11-17 10:30:00	MSFT	Stock	371.43	371.445	369.97	370.296	1209793.0
2023-11-17 11:00:00	MSFT	Stock	370.35	371.01	369.21	370.9259	1270995.0
2023-11-17 11:30:00	MSFT	Stock	370.93	372.05	370.5	372.0428	995822.0
2023-11-17 12:00:00	MSFT	Stock	372.0187	372.65	371.27	371.81	1067073.0
2023-11-17 12:30:00	MSFT	Stock	371.8	372.0822	371.66	371.88	520303.0

> showing 50 of 99,078 rows — these rows as CSV

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