PREVIEW / stock_1min / 2023-10-23

all stock 1-min files

  file:    by_date/stock_1min/2023/2023-10-23.parquet
  size:    19.9 MB
  rows:    1,244,211
  symbols: 1,320

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-10-23 04:00:00	AAPL	Stock	172.6	172.6	172.01	172.01	1061.0
2023-10-23 04:01:00	AAPL	Stock	172.0	172.0	171.8	171.8	1559.0
2023-10-23 04:02:00	AAPL	Stock	171.79	171.79	171.68	171.68	600.0
2023-10-23 04:03:00	AAPL	Stock	171.7	171.7	171.7	171.7	400.0
2023-10-23 04:05:00	AAPL	Stock	171.68	171.68	171.68	171.68	100.0
2023-10-23 04:06:00	AAPL	Stock	171.7	171.8	171.7	171.8	2217.0
2023-10-23 04:08:00	AAPL	Stock	171.79	171.8	171.79	171.8	3691.0
2023-10-23 04:09:00	AAPL	Stock	171.74	171.98	171.74	171.98	1630.0
2023-10-23 04:11:00	AAPL	Stock	171.96	171.98	171.95	171.95	1450.0
2023-10-23 04:12:00	AAPL	Stock	171.96	172.0	171.96	172.0	3289.0
2023-10-23 04:13:00	AAPL	Stock	172.01	172.04	172.0	172.04	1360.0
2023-10-23 04:14:00	AAPL	Stock	172.06	172.06	172.05	172.05	575.0
2023-10-23 04:15:00	AAPL	Stock	172.01	172.01	172.0	172.0	3050.0
2023-10-23 04:16:00	AAPL	Stock	171.98	171.98	171.98	171.98	300.0
2023-10-23 04:17:00	AAPL	Stock	172.0	172.0	171.99	171.99	1141.0
2023-10-23 04:20:00	AAPL	Stock	171.97	172.0	171.97	172.0	1787.0
2023-10-23 04:21:00	AAPL	Stock	171.99	172.0	171.94	171.94	2964.0
2023-10-23 04:22:00	AAPL	Stock	171.99	172.0	171.99	172.0	750.0
2023-10-23 04:23:00	AAPL	Stock	171.98	172.0	171.97	171.97	675.0
2023-10-23 04:25:00	AAPL	Stock	171.95	171.95	171.94	171.94	299.0
2023-10-23 04:26:00	AAPL	Stock	171.94	171.94	171.89	171.89	2614.0
2023-10-23 04:28:00	AAPL	Stock	171.83	171.83	171.75	171.75	713.0
2023-10-23 04:29:00	AAPL	Stock	171.77	171.77	171.75	171.75	902.0
2023-10-23 04:30:00	AAPL	Stock	171.76	171.76	171.73	171.73	2200.0
2023-10-23 04:33:00	AAPL	Stock	171.73	171.73	171.7	171.7	1507.0
2023-10-23 04:34:00	AAPL	Stock	171.7	171.7	171.7	171.7	699.0
2023-10-23 04:36:00	AAPL	Stock	171.86	171.86	171.86	171.86	606.0
2023-10-23 04:38:00	AAPL	Stock	171.83	171.85	171.83	171.85	666.0
2023-10-23 04:39:00	AAPL	Stock	171.84	171.84	171.84	171.84	100.0
2023-10-23 04:42:00	AAPL	Stock	171.84	171.86	171.84	171.86	1085.0
2023-10-23 04:47:00	AAPL	Stock	171.82	171.82	171.82	171.82	313.0
2023-10-23 04:53:00	AAPL	Stock	171.7	171.71	171.7	171.7	1689.0
2023-10-23 04:55:00	AAPL	Stock	171.7	171.7	171.7	171.7	249.0
2023-10-23 05:00:00	AAPL	Stock	171.67	171.67	171.43	171.43	2523.0
2023-10-23 05:02:00	AAPL	Stock	171.3	171.3	171.3	171.3	100.0
2023-10-23 05:04:00	AAPL	Stock	171.27	171.27	171.11	171.12	3560.0
2023-10-23 05:05:00	AAPL	Stock	171.15	171.15	171.1	171.11	788.0
2023-10-23 05:06:00	AAPL	Stock	171.16	171.18	171.14	171.18	1296.0
2023-10-23 05:07:00	AAPL	Stock	171.15	171.15	171.1	171.1	1163.0
2023-10-23 05:08:00	AAPL	Stock	171.09	171.09	170.98	170.98	3196.0
2023-10-23 05:09:00	AAPL	Stock	170.98	170.98	170.0	170.29	12976.0
2023-10-23 05:10:00	AAPL	Stock	170.5	170.55	170.2	170.25	4330.0
2023-10-23 05:11:00	AAPL	Stock	170.48	170.48	170.36	170.36	686.0
2023-10-23 05:12:00	AAPL	Stock	170.48	170.48	170.45	170.45	488.0
2023-10-23 05:13:00	AAPL	Stock	170.45	170.46	170.45	170.46	4235.0
2023-10-23 05:15:00	AAPL	Stock	170.4	170.4	170.39	170.39	2320.0
2023-10-23 05:16:00	AAPL	Stock	170.48	170.56	170.48	170.51	2189.0
2023-10-23 05:17:00	AAPL	Stock	170.75	170.8	170.75	170.8	756.0
2023-10-23 05:18:00	AAPL	Stock	170.85	170.85	170.85	170.85	100.0
2023-10-23 05:20:00	AAPL	Stock	170.89	170.89	170.75	170.8	787.0

> showing 50 of 1,244,211 rows — these rows as CSV

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