PREVIEW / stock_30min / 2023-02-07

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-02-07.parquet
  size:    2.1 MB
  rows:    104,080
  symbols: 1,861

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-07 04:00:00	AAPL	Stock	151.79	152.01	151.67	151.93	24655.0
2023-02-07 04:30:00	AAPL	Stock	152.0	152.09	151.96	151.96	6656.0
2023-02-07 05:00:00	AAPL	Stock	152.01	152.01	151.74	151.98	3210.0
2023-02-07 05:30:00	AAPL	Stock	152.01	152.01	151.7	151.7	4906.0
2023-02-07 06:00:00	AAPL	Stock	151.71	151.77	151.6	151.7	7657.0
2023-02-07 06:30:00	AAPL	Stock	151.7	151.7	151.61	151.64	2193.0
2023-02-07 07:00:00	AAPL	Stock	151.78	152.1	151.68	151.96	35430.0
2023-02-07 07:30:00	AAPL	Stock	152.01	152.03	151.86	151.95	24208.0
2023-02-07 08:00:00	AAPL	Stock	151.7	152.39	151.351	151.63	111569.0
2023-02-07 08:30:00	AAPL	Stock	151.62	151.65	151.19	151.37	117887.0
2023-02-07 09:00:00	AAPL	Stock	151.39	151.39	150.33	150.71	255714.0
2023-02-07 09:30:00	AAPL	Stock	150.73	152.925	150.63	152.3156	8296536.0
2023-02-07 10:00:00	AAPL	Stock	152.31	152.44	151.84	152.1384	3638572.0
2023-02-07 10:30:00	AAPL	Stock	152.1355	153.19	152.1001	152.6	4275259.0
2023-02-07 11:00:00	AAPL	Stock	152.6	153.365	152.561	153.1874	3284401.0
2023-02-07 11:30:00	AAPL	Stock	153.19	153.5999	152.995	153.014	2253726.0
2023-02-07 12:00:00	AAPL	Stock	153.015	153.19	152.52	152.63	1820071.0
2023-02-07 12:30:00	AAPL	Stock	152.63	155.23	152.38	154.8101	5618404.0
2023-02-07 13:00:00	AAPL	Stock	154.83	155.15	152.85	152.88	5362187.0
2023-02-07 13:30:00	AAPL	Stock	152.88	152.9064	151.36	152.1299	5113876.0
2023-02-07 14:00:00	AAPL	Stock	152.1162	153.93	152.048	153.65	4003133.0
2023-02-07 14:30:00	AAPL	Stock	153.68	154.47	153.565	154.22	3230270.0
2023-02-07 15:00:00	AAPL	Stock	154.22	154.58	153.43	154.2998	3758108.0
2023-02-07 15:30:00	AAPL	Stock	154.2949	155.22	154.07	154.64	8982480.0
2023-02-07 16:00:00	AAPL	Stock	154.64	154.66	153.87	154.07	11232697.0
2023-02-07 16:30:00	AAPL	Stock	154.0844	154.65	153.94	153.99	69702.0
2023-02-07 17:00:00	AAPL	Stock	154.0	154.09	153.99	154.08	12642.0
2023-02-07 17:30:00	AAPL	Stock	154.1	154.2	154.03	154.19	30777.0
2023-02-07 18:00:00	AAPL	Stock	154.15	154.6	154.15	154.43	61553.0
2023-02-07 18:30:00	AAPL	Stock	154.47	154.49	154.12	154.1999	22904.0
2023-02-07 19:00:00	AAPL	Stock	154.19	154.25	153.91	154.0	20674.0
2023-02-07 19:30:00	AAPL	Stock	154.04	154.15	154.0	154.15	26351.0
2023-02-07 04:00:00	MSFT	Stock	257.27	259.64	257.27	259.51	30714.0
2023-02-07 04:30:00	MSFT	Stock	259.44	260.0	259.23	259.3	16539.0
2023-02-07 05:00:00	MSFT	Stock	259.43	259.51	259.15	259.51	4728.0
2023-02-07 05:30:00	MSFT	Stock	259.4	259.52	258.65	258.65	6875.0
2023-02-07 06:00:00	MSFT	Stock	258.51	258.9	258.3	258.5	3602.0
2023-02-07 06:30:00	MSFT	Stock	258.64	258.87	258.5	258.87	4982.0
2023-02-07 07:00:00	MSFT	Stock	258.88	259.19	258.75	258.98	18498.0
2023-02-07 07:30:00	MSFT	Stock	258.99	259.96	258.75	259.95	16502.0
2023-02-07 08:00:00	MSFT	Stock	259.03	260.6799	256.129	260.0	81748.0
2023-02-07 08:30:00	MSFT	Stock	260.2479	261.0	259.75	260.16	86890.0
2023-02-07 09:00:00	MSFT	Stock	260.16	260.67	259.75	260.52	57077.0
2023-02-07 09:30:00	MSFT	Stock	260.53	263.45	260.08	260.8	5118657.0
2023-02-07 10:00:00	MSFT	Stock	260.7801	262.5284	260.5689	262.0954	2458347.0
2023-02-07 10:30:00	MSFT	Stock	262.06	263.6699	262.0401	262.56	2262893.0
2023-02-07 11:00:00	MSFT	Stock	262.55	263.66	261.97	263.29	1713867.0
2023-02-07 11:30:00	MSFT	Stock	263.31	264.62	263.3	264.14	1866265.0
2023-02-07 12:00:00	MSFT	Stock	264.13	264.41	262.88	262.9722	1585477.0
2023-02-07 12:30:00	MSFT	Stock	262.97	268.32	262.9013	267.31	2706344.0

> showing 50 of 104,080 rows — these rows as CSV

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