PREVIEW / stock_30min / 2022-10-24

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-10-24.parquet
  size:    2.1 MB
  rows:    102,441
  symbols: 2,135

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
2022-10-24 04:00:00	AAPL	Stock	147.9	147.9	145.74	145.85	59711.0
2022-10-24 04:30:00	AAPL	Stock	145.77	146.26	145.64	146.06	19430.0
2022-10-24 05:00:00	AAPL	Stock	146.11	146.3	145.9	145.9	10188.0
2022-10-24 05:30:00	AAPL	Stock	145.98	146.78	145.96	146.65	20214.0
2022-10-24 06:00:00	AAPL	Stock	146.67	147.14	146.5	146.87	29469.0
2022-10-24 06:30:00	AAPL	Stock	146.8	147.27	146.65	147.26	25228.0
2022-10-24 07:00:00	AAPL	Stock	147.27	147.55	147.2	147.55	101059.0
2022-10-24 07:30:00	AAPL	Stock	147.55	148.15	147.44	147.83	64956.0
2022-10-24 08:00:00	AAPL	Stock	147.39	148.13	146.56	147.07	179973.0
2022-10-24 08:30:00	AAPL	Stock	147.04	147.42	146.41	147.24	109726.0
2022-10-24 09:00:00	AAPL	Stock	147.25	147.35	146.87	147.11	176433.0
2022-10-24 09:30:00	AAPL	Stock	147.12	148.35	146.25	148.2811	10698625.0
2022-10-24 10:00:00	AAPL	Stock	148.29	148.34	146.0	146.6302	5605868.0
2022-10-24 10:30:00	AAPL	Stock	146.6301	147.75	146.47	147.69	4697613.0
2022-10-24 11:00:00	AAPL	Stock	147.6813	148.45	147.41	148.21	4284556.0
2022-10-24 11:30:00	AAPL	Stock	148.2199	148.49	147.53	148.475	3653928.0
2022-10-24 12:00:00	AAPL	Stock	148.47	148.82	148.185	148.4361	3441588.0
2022-10-24 12:30:00	AAPL	Stock	148.435	148.73	148.26	148.495	3017292.0
2022-10-24 13:00:00	AAPL	Stock	148.5	148.53	147.91	148.08	2471643.0
2022-10-24 13:30:00	AAPL	Stock	148.07	148.7	147.93	148.55	2363902.0
2022-10-24 14:00:00	AAPL	Stock	148.56	149.365	148.5	149.285	2885950.0
2022-10-24 14:30:00	AAPL	Stock	149.28	149.87	149.24	149.7897	3625070.0
2022-10-24 15:00:00	AAPL	Stock	149.785	150.23	149.72	149.98	5289139.0
2022-10-24 15:30:00	AAPL	Stock	149.975	150.04	149.13	149.56	6623320.0
2022-10-24 16:00:00	AAPL	Stock	149.56	149.68	149.36	149.43	7111046.0
2022-10-24 16:30:00	AAPL	Stock	149.44	149.48	149.29	149.35	47652.0
2022-10-24 17:00:00	AAPL	Stock	149.36	149.56	149.28	149.42	47537.0
2022-10-24 17:30:00	AAPL	Stock	149.47	149.53	149.41	149.41	37862.0
2022-10-24 18:00:00	AAPL	Stock	149.43	149.58	149.42	149.43	14204.0
2022-10-24 18:30:00	AAPL	Stock	149.45	149.55	149.43	149.54	7705.0
2022-10-24 19:00:00	AAPL	Stock	149.54	149.65	149.51	149.55	22699.0
2022-10-24 19:30:00	AAPL	Stock	149.54	149.6	149.5	149.59	20006.0
2022-10-24 04:00:00	MSFT	Stock	241.99	242.21	240.91	241.49	15141.0
2022-10-24 04:30:00	MSFT	Stock	241.3	241.99	241.3	241.99	2605.0
2022-10-24 05:00:00	MSFT	Stock	241.58	241.95	241.58	241.68	2556.0
2022-10-24 05:30:00	MSFT	Stock	241.98	243.3	241.98	243.0	3236.0
2022-10-24 06:00:00	MSFT	Stock	243.26	244.05	242.1	243.75	2994.0
2022-10-24 06:30:00	MSFT	Stock	243.63	244.47	243.1	244.26	7038.0
2022-10-24 07:00:00	MSFT	Stock	243.64	244.5	243.47	244.4	13640.0
2022-10-24 07:30:00	MSFT	Stock	244.36	244.98	244.21	244.51	12653.0
2022-10-24 08:00:00	MSFT	Stock	244.0	245.17	241.515	244.25	59894.0
2022-10-24 08:30:00	MSFT	Stock	244.2	245.12	242.12	244.688	27748.0
2022-10-24 09:00:00	MSFT	Stock	244.69	244.75	243.16	243.82	30642.0
2022-10-24 09:30:00	MSFT	Stock	243.63	245.73	241.5	244.63	3101349.0
2022-10-24 10:00:00	MSFT	Stock	244.62	244.66	241.295	242.48	1784047.0
2022-10-24 10:30:00	MSFT	Stock	242.485	244.52	242.275	244.2344	1304535.0
2022-10-24 11:00:00	MSFT	Stock	244.245	244.5972	243.37	244.52	883497.0
2022-10-24 11:30:00	MSFT	Stock	244.4799	245.84	244.13	245.77	1043260.0
2022-10-24 12:00:00	MSFT	Stock	245.77	246.7	245.27	246.125	988471.0
2022-10-24 12:30:00	MSFT	Stock	246.13	246.4	245.48	246.05	535942.0

> showing 50 of 102,441 rows — these rows as CSV

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