PREVIEW / stock_30min / 2023-10-18

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-10-18.parquet
  size:    2.0 MB
  rows:    96,374
  symbols: 1,357

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-18 04:00:00	AAPL	Stock	176.66	176.66	176.62	176.62	2048.0
2023-10-18 04:30:00	AAPL	Stock	176.6	176.73	176.6	176.73	2528.0
2023-10-18 05:00:00	AAPL	Stock	176.61	176.73	176.38	176.38	3108.0
2023-10-18 05:30:00	AAPL	Stock	176.38	176.38	175.8	176.02	11063.0
2023-10-18 06:00:00	AAPL	Stock	176.1	176.12	175.97	175.97	5614.0
2023-10-18 06:30:00	AAPL	Stock	175.95	175.95	175.7	175.84	10676.0
2023-10-18 07:00:00	AAPL	Stock	175.98	176.1	175.71	175.88	25664.0
2023-10-18 07:30:00	AAPL	Stock	175.85	175.85	175.45	175.61	22239.0
2023-10-18 08:00:00	AAPL	Stock	175.99	176.8	175.41	175.75	62015.0
2023-10-18 08:30:00	AAPL	Stock	175.76	175.8	175.6	175.66	93504.0
2023-10-18 09:00:00	AAPL	Stock	175.66	175.75	175.35	175.59	142651.0
2023-10-18 09:30:00	AAPL	Stock	175.57	176.65	175.42	176.58	5493103.0
2023-10-18 10:00:00	AAPL	Stock	176.585	177.575	176.15	176.62	4236963.0
2023-10-18 10:30:00	AAPL	Stock	176.605	176.64	175.755	176.14	3662842.0
2023-10-18 11:00:00	AAPL	Stock	176.14	177.12	176.12	176.73	2597949.0
2023-10-18 11:30:00	AAPL	Stock	176.73	177.4	176.6301	177.02	2360490.0
2023-10-18 12:00:00	AAPL	Stock	177.015	177.53	176.72	176.82	2316342.0
2023-10-18 12:30:00	AAPL	Stock	176.82	176.945	176.26	176.38	1866699.0
2023-10-18 13:00:00	AAPL	Stock	176.3709	177.37	176.225	177.12	2378582.0
2023-10-18 13:30:00	AAPL	Stock	177.12	177.12	176.22	176.76	2035391.0
2023-10-18 14:00:00	AAPL	Stock	176.751	177.13	176.475	176.695	1931378.0
2023-10-18 14:30:00	AAPL	Stock	176.685	176.915	176.23	176.42	1622659.0
2023-10-18 15:00:00	AAPL	Stock	176.42	176.44	175.78	175.8799	2533185.0
2023-10-18 15:30:00	AAPL	Stock	175.88	176.09	175.11	175.84	5641689.0
2023-10-18 16:00:00	AAPL	Stock	175.81	175.86	175.5	175.77	6690118.0
2023-10-18 16:30:00	AAPL	Stock	175.77	175.92	175.67	175.68	87610.0
2023-10-18 17:00:00	AAPL	Stock	175.71	175.84	175.65	175.71	45716.0
2023-10-18 17:30:00	AAPL	Stock	175.7	175.84	175.56	175.62	40823.0
2023-10-18 18:00:00	AAPL	Stock	175.6	175.79	175.5	175.51	14017.0
2023-10-18 18:30:00	AAPL	Stock	175.56	175.78	175.52	175.56	15596.0
2023-10-18 19:00:00	AAPL	Stock	175.56	175.69	175.51	175.54	8899.0
2023-10-18 19:30:00	AAPL	Stock	175.52	175.59	175.4987	175.5	11544.0
2023-10-18 04:00:00	MSFT	Stock	333.25	333.3	332.52	332.52	1555.0
2023-10-18 04:30:00	MSFT	Stock	332.8	333.2	332.77	333.2	938.0
2023-10-18 05:00:00	MSFT	Stock	333.27	333.27	333.27	333.27	100.0
2023-10-18 05:30:00	MSFT	Stock	333.03	333.03	332.52	332.8	783.0
2023-10-18 06:00:00	MSFT	Stock	332.65	332.65	332.4	332.4	502.0
2023-10-18 06:30:00	MSFT	Stock	332.17	332.5	332.0	332.47	2052.0
2023-10-18 07:00:00	MSFT	Stock	332.9	333.9	332.9	333.5	7911.0
2023-10-18 07:30:00	MSFT	Stock	333.55	333.8	333.0	333.0	7328.0
2023-10-18 08:00:00	MSFT	Stock	332.75	334.0	332.75	333.25	16935.0
2023-10-18 08:30:00	MSFT	Stock	333.6	333.6	332.1	332.1	14053.0
2023-10-18 09:00:00	MSFT	Stock	332.1	333.0	332.03	332.47	13476.0
2023-10-18 09:30:00	MSFT	Stock	332.49	335.59	332.19	334.8701	2296973.0
2023-10-18 10:00:00	MSFT	Stock	334.906	335.28	333.3	333.48	1369375.0
2023-10-18 10:30:00	MSFT	Stock	333.49	333.58	331.46	332.12	1425721.0
2023-10-18 11:00:00	MSFT	Stock	332.12	333.26	331.94	332.68	734654.0
2023-10-18 11:30:00	MSFT	Stock	332.685	333.6245	332.52	332.94	519080.0
2023-10-18 12:00:00	MSFT	Stock	332.98	333.98	332.1491	332.2	563336.0
2023-10-18 12:30:00	MSFT	Stock	332.2299	332.67	331.55	331.7	542975.0

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

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