PREVIEW / stock_30min / 2023-05-12

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-05-12.parquet
  size:    2.0 MB
  rows:    99,177
  symbols: 1,638

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-05-12 04:00:00	AAPL	Stock	174.0	174.05	173.77	174.0	8786.0
2023-05-12 04:30:00	AAPL	Stock	173.94	173.94	173.79	173.86	3995.0
2023-05-12 05:00:00	AAPL	Stock	173.86	173.95	173.78	173.81	1411.0
2023-05-12 05:30:00	AAPL	Stock	173.81	173.81	173.5	173.5	4955.0
2023-05-12 06:00:00	AAPL	Stock	173.57	173.59	173.54	173.54	1189.0
2023-05-12 06:30:00	AAPL	Stock	173.59	173.81	173.59	173.69	2740.0
2023-05-12 07:00:00	AAPL	Stock	173.83	173.87	173.7	173.76	15271.0
2023-05-12 07:30:00	AAPL	Stock	173.7	173.73	173.55	173.6	13136.0
2023-05-12 08:00:00	AAPL	Stock	173.74	173.85	173.38	173.4	46417.0
2023-05-12 08:30:00	AAPL	Stock	173.38	173.68	173.34	173.5	54936.0
2023-05-12 09:00:00	AAPL	Stock	173.47	173.75	173.45	173.62	134871.0
2023-05-12 09:30:00	AAPL	Stock	173.62	174.06	172.95	173.08	4886654.0
2023-05-12 10:00:00	AAPL	Stock	173.08	173.26	172.51	172.69	2884762.0
2023-05-12 10:30:00	AAPL	Stock	172.69	172.9	172.33	172.78	2448372.0
2023-05-12 11:00:00	AAPL	Stock	172.78	172.975	172.375	172.48	1979103.0
2023-05-12 11:30:00	AAPL	Stock	172.485	172.72	172.32	172.665	1714762.0
2023-05-12 12:00:00	AAPL	Stock	172.67	172.69	171.93	171.945	2160980.0
2023-05-12 12:30:00	AAPL	Stock	171.93	172.19	171.49	171.54	1948924.0
2023-05-12 13:00:00	AAPL	Stock	171.53	172.015	171.315	171.775	1871610.0
2023-05-12 13:30:00	AAPL	Stock	171.77	171.975	171.21	171.28	1539343.0
2023-05-12 14:00:00	AAPL	Stock	171.27	171.5	171.0	171.33	1916031.0
2023-05-12 14:30:00	AAPL	Stock	171.33	171.75	171.18	171.6599	2167251.0
2023-05-12 15:00:00	AAPL	Stock	171.66	171.93	171.56	171.9001	2532546.0
2023-05-12 15:30:00	AAPL	Stock	171.91	172.62	171.905	172.56	4614044.0
2023-05-12 16:00:00	AAPL	Stock	172.57	172.57	172.41	172.47	5016916.0
2023-05-12 16:30:00	AAPL	Stock	172.48	172.57	172.46	172.48	88358.0
2023-05-12 17:00:00	AAPL	Stock	172.46	172.5	172.44	172.48	40242.0
2023-05-12 17:30:00	AAPL	Stock	172.47	172.4721	172.35	172.39	6714.0
2023-05-12 18:00:00	AAPL	Stock	172.4	172.45	172.35	172.42	5687.0
2023-05-12 18:30:00	AAPL	Stock	172.42	172.43	172.35	172.3701	5163.0
2023-05-12 19:00:00	AAPL	Stock	172.4	172.42	172.37	172.39	3546.0
2023-05-12 19:30:00	AAPL	Stock	172.39	172.45	172.36	172.45	16717.0
2023-05-12 04:00:00	MSFT	Stock	310.2	310.46	310.2	310.38	355.0
2023-05-12 04:30:00	MSFT	Stock	310.38	310.38	310.28	310.29	318.0
2023-05-12 05:00:00	MSFT	Stock	310.35	310.4	310.35	310.4	700.0
2023-05-12 05:30:00	MSFT	Stock	310.2	310.2	310.16	310.2	334.0
2023-05-12 06:00:00	MSFT	Stock	310.15	310.24	310.15	310.24	226.0
2023-05-12 07:00:00	MSFT	Stock	310.34	310.6	309.9	309.9	5119.0
2023-05-12 07:30:00	MSFT	Stock	309.9	309.99	309.52	309.65	6443.0
2023-05-12 08:00:00	MSFT	Stock	309.5306	310.48	309.4	309.55	8991.0
2023-05-12 08:30:00	MSFT	Stock	309.55	310.09	309.55	309.84	10404.0
2023-05-12 09:00:00	MSFT	Stock	309.74	310.8	309.08	310.29	19000.0
2023-05-12 09:30:00	MSFT	Stock	310.54	310.65	307.6	308.1	2067379.0
2023-05-12 10:00:00	MSFT	Stock	308.2	308.58	307.62	307.68	1158815.0
2023-05-12 10:30:00	MSFT	Stock	307.67	308.46	306.95	308.07	1329070.0
2023-05-12 11:00:00	MSFT	Stock	308.07	308.79	307.2	307.35	834242.0
2023-05-12 11:30:00	MSFT	Stock	307.33	308.7	307.31	308.55	783080.0
2023-05-12 12:00:00	MSFT	Stock	308.55	308.6	307.62	307.62	520953.0
2023-05-12 12:30:00	MSFT	Stock	307.62	307.91	306.86	307.0369	531541.0
2023-05-12 13:00:00	MSFT	Stock	307.02	308.41	306.97	307.93	671755.0

> showing 50 of 99,177 rows — these rows as CSV

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