PREVIEW / stock_30min / 2023-08-24

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-24.parquet
  size:    2.0 MB
  rows:    97,143
  symbols: 1,447

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-24 04:00:00	AAPL	Stock	182.04	182.78	182.0	182.44	37854.0
2023-08-24 04:30:00	AAPL	Stock	182.4	182.44	181.79	181.99	20311.0
2023-08-24 05:00:00	AAPL	Stock	181.94	181.95	181.39	181.78	29258.0
2023-08-24 05:30:00	AAPL	Stock	181.76	181.88	181.55	181.88	14611.0
2023-08-24 06:00:00	AAPL	Stock	181.85	181.9	181.75	181.8	28747.0
2023-08-24 06:30:00	AAPL	Stock	181.79	181.89	181.72	181.76	14094.0
2023-08-24 07:00:00	AAPL	Stock	181.7	182.0	181.5	181.83	40838.0
2023-08-24 07:30:00	AAPL	Stock	181.77	181.94	181.49	181.49	22374.0
2023-08-24 08:00:00	AAPL	Stock	181.67	183.34	180.8204	181.15	217653.0
2023-08-24 08:30:00	AAPL	Stock	181.15	181.27	180.34	180.74	113355.0
2023-08-24 09:00:00	AAPL	Stock	180.76	181.1	180.28	180.68	181099.0
2023-08-24 09:30:00	AAPL	Stock	180.73	181.104	179.61	180.02	4957936.0
2023-08-24 10:00:00	AAPL	Stock	180.02	180.13	178.39	178.402	3517003.0
2023-08-24 10:30:00	AAPL	Stock	178.4099	178.4562	177.68	177.895	3753688.0
2023-08-24 11:00:00	AAPL	Stock	177.91	178.41	177.65	178.125	2432853.0
2023-08-24 11:30:00	AAPL	Stock	178.12	178.13	177.52	177.6099	2241871.0
2023-08-24 12:00:00	AAPL	Stock	177.61	178.3	177.5	178.0599	1486223.0
2023-08-24 12:30:00	AAPL	Stock	178.05	178.31	177.95	177.955	1246714.0
2023-08-24 13:00:00	AAPL	Stock	177.96	178.14	177.6806	177.74	1049097.0
2023-08-24 13:30:00	AAPL	Stock	177.73	177.93	177.43	177.5514	1240608.0
2023-08-24 14:00:00	AAPL	Stock	177.56	177.88	177.465	177.524	1555256.0
2023-08-24 14:30:00	AAPL	Stock	177.52	177.64	177.0	177.3537	2016058.0
2023-08-24 15:00:00	AAPL	Stock	177.36	177.47	176.8	176.82	2197689.0
2023-08-24 15:30:00	AAPL	Stock	176.82	176.89	176.01	176.33	6135359.0
2023-08-24 16:00:00	AAPL	Stock	176.32	176.4645	176.0	176.02	10616002.0
2023-08-24 16:30:00	AAPL	Stock	176.03	176.38	175.92	176.09	160908.0
2023-08-24 17:00:00	AAPL	Stock	176.09	176.1	175.88	175.95	14971.0
2023-08-24 17:30:00	AAPL	Stock	175.95	176.08	175.91	176.05	17205.0
2023-08-24 18:00:00	AAPL	Stock	176.0599	176.38	176.0599	176.35	23934.0
2023-08-24 18:30:00	AAPL	Stock	176.37	176.65	176.37	176.6014	16041.0
2023-08-24 19:00:00	AAPL	Stock	176.57	176.57	176.22	176.25	8208.0
2023-08-24 19:30:00	AAPL	Stock	176.38	176.48	176.27	176.33	11491.0
2023-08-24 04:00:00	MSFT	Stock	332.42	334.71	332.42	333.98	7360.0
2023-08-24 04:30:00	MSFT	Stock	333.67	333.71	333.2	333.2	2727.0
2023-08-24 05:00:00	MSFT	Stock	333.2	333.2	333.0	333.0	2381.0
2023-08-24 05:30:00	MSFT	Stock	333.0	333.0	332.66	332.77	4248.0
2023-08-24 06:00:00	MSFT	Stock	333.0	333.27	332.42	333.27	8426.0
2023-08-24 06:30:00	MSFT	Stock	333.0	333.01	332.5	332.5	1685.0
2023-08-24 07:00:00	MSFT	Stock	332.9	334.68	332.85	334.02	25444.0
2023-08-24 07:30:00	MSFT	Stock	333.85	333.85	333.3	333.31	4609.0
2023-08-24 08:00:00	MSFT	Stock	333.13	334.6785	332.3	333.4	52101.0
2023-08-24 08:30:00	MSFT	Stock	333.4	333.4	332.59	333.02	39442.0
2023-08-24 09:00:00	MSFT	Stock	332.81	333.3	332.36	332.86	48975.0
2023-08-24 09:30:00	MSFT	Stock	332.85	332.98	327.42	329.43	2170170.0
2023-08-24 10:00:00	MSFT	Stock	329.47	329.865	324.83	325.14	1445638.0
2023-08-24 10:30:00	MSFT	Stock	325.145	325.55	324.14	324.5	854176.0
2023-08-24 11:00:00	MSFT	Stock	324.51	324.53	322.24	322.68	954989.0
2023-08-24 11:30:00	MSFT	Stock	322.65	322.89	321.06	321.345	756636.0
2023-08-24 12:00:00	MSFT	Stock	321.38	322.64	321.32	322.0714	600941.0
2023-08-24 12:30:00	MSFT	Stock	322.13	323.25	321.97	322.42	454155.0

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

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