PREVIEW / stock_30min / 2022-07-25

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-25.parquet
  size:    2.1 MB
  rows:    102,217
  symbols: 2,312

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-07-25 04:00:00	AAPL	Stock	154.12	154.22	153.76	154.07	10346.0
2022-07-25 04:30:00	AAPL	Stock	154.08	154.44	154.04	154.35	8949.0
2022-07-25 05:00:00	AAPL	Stock	154.34	154.69	154.19	154.64	21642.0
2022-07-25 05:30:00	AAPL	Stock	154.52	154.99	154.52	154.97	14117.0
2022-07-25 06:00:00	AAPL	Stock	154.95	155.09	154.84	155.0	8877.0
2022-07-25 06:30:00	AAPL	Stock	154.93	155.17	154.79	155.17	18833.0
2022-07-25 07:00:00	AAPL	Stock	155.1	155.29	154.87	155.05	54794.0
2022-07-25 07:30:00	AAPL	Stock	155.14	155.15	154.55	154.77	46553.0
2022-07-25 08:00:00	AAPL	Stock	155.0793	155.2397	153.39	154.7	193877.0
2022-07-25 08:30:00	AAPL	Stock	154.7001	154.78	154.4	154.46	138136.0
2022-07-25 09:00:00	AAPL	Stock	154.42	154.46	153.95	154.0	153430.0
2022-07-25 09:30:00	AAPL	Stock	154.01	155.04	153.5125	153.5355	7361801.0
2022-07-25 10:00:00	AAPL	Stock	153.5499	153.94	152.455	152.905	5227694.0
2022-07-25 10:30:00	AAPL	Stock	152.9099	153.41	152.47	153.099	3415724.0
2022-07-25 11:00:00	AAPL	Stock	153.0909	153.16	152.358	153.0467	2969482.0
2022-07-25 11:30:00	AAPL	Stock	153.05	153.7199	153.01	153.645	2967803.0
2022-07-25 12:00:00	AAPL	Stock	153.6484	153.97	153.25	153.51	2241540.0
2022-07-25 12:30:00	AAPL	Stock	153.5	154.08	153.48	153.709	1998902.0
2022-07-25 13:00:00	AAPL	Stock	153.72	153.97	153.55	153.56	1467563.0
2022-07-25 13:30:00	AAPL	Stock	153.56	153.65	153.25	153.28	1460380.0
2022-07-25 14:00:00	AAPL	Stock	153.28	153.34	152.85	152.9296	1571340.0
2022-07-25 14:30:00	AAPL	Stock	152.93	153.18	152.495	152.6099	2294525.0
2022-07-25 15:00:00	AAPL	Stock	152.61	152.8399	152.405	152.54	2435503.0
2022-07-25 15:30:00	AAPL	Stock	152.545	153.02	152.28	152.949	5492390.0
2022-07-25 16:00:00	AAPL	Stock	152.98	153.15	152.7	152.81	4368945.0
2022-07-25 16:30:00	AAPL	Stock	152.8	152.9704	152.0	152.63	286544.0
2022-07-25 17:00:00	AAPL	Stock	152.72	152.78	152.55	152.64	33309.0
2022-07-25 17:30:00	AAPL	Stock	152.64	152.67	152.41	152.54	30761.0
2022-07-25 18:00:00	AAPL	Stock	152.55	152.69	152.42	152.53	29743.0
2022-07-25 18:30:00	AAPL	Stock	152.52	152.68	152.5	152.55	23042.0
2022-07-25 19:00:00	AAPL	Stock	152.51	152.53	152.35	152.35	9262.0
2022-07-25 19:30:00	AAPL	Stock	152.32	152.68	152.25	152.68	41972.0
2022-07-25 04:00:00	MSFT	Stock	260.49	261.5	260.49	261.5	3599.0
2022-07-25 04:30:00	MSFT	Stock	261.48	261.69	261.48	261.5	5349.0
2022-07-25 05:00:00	MSFT	Stock	261.5	261.8	261.5	261.8	2117.0
2022-07-25 05:30:00	MSFT	Stock	261.78	261.89	261.73	261.89	1418.0
2022-07-25 06:00:00	MSFT	Stock	262.0	262.0	261.9	261.9	669.0
2022-07-25 06:30:00	MSFT	Stock	261.97	262.0	261.56	261.75	2487.0
2022-07-25 07:00:00	MSFT	Stock	261.75	261.76	261.23	261.67	2983.0
2022-07-25 07:30:00	MSFT	Stock	261.7	261.8	261.31	261.31	14471.0
2022-07-25 08:00:00	MSFT	Stock	261.35	261.94	259.71	261.7	24903.0
2022-07-25 08:30:00	MSFT	Stock	261.71	261.899	261.353	261.75	15642.0
2022-07-25 09:00:00	MSFT	Stock	261.4722	261.85	260.7	260.96	19269.0
2022-07-25 09:30:00	MSFT	Stock	261.06	261.5	257.15	258.11	2337599.0
2022-07-25 10:00:00	MSFT	Stock	258.15	259.1396	256.81	257.685	1145349.0
2022-07-25 10:30:00	MSFT	Stock	257.635	259.1902	257.26	258.88	798152.0
2022-07-25 11:00:00	MSFT	Stock	258.88	259.11	257.9	258.93	619198.0
2022-07-25 11:30:00	MSFT	Stock	258.94	259.71	258.83	259.2	797849.0
2022-07-25 12:00:00	MSFT	Stock	259.19	259.4199	258.1401	258.48	552495.0
2022-07-25 12:30:00	MSFT	Stock	258.5028	259.63	258.48	259.045	370264.0

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

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