PREVIEW / stock_30min / 2024-01-19

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-01-19.parquet
  size:    2.0 MB
  rows:    97,501
  symbols: 1,169

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
2024-01-19 04:00:00	AAPL	Stock	188.89	189.95	188.89	189.68	25880.0
2024-01-19 04:30:00	AAPL	Stock	189.67	189.67	189.0	189.45	12646.0
2024-01-19 05:00:00	AAPL	Stock	189.47	189.47	189.21	189.3	8708.0
2024-01-19 05:30:00	AAPL	Stock	189.37	189.79	189.3	189.66	17925.0
2024-01-19 06:00:00	AAPL	Stock	189.6	189.99	189.55	189.93	31323.0
2024-01-19 06:30:00	AAPL	Stock	189.9	190.58	189.9	190.25	73704.0
2024-01-19 07:00:00	AAPL	Stock	190.16	190.2	189.7	189.8	59959.0
2024-01-19 07:30:00	AAPL	Stock	189.81	189.89	189.55	189.84	26480.0
2024-01-19 08:00:00	AAPL	Stock	190.0	190.2	188.65	189.65	259767.0
2024-01-19 08:30:00	AAPL	Stock	189.8	189.85	188.9	189.15	103031.0
2024-01-19 09:00:00	AAPL	Stock	189.15	189.53	188.5	189.5	283088.0
2024-01-19 09:30:00	AAPL	Stock	189.4	189.8798	188.82	189.59	9556127.0
2024-01-19 10:00:00	AAPL	Stock	189.59	189.965	188.91	189.94	3477419.0
2024-01-19 10:30:00	AAPL	Stock	189.935	190.16	189.62	189.79	3738404.0
2024-01-19 11:00:00	AAPL	Stock	189.78	190.06	189.58	189.91	2330761.0
2024-01-19 11:30:00	AAPL	Stock	189.9	190.03	189.3301	189.975	2282339.0
2024-01-19 12:00:00	AAPL	Stock	189.975	190.43	189.9	190.315	2474378.0
2024-01-19 12:30:00	AAPL	Stock	190.32	190.64	190.28	190.565	2046420.0
2024-01-19 13:00:00	AAPL	Stock	190.565	190.99	190.495	190.935	2527814.0
2024-01-19 13:30:00	AAPL	Stock	190.9345	191.45	190.925	191.414	2506173.0
2024-01-19 14:00:00	AAPL	Stock	191.4101	191.95	191.37	191.47	3251829.0
2024-01-19 14:30:00	AAPL	Stock	191.48	191.67	191.17	191.65	2515869.0
2024-01-19 15:00:00	AAPL	Stock	191.6538	191.74	191.32	191.435	2542118.0
2024-01-19 15:30:00	AAPL	Stock	191.4343	191.82	191.32	191.58	4811686.0
2024-01-19 16:00:00	AAPL	Stock	191.56	191.6	191.32	191.37	10670874.0
2024-01-19 16:30:00	AAPL	Stock	191.39	191.61	191.35	191.55	237810.0
2024-01-19 17:00:00	AAPL	Stock	191.5501	191.59	191.45	191.45	5606.0
2024-01-19 17:30:00	AAPL	Stock	191.45	191.5	191.39	191.41	4854.0
2024-01-19 18:00:00	AAPL	Stock	191.49	191.56	191.41	191.56	119211.0
2024-01-19 18:30:00	AAPL	Stock	191.4466	191.4466	191.29	191.29	7789.0
2024-01-19 19:00:00	AAPL	Stock	191.3	191.3	191.1	191.25	10159.0
2024-01-19 19:30:00	AAPL	Stock	191.2	191.31	191.1101	191.23	9367.0
2024-01-19 04:00:00	MSFT	Stock	397.0	398.06	396.17	397.76	6876.0
2024-01-19 04:30:00	MSFT	Stock	397.4	398.3	397.1	398.3	10605.0
2024-01-19 05:00:00	MSFT	Stock	398.36	398.39	397.9	398.15	5064.0
2024-01-19 05:30:00	MSFT	Stock	398.12	398.46	397.91	398.4	3903.0
2024-01-19 06:00:00	MSFT	Stock	397.95	398.1	397.95	397.95	4268.0
2024-01-19 06:30:00	MSFT	Stock	398.0	398.0	397.75	397.82	1218.0
2024-01-19 07:00:00	MSFT	Stock	397.72	397.72	396.4	396.66	21194.0
2024-01-19 07:30:00	MSFT	Stock	396.51	397.14	396.5	397.14	7393.0
2024-01-19 08:00:00	MSFT	Stock	395.85	398.47	395.85	396.35	44407.0
2024-01-19 08:30:00	MSFT	Stock	396.28	396.76	396.24	396.3406	25352.0
2024-01-19 09:00:00	MSFT	Stock	396.45	396.85	395.15	395.75	75642.0
2024-01-19 09:30:00	MSFT	Stock	395.76	395.85	393.5	394.88	4030476.0
2024-01-19 10:00:00	MSFT	Stock	394.89	395.5366	394.16	394.92	1186409.0
2024-01-19 10:30:00	MSFT	Stock	394.92	395.35	393.86	394.98	1040645.0
2024-01-19 11:00:00	MSFT	Stock	395.0	396.3	394.86	396.0169	908363.0
2024-01-19 11:30:00	MSFT	Stock	395.99	395.99	394.81	395.4223	687036.0
2024-01-19 12:00:00	MSFT	Stock	395.455	395.65	394.73	395.47	602384.0
2024-01-19 12:30:00	MSFT	Stock	395.5	396.23	395.38	396.22	629676.0

> showing 50 of 97,501 rows — these rows as CSV

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