PREVIEW / stock_30min / 2022-09-26

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-26.parquet
  size:    2.1 MB
  rows:    105,195
  symbols: 2,281

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-09-26 04:00:00	AAPL	Stock	150.39	150.7	149.96	150.7	30124.0
2022-09-26 04:30:00	AAPL	Stock	150.7	150.8	150.15	150.38	5304.0
2022-09-26 05:00:00	AAPL	Stock	150.45	150.45	149.85	149.85	5627.0
2022-09-26 05:30:00	AAPL	Stock	149.7	149.7	149.17	149.4	15153.0
2022-09-26 06:00:00	AAPL	Stock	149.39	149.75	149.23	149.74	15939.0
2022-09-26 06:30:00	AAPL	Stock	149.69	149.78	149.5	149.55	20346.0
2022-09-26 07:00:00	AAPL	Stock	149.52	149.65	149.27	149.65	45610.0
2022-09-26 07:30:00	AAPL	Stock	149.63	149.82	149.55	149.8	38176.0
2022-09-26 08:00:00	AAPL	Stock	149.78	150.42	148.83	149.92	140173.0
2022-09-26 08:30:00	AAPL	Stock	149.93	150.56	149.57	150.53	113309.0
2022-09-26 09:00:00	AAPL	Stock	150.5	150.5199	149.42	149.79	346630.0
2022-09-26 09:30:00	AAPL	Stock	149.66	152.75	149.64	152.6818	12337943.0
2022-09-26 10:00:00	AAPL	Stock	152.69	153.7701	152.36	153.5873	7222350.0
2022-09-26 10:30:00	AAPL	Stock	153.5797	153.7	152.3	152.52	5552517.0
2022-09-26 11:00:00	AAPL	Stock	152.53	152.84	151.6993	151.715	5396370.0
2022-09-26 11:30:00	AAPL	Stock	151.715	151.99	150.9201	151.9	5666194.0
2022-09-26 12:00:00	AAPL	Stock	151.91	152.09	150.8	150.8672	4022610.0
2022-09-26 12:30:00	AAPL	Stock	150.86	151.54	150.53	151.38	3627792.0
2022-09-26 13:00:00	AAPL	Stock	151.38	151.44	150.4	150.75	3387725.0
2022-09-26 13:30:00	AAPL	Stock	150.74	151.11	150.04	150.11	3478107.0
2022-09-26 14:00:00	AAPL	Stock	150.1	151.3	150.0407	150.65	3429073.0
2022-09-26 14:30:00	AAPL	Stock	150.65	151.7	150.3	151.53	4070533.0
2022-09-26 15:00:00	AAPL	Stock	151.53	151.86	151.17	151.675	4342841.0
2022-09-26 15:30:00	AAPL	Stock	151.68	152.0	150.56	150.75	9120490.0
2022-09-26 16:00:00	AAPL	Stock	150.75	151.1347	150.42	150.57	7826883.0
2022-09-26 16:30:00	AAPL	Stock	150.56	150.77	150.49	150.59	75189.0
2022-09-26 17:00:00	AAPL	Stock	150.57	150.77	150.57	150.6	26935.0
2022-09-26 17:30:00	AAPL	Stock	150.5537	150.6665	150.53	150.649	25017.0
2022-09-26 18:00:00	AAPL	Stock	150.65	150.91	150.5	150.61	38549.0
2022-09-26 18:30:00	AAPL	Stock	150.63	150.98	150.57	150.78	11839.0
2022-09-26 19:00:00	AAPL	Stock	150.77	151.17	150.75	151.03	18819.0
2022-09-26 19:30:00	AAPL	Stock	151.05	151.23	150.9	151.1	39184.0
2022-09-26 04:00:00	MSFT	Stock	237.8	238.3	237.3	238.3	3387.0
2022-09-26 04:30:00	MSFT	Stock	238.55	238.55	238.38	238.47	937.0
2022-09-26 05:00:00	MSFT	Stock	238.37	238.37	237.0	237.0	4579.0
2022-09-26 05:30:00	MSFT	Stock	237.0	237.04	236.39	236.51	4392.0
2022-09-26 06:00:00	MSFT	Stock	236.52	237.2	236.37	237.2	1589.0
2022-09-26 06:30:00	MSFT	Stock	236.88	237.0	236.88	236.9	495.0
2022-09-26 07:00:00	MSFT	Stock	237.2	237.3	236.41	236.88	19139.0
2022-09-26 07:30:00	MSFT	Stock	237.0	237.1	236.79	236.79	2503.0
2022-09-26 08:00:00	MSFT	Stock	236.9003	237.5	236.4	237.36	25357.0
2022-09-26 08:30:00	MSFT	Stock	237.3	238.5666	236.93	238.5666	18774.0
2022-09-26 09:00:00	MSFT	Stock	238.35	238.35	235.66	236.99	143246.0
2022-09-26 09:30:00	MSFT	Stock	237.04	240.71	236.95	240.54	3029465.0
2022-09-26 10:00:00	MSFT	Stock	240.565	241.26	239.86	241.04	1600155.0
2022-09-26 10:30:00	MSFT	Stock	241.08	241.45	239.78	240.57	1392050.0
2022-09-26 11:00:00	MSFT	Stock	240.57	240.84	238.75	238.7706	1044688.0
2022-09-26 11:30:00	MSFT	Stock	238.81	239.83	238.375	239.67	829968.0
2022-09-26 12:00:00	MSFT	Stock	239.69	239.7319	237.83	238.08	779649.0
2022-09-26 12:30:00	MSFT	Stock	238.07	239.33	237.7918	239.0827	729972.0

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

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