PREVIEW / stock_30min / 2023-08-31

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-31.parquet
  size:    2.0 MB
  rows:    99,098
  symbols: 1,458

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-31 04:00:00	AAPL	Stock	187.8	187.83	187.69	187.8	3862.0
2023-08-31 04:30:00	AAPL	Stock	187.72	187.75	187.65	187.7	3952.0
2023-08-31 05:00:00	AAPL	Stock	187.71	187.74	187.29	187.35	16602.0
2023-08-31 05:30:00	AAPL	Stock	187.38	187.4	187.21	187.29	6115.0
2023-08-31 06:00:00	AAPL	Stock	187.3	187.67	187.3	187.66	5474.0
2023-08-31 06:30:00	AAPL	Stock	187.64	187.64	187.56	187.56	1298.0
2023-08-31 07:00:00	AAPL	Stock	187.56	188.0	187.44	188.0	16118.0
2023-08-31 07:30:00	AAPL	Stock	188.0	188.35	187.99	188.25	19624.0
2023-08-31 08:00:00	AAPL	Stock	187.59	188.36	187.2851	188.3	131709.0
2023-08-31 08:30:00	AAPL	Stock	188.27	188.33	187.61	187.8	136989.0
2023-08-31 09:00:00	AAPL	Stock	187.84	187.9	187.45	187.9	88661.0
2023-08-31 09:30:00	AAPL	Stock	187.86	188.5099	187.68	188.0544	5078484.0
2023-08-31 10:00:00	AAPL	Stock	188.08	188.41	187.65	188.33	2871336.0
2023-08-31 10:30:00	AAPL	Stock	188.34	188.76	188.115	188.485	2580072.0
2023-08-31 11:00:00	AAPL	Stock	188.49	188.535	188.12	188.49	1681524.0
2023-08-31 11:30:00	AAPL	Stock	188.485	188.6481	188.095	188.225	1662687.0
2023-08-31 12:00:00	AAPL	Stock	188.23	188.48	187.78	187.98	1908791.0
2023-08-31 12:30:00	AAPL	Stock	187.98	188.05	187.48	187.82	2099270.0
2023-08-31 13:00:00	AAPL	Stock	187.82	188.17	187.74	188.14	1756752.0
2023-08-31 13:30:00	AAPL	Stock	188.14	188.19	187.8298	188.02	1283067.0
2023-08-31 14:00:00	AAPL	Stock	188.015	188.68	187.98	188.595	1852904.0
2023-08-31 14:30:00	AAPL	Stock	188.595	188.69	188.415	188.51	2072527.0
2023-08-31 15:00:00	AAPL	Stock	188.5	189.06	188.495	188.9101	2611897.0
2023-08-31 15:30:00	AAPL	Stock	188.92	189.12	187.75	187.87	7986092.0
2023-08-31 16:00:00	AAPL	Stock	187.88	188.22	187.63	187.9722	13461791.0
2023-08-31 16:30:00	AAPL	Stock	188.0	188.25	187.87	188.13	92128.0
2023-08-31 17:00:00	AAPL	Stock	188.13	188.24	188.0	188.0204	59185.0
2023-08-31 17:30:00	AAPL	Stock	188.05	188.17	188.02	188.12	9265.0
2023-08-31 18:00:00	AAPL	Stock	188.14	188.19	187.9665	188.19	13537.0
2023-08-31 18:30:00	AAPL	Stock	188.16	188.25	188.06	188.07	10113.0
2023-08-31 19:00:00	AAPL	Stock	188.05	188.12	187.91	188.0	10234.0
2023-08-31 19:30:00	AAPL	Stock	188.0	188.2	188.0	188.11	14162.0
2023-08-31 04:00:00	MSFT	Stock	329.59	329.7	329.19	329.7	939.0
2023-08-31 04:30:00	MSFT	Stock	329.59	329.59	329.59	329.59	300.0
2023-08-31 05:00:00	MSFT	Stock	329.13	329.13	329.09	329.09	2520.0
2023-08-31 05:30:00	MSFT	Stock	329.02	329.02	328.7	328.7	1778.0
2023-08-31 06:00:00	MSFT	Stock	328.7	328.7	328.7	328.7	700.0
2023-08-31 06:30:00	MSFT	Stock	328.88	328.88	328.88	328.88	100.0
2023-08-31 07:00:00	MSFT	Stock	328.7	328.9	328.7	328.9	828.0
2023-08-31 07:30:00	MSFT	Stock	329.18	329.3	329.1	329.3	2022.0
2023-08-31 08:00:00	MSFT	Stock	328.72	329.6	328.39	329.4	12335.0
2023-08-31 08:30:00	MSFT	Stock	329.24	329.5	328.01	328.9	23790.0
2023-08-31 09:00:00	MSFT	Stock	328.9	329.6	328.0	329.29	20116.0
2023-08-31 09:30:00	MSFT	Stock	329.2	330.9099	328.38	329.05	1588007.0
2023-08-31 10:00:00	MSFT	Stock	329.08	330.07	328.59	329.655	795321.0
2023-08-31 10:30:00	MSFT	Stock	329.7	329.7	327.58	328.3	745319.0
2023-08-31 11:00:00	MSFT	Stock	328.28	328.4	327.09	327.62	739054.0
2023-08-31 11:30:00	MSFT	Stock	327.61	328.12	327.1	327.95	719851.0
2023-08-31 12:00:00	MSFT	Stock	327.95	328.08	326.78	327.29	586238.0
2023-08-31 12:30:00	MSFT	Stock	327.28	327.6	327.0	327.47	502747.0

> showing 50 of 99,098 rows — these rows as CSV

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