PREVIEW / stock_30min / 2022-07-18

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-18.parquet
  size:    2.1 MB
  rows:    106,008
  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-18 04:00:00	AAPL	Stock	150.61	151.85	150.61	151.85	29437.0
2022-07-18 04:30:00	AAPL	Stock	151.84	151.9	151.68	151.7	13405.0
2022-07-18 05:00:00	AAPL	Stock	151.69	151.75	151.51	151.63	5955.0
2022-07-18 05:30:00	AAPL	Stock	151.5	151.59	151.4	151.5	12771.0
2022-07-18 06:00:00	AAPL	Stock	151.45	151.5	151.43	151.46	4202.0
2022-07-18 06:30:00	AAPL	Stock	151.57	151.57	151.4	151.51	6974.0
2022-07-18 07:00:00	AAPL	Stock	151.5	151.7	151.31	151.63	71857.0
2022-07-18 07:30:00	AAPL	Stock	151.63	151.63	151.45	151.45	39924.0
2022-07-18 08:00:00	AAPL	Stock	151.5499	151.7	150.95	150.99	198169.0
2022-07-18 08:30:00	AAPL	Stock	150.99	151.23	150.87	151.19	107736.0
2022-07-18 09:00:00	AAPL	Stock	151.19	151.2	150.44	150.75	223636.0
2022-07-18 09:30:00	AAPL	Stock	150.74	151.38	150.27	151.1024	8669073.0
2022-07-18 10:00:00	AAPL	Stock	151.12	151.57	150.72	151.0	4276502.0
2022-07-18 10:30:00	AAPL	Stock	151.0	151.31	150.5812	151.195	3281404.0
2022-07-18 11:00:00	AAPL	Stock	151.21	151.43	150.875	150.8951	2541817.0
2022-07-18 11:30:00	AAPL	Stock	150.89	151.43	150.82	151.405	2583958.0
2022-07-18 12:00:00	AAPL	Stock	151.41	151.41	150.94	150.98	1632617.0
2022-07-18 12:30:00	AAPL	Stock	150.97	151.07	150.71	150.75	1506247.0
2022-07-18 13:00:00	AAPL	Stock	150.7499	150.7937	150.25	150.4797	2212407.0
2022-07-18 13:30:00	AAPL	Stock	150.47	150.52	147.2	147.795	11882719.0
2022-07-18 14:00:00	AAPL	Stock	147.79	148.24	147.31	147.72	5851451.0
2022-07-18 14:30:00	AAPL	Stock	147.72	148.2	147.21	147.3	4383757.0
2022-07-18 15:00:00	AAPL	Stock	147.29	147.84	147.18	147.18	3941090.0
2022-07-18 15:30:00	AAPL	Stock	147.19	147.31	146.7	147.13	7950266.0
2022-07-18 16:00:00	AAPL	Stock	147.13	147.18	146.85	146.88	6035471.0
2022-07-18 16:30:00	AAPL	Stock	146.88	146.99	146.82	146.89	62701.0
2022-07-18 17:00:00	AAPL	Stock	146.9	147.07	146.6	146.62	85060.0
2022-07-18 17:30:00	AAPL	Stock	146.65	147.07	146.44	146.5	58942.0
2022-07-18 18:00:00	AAPL	Stock	146.54	146.67	146.3	146.67	51164.0
2022-07-18 18:30:00	AAPL	Stock	146.62	146.75	146.6	146.73	22360.0
2022-07-18 19:00:00	AAPL	Stock	146.73	146.89	146.45	146.87	31177.0
2022-07-18 19:30:00	AAPL	Stock	146.88	147.0	146.3	146.9	49474.0
2022-07-18 04:00:00	MSFT	Stock	258.63	260.5	258.63	260.5	8647.0
2022-07-18 04:30:00	MSFT	Stock	260.5	260.68	260.14	260.14	11067.0
2022-07-18 05:00:00	MSFT	Stock	259.96	260.0	259.96	260.0	2338.0
2022-07-18 05:30:00	MSFT	Stock	259.8	259.8	259.7	259.7	409.0
2022-07-18 06:00:00	MSFT	Stock	259.6	259.6	259.6	259.6	1107.0
2022-07-18 06:30:00	MSFT	Stock	259.88	260.1	259.88	260.0	8275.0
2022-07-18 07:00:00	MSFT	Stock	260.0	260.04	259.76	259.99	14067.0
2022-07-18 07:30:00	MSFT	Stock	260.08	260.08	259.7	259.9	4553.0
2022-07-18 08:00:00	MSFT	Stock	260.095	260.15	258.08	258.85	33019.0
2022-07-18 08:30:00	MSFT	Stock	258.85	259.46	258.6	259.37	8374.0
2022-07-18 09:00:00	MSFT	Stock	259.11	259.8	258.6	259.8	23170.0
2022-07-18 09:30:00	MSFT	Stock	259.6	260.57	258.55	259.91	2052075.0
2022-07-18 10:00:00	MSFT	Stock	259.91	260.84	259.04	259.07	1065111.0
2022-07-18 10:30:00	MSFT	Stock	259.07	259.3	257.7	258.3701	1069861.0
2022-07-18 11:00:00	MSFT	Stock	258.4	258.6086	256.91	257.4901	1174941.0
2022-07-18 11:30:00	MSFT	Stock	257.48	258.92	257.22	258.82	957301.0
2022-07-18 12:00:00	MSFT	Stock	258.81	258.85	258.33	258.6	459394.0
2022-07-18 12:30:00	MSFT	Stock	258.6	259.3	258.47	258.67	535747.0

> showing 50 of 106,008 rows — these rows as CSV

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