PREVIEW / stock_30min / 2022-08-29

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-08-29.parquet
  size:    2.1 MB
  rows:    105,082
  symbols: 2,230

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-08-29 04:00:00	AAPL	Stock	161.98	162.04	160.3	161.55	47183.0
2022-08-29 04:30:00	AAPL	Stock	161.62	161.64	161.24	161.24	15760.0
2022-08-29 05:00:00	AAPL	Stock	161.26	161.48	161.07	161.4	15179.0
2022-08-29 05:30:00	AAPL	Stock	161.39	161.45	161.16	161.41	12209.0
2022-08-29 06:00:00	AAPL	Stock	161.41	161.68	161.39	161.45	10328.0
2022-08-29 06:30:00	AAPL	Stock	161.53	161.8	161.5	161.57	15762.0
2022-08-29 07:00:00	AAPL	Stock	161.66	161.66	161.26	161.26	42134.0
2022-08-29 07:30:00	AAPL	Stock	161.25	161.39	161.19	161.38	55245.0
2022-08-29 08:00:00	AAPL	Stock	161.5818	163.211	160.07	161.635	218327.0
2022-08-29 08:30:00	AAPL	Stock	161.67	163.62	161.26	161.27	235115.0
2022-08-29 09:00:00	AAPL	Stock	161.3069	161.79	160.88	161.15	403179.0
2022-08-29 09:30:00	AAPL	Stock	161.145	162.75	160.6	161.825	10157824.0
2022-08-29 10:00:00	AAPL	Stock	161.82	162.9	161.65	162.0524	5210143.0
2022-08-29 10:30:00	AAPL	Stock	162.06	162.19	160.07	160.191	5064656.0
2022-08-29 11:00:00	AAPL	Stock	160.2	160.45	159.82	160.26	5556589.0
2022-08-29 11:30:00	AAPL	Stock	160.26	161.3	160.08	161.22	3854214.0
2022-08-29 12:00:00	AAPL	Stock	161.22	161.7501	161.075	161.46	3355226.0
2022-08-29 12:30:00	AAPL	Stock	161.455	162.19	160.935	161.9399	2973539.0
2022-08-29 13:00:00	AAPL	Stock	161.94	162.38	161.57	161.87	2475349.0
2022-08-29 13:30:00	AAPL	Stock	161.8602	162.61	161.79	162.085	2563927.0
2022-08-29 14:00:00	AAPL	Stock	162.09	162.27	161.67	161.81	2484509.0
2022-08-29 14:30:00	AAPL	Stock	161.8	162.26	161.56	161.975	2441193.0
2022-08-29 15:00:00	AAPL	Stock	161.98	162.54	161.95	162.08	2944871.0
2022-08-29 15:30:00	AAPL	Stock	162.08	162.295	161.12	161.37	5749137.0
2022-08-29 16:00:00	AAPL	Stock	161.38	161.38	161.06	161.13	5617520.0
2022-08-29 16:30:00	AAPL	Stock	161.0728	161.45	161.07	161.45	70903.0
2022-08-29 17:00:00	AAPL	Stock	161.46	161.49	161.32	161.35	25150.0
2022-08-29 17:30:00	AAPL	Stock	161.33	161.4182	161.13	161.35	10440.0
2022-08-29 18:00:00	AAPL	Stock	161.35	161.47	161.24	161.25	27352.0
2022-08-29 18:30:00	AAPL	Stock	161.26	161.38	161.25	161.38	7800.0
2022-08-29 19:00:00	AAPL	Stock	161.37	161.52	161.32	161.5	16044.0
2022-08-29 19:30:00	AAPL	Stock	161.48	161.8	161.45	161.79	20751.0
2022-08-29 04:00:00	MSFT	Stock	266.49	266.52	260.05	265.4	21990.0
2022-08-29 04:30:00	MSFT	Stock	265.3	265.54	265.02	265.02	8490.0
2022-08-29 05:00:00	MSFT	Stock	265.02	265.53	264.78	265.37	1522.0
2022-08-29 05:30:00	MSFT	Stock	265.21	265.21	265.0	265.0	912.0
2022-08-29 06:00:00	MSFT	Stock	265.41	265.58	265.4	265.4	779.0
2022-08-29 06:30:00	MSFT	Stock	265.45	265.58	265.45	265.57	590.0
2022-08-29 07:00:00	MSFT	Stock	265.26	265.43	265.06	265.19	5129.0
2022-08-29 07:30:00	MSFT	Stock	265.03	265.2	265.0	265.2	8050.0
2022-08-29 08:00:00	MSFT	Stock	265.2507	267.42	265.0	265.72	19517.0
2022-08-29 08:30:00	MSFT	Stock	265.9	266.25	265.5	265.72	25151.0
2022-08-29 09:00:00	MSFT	Stock	265.52	266.37	265.15	265.98	26397.0
2022-08-29 09:30:00	MSFT	Stock	265.88	267.4	265.01	265.1888	1585716.0
2022-08-29 10:00:00	MSFT	Stock	265.17	266.59	264.92	266.04	1045680.0
2022-08-29 10:30:00	MSFT	Stock	266.05	266.5	264.23	264.3	784075.0
2022-08-29 11:00:00	MSFT	Stock	264.29	264.96	263.85	264.15	803585.0
2022-08-29 11:30:00	MSFT	Stock	264.19	265.34	264.08	265.12	596099.0
2022-08-29 12:00:00	MSFT	Stock	265.16	266.35	265.09	265.39	454744.0
2022-08-29 12:30:00	MSFT	Stock	265.37	266.605	264.72	266.03	434464.0

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

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