PREVIEW / stock_30min / 2022-09-15

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-15.parquet
  size:    2.1 MB
  rows:    106,702
  symbols: 2,215

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-15 04:00:00	AAPL	Stock	156.0	156.15	155.35	155.52	20730.0
2022-09-15 04:30:00	AAPL	Stock	155.55	155.59	155.3	155.32	5848.0
2022-09-15 05:00:00	AAPL	Stock	155.43	155.5	155.34	155.41	7678.0
2022-09-15 05:30:00	AAPL	Stock	155.46	155.63	155.46	155.59	6575.0
2022-09-15 06:00:00	AAPL	Stock	155.55	155.59	155.5	155.57	5522.0
2022-09-15 06:30:00	AAPL	Stock	155.42	155.42	154.65	154.92	23085.0
2022-09-15 07:00:00	AAPL	Stock	154.98	155.39	154.95	155.39	25732.0
2022-09-15 07:30:00	AAPL	Stock	155.39	155.42	154.85	154.96	55303.0
2022-09-15 08:00:00	AAPL	Stock	155.05	155.78	154.5325	154.79	153411.0
2022-09-15 08:30:00	AAPL	Stock	154.75	155.23	154.54	155.03	197909.0
2022-09-15 09:00:00	AAPL	Stock	155.0	155.1	154.4301	154.67	173303.0
2022-09-15 09:30:00	AAPL	Stock	154.65	155.24	154.09	154.8681	7731444.0
2022-09-15 10:00:00	AAPL	Stock	154.87	155.21	153.75	153.81	6544970.0
2022-09-15 10:30:00	AAPL	Stock	153.81	153.98	151.78	152.0699	7547422.0
2022-09-15 11:00:00	AAPL	Stock	152.05	153.05	151.92	152.84	5999600.0
2022-09-15 11:30:00	AAPL	Stock	152.84	153.0879	152.3699	152.645	3789277.0
2022-09-15 12:00:00	AAPL	Stock	152.64	152.88	152.26	152.46	3488873.0
2022-09-15 12:30:00	AAPL	Stock	152.47	153.245	152.4	153.23	2865927.0
2022-09-15 13:00:00	AAPL	Stock	153.24	154.3	153.24	153.915	4070747.0
2022-09-15 13:30:00	AAPL	Stock	153.9	153.965	153.2	153.42	2476275.0
2022-09-15 14:00:00	AAPL	Stock	153.43	153.455	152.73	153.045	2771126.0
2022-09-15 14:30:00	AAPL	Stock	153.0406	153.31	152.31	152.39	3509294.0
2022-09-15 15:00:00	AAPL	Stock	152.4	152.51	151.38	151.4829	6583316.0
2022-09-15 15:30:00	AAPL	Stock	151.48	152.69	151.4	152.35	9248898.0
2022-09-15 16:00:00	AAPL	Stock	152.35	152.68	152.35	152.4698	8981897.0
2022-09-15 16:30:00	AAPL	Stock	152.48	152.48	151.73	152.05	177623.0
2022-09-15 17:00:00	AAPL	Stock	152.05	152.37	151.523	151.75	74224.0
2022-09-15 17:30:00	AAPL	Stock	151.75	152.37	151.62	151.69	31310.0
2022-09-15 18:00:00	AAPL	Stock	151.69	151.69	151.11	151.25	86399.0
2022-09-15 18:30:00	AAPL	Stock	151.29	151.4	151.22	151.35	28301.0
2022-09-15 19:00:00	AAPL	Stock	151.35	151.37	151.1	151.15	36547.0
2022-09-15 19:30:00	AAPL	Stock	151.16	151.4	151.15	151.35	60841.0
2022-09-15 04:00:00	MSFT	Stock	252.88	252.88	252.0	252.44	1927.0
2022-09-15 04:30:00	MSFT	Stock	252.39	252.39	252.0	252.36	3361.0
2022-09-15 05:00:00	MSFT	Stock	252.36	252.36	252.05	252.22	976.0
2022-09-15 05:30:00	MSFT	Stock	252.22	252.53	252.22	252.5	2850.0
2022-09-15 06:00:00	MSFT	Stock	252.5	252.55	252.49	252.55	594.0
2022-09-15 06:30:00	MSFT	Stock	252.22	252.22	251.21	251.38	2651.0
2022-09-15 07:30:00	MSFT	Stock	251.85	251.86	251.4	251.4	2674.0
2022-09-15 08:00:00	MSFT	Stock	251.6011	252.1887	250.97	251.25	30325.0
2022-09-15 08:30:00	MSFT	Stock	251.5	252.1	250.8817	251.72	13353.0
2022-09-15 09:00:00	MSFT	Stock	251.73	251.99	249.52	249.76	46851.0
2022-09-15 09:30:00	MSFT	Stock	249.75	250.6202	248.3256	250.42	2648816.0
2022-09-15 10:00:00	MSFT	Stock	250.42	251.4	247.15	247.25	2281975.0
2022-09-15 10:30:00	MSFT	Stock	247.25	247.87	245.59	245.64	1784205.0
2022-09-15 11:00:00	MSFT	Stock	245.63	247.15	245.2	246.865	1447935.0
2022-09-15 11:30:00	MSFT	Stock	246.85	247.38	245.411	245.8129	877448.0
2022-09-15 12:00:00	MSFT	Stock	245.8	246.23	245.27	245.55	870284.0
2022-09-15 12:30:00	MSFT	Stock	245.55	246.64	245.55	246.56	681795.0
2022-09-15 13:00:00	MSFT	Stock	246.57	248.45	246.57	247.7	943536.0

> showing 50 of 106,702 rows — these rows as CSV

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