PREVIEW / stock_1min / 2023-09-07

all stock 1-min files

  file:    by_date/stock_1min/2023/2023-09-07.parquet
  size:    19.8 MB
  rows:    1,227,726
  symbols: 1,367

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-09-07 04:00:00	AAPL	Stock	181.48	181.9	179.76	179.76	27568.0
2023-09-07 04:01:00	AAPL	Stock	179.7	180.0	179.7	179.9	10192.0
2023-09-07 04:02:00	AAPL	Stock	179.91	179.91	179.81	179.81	1671.0
2023-09-07 04:03:00	AAPL	Stock	179.9	179.9	179.71	179.71	10628.0
2023-09-07 04:04:00	AAPL	Stock	179.71	179.71	179.6	179.71	8967.0
2023-09-07 04:05:00	AAPL	Stock	179.66	179.74	179.63	179.71	8360.0
2023-09-07 04:06:00	AAPL	Stock	179.74	179.74	179.69	179.69	4287.0
2023-09-07 04:07:00	AAPL	Stock	179.67	179.71	179.67	179.71	1470.0
2023-09-07 04:08:00	AAPL	Stock	179.71	179.74	179.56	179.67	6261.0
2023-09-07 04:09:00	AAPL	Stock	179.7	179.71	179.7	179.7	2059.0
2023-09-07 04:11:00	AAPL	Stock	179.56	179.7	179.55	179.7	3733.0
2023-09-07 04:12:00	AAPL	Stock	179.7	179.7	179.68	179.68	2060.0
2023-09-07 04:13:00	AAPL	Stock	179.65	179.65	179.65	179.65	423.0
2023-09-07 04:14:00	AAPL	Stock	179.68	179.68	179.66	179.66	329.0
2023-09-07 04:15:00	AAPL	Stock	179.68	179.69	179.68	179.69	1941.0
2023-09-07 04:16:00	AAPL	Stock	179.7	179.71	179.66	179.66	1781.0
2023-09-07 04:17:00	AAPL	Stock	179.7	179.7	179.7	179.7	100.0
2023-09-07 04:18:00	AAPL	Stock	179.69	179.71	179.69	179.69	566.0
2023-09-07 04:19:00	AAPL	Stock	179.69	179.69	179.47	179.51	5753.0
2023-09-07 04:20:00	AAPL	Stock	179.51	179.51	179.51	179.51	500.0
2023-09-07 04:21:00	AAPL	Stock	179.53	179.6	179.53	179.6	3957.0
2023-09-07 04:22:00	AAPL	Stock	179.68	179.68	179.43	179.43	8291.0
2023-09-07 04:23:00	AAPL	Stock	179.41	179.44	179.39	179.39	1611.0
2023-09-07 04:24:00	AAPL	Stock	179.31	179.31	179.3	179.3	1384.0
2023-09-07 04:25:00	AAPL	Stock	179.26	179.26	179.24	179.25	1374.0
2023-09-07 04:26:00	AAPL	Stock	179.22	179.22	178.76	178.8	23381.0
2023-09-07 04:27:00	AAPL	Stock	178.8	178.8	178.61	178.61	2739.0
2023-09-07 04:28:00	AAPL	Stock	178.6	178.6	178.2	178.2	16453.0
2023-09-07 04:29:00	AAPL	Stock	178.33	178.5	177.0	177.89	37027.0
2023-09-07 04:30:00	AAPL	Stock	177.89	178.37	177.5	178.0	18875.0
2023-09-07 04:31:00	AAPL	Stock	178.0	178.02	177.88	178.0	8260.0
2023-09-07 04:32:00	AAPL	Stock	177.96	178.0	177.91	177.95	5797.0
2023-09-07 04:33:00	AAPL	Stock	178.0	178.1	177.96	178.1	2184.0
2023-09-07 04:34:00	AAPL	Stock	178.2	178.38	178.2	178.3	2987.0
2023-09-07 04:35:00	AAPL	Stock	178.3	178.3	177.82	177.84	4560.0
2023-09-07 04:36:00	AAPL	Stock	177.94	177.95	177.85	177.85	6095.0
2023-09-07 04:37:00	AAPL	Stock	178.0	178.04	178.0	178.04	500.0
2023-09-07 04:38:00	AAPL	Stock	178.15	178.3	178.15	178.28	1756.0
2023-09-07 04:39:00	AAPL	Stock	178.2	178.2	178.18	178.18	641.0
2023-09-07 04:40:00	AAPL	Stock	178.27	178.3	178.26	178.3	6114.0
2023-09-07 04:41:00	AAPL	Stock	178.29	178.33	178.25	178.25	2193.0
2023-09-07 04:42:00	AAPL	Stock	178.27	178.33	178.27	178.33	1799.0
2023-09-07 04:43:00	AAPL	Stock	178.35	178.47	178.3	178.32	4025.0
2023-09-07 04:44:00	AAPL	Stock	178.35	178.35	178.27	178.31	1867.0
2023-09-07 04:45:00	AAPL	Stock	178.31	178.38	178.31	178.35	2427.0
2023-09-07 04:46:00	AAPL	Stock	178.35	178.35	178.0	178.0	2725.0
2023-09-07 04:47:00	AAPL	Stock	177.85	178.01	177.76	178.01	2044.0
2023-09-07 04:48:00	AAPL	Stock	178.06	178.11	178.06	178.11	858.0
2023-09-07 04:49:00	AAPL	Stock	178.26	178.35	178.26	178.35	2108.0
2023-09-07 04:50:00	AAPL	Stock	178.35	178.42	177.7	177.82	13621.0

> showing 50 of 1,227,726 rows — these rows as CSV

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