PREVIEW / stock_30min / 2023-09-13

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-13.parquet
  size:    2.0 MB
  rows:    96,669
  symbols: 1,430

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-13 04:00:00	AAPL	Stock	176.2	177.0	176.08	176.58	44032.0
2023-09-13 04:30:00	AAPL	Stock	176.59	176.9	175.81	175.81	54498.0
2023-09-13 05:00:00	AAPL	Stock	175.81	175.89	175.4	175.82	30395.0
2023-09-13 05:30:00	AAPL	Stock	175.84	175.85	175.43	175.54	13615.0
2023-09-13 06:00:00	AAPL	Stock	175.43	175.5	175.2	175.36	18833.0
2023-09-13 06:30:00	AAPL	Stock	175.38	175.59	175.28	175.5	30772.0
2023-09-13 07:00:00	AAPL	Stock	175.58	176.25	175.21	175.95	91067.0
2023-09-13 07:30:00	AAPL	Stock	175.95	176.73	175.9	176.66	86721.0
2023-09-13 08:00:00	AAPL	Stock	175.44	177.0	175.37	176.4002	325222.0
2023-09-13 08:30:00	AAPL	Stock	176.44	177.4	175.3	177.1	575613.0
2023-09-13 09:00:00	AAPL	Stock	177.1	177.4982	176.21	176.5	435379.0
2023-09-13 09:30:00	AAPL	Stock	176.5	177.3	174.59	175.8082	10391327.0
2023-09-13 10:00:00	AAPL	Stock	175.815	175.8999	174.07	175.1896	6390747.0
2023-09-13 10:30:00	AAPL	Stock	175.19	175.5	174.7	174.735	4370408.0
2023-09-13 11:00:00	AAPL	Stock	174.74	175.3	174.67	175.2165	3574557.0
2023-09-13 11:30:00	AAPL	Stock	175.2	175.77	174.87	175.7325	3479096.0
2023-09-13 12:00:00	AAPL	Stock	175.74	176.23	175.66	175.73	3662876.0
2023-09-13 12:30:00	AAPL	Stock	175.705	175.77	175.26	175.565	2314413.0
2023-09-13 13:00:00	AAPL	Stock	175.565	175.73	175.311	175.3213	2422608.0
2023-09-13 13:30:00	AAPL	Stock	175.33	175.5	175.09	175.1867	2193485.0
2023-09-13 14:00:00	AAPL	Stock	175.175	175.27	174.75	174.84	2705647.0
2023-09-13 14:30:00	AAPL	Stock	174.84	175.19	174.36	174.7041	4122390.0
2023-09-13 15:00:00	AAPL	Stock	174.71	175.1	174.5	175.06	2924048.0
2023-09-13 15:30:00	AAPL	Stock	175.065	175.1994	173.98	174.2	9887451.0
2023-09-13 16:00:00	AAPL	Stock	174.2	174.25	173.85	174.0003	9058265.0
2023-09-13 16:30:00	AAPL	Stock	174.06	174.21	173.89	173.96	243690.0
2023-09-13 17:00:00	AAPL	Stock	173.96	174.01	173.8	173.93	67006.0
2023-09-13 17:30:00	AAPL	Stock	173.94	174.14	173.86	174.1	59119.0
2023-09-13 18:00:00	AAPL	Stock	174.12	174.18	174.0	174.1	31417.0
2023-09-13 18:30:00	AAPL	Stock	174.08	174.1	174.0	174.02	19301.0
2023-09-13 19:00:00	AAPL	Stock	174.02	174.15	174.0	174.1	12319.0
2023-09-13 19:30:00	AAPL	Stock	174.1	174.15	174.06	174.09	30980.0
2023-09-13 04:00:00	MSFT	Stock	332.0	332.12	331.73	332.05	959.0
2023-09-13 04:30:00	MSFT	Stock	332.13	332.17	331.76	331.77	2232.0
2023-09-13 05:00:00	MSFT	Stock	331.79	332.0	331.79	332.0	883.0
2023-09-13 05:30:00	MSFT	Stock	331.89	331.89	331.89	331.89	163.0
2023-09-13 06:30:00	MSFT	Stock	331.48	331.64	331.1	331.64	1938.0
2023-09-13 07:00:00	MSFT	Stock	331.65	331.93	331.65	331.93	1845.0
2023-09-13 07:30:00	MSFT	Stock	332.1	332.73	332.1	332.5	1983.0
2023-09-13 08:00:00	MSFT	Stock	331.65	332.6	331.53	331.7	11692.0
2023-09-13 08:30:00	MSFT	Stock	331.85	332.3	329.85	331.63	41690.0
2023-09-13 09:00:00	MSFT	Stock	331.67	332.25	330.85	331.26	13895.0
2023-09-13 09:30:00	MSFT	Stock	331.47	335.27	331.17	334.72	1478902.0
2023-09-13 10:00:00	MSFT	Stock	334.69	334.7899	331.9165	333.44	737914.0
2023-09-13 10:30:00	MSFT	Stock	333.47	334.99	333.44	334.52	729522.0
2023-09-13 11:00:00	MSFT	Stock	334.53	335.46	334.23	335.46	526262.0
2023-09-13 11:30:00	MSFT	Stock	335.47	335.58	333.9282	334.79	442331.0
2023-09-13 12:00:00	MSFT	Stock	334.83	335.9	334.46	335.889	450748.0
2023-09-13 12:30:00	MSFT	Stock	335.91	336.1699	335.26	335.685	424117.0
2023-09-13 13:00:00	MSFT	Stock	335.67	336.44	335.58	335.98	325706.0

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

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