PREVIEW / stock_30min / 2022-09-12

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-12.parquet
  size:    2.1 MB
  rows:    104,638
  symbols: 2,222

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-12 04:00:00	AAPL	Stock	158.02	158.7	158.0	158.34	24348.0
2022-09-12 04:30:00	AAPL	Stock	158.27	158.79	158.26	158.79	26231.0
2022-09-12 05:00:00	AAPL	Stock	158.75	159.09	158.7	158.93	56570.0
2022-09-12 05:30:00	AAPL	Stock	158.9	158.97	158.8	158.81	22187.0
2022-09-12 06:00:00	AAPL	Stock	158.8	158.87	158.65	158.82	19099.0
2022-09-12 06:30:00	AAPL	Stock	158.83	159.04	158.83	158.91	14306.0
2022-09-12 07:00:00	AAPL	Stock	158.89	159.34	158.78	159.2	55005.0
2022-09-12 07:30:00	AAPL	Stock	159.2	159.54	158.9	159.48	66581.0
2022-09-12 08:00:00	AAPL	Stock	158.92	159.55	157.61	159.07	209333.0
2022-09-12 08:30:00	AAPL	Stock	159.07	159.32	159.05	159.26	83938.0
2022-09-12 09:00:00	AAPL	Stock	159.2897	159.91	159.15	159.6	212660.0
2022-09-12 09:30:00	AAPL	Stock	159.6	161.69	159.3	161.615	12735154.0
2022-09-12 10:00:00	AAPL	Stock	161.615	162.05	161.4	161.6299	7695737.0
2022-09-12 10:30:00	AAPL	Stock	161.62	161.85	161.21	161.41	5037480.0
2022-09-12 11:00:00	AAPL	Stock	161.415	162.665	161.22	162.645	6639081.0
2022-09-12 11:30:00	AAPL	Stock	162.645	162.89	161.67	161.895	6472932.0
2022-09-12 12:00:00	AAPL	Stock	161.9	162.66	161.73	162.6	4910597.0
2022-09-12 12:30:00	AAPL	Stock	162.6	163.139	162.44	163.09	4501039.0
2022-09-12 13:00:00	AAPL	Stock	163.09	163.65	162.73	163.6203	4315731.0
2022-09-12 13:30:00	AAPL	Stock	163.62	164.26	163.515	164.135	5482247.0
2022-09-12 14:00:00	AAPL	Stock	164.13	164.1777	163.43	163.47	4703936.0
2022-09-12 14:30:00	AAPL	Stock	163.461	163.75	163.28	163.57	3494914.0
2022-09-12 15:00:00	AAPL	Stock	163.579	163.9699	163.0701	163.325	4485464.0
2022-09-12 15:30:00	AAPL	Stock	163.33	163.735	163.2	163.45	8414494.0
2022-09-12 16:00:00	AAPL	Stock	163.45	163.85	163.27	163.71	8835447.0
2022-09-12 16:30:00	AAPL	Stock	163.71	163.83	163.43	163.83	254830.0
2022-09-12 17:00:00	AAPL	Stock	163.8296	163.88	163.72	163.74	55820.0
2022-09-12 17:30:00	AAPL	Stock	163.76	163.83	163.71	163.72	30136.0
2022-09-12 18:00:00	AAPL	Stock	163.72	163.83	163.66	163.71	20946.0
2022-09-12 18:30:00	AAPL	Stock	163.74	163.85	163.65	163.85	16790.0
2022-09-12 19:00:00	AAPL	Stock	163.86	163.95	163.84	163.94	18792.0
2022-09-12 19:30:00	AAPL	Stock	163.94	164.18	163.88	164.15	55351.0
2022-09-12 04:00:00	MSFT	Stock	264.45	265.33	264.45	265.1	1084.0
2022-09-12 04:30:00	MSFT	Stock	266.09	266.6	266.09	266.47	3441.0
2022-09-12 05:00:00	MSFT	Stock	266.79	266.98	266.78	266.98	523.0
2022-09-12 05:30:00	MSFT	Stock	266.42	266.42	266.25	266.25	913.0
2022-09-12 06:00:00	MSFT	Stock	265.82	265.82	265.32	265.63	761.0
2022-09-12 07:00:00	MSFT	Stock	265.45	265.75	265.11	265.5	11201.0
2022-09-12 07:30:00	MSFT	Stock	265.35	265.82	265.3	265.77	11384.0
2022-09-12 08:00:00	MSFT	Stock	265.7439	265.8298	264.52	264.52	27175.0
2022-09-12 08:30:00	MSFT	Stock	264.46	265.4	264.46	265.4	6366.0
2022-09-12 09:00:00	MSFT	Stock	265.303	265.79	264.86	265.78	8963.0
2022-09-12 09:30:00	MSFT	Stock	265.78	267.35	265.16	266.94	1542955.0
2022-09-12 10:00:00	MSFT	Stock	266.95	267.45	266.3283	267.12	788586.0
2022-09-12 10:30:00	MSFT	Stock	267.12	267.25	266.46	266.77	700274.0
2022-09-12 11:00:00	MSFT	Stock	266.78	267.08	265.8101	267.079	611617.0
2022-09-12 11:30:00	MSFT	Stock	267.05	267.26	265.3637	265.64	632456.0
2022-09-12 12:00:00	MSFT	Stock	265.63	266.15	265.19	265.86	459564.0
2022-09-12 12:30:00	MSFT	Stock	265.86	266.43	265.47	266.19	495946.0
2022-09-12 13:00:00	MSFT	Stock	266.1892	266.86	265.63	266.82	490413.0

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

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