PREVIEW / stock_30min / 2023-02-06

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-02-06.parquet
  size:    2.2 MB
  rows:    105,246
  symbols: 1,874

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-02-06 04:00:00	AAPL	Stock	153.51	153.51	152.87	153.29	39887.0
2023-02-06 04:30:00	AAPL	Stock	153.24	153.33	152.96	152.96	32190.0
2023-02-06 05:00:00	AAPL	Stock	153.03	153.04	152.68	152.78	19721.0
2023-02-06 05:30:00	AAPL	Stock	152.78	153.01	152.65	152.93	18892.0
2023-02-06 06:00:00	AAPL	Stock	152.84	152.93	152.71	152.86	11684.0
2023-02-06 06:30:00	AAPL	Stock	152.75	152.87	152.5	152.7	34194.0
2023-02-06 07:00:00	AAPL	Stock	152.85	153.1	152.65	152.75	74029.0
2023-02-06 07:30:00	AAPL	Stock	152.71	153.24	152.6	152.97	86950.0
2023-02-06 08:00:00	AAPL	Stock	152.9731	154.114	152.5815	153.1603	215759.0
2023-02-06 08:30:00	AAPL	Stock	153.2	153.2394	152.55	152.87	176838.0
2023-02-06 09:00:00	AAPL	Stock	152.89	153.24	152.23	152.5	338481.0
2023-02-06 09:30:00	AAPL	Stock	152.575	153.1	151.71	152.48	9713267.0
2023-02-06 10:00:00	AAPL	Stock	152.48	152.7101	151.3399	151.37	5720326.0
2023-02-06 10:30:00	AAPL	Stock	151.38	152.37	150.9	152.27	4717473.0
2023-02-06 11:00:00	AAPL	Stock	152.28	153.06	152.11	152.8901	3571664.0
2023-02-06 11:30:00	AAPL	Stock	152.9	153.1	151.98	152.04	2694879.0
2023-02-06 12:00:00	AAPL	Stock	152.0301	152.42	151.81	152.21	2386932.0
2023-02-06 12:30:00	AAPL	Stock	152.2005	152.79	152.16	152.428	1932279.0
2023-02-06 13:00:00	AAPL	Stock	152.42	152.5194	151.8	151.81	2273244.0
2023-02-06 13:30:00	AAPL	Stock	151.815	152.22	151.585	152.154	2320159.0
2023-02-06 14:00:00	AAPL	Stock	152.159	152.52	152.13	152.36	2417425.0
2023-02-06 14:30:00	AAPL	Stock	152.36	152.37	151.51	151.645	2835978.0
2023-02-06 15:00:00	AAPL	Stock	151.64	151.91	150.975	150.99	3132550.0
2023-02-06 15:30:00	AAPL	Stock	150.99	151.88	150.78	151.68	5703438.0
2023-02-06 16:00:00	AAPL	Stock	151.68	152.03	151.58	151.76	6270422.0
2023-02-06 16:30:00	AAPL	Stock	151.82	151.82	151.61	151.65	60130.0
2023-02-06 17:00:00	AAPL	Stock	151.67	151.73	151.6311	151.73	10898.0
2023-02-06 17:30:00	AAPL	Stock	151.67	151.73	151.63	151.7	11309.0
2023-02-06 18:00:00	AAPL	Stock	151.68	151.8	151.64	151.76	19789.0
2023-02-06 18:30:00	AAPL	Stock	151.78	151.89	151.65	151.74	18184.0
2023-02-06 19:00:00	AAPL	Stock	151.82	151.93	151.82	151.93	16191.0
2023-02-06 19:30:00	AAPL	Stock	151.91	152.0	151.84	151.98	22586.0
2023-02-06 04:00:00	MSFT	Stock	257.34	258.33	256.72	256.82	6554.0
2023-02-06 04:30:00	MSFT	Stock	256.88	256.95	256.25	256.25	736.0
2023-02-06 05:00:00	MSFT	Stock	256.08	256.08	255.41	255.72	2961.0
2023-02-06 05:30:00	MSFT	Stock	255.4	256.0	255.14	256.0	2528.0
2023-02-06 06:00:00	MSFT	Stock	255.59	255.91	255.59	255.64	571.0
2023-02-06 06:30:00	MSFT	Stock	255.57	255.9	255.33	255.89	9408.0
2023-02-06 07:00:00	MSFT	Stock	255.99	256.6	255.9	255.9	7410.0
2023-02-06 07:30:00	MSFT	Stock	255.83	256.45	255.83	256.2	15480.0
2023-02-06 08:00:00	MSFT	Stock	256.55	258.35	255.6701	255.7	109801.0
2023-02-06 08:30:00	MSFT	Stock	255.7	255.7	255.0	255.3	11363.0
2023-02-06 09:00:00	MSFT	Stock	255.2	257.51	255.2	257.43	16128.0
2023-02-06 09:30:00	MSFT	Stock	257.44	257.75	255.69	256.64	2125081.0
2023-02-06 10:00:00	MSFT	Stock	256.67	257.93	255.2	255.37	1316593.0
2023-02-06 10:30:00	MSFT	Stock	255.35	257.23	254.78	257.13	1132885.0
2023-02-06 11:00:00	MSFT	Stock	257.15	258.25	256.78	258.0364	825837.0
2023-02-06 11:30:00	MSFT	Stock	258.04	258.3	256.92	257.02	578723.0
2023-02-06 12:00:00	MSFT	Stock	256.98	257.215	256.5704	256.81	706304.0
2023-02-06 12:30:00	MSFT	Stock	256.85	257.36	256.48	256.8	679339.0

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

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