PREVIEW / stock_30min / 2023-11-06

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-11-06.parquet
  size:    2.0 MB
  rows:    98,792
  symbols: 1,332

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-06 04:00:00	AAPL	Stock	177.03	177.2	176.75	176.85	20728.0
2023-11-06 04:30:00	AAPL	Stock	176.91	177.05	176.9	176.96	3398.0
2023-11-06 05:00:00	AAPL	Stock	176.95	176.98	176.92	176.92	3907.0
2023-11-06 05:30:00	AAPL	Stock	176.8	176.86	176.8	176.86	1434.0
2023-11-06 06:00:00	AAPL	Stock	176.79	176.82	176.58	176.6	4896.0
2023-11-06 06:30:00	AAPL	Stock	176.67	176.83	176.67	176.83	6257.0
2023-11-06 07:00:00	AAPL	Stock	176.8	176.83	176.36	176.36	54921.0
2023-11-06 07:30:00	AAPL	Stock	176.4	176.66	176.32	176.41	49926.0
2023-11-06 08:00:00	AAPL	Stock	176.8	177.2	176.07	176.19	180209.0
2023-11-06 08:30:00	AAPL	Stock	176.2499	176.39	176.19	176.3	72758.0
2023-11-06 09:00:00	AAPL	Stock	176.23	176.58	176.01	176.35	143294.0
2023-11-06 09:30:00	AAPL	Stock	176.36	178.75	176.21	178.58	9489669.0
2023-11-06 10:00:00	AAPL	Stock	178.59	178.86	177.9	178.26	4631041.0
2023-11-06 10:30:00	AAPL	Stock	178.26	179.06	178.21	178.755	3435343.0
2023-11-06 11:00:00	AAPL	Stock	178.75	179.43	178.72	179.09	3370486.0
2023-11-06 11:30:00	AAPL	Stock	179.09	179.39	178.8	179.26	2361771.0
2023-11-06 12:00:00	AAPL	Stock	179.255	179.265	178.71	178.8899	1935199.0
2023-11-06 12:30:00	AAPL	Stock	178.885	179.06	178.64	178.89	2001078.0
2023-11-06 13:00:00	AAPL	Stock	178.89	178.8936	178.01	178.33	2228822.0
2023-11-06 13:30:00	AAPL	Stock	178.325	178.5	178.02	178.3503	1733265.0
2023-11-06 14:00:00	AAPL	Stock	178.36	178.765	178.1199	178.7599	1741690.0
2023-11-06 14:30:00	AAPL	Stock	178.75	179.22	178.68	179.2101	2399061.0
2023-11-06 15:00:00	AAPL	Stock	179.21	179.32	179.02	179.1	2242805.0
2023-11-06 15:30:00	AAPL	Stock	179.11	179.33	178.7	179.29	5784728.0
2023-11-06 16:00:00	AAPL	Stock	179.3	179.3	179.03	179.0385	5791366.0
2023-11-06 16:30:00	AAPL	Stock	179.03	179.23	178.97	179.09	88902.0
2023-11-06 17:00:00	AAPL	Stock	179.09	179.16	179.04	179.05	22103.0
2023-11-06 17:30:00	AAPL	Stock	179.1	179.1	179.05	179.06	7451.0
2023-11-06 18:00:00	AAPL	Stock	179.07	179.07	178.91	178.93	9552.0
2023-11-06 18:30:00	AAPL	Stock	178.93	178.99	178.91	178.98	6730.0
2023-11-06 19:00:00	AAPL	Stock	178.95	178.97	178.9	178.97	4209.0
2023-11-06 19:30:00	AAPL	Stock	178.95	178.98	178.85	178.98	9503.0
2023-11-06 04:00:00	MSFT	Stock	353.33	353.33	353.1	353.16	1102.0
2023-11-06 04:30:00	MSFT	Stock	353.1	353.5	353.1	353.5	3158.0
2023-11-06 05:00:00	MSFT	Stock	353.73	353.75	353.66	353.66	2073.0
2023-11-06 05:30:00	MSFT	Stock	353.51	353.65	353.4	353.65	1300.0
2023-11-06 06:00:00	MSFT	Stock	353.6	353.63	353.47	353.47	824.0
2023-11-06 06:30:00	MSFT	Stock	353.79	353.93	353.77	353.77	3131.0
2023-11-06 07:00:00	MSFT	Stock	353.77	353.8	353.56	353.76	11279.0
2023-11-06 07:30:00	MSFT	Stock	353.57	353.7	353.5	353.7	14781.0
2023-11-06 08:00:00	MSFT	Stock	352.05	353.8	352.05	353.2	33734.0
2023-11-06 08:30:00	MSFT	Stock	353.25	353.8	353.25	353.55	37566.0
2023-11-06 09:00:00	MSFT	Stock	353.55	353.55	353.29	353.33	8060.0
2023-11-06 09:30:00	MSFT	Stock	353.46	356.8	353.35	356.04	2942804.0
2023-11-06 10:00:00	MSFT	Stock	356.09	357.4	355.48	356.11	1515267.0
2023-11-06 10:30:00	MSFT	Stock	356.095	357.32	356.0	357.0227	958177.0
2023-11-06 11:00:00	MSFT	Stock	357.0	357.54	356.7	356.83	660454.0
2023-11-06 11:30:00	MSFT	Stock	356.84	357.135	356.23	356.845	478945.0
2023-11-06 12:00:00	MSFT	Stock	356.8	356.82	356.02	356.52	562301.0
2023-11-06 12:30:00	MSFT	Stock	356.49	356.75	355.28	355.54	863012.0

> showing 50 of 98,792 rows — these rows as CSV

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