PREVIEW / stock_30min / 2022-07-29

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-29.parquet
  size:    2.1 MB
  rows:    105,412
  symbols: 2,305

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-29 04:00:00	AAPL	Stock	162.03	162.03	160.32	161.69	53814.0
2022-07-29 04:30:00	AAPL	Stock	161.68	161.68	160.94	161.2	47608.0
2022-07-29 05:00:00	AAPL	Stock	161.21	161.6	161.04	161.48	14092.0
2022-07-29 05:30:00	AAPL	Stock	161.58	161.64	161.34	161.46	10520.0
2022-07-29 06:00:00	AAPL	Stock	161.45	161.5	160.6	161.0	62853.0
2022-07-29 06:30:00	AAPL	Stock	161.08	161.34	160.86	160.88	34613.0
2022-07-29 07:00:00	AAPL	Stock	160.95	161.4	160.95	161.02	135544.0
2022-07-29 07:30:00	AAPL	Stock	161.05	161.84	160.96	161.8	156261.0
2022-07-29 08:00:00	AAPL	Stock	161.2387	162.0	160.95	161.39	505588.0
2022-07-29 08:30:00	AAPL	Stock	161.39	161.92	160.27	161.49	642538.0
2022-07-29 09:00:00	AAPL	Stock	161.49	161.81	160.8	161.26	519621.0
2022-07-29 09:30:00	AAPL	Stock	161.24	163.0	159.5	161.9552	16996199.0
2022-07-29 10:00:00	AAPL	Stock	161.96	163.53	161.5	163.2651	8303558.0
2022-07-29 10:30:00	AAPL	Stock	163.28	163.63	162.36	162.41	5581782.0
2022-07-29 11:00:00	AAPL	Stock	162.405	162.56	160.86	160.96	5492158.0
2022-07-29 11:30:00	AAPL	Stock	160.9599	162.3	160.57	162.14	4940186.0
2022-07-29 12:00:00	AAPL	Stock	162.135	162.3404	161.73	162.04	2634179.0
2022-07-29 12:30:00	AAPL	Stock	162.05	162.64	162.05	162.55	3321905.0
2022-07-29 13:00:00	AAPL	Stock	162.56	162.565	162.1	162.2983	2433135.0
2022-07-29 13:30:00	AAPL	Stock	162.29	162.95	162.245	162.73	2792317.0
2022-07-29 14:00:00	AAPL	Stock	162.73	162.91	162.56	162.815	2250624.0
2022-07-29 14:30:00	AAPL	Stock	162.82	163.18	162.52	162.64	3144782.0
2022-07-29 15:00:00	AAPL	Stock	162.64	163.09	162.59	163.065	3281829.0
2022-07-29 15:30:00	AAPL	Stock	163.06	163.17	162.41	162.57	7865356.0
2022-07-29 16:00:00	AAPL	Stock	162.58	162.58	162.3	162.51	13757254.0
2022-07-29 16:30:00	AAPL	Stock	162.5	162.54	162.42	162.47	160695.0
2022-07-29 17:00:00	AAPL	Stock	162.48	162.52	162.36	162.36	52896.0
2022-07-29 17:30:00	AAPL	Stock	162.35	162.39	162.27	162.3	31142.0
2022-07-29 18:00:00	AAPL	Stock	162.3	162.33	162.1	162.1	19583.0
2022-07-29 18:30:00	AAPL	Stock	162.2	162.2	162.11	162.2	12606.0
2022-07-29 19:00:00	AAPL	Stock	162.16	162.17	162.06	162.14	25750.0
2022-07-29 19:30:00	AAPL	Stock	162.17	162.18	162.1	162.15	21298.0
2022-07-29 04:00:00	MSFT	Stock	277.95	278.88	277.5	278.5	8128.0
2022-07-29 04:30:00	MSFT	Stock	278.22	278.22	277.17	277.4	1729.0
2022-07-29 05:00:00	MSFT	Stock	277.15	277.6	277.15	277.6	5552.0
2022-07-29 05:30:00	MSFT	Stock	277.72	277.97	277.72	277.97	1079.0
2022-07-29 06:00:00	MSFT	Stock	277.93	278.0	277.81	277.81	2625.0
2022-07-29 06:30:00	MSFT	Stock	277.65	278.15	277.65	277.85	2480.0
2022-07-29 07:00:00	MSFT	Stock	277.9	278.12	277.52	277.7	34886.0
2022-07-29 07:30:00	MSFT	Stock	277.85	277.9	277.55	277.7	5680.0
2022-07-29 08:00:00	MSFT	Stock	277.8696	278.0972	275.719	277.45	22927.0
2022-07-29 08:30:00	MSFT	Stock	277.37	277.37	276.58	277.1	46203.0
2022-07-29 09:00:00	MSFT	Stock	277.1284	277.96	276.16	277.62	57012.0
2022-07-29 09:30:00	MSFT	Stock	277.66	279.35	276.63	279.295	3017757.0
2022-07-29 10:00:00	MSFT	Stock	279.295	280.8	278.86	280.8	2058132.0
2022-07-29 10:30:00	MSFT	Stock	280.77	281.12	279.52	279.6449	1954454.0
2022-07-29 11:00:00	MSFT	Stock	279.65	279.65	277.28	277.46	1683783.0
2022-07-29 11:30:00	MSFT	Stock	277.42	279.37	277.31	279.3204	952245.0
2022-07-29 12:00:00	MSFT	Stock	279.33	279.3699	278.18	279.25	715266.0
2022-07-29 12:30:00	MSFT	Stock	279.2505	279.99	278.885	279.741	668082.0

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

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