PREVIEW / stock_30min / 2022-11-09

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-11-09.parquet
  size:    2.1 MB
  rows:    102,797
  symbols: 2,091

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-09 04:00:00	AAPL	Stock	140.05	140.05	139.17	139.25	17028.0
2022-11-09 04:30:00	AAPL	Stock	139.21	139.28	138.4	138.4	19178.0
2022-11-09 05:00:00	AAPL	Stock	138.63	138.69	138.42	138.6	8211.0
2022-11-09 05:30:00	AAPL	Stock	138.8	139.1	138.8	139.07	9009.0
2022-11-09 06:00:00	AAPL	Stock	139.07	139.42	139.02	139.14	10204.0
2022-11-09 06:30:00	AAPL	Stock	139.22	139.35	139.0	139.0	5353.0
2022-11-09 07:00:00	AAPL	Stock	139.19	139.34	138.65	138.81	36397.0
2022-11-09 07:30:00	AAPL	Stock	138.9	139.5	138.9	139.4	13454.0
2022-11-09 08:00:00	AAPL	Stock	139.1821	140.0	138.3106	138.54	120672.0
2022-11-09 08:30:00	AAPL	Stock	138.52	138.9	138.33	138.5315	78582.0
2022-11-09 09:00:00	AAPL	Stock	138.56	139.07	138.28	138.49	114104.0
2022-11-09 09:30:00	AAPL	Stock	138.5	138.55	136.98	137.27	7107434.0
2022-11-09 10:00:00	AAPL	Stock	137.27	137.98	137.08	137.1698	4546775.0
2022-11-09 10:30:00	AAPL	Stock	137.1789	137.4601	136.145	136.515	4509123.0
2022-11-09 11:00:00	AAPL	Stock	136.52	137.29	136.48	136.955	3135286.0
2022-11-09 11:30:00	AAPL	Stock	136.95	137.41	136.4101	136.61	3111776.0
2022-11-09 12:00:00	AAPL	Stock	136.61	136.7102	136.13	136.249	2439129.0
2022-11-09 12:30:00	AAPL	Stock	136.244	136.6	136.212	136.35	2231154.0
2022-11-09 13:00:00	AAPL	Stock	136.36	136.57	135.761	135.91	3100585.0
2022-11-09 13:30:00	AAPL	Stock	135.9	135.908	135.0	135.22	4047825.0
2022-11-09 14:00:00	AAPL	Stock	135.23	135.54	135.01	135.38	3376345.0
2022-11-09 14:30:00	AAPL	Stock	135.38	135.3869	134.7	134.77	4063303.0
2022-11-09 15:00:00	AAPL	Stock	134.77	135.4799	134.7185	135.095	3905629.0
2022-11-09 15:30:00	AAPL	Stock	135.11	135.19	134.5933	134.87	8202316.0
2022-11-09 16:00:00	AAPL	Stock	134.89	135.03	134.74	134.9299	10409365.0
2022-11-09 16:30:00	AAPL	Stock	134.92	135.17	134.8	134.88	129087.0
2022-11-09 17:00:00	AAPL	Stock	134.91	134.94	134.78	134.86	34986.0
2022-11-09 17:30:00	AAPL	Stock	134.8	134.85	134.73	134.8058	14977.0
2022-11-09 18:00:00	AAPL	Stock	134.86	135.18	134.86	135.01	21216.0
2022-11-09 18:30:00	AAPL	Stock	135.03	135.1	135.0	135.05	13195.0
2022-11-09 19:00:00	AAPL	Stock	135.04	135.5	134.95	135.29	38314.0
2022-11-09 19:30:00	AAPL	Stock	135.25	135.49	135.2	135.27	36488.0
2022-11-09 04:00:00	MSFT	Stock	228.72	228.92	228.72	228.91	460.0
2022-11-09 04:30:00	MSFT	Stock	228.0	228.0	228.0	228.0	100.0
2022-11-09 05:00:00	MSFT	Stock	227.4	227.4	227.19	227.3	1117.0
2022-11-09 05:30:00	MSFT	Stock	228.0	228.19	228.0	228.19	200.0
2022-11-09 06:30:00	MSFT	Stock	228.41	228.41	228.41	228.41	150.0
2022-11-09 07:00:00	MSFT	Stock	228.24	228.33	227.63	227.71	2687.0
2022-11-09 07:30:00	MSFT	Stock	227.69	228.35	227.69	228.1	1747.0
2022-11-09 08:00:00	MSFT	Stock	228.6028	229.0	226.65	227.0156	21391.0
2022-11-09 08:30:00	MSFT	Stock	227.1201	228.0001	227.009	227.24	7007.0
2022-11-09 09:00:00	MSFT	Stock	228.87	228.87	226.89	226.89	1791528.0
2022-11-09 09:30:00	MSFT	Stock	227.36	228.54	226.51	227.18	1722656.0
2022-11-09 10:00:00	MSFT	Stock	227.23	228.6327	226.9	227.18	1200450.0
2022-11-09 10:30:00	MSFT	Stock	227.15	227.47	225.3	225.86	1146150.0
2022-11-09 11:00:00	MSFT	Stock	225.9	227.47	225.9	226.74	795448.0
2022-11-09 11:30:00	MSFT	Stock	226.74	228.28	226.38	227.19	698545.0
2022-11-09 12:00:00	MSFT	Stock	227.18	227.68	226.44	226.49	628166.0
2022-11-09 12:30:00	MSFT	Stock	226.49	227.07	226.47	226.6	620654.0
2022-11-09 13:00:00	MSFT	Stock	226.6	226.98	226.09	226.24	651808.0

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

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