PREVIEW / stock_30min / 2023-09-22

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-22.parquet
  size:    2.0 MB
  rows:    95,670
  symbols: 1,402

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-22 04:00:00	AAPL	Stock	174.5	174.7	174.45	174.58	10436.0
2023-09-22 04:30:00	AAPL	Stock	174.64	174.8	174.61	174.7	12665.0
2023-09-22 05:00:00	AAPL	Stock	174.66	174.82	174.6	174.74	7044.0
2023-09-22 05:30:00	AAPL	Stock	174.75	175.1	174.75	175.02	4232.0
2023-09-22 06:00:00	AAPL	Stock	175.0	175.0	174.75	174.75	9537.0
2023-09-22 06:30:00	AAPL	Stock	174.95	175.02	174.77	174.78	9330.0
2023-09-22 07:00:00	AAPL	Stock	174.84	174.95	174.59	174.83	24113.0
2023-09-22 07:30:00	AAPL	Stock	174.76	174.8	174.6	174.7	12438.0
2023-09-22 08:00:00	AAPL	Stock	174.74	175.48	174.33	175.4	160050.0
2023-09-22 08:30:00	AAPL	Stock	175.34	175.35	175.0	175.05	64467.0
2023-09-22 09:00:00	AAPL	Stock	175.08	175.28	174.44	174.67	184291.0
2023-09-22 09:30:00	AAPL	Stock	174.67	174.9	174.05	174.9	4981953.0
2023-09-22 10:00:00	AAPL	Stock	174.9	175.39	174.5701	175.2758	3305622.0
2023-09-22 10:30:00	AAPL	Stock	175.29	176.55	175.2824	176.48	5104525.0
2023-09-22 11:00:00	AAPL	Stock	176.485	176.62	176.0	176.38	2699227.0
2023-09-22 11:30:00	AAPL	Stock	176.39	176.61	175.94	176.1401	1967031.0
2023-09-22 12:00:00	AAPL	Stock	176.14	176.75	175.97	176.61	3138302.0
2023-09-22 12:30:00	AAPL	Stock	176.62	177.079	176.56	176.67	2632063.0
2023-09-22 13:00:00	AAPL	Stock	176.6717	176.73	175.58	175.7	2440075.0
2023-09-22 13:30:00	AAPL	Stock	175.68	175.68	175.15	175.32	2295998.0
2023-09-22 14:00:00	AAPL	Stock	175.32	175.56	174.96	175.13	2108282.0
2023-09-22 14:30:00	AAPL	Stock	175.12	175.43	174.81	175.291	1972642.0
2023-09-22 15:00:00	AAPL	Stock	175.28	175.99	175.21	175.69	2661490.0
2023-09-22 15:30:00	AAPL	Stock	175.685	175.785	174.62	174.74	5413049.0
2023-09-22 16:00:00	AAPL	Stock	174.79	174.93	174.69	174.88	6662951.0
2023-09-22 16:30:00	AAPL	Stock	174.89	175.02	174.88	175.02	88391.0
2023-09-22 17:00:00	AAPL	Stock	175.0	175.0	174.94	174.99	23875.0
2023-09-22 17:30:00	AAPL	Stock	174.98	175.0	174.79	174.95	27974.0
2023-09-22 18:00:00	AAPL	Stock	174.9202	175.0	174.92	175.0	7792.0
2023-09-22 18:30:00	AAPL	Stock	174.98	174.9903	174.91	174.93	13131.0
2023-09-22 19:00:00	AAPL	Stock	174.97	175.2	174.97	175.05	22021.0
2023-09-22 19:30:00	AAPL	Stock	175.07	175.1	174.9	174.95	12641.0
2023-09-22 04:00:00	MSFT	Stock	320.86	321.46	320.86	321.0	6190.0
2023-09-22 04:30:00	MSFT	Stock	320.97	320.97	320.5	320.52	1192.0
2023-09-22 05:00:00	MSFT	Stock	320.72	320.72	320.2	320.47	432.0
2023-09-22 05:30:00	MSFT	Stock	320.67	320.87	320.67	320.87	419.0
2023-09-22 06:00:00	MSFT	Stock	321.0	321.06	320.22	320.22	3631.0
2023-09-22 06:30:00	MSFT	Stock	320.22	320.84	320.22	320.84	2488.0
2023-09-22 07:00:00	MSFT	Stock	320.95	320.95	320.31	320.35	2571.0
2023-09-22 07:30:00	MSFT	Stock	320.19	320.67	320.06	320.46	4485.0
2023-09-22 08:00:00	MSFT	Stock	320.4	321.74	320.03	321.73	31997.0
2023-09-22 08:30:00	MSFT	Stock	321.7	321.8	321.1	321.29	16094.0
2023-09-22 09:00:00	MSFT	Stock	321.3	321.67	320.6	321.5	23832.0
2023-09-22 09:30:00	MSFT	Stock	321.32	321.45	317.81	320.18	1940264.0
2023-09-22 10:00:00	MSFT	Stock	320.2	320.86	318.55	319.41	912520.0
2023-09-22 10:30:00	MSFT	Stock	319.41	321.04	319.23	320.79	1082695.0
2023-09-22 11:00:00	MSFT	Stock	320.79	320.93	319.93	320.56	655047.0
2023-09-22 11:30:00	MSFT	Stock	320.59	320.7	319.0	319.05	614890.0
2023-09-22 12:00:00	MSFT	Stock	319.04	320.06	318.925	319.705	489802.0
2023-09-22 12:30:00	MSFT	Stock	319.68	320.13	319.54	319.71	420021.0

> showing 50 of 95,670 rows — these rows as CSV

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