PREVIEW / stock_30min / 2023-10-17

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-10-17.parquet
  size:    2.0 MB
  rows:    97,979
  symbols: 1,348

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-10-17 04:00:00	AAPL	Stock	178.5	178.5	178.29	178.3	3074.0
2023-10-17 04:30:00	AAPL	Stock	178.32	178.32	177.9	178.05	22647.0
2023-10-17 05:00:00	AAPL	Stock	178.05	178.2	178.05	178.2	355.0
2023-10-17 05:30:00	AAPL	Stock	178.13	178.13	177.97	177.97	4354.0
2023-10-17 06:00:00	AAPL	Stock	178.05	178.18	177.97	178.14	4767.0
2023-10-17 06:30:00	AAPL	Stock	178.11	178.17	178.0	178.16	7203.0
2023-10-17 07:00:00	AAPL	Stock	178.16	178.16	177.96	178.02	16085.0
2023-10-17 07:30:00	AAPL	Stock	177.99	178.3	177.99	178.3	10289.0
2023-10-17 08:00:00	AAPL	Stock	178.1893	178.44	177.95	178.1898	70194.0
2023-10-17 08:30:00	AAPL	Stock	178.15	178.38	177.35	177.38	156952.0
2023-10-17 09:00:00	AAPL	Stock	177.4003	177.5	176.33	176.68	383443.0
2023-10-17 09:30:00	AAPL	Stock	176.67	176.99	174.8	175.3433	8305090.0
2023-10-17 10:00:00	AAPL	Stock	175.345	176.69	175.28	176.45	4699709.0
2023-10-17 10:30:00	AAPL	Stock	176.45	177.23	176.32	176.66	3877504.0
2023-10-17 11:00:00	AAPL	Stock	176.665	177.25	176.491	177.09	2648123.0
2023-10-17 11:30:00	AAPL	Stock	177.08	177.845	177.08	177.73	2482400.0
2023-10-17 12:00:00	AAPL	Stock	177.73	178.31	177.63	178.225	2116747.0
2023-10-17 12:30:00	AAPL	Stock	178.23	178.42	177.972	178.19	1891458.0
2023-10-17 13:00:00	AAPL	Stock	178.2	178.35	177.66	177.6678	2066500.0
2023-10-17 13:30:00	AAPL	Stock	177.661	177.83	176.95	177.16	2427633.0
2023-10-17 14:00:00	AAPL	Stock	177.17	177.5399	176.97	177.0989	2548387.0
2023-10-17 14:30:00	AAPL	Stock	177.09	177.34	176.365	176.62	2855254.0
2023-10-17 15:00:00	AAPL	Stock	176.62	176.95	176.5	176.77	2671554.0
2023-10-17 15:30:00	AAPL	Stock	176.78	177.3	176.445	177.14	5312712.0
2023-10-17 16:00:00	AAPL	Stock	177.13	177.23	176.97	177.02	5141262.0
2023-10-17 16:30:00	AAPL	Stock	177.02	177.15	176.94	176.98	40362.0
2023-10-17 17:00:00	AAPL	Stock	176.95	177.09	176.95	177.02	8995.0
2023-10-17 17:30:00	AAPL	Stock	177.0	177.1	177.0	177.09	8422.0
2023-10-17 18:00:00	AAPL	Stock	177.1	177.1	176.96	176.99	8139.0
2023-10-17 18:30:00	AAPL	Stock	176.99	176.99	176.93	176.95	1952.0
2023-10-17 19:00:00	AAPL	Stock	176.94	176.99	176.68	176.99	10751.0
2023-10-17 19:30:00	AAPL	Stock	176.83	176.9	176.52	176.68	7938.0
2023-10-17 04:00:00	MSFT	Stock	333.04	333.04	332.43	332.43	1460.0
2023-10-17 04:30:00	MSFT	Stock	332.6	332.6	332.2	332.5	2408.0
2023-10-17 05:00:00	MSFT	Stock	332.55	332.68	332.55	332.68	200.0
2023-10-17 05:30:00	MSFT	Stock	332.69	332.69	332.69	332.69	549.0
2023-10-17 06:00:00	MSFT	Stock	332.6	332.6	332.24	332.46	2280.0
2023-10-17 06:30:00	MSFT	Stock	332.34	332.34	332.19	332.19	2086.0
2023-10-17 07:00:00	MSFT	Stock	332.21	332.21	331.1	331.1	9613.0
2023-10-17 07:30:00	MSFT	Stock	331.26	332.2	331.26	332.2	2654.0
2023-10-17 08:00:00	MSFT	Stock	332.35	332.5	331.0264	331.5	24832.0
2023-10-17 08:30:00	MSFT	Stock	331.48	331.5	329.66	330.5	36607.0
2023-10-17 09:00:00	MSFT	Stock	330.39	330.39	328.66	329.5	44343.0
2023-10-17 09:30:00	MSFT	Stock	329.59	330.66	327.41	328.615	2177841.0
2023-10-17 10:00:00	MSFT	Stock	328.59	332.27	328.59	331.19	1183316.0
2023-10-17 10:30:00	MSFT	Stock	331.215	332.43	331.01	331.3	788558.0
2023-10-17 11:00:00	MSFT	Stock	331.27	331.87	330.81	331.6117	712065.0
2023-10-17 11:30:00	MSFT	Stock	331.62	332.43	331.56	331.9	559512.0
2023-10-17 12:00:00	MSFT	Stock	331.95	333.06	331.86	332.97	481096.0
2023-10-17 12:30:00	MSFT	Stock	332.97	333.46	332.68	332.815	555159.0

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

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