PREVIEW / stock_1min / 2023-08-23

all stock 1-min files

  file:    by_date/stock_1min/2023/2023-08-23.parquet
  size:    19.5 MB
  rows:    1,191,100
  symbols: 1,415

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-08-23 04:00:00	AAPL	Stock	178.0	178.2	178.0	178.2	690.0
2023-08-23 04:07:00	AAPL	Stock	177.95	178.0	177.95	178.0	1362.0
2023-08-23 04:09:00	AAPL	Stock	178.1	178.2	178.1	178.2	2084.0
2023-08-23 04:11:00	AAPL	Stock	178.18	178.29	178.18	178.29	592.0
2023-08-23 04:12:00	AAPL	Stock	178.29	178.29	178.29	178.29	112.0
2023-08-23 04:14:00	AAPL	Stock	178.29	178.29	178.29	178.29	200.0
2023-08-23 04:15:00	AAPL	Stock	178.29	178.29	178.29	178.29	126.0
2023-08-23 04:16:00	AAPL	Stock	178.28	178.33	178.28	178.33	1212.0
2023-08-23 04:23:00	AAPL	Stock	178.3	178.31	178.26	178.26	804.0
2023-08-23 04:29:00	AAPL	Stock	178.21	178.21	178.21	178.21	100.0
2023-08-23 04:30:00	AAPL	Stock	178.21	178.21	178.21	178.21	100.0
2023-08-23 04:33:00	AAPL	Stock	178.21	178.21	178.21	178.21	118.0
2023-08-23 04:34:00	AAPL	Stock	178.21	178.21	178.21	178.21	500.0
2023-08-23 04:35:00	AAPL	Stock	178.21	178.21	178.2	178.2	596.0
2023-08-23 04:36:00	AAPL	Stock	178.21	178.25	178.21	178.25	2283.0
2023-08-23 04:37:00	AAPL	Stock	178.25	178.25	178.25	178.25	350.0
2023-08-23 04:38:00	AAPL	Stock	178.26	178.26	178.25	178.25	350.0
2023-08-23 04:39:00	AAPL	Stock	178.26	178.26	178.26	178.26	423.0
2023-08-23 04:41:00	AAPL	Stock	178.3	178.3	178.3	178.3	130.0
2023-08-23 04:42:00	AAPL	Stock	178.21	178.21	178.21	178.21	269.0
2023-08-23 04:47:00	AAPL	Stock	178.28	178.32	178.28	178.32	1546.0
2023-08-23 04:50:00	AAPL	Stock	178.3	178.31	178.3	178.31	595.0
2023-08-23 04:54:00	AAPL	Stock	178.32	178.32	178.32	178.32	100.0
2023-08-23 05:01:00	AAPL	Stock	178.29	178.3	178.29	178.3	490.0
2023-08-23 05:02:00	AAPL	Stock	178.34	178.34	178.34	178.34	100.0
2023-08-23 05:04:00	AAPL	Stock	178.38	178.39	178.38	178.39	560.0
2023-08-23 05:06:00	AAPL	Stock	178.38	178.38	178.38	178.38	100.0
2023-08-23 05:07:00	AAPL	Stock	178.37	178.37	178.37	178.37	100.0
2023-08-23 05:09:00	AAPL	Stock	178.42	178.43	178.42	178.43	1170.0
2023-08-23 05:11:00	AAPL	Stock	178.43	178.43	178.43	178.43	100.0
2023-08-23 05:13:00	AAPL	Stock	178.39	178.39	178.39	178.39	150.0
2023-08-23 05:14:00	AAPL	Stock	178.35	178.35	178.35	178.35	250.0
2023-08-23 05:15:00	AAPL	Stock	178.29	178.29	178.2	178.2	276.0
2023-08-23 05:16:00	AAPL	Stock	178.2	178.2	178.1	178.1	1161.0
2023-08-23 05:17:00	AAPL	Stock	178.03	178.03	178.01	178.01	2015.0
2023-08-23 05:23:00	AAPL	Stock	178.13	178.13	178.13	178.13	100.0
2023-08-23 05:25:00	AAPL	Stock	178.17	178.17	178.17	178.17	294.0
2023-08-23 05:26:00	AAPL	Stock	178.16	178.16	178.16	178.16	100.0
2023-08-23 05:37:00	AAPL	Stock	178.11	178.11	178.11	178.11	100.0
2023-08-23 05:47:00	AAPL	Stock	178.18	178.18	178.18	178.18	200.0
2023-08-23 05:55:00	AAPL	Stock	178.18	178.31	178.18	178.3	1877.0
2023-08-23 05:59:00	AAPL	Stock	178.23	178.24	178.23	178.23	1016.0
2023-08-23 06:01:00	AAPL	Stock	178.27	178.27	178.27	178.27	100.0
2023-08-23 06:05:00	AAPL	Stock	178.28	178.3	178.28	178.3	631.0
2023-08-23 06:06:00	AAPL	Stock	178.24	178.24	178.23	178.23	391.0
2023-08-23 06:07:00	AAPL	Stock	178.23	178.23	178.23	178.23	1500.0
2023-08-23 06:18:00	AAPL	Stock	178.2	178.2	178.2	178.2	1100.0
2023-08-23 06:20:00	AAPL	Stock	178.22	178.37	178.22	178.32	712.0
2023-08-23 06:21:00	AAPL	Stock	178.35	178.35	178.35	178.35	100.0
2023-08-23 06:22:00	AAPL	Stock	178.32	178.32	178.32	178.32	150.0

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

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