PREVIEW / stock_30min / 2023-03-22

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-22.parquet
  size:    2.0 MB
  rows:    100,100
  symbols: 1,731

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-03-22 04:00:00	AAPL	Stock	158.0	158.85	158.0	158.33	9556.0
2023-03-22 04:30:00	AAPL	Stock	158.32	158.44	158.21	158.21	7564.0
2023-03-22 05:00:00	AAPL	Stock	158.16	160.0	158.09	158.79	15228.0
2023-03-22 05:30:00	AAPL	Stock	158.74	158.77	158.61	158.61	3585.0
2023-03-22 06:00:00	AAPL	Stock	158.7	158.7	158.54	158.67	5092.0
2023-03-22 06:30:00	AAPL	Stock	158.6	158.77	158.44	158.77	5281.0
2023-03-22 07:00:00	AAPL	Stock	158.78	159.11	158.7	159.05	21129.0
2023-03-22 07:30:00	AAPL	Stock	159.07	159.12	158.55	158.77	21638.0
2023-03-22 08:00:00	AAPL	Stock	158.79	159.25	158.2885	158.68	66356.0
2023-03-22 08:30:00	AAPL	Stock	158.7	158.95	158.64	158.89	35936.0
2023-03-22 09:00:00	AAPL	Stock	158.93	159.37	158.8	159.37	71384.0
2023-03-22 09:30:00	AAPL	Stock	159.29	159.99	159.21	159.72	5312056.0
2023-03-22 10:00:00	AAPL	Stock	159.73	160.4	159.118	160.0642	4775758.0
2023-03-22 10:30:00	AAPL	Stock	160.06	160.41	159.935	160.2	3402410.0
2023-03-22 11:00:00	AAPL	Stock	160.1909	160.3685	159.89	160.22	2383856.0
2023-03-22 11:30:00	AAPL	Stock	160.22	160.52	160.09	160.46	2154557.0
2023-03-22 12:00:00	AAPL	Stock	160.46	160.46	159.6104	159.615	2342863.0
2023-03-22 12:30:00	AAPL	Stock	159.615	159.815	159.47	159.7574	1738929.0
2023-03-22 13:00:00	AAPL	Stock	159.75	160.05	159.61	160.04	1974649.0
2023-03-22 13:30:00	AAPL	Stock	160.05	160.26	159.95	160.11	1855186.0
2023-03-22 14:00:00	AAPL	Stock	160.11	161.52	160.06	161.19	5996850.0
2023-03-22 14:30:00	AAPL	Stock	161.195	162.14	159.825	160.3954	7222247.0
2023-03-22 15:00:00	AAPL	Stock	160.39	160.95	159.02	160.5561	6284180.0
2023-03-22 15:30:00	AAPL	Stock	160.54	160.68	157.81	157.815	9875412.0
2023-03-22 16:00:00	AAPL	Stock	157.82	158.04	157.5732	157.93	5129791.0
2023-03-22 16:30:00	AAPL	Stock	157.93	158.2	157.83	158.0	65771.0
2023-03-22 17:00:00	AAPL	Stock	158.08	158.08	157.91	157.9401	35577.0
2023-03-22 17:30:00	AAPL	Stock	157.95	158.1	157.93	158.0	17478.0
2023-03-22 18:00:00	AAPL	Stock	158.0	158.2	157.93	158.03	19555.0
2023-03-22 18:30:00	AAPL	Stock	158.03	158.38	158.03	158.19	15793.0
2023-03-22 19:00:00	AAPL	Stock	158.2	158.28	158.06	158.22	9752.0
2023-03-22 19:30:00	AAPL	Stock	158.3	158.7	158.2	158.42	17719.0
2023-03-22 04:00:00	MSFT	Stock	273.08	273.08	271.98	272.32	6731.0
2023-03-22 04:30:00	MSFT	Stock	272.17	272.63	272.13	272.48	956.0
2023-03-22 05:00:00	MSFT	Stock	272.14	272.9	271.92	272.9	1426.0
2023-03-22 05:30:00	MSFT	Stock	272.93	273.33	272.74	272.74	1690.0
2023-03-22 06:00:00	MSFT	Stock	272.91	272.91	272.31	272.72	1478.0
2023-03-22 06:30:00	MSFT	Stock	272.57	273.0	272.53	272.95	1797.0
2023-03-22 07:00:00	MSFT	Stock	272.84	273.65	272.84	273.55	7190.0
2023-03-22 07:30:00	MSFT	Stock	273.55	273.55	272.9	273.01	7233.0
2023-03-22 08:00:00	MSFT	Stock	272.8283	274.23	271.8915	272.8	22146.0
2023-03-22 08:30:00	MSFT	Stock	272.84	273.5	272.84	273.23	10756.0
2023-03-22 09:00:00	MSFT	Stock	273.328	274.1	273.13	273.73	23710.0
2023-03-22 09:30:00	MSFT	Stock	273.4	274.24	272.62	273.14	1816529.0
2023-03-22 10:00:00	MSFT	Stock	273.13	277.15	272.85	276.93	2154719.0
2023-03-22 10:30:00	MSFT	Stock	276.96	277.3	275.57	276.09	1874431.0
2023-03-22 11:00:00	MSFT	Stock	276.07	276.6	275.6	276.24	886937.0
2023-03-22 11:30:00	MSFT	Stock	276.24	278.26	276.205	277.85	1385624.0
2023-03-22 12:00:00	MSFT	Stock	277.86	277.89	275.85	275.8501	1198217.0
2023-03-22 12:30:00	MSFT	Stock	275.85	276.94	275.764	276.94	690151.0

> showing 50 of 100,100 rows — these rows as CSV

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