PREVIEW / stock_30min / 2023-11-20

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-11-20.parquet
  size:    2.0 MB
  rows:    99,334
  symbols: 1,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
2023-11-20 04:00:00	AAPL	Stock	189.52	189.55	188.92	189.55	16448.0
2023-11-20 04:30:00	AAPL	Stock	189.55	189.6	189.5	189.57	4589.0
2023-11-20 05:00:00	AAPL	Stock	189.55	189.68	189.5	189.51	6142.0
2023-11-20 05:30:00	AAPL	Stock	189.59	189.67	189.5	189.67	7781.0
2023-11-20 06:00:00	AAPL	Stock	189.67	189.88	189.66	189.87	2038.0
2023-11-20 06:30:00	AAPL	Stock	189.68	189.68	189.58	189.59	6533.0
2023-11-20 07:00:00	AAPL	Stock	189.67	189.68	189.5	189.5	10921.0
2023-11-20 07:30:00	AAPL	Stock	189.46	189.51	189.4	189.5	5990.0
2023-11-20 08:00:00	AAPL	Stock	189.68	190.1	189.13	190.05	78874.0
2023-11-20 08:30:00	AAPL	Stock	189.99	190.25	189.99	190.15	80422.0
2023-11-20 09:00:00	AAPL	Stock	190.13	190.3	189.55	189.86	99987.0
2023-11-20 09:30:00	AAPL	Stock	189.89	191.669	189.88	191.22	5869783.0
2023-11-20 10:00:00	AAPL	Stock	191.22	191.3687	190.43	190.715	3078422.0
2023-11-20 10:30:00	AAPL	Stock	190.72	191.12	190.53	191.1121	2233080.0
2023-11-20 11:00:00	AAPL	Stock	191.12	191.37	191.0101	191.165	2089848.0
2023-11-20 11:30:00	AAPL	Stock	191.17	191.3199	191.09	191.3199	1317074.0
2023-11-20 12:00:00	AAPL	Stock	191.32	191.55	191.2	191.23	1603928.0
2023-11-20 12:30:00	AAPL	Stock	191.25	191.355	191.08	191.15	1169988.0
2023-11-20 13:00:00	AAPL	Stock	191.16	191.8	191.13	191.625	2586448.0
2023-11-20 13:30:00	AAPL	Stock	191.62	191.77	191.51	191.6825	1192925.0
2023-11-20 14:00:00	AAPL	Stock	191.685	191.77	191.33	191.5199	1480242.0
2023-11-20 14:30:00	AAPL	Stock	191.51	191.72	191.5	191.59	1407456.0
2023-11-20 15:00:00	AAPL	Stock	191.59	191.905	191.54	191.875	1963626.0
2023-11-20 15:30:00	AAPL	Stock	191.875	191.875	191.16	191.5	4257311.0
2023-11-20 16:00:00	AAPL	Stock	191.5	191.52	191.41	191.48	8203892.0
2023-11-20 16:30:00	AAPL	Stock	191.47	191.5	191.45	191.5	64492.0
2023-11-20 17:00:00	AAPL	Stock	191.45	191.54	191.45	191.53	23873.0
2023-11-20 17:30:00	AAPL	Stock	191.49	191.54	191.462	191.5	3447.0
2023-11-20 18:00:00	AAPL	Stock	191.53	191.62	191.5148	191.53	10488.0
2023-11-20 18:30:00	AAPL	Stock	191.52	191.54	191.47	191.51	7983.0
2023-11-20 19:00:00	AAPL	Stock	191.54	191.57	191.46	191.56	6400.0
2023-11-20 19:30:00	AAPL	Stock	191.6	191.65	191.5501	191.65	4611.0
2023-11-20 04:00:00	MSFT	Stock	374.07	379.97	369.2	377.2	223248.0
2023-11-20 04:30:00	MSFT	Stock	377.35	379.5	377.35	379.3	53271.0
2023-11-20 05:00:00	MSFT	Stock	379.4	379.4	377.7	377.9	47229.0
2023-11-20 05:30:00	MSFT	Stock	377.8	377.89	375.78	375.97	53489.0
2023-11-20 06:00:00	MSFT	Stock	375.61	376.25	373.88	374.77	77110.0
2023-11-20 06:30:00	MSFT	Stock	374.72	377.99	374.64	377.3	74677.0
2023-11-20 07:00:00	MSFT	Stock	377.3	377.39	375.88	376.2	215681.0
2023-11-20 07:30:00	MSFT	Stock	376.01	376.51	373.41	373.75	192367.0
2023-11-20 08:00:00	MSFT	Stock	377.27	379.3822	359.86	372.0	708374.0
2023-11-20 08:30:00	MSFT	Stock	372.0	372.7298	370.7	371.8	370622.0
2023-11-20 09:00:00	MSFT	Stock	372.0	372.43	367.17	371.1	640780.0
2023-11-20 09:30:00	MSFT	Stock	371.01	377.1	371.0	375.515	7449189.0
2023-11-20 10:00:00	MSFT	Stock	375.525	375.65	371.8	372.9337	2598500.0
2023-11-20 10:30:00	MSFT	Stock	372.96	375.62	372.27	374.445	1820867.0
2023-11-20 11:00:00	MSFT	Stock	374.5	375.59	374.09	375.345	1489821.0
2023-11-20 11:30:00	MSFT	Stock	375.35	376.69	374.97	375.9068	1866657.0
2023-11-20 12:00:00	MSFT	Stock	375.92	377.02	375.58	376.71	1582570.0
2023-11-20 12:30:00	MSFT	Stock	376.72	377.53	376.35	376.76	1382886.0

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

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