PREVIEW / stock_30min / 2023-11-27

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-11-27.parquet
  size:    2.0 MB
  rows:    99,458
  symbols: 1,336

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-11-27 04:00:00	AAPL	Stock	189.6	189.6	189.2	189.3	7147.0
2023-11-27 04:30:00	AAPL	Stock	189.3	189.31	189.25	189.28	2924.0
2023-11-27 05:00:00	AAPL	Stock	189.27	189.4	189.27	189.4	927.0
2023-11-27 05:30:00	AAPL	Stock	189.43	189.51	189.43	189.51	1851.0
2023-11-27 06:00:00	AAPL	Stock	189.55	189.55	189.45	189.5	1390.0
2023-11-27 06:30:00	AAPL	Stock	189.45	189.45	189.38	189.4	2388.0
2023-11-27 07:00:00	AAPL	Stock	189.4	189.7	189.39	189.56	10375.0
2023-11-27 07:30:00	AAPL	Stock	189.56	189.63	189.5	189.63	7060.0
2023-11-27 08:00:00	AAPL	Stock	189.67	190.07	188.9	189.9	57451.0
2023-11-27 08:30:00	AAPL	Stock	189.87	189.97	189.6	189.61	39139.0
2023-11-27 09:00:00	AAPL	Stock	189.6634	189.95	189.36	189.91	82305.0
2023-11-27 09:30:00	AAPL	Stock	189.91	190.39	188.9	189.25	3922599.0
2023-11-27 10:00:00	AAPL	Stock	189.25	189.91	189.02	189.07	2422260.0
2023-11-27 10:30:00	AAPL	Stock	189.06	189.44	189.01	189.335	1608231.0
2023-11-27 11:00:00	AAPL	Stock	189.33	189.5	189.045	189.495	1392581.0
2023-11-27 11:30:00	AAPL	Stock	189.49	190.42	189.44	190.27	2451163.0
2023-11-27 12:00:00	AAPL	Stock	190.27	190.51	190.205	190.37	1558902.0
2023-11-27 12:30:00	AAPL	Stock	190.379	190.49	190.2558	190.45	966293.0
2023-11-27 13:00:00	AAPL	Stock	190.459	190.67	190.29	190.365	1485305.0
2023-11-27 13:30:00	AAPL	Stock	190.365	190.365	190.02	190.12	1261950.0
2023-11-27 14:00:00	AAPL	Stock	190.13	190.19	189.95	190.07	967583.0
2023-11-27 14:30:00	AAPL	Stock	190.075	190.075	189.52	189.885	1249162.0
2023-11-27 15:00:00	AAPL	Stock	189.885	189.93	189.64	189.84	1224624.0
2023-11-27 15:30:00	AAPL	Stock	189.85	190.06	189.605	189.78	3926619.0
2023-11-27 16:00:00	AAPL	Stock	189.78	190.14	189.78	189.85	7082316.0
2023-11-27 16:30:00	AAPL	Stock	189.89	189.95	189.79	189.95	21052.0
2023-11-27 17:00:00	AAPL	Stock	189.95	190.1	189.91	190.059	34460.0
2023-11-27 17:30:00	AAPL	Stock	190.04	190.08	190.04	190.08	4203.0
2023-11-27 18:00:00	AAPL	Stock	190.05	190.11	190.05	190.11	6795.0
2023-11-27 18:30:00	AAPL	Stock	190.11	190.2	190.11	190.16	20678.0
2023-11-27 19:00:00	AAPL	Stock	190.13	190.13	189.91	189.91	12309.0
2023-11-27 19:30:00	AAPL	Stock	189.88	190.17	189.88	190.15	5184.0
2023-11-27 04:00:00	MSFT	Stock	377.0	377.85	376.8	376.8	1897.0
2023-11-27 05:00:00	MSFT	Stock	376.9	377.13	376.9	377.13	352.0
2023-11-27 05:30:00	MSFT	Stock	377.28	377.28	377.28	377.28	110.0
2023-11-27 06:30:00	MSFT	Stock	377.0	377.0	376.7	376.7	718.0
2023-11-27 07:00:00	MSFT	Stock	376.8	377.3	376.8	376.92	4863.0
2023-11-27 07:30:00	MSFT	Stock	376.77	376.85	376.31	376.34	6516.0
2023-11-27 08:00:00	MSFT	Stock	376.8887	377.41	376.01	376.62	19095.0
2023-11-27 08:30:00	MSFT	Stock	376.66	377.43	376.22	376.22	11631.0
2023-11-27 09:00:00	MSFT	Stock	376.33	376.79	376.01	376.79	17924.0
2023-11-27 09:30:00	MSFT	Stock	376.8	378.18	376.2	377.63	1558813.0
2023-11-27 10:00:00	MSFT	Stock	377.66	377.94	376.82	376.94	910706.0
2023-11-27 10:30:00	MSFT	Stock	376.99	378.145	376.99	377.975	629387.0
2023-11-27 11:00:00	MSFT	Stock	377.95	377.955	377.25	377.715	602153.0
2023-11-27 11:30:00	MSFT	Stock	377.7	379.0595	377.6323	379.02	742109.0
2023-11-27 12:00:00	MSFT	Stock	379.04	379.91	378.94	379.84	984394.0
2023-11-27 12:30:00	MSFT	Stock	379.85	380.59	379.58	380.3505	988493.0
2023-11-27 13:00:00	MSFT	Stock	380.36	380.64	379.7501	379.92	698600.0
2023-11-27 13:30:00	MSFT	Stock	379.93	380.0505	379.39	379.725	477329.0

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

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