PREVIEW / stock_30min / 2023-08-04

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-04.parquet
  size:    2.0 MB
  rows:    98,999
  symbols: 1,481

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-08-04 04:00:00	AAPL	Stock	187.31	188.92	187.04	187.84	60809.0
2023-08-04 04:30:00	AAPL	Stock	187.8	188.25	187.55	187.81	14733.0
2023-08-04 05:00:00	AAPL	Stock	187.83	188.0	187.68	187.99	11661.0
2023-08-04 05:30:00	AAPL	Stock	187.96	187.96	187.51	187.51	18416.0
2023-08-04 06:00:00	AAPL	Stock	187.58	187.7	187.56	187.63	12845.0
2023-08-04 06:30:00	AAPL	Stock	187.63	187.75	187.22	187.37	23045.0
2023-08-04 07:00:00	AAPL	Stock	187.42	187.44	186.45	186.45	133695.0
2023-08-04 07:30:00	AAPL	Stock	186.46	186.77	186.22	186.65	117400.0
2023-08-04 08:00:00	AAPL	Stock	187.31	189.19	185.68	185.9	535709.0
2023-08-04 08:30:00	AAPL	Stock	185.88	191.17	185.01	186.01	950377.0
2023-08-04 09:00:00	AAPL	Stock	186.0	186.75	185.05	185.56	710278.0
2023-08-04 09:30:00	AAPL	Stock	185.52	187.38	183.25	185.295	21191537.0
2023-08-04 10:00:00	AAPL	Stock	185.3	185.77	184.27	185.11	8003373.0
2023-08-04 10:30:00	AAPL	Stock	185.1	185.635	184.91	185.36	4862308.0
2023-08-04 11:00:00	AAPL	Stock	185.37	186.375	185.18	185.31	4340622.0
2023-08-04 11:30:00	AAPL	Stock	185.315	185.78	184.93	185.6	4006641.0
2023-08-04 12:00:00	AAPL	Stock	185.605	185.68	185.08	185.48	2498041.0
2023-08-04 12:30:00	AAPL	Stock	185.48	185.495	185.19	185.22	1945987.0
2023-08-04 13:00:00	AAPL	Stock	185.23	185.26	184.79	184.98	3593184.0
2023-08-04 13:30:00	AAPL	Stock	184.98	185.17	184.87	184.91	2759667.0
2023-08-04 14:00:00	AAPL	Stock	184.91	184.915	183.18	183.365	7119547.0
2023-08-04 14:30:00	AAPL	Stock	183.365	183.55	182.07	182.35	6859890.0
2023-08-04 15:00:00	AAPL	Stock	182.355	183.24	182.32	182.69	5136484.0
2023-08-04 15:30:00	AAPL	Stock	182.7	182.88	181.92	181.99	10243556.0
2023-08-04 16:00:00	AAPL	Stock	182.0	182.12	181.72	182.06	8041210.0
2023-08-04 16:30:00	AAPL	Stock	182.05	182.2	181.8	182.13	476647.0
2023-08-04 17:00:00	AAPL	Stock	182.09	182.17	181.96	182.0	113985.0
2023-08-04 17:30:00	AAPL	Stock	182.01	182.02	181.81	181.84	50441.0
2023-08-04 18:00:00	AAPL	Stock	181.86	181.89	181.83	181.86	30772.0
2023-08-04 18:30:00	AAPL	Stock	181.8506	181.91	181.85	181.89	25291.0
2023-08-04 19:00:00	AAPL	Stock	181.9	181.9	181.85	181.86	17963.0
2023-08-04 19:30:00	AAPL	Stock	181.87	182.05	181.86	182.05	53307.0
2023-08-04 04:00:00	MSFT	Stock	329.96	331.0	329.61	331.0	3681.0
2023-08-04 04:30:00	MSFT	Stock	330.51	330.51	330.2	330.2	1806.0
2023-08-04 05:00:00	MSFT	Stock	330.32	330.36	330.32	330.36	200.0
2023-08-04 05:30:00	MSFT	Stock	330.58	330.58	330.27	330.27	1247.0
2023-08-04 06:00:00	MSFT	Stock	330.24	330.24	330.0	330.03	2473.0
2023-08-04 06:30:00	MSFT	Stock	330.1	330.1	329.51	329.83	3013.0
2023-08-04 07:00:00	MSFT	Stock	329.8	330.0	329.09	329.24	12213.0
2023-08-04 07:30:00	MSFT	Stock	329.12	329.42	328.66	329.29	13196.0
2023-08-04 08:00:00	MSFT	Stock	329.2	331.0	328.83	329.9626	35936.0
2023-08-04 08:30:00	MSFT	Stock	329.96	331.48	328.8	331.15	93700.0
2023-08-04 09:00:00	MSFT	Stock	331.15	332.25	331.0	332.02	54822.0
2023-08-04 09:30:00	MSFT	Stock	331.95	335.14	329.83	330.5081	4058129.0
2023-08-04 10:00:00	MSFT	Stock	330.474	331.3636	328.975	331.07	1340535.0
2023-08-04 10:30:00	MSFT	Stock	331.1399	332.4299	331.0	331.74	911093.0
2023-08-04 11:00:00	MSFT	Stock	331.78	332.9564	331.55	332.685	679301.0
2023-08-04 11:30:00	MSFT	Stock	332.72	333.54	332.2	332.89	733639.0
2023-08-04 12:00:00	MSFT	Stock	332.9	334.079	332.62	333.7	668119.0
2023-08-04 12:30:00	MSFT	Stock	333.71	334.2999	333.5	333.82	692033.0

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

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