PREVIEW / stock_30min / 2023-09-19

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-19.parquet
  size:    2.0 MB
  rows:    96,254
  symbols: 1,422

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-09-19 04:00:00	AAPL	Stock	178.57	178.61	178.44	178.55	5634.0
2023-09-19 04:30:00	AAPL	Stock	178.55	178.6	178.5	178.58	1788.0
2023-09-19 05:00:00	AAPL	Stock	178.55	178.75	178.46	178.75	2734.0
2023-09-19 05:30:00	AAPL	Stock	178.77	178.82	178.7	178.73	6626.0
2023-09-19 06:00:00	AAPL	Stock	178.7	178.75	178.46	178.49	2980.0
2023-09-19 06:30:00	AAPL	Stock	178.5	178.66	178.47	178.51	6244.0
2023-09-19 07:00:00	AAPL	Stock	178.5	178.89	178.49	178.89	26941.0
2023-09-19 07:30:00	AAPL	Stock	178.91	178.96	178.59	178.68	31007.0
2023-09-19 08:00:00	AAPL	Stock	178.5	178.99	177.8	178.47	147108.0
2023-09-19 08:30:00	AAPL	Stock	178.45	178.45	177.88	177.99	120959.0
2023-09-19 09:00:00	AAPL	Stock	177.98	178.07	177.13	177.53	196655.0
2023-09-19 09:30:00	AAPL	Stock	177.52	178.67	177.31	177.595	7189130.0
2023-09-19 10:00:00	AAPL	Stock	177.6	177.91	177.13	177.76	4085546.0
2023-09-19 10:30:00	AAPL	Stock	177.77	177.77	177.19	177.2288	2442733.0
2023-09-19 11:00:00	AAPL	Stock	177.22	177.6	177.15	177.585	1899875.0
2023-09-19 11:30:00	AAPL	Stock	177.58	178.12	177.5	178.0601	2229303.0
2023-09-19 12:00:00	AAPL	Stock	178.07	178.2	177.63	178.135	1930788.0
2023-09-19 12:30:00	AAPL	Stock	178.14	178.2376	177.78	178.19	1691487.0
2023-09-19 13:00:00	AAPL	Stock	178.19	178.58	178.14	178.58	2352870.0
2023-09-19 13:30:00	AAPL	Stock	178.58	179.17	178.57	179.09	2773791.0
2023-09-19 14:00:00	AAPL	Stock	179.1	179.39	179.08	179.135	2581935.0
2023-09-19 14:30:00	AAPL	Stock	179.13	179.63	178.9	178.9	2629139.0
2023-09-19 15:00:00	AAPL	Stock	178.9	179.1484	178.74	179.105	2150963.0
2023-09-19 15:30:00	AAPL	Stock	179.1	179.44	178.93	179.1	4164169.0
2023-09-19 16:00:00	AAPL	Stock	179.07	179.35	179.05	179.08	5693582.0
2023-09-19 16:30:00	AAPL	Stock	179.1	179.2	179.07	179.14	42482.0
2023-09-19 17:00:00	AAPL	Stock	179.14	179.17	179.1	179.17	12138.0
2023-09-19 17:30:00	AAPL	Stock	179.12	179.18	179.1025	179.14	7632.0
2023-09-19 18:00:00	AAPL	Stock	179.1404	179.1999	179.11	179.11	4208.0
2023-09-19 18:30:00	AAPL	Stock	179.0861	179.15	179.08	179.15	2999.0
2023-09-19 19:00:00	AAPL	Stock	179.17	179.18	179.07	179.13	6982.0
2023-09-19 19:30:00	AAPL	Stock	179.14	179.14	178.9	179.0	29799.0
2023-09-19 04:00:00	MSFT	Stock	329.55	329.55	329.55	329.55	475.0
2023-09-19 04:30:00	MSFT	Stock	329.45	329.55	329.45	329.55	200.0
2023-09-19 05:00:00	MSFT	Stock	329.5	329.51	329.46	329.51	393.0
2023-09-19 06:00:00	MSFT	Stock	329.4	329.4	329.23	329.25	650.0
2023-09-19 06:30:00	MSFT	Stock	329.56	329.65	329.29	329.29	1078.0
2023-09-19 07:00:00	MSFT	Stock	329.5	329.5	329.15	329.28	1556.0
2023-09-19 07:30:00	MSFT	Stock	329.35	329.35	328.6	328.76	3523.0
2023-09-19 08:00:00	MSFT	Stock	329.21	330.2	328.5	328.7	9177.0
2023-09-19 08:30:00	MSFT	Stock	328.56	328.56	327.8	327.9	8087.0
2023-09-19 09:00:00	MSFT	Stock	327.85	328.16	325.2	325.85	89263.0
2023-09-19 09:30:00	MSFT	Stock	326.0	328.75	324.87	326.66	2219732.0
2023-09-19 10:00:00	MSFT	Stock	326.67	326.765	325.34	325.68	1033744.0
2023-09-19 10:30:00	MSFT	Stock	325.68	325.78	324.51	325.1401	821040.0
2023-09-19 11:00:00	MSFT	Stock	325.14	326.0	325.02	325.65	683373.0
2023-09-19 11:30:00	MSFT	Stock	325.6	326.58	325.49	326.45	449628.0
2023-09-19 12:00:00	MSFT	Stock	326.45	326.678	325.9638	326.05	450235.0
2023-09-19 12:30:00	MSFT	Stock	326.02	326.4698	325.56	326.34	373086.0
2023-09-19 13:00:00	MSFT	Stock	326.34	327.36	326.28	326.795	411024.0

> showing 50 of 96,254 rows — these rows as CSV

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