PREVIEW / stock_30min / 2022-11-14

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-11-14.parquet
  size:    2.1 MB
  rows:    105,006
  symbols: 2,144

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-11-14 04:00:00	AAPL	Stock	149.24	149.24	148.26	148.5	20377.0
2022-11-14 04:30:00	AAPL	Stock	148.61	148.72	148.4	148.4	18963.0
2022-11-14 05:00:00	AAPL	Stock	148.45	148.49	148.12	148.44	10520.0
2022-11-14 05:30:00	AAPL	Stock	148.32	148.36	148.2	148.36	23758.0
2022-11-14 06:00:00	AAPL	Stock	148.36	148.36	148.25	148.25	832.0
2022-11-14 06:30:00	AAPL	Stock	148.28	148.34	148.23	148.3	4647.0
2022-11-14 07:00:00	AAPL	Stock	148.32	148.75	148.25	148.74	36530.0
2022-11-14 07:30:00	AAPL	Stock	148.68	148.87	148.64	148.82	40345.0
2022-11-14 08:00:00	AAPL	Stock	148.44	148.88	147.96	148.75	120882.0
2022-11-14 08:30:00	AAPL	Stock	148.68	148.75	148.41	148.55	97702.0
2022-11-14 09:00:00	AAPL	Stock	148.55	149.7	148.26	149.06	540110.0
2022-11-14 09:30:00	AAPL	Stock	149.06	149.46	147.43	147.9	8593697.0
2022-11-14 10:00:00	AAPL	Stock	147.91	148.6651	147.71	148.1228	4607229.0
2022-11-14 10:30:00	AAPL	Stock	148.13	148.41	147.81	148.25	3556830.0
2022-11-14 11:00:00	AAPL	Stock	148.23	148.3	147.62	147.64	3479855.0
2022-11-14 11:30:00	AAPL	Stock	147.64	148.55	147.5399	148.4212	4098420.0
2022-11-14 12:00:00	AAPL	Stock	148.4299	149.25	148.26	148.9601	3406201.0
2022-11-14 12:30:00	AAPL	Stock	148.97	149.28	148.83	148.84	2209569.0
2022-11-14 13:00:00	AAPL	Stock	148.84	149.8	148.701	149.715	2940872.0
2022-11-14 13:30:00	AAPL	Stock	149.72	150.2	149.45	150.18	2868501.0
2022-11-14 14:00:00	AAPL	Stock	150.18	150.28	149.68	150.0	2965896.0
2022-11-14 14:30:00	AAPL	Stock	150.0	150.21	149.5	149.55	2972535.0
2022-11-14 15:00:00	AAPL	Stock	149.56	150.1599	149.11	149.3116	3785752.0
2022-11-14 15:30:00	AAPL	Stock	149.32	149.435	148.07	148.37	6758998.0
2022-11-14 16:00:00	AAPL	Stock	148.37	148.75	148.21	148.47	10108904.0
2022-11-14 16:30:00	AAPL	Stock	148.47	148.65	148.28	148.54	409716.0
2022-11-14 17:00:00	AAPL	Stock	148.52	148.59	148.41	148.59	40247.0
2022-11-14 17:30:00	AAPL	Stock	148.5	148.58	148.5	148.5	5653.0
2022-11-14 18:00:00	AAPL	Stock	148.68	148.81	148.55	148.68	15737.0
2022-11-14 18:30:00	AAPL	Stock	148.75	148.95	148.66	148.83	17712.0
2022-11-14 19:00:00	AAPL	Stock	148.84	148.94	148.76	148.84	8959.0
2022-11-14 19:30:00	AAPL	Stock	148.8	148.89	148.71	148.76	12391.0
2022-11-14 04:00:00	MSFT	Stock	246.48	246.48	245.27	245.27	4708.0
2022-11-14 04:30:00	MSFT	Stock	245.27	245.27	245.2	245.2	1120.0
2022-11-14 05:00:00	MSFT	Stock	245.15	245.53	245.0	245.53	12466.0
2022-11-14 05:30:00	MSFT	Stock	245.47	245.76	245.22	245.76	1175.0
2022-11-14 06:00:00	MSFT	Stock	245.62	245.7	245.5	245.52	1926.0
2022-11-14 06:30:00	MSFT	Stock	245.42	245.87	245.42	245.45	4065.0
2022-11-14 07:00:00	MSFT	Stock	245.55	245.55	244.85	245.3	18497.0
2022-11-14 07:30:00	MSFT	Stock	245.21	245.21	244.16	244.37	20320.0
2022-11-14 08:00:00	MSFT	Stock	245.55	245.55	243.55	244.05	36068.0
2022-11-14 08:30:00	MSFT	Stock	244.05	244.34	243.7	243.92	17257.0
2022-11-14 09:00:00	MSFT	Stock	243.88	247.11	241.69	241.99	151035.0
2022-11-14 09:30:00	MSFT	Stock	241.99	242.2	239.21	241.54	4039020.0
2022-11-14 10:00:00	MSFT	Stock	241.55	243.22	241.47	242.29	1887446.0
2022-11-14 10:30:00	MSFT	Stock	242.3	242.33	241.15	241.6889	1413581.0
2022-11-14 11:00:00	MSFT	Stock	241.68	242.075	240.8267	241.73	1077432.0
2022-11-14 11:30:00	MSFT	Stock	241.73	243.15	241.5513	242.35	1155067.0
2022-11-14 12:00:00	MSFT	Stock	242.36	242.96	241.73	242.3866	860280.0
2022-11-14 12:30:00	MSFT	Stock	242.38	243.19	242.36	242.5765	780838.0

> showing 50 of 105,006 rows — these rows as CSV

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