PREVIEW / stock_1min / 2023-09-20

all stock 1-min files

  file:    by_date/stock_1min/2023/2023-09-20.parquet
  size:    18.9 MB
  rows:    1,159,898
  symbols: 1,387

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-20 04:01:00	AAPL	Stock	178.98	178.99	178.85	178.85	831.0
2023-09-20 04:02:00	AAPL	Stock	178.85	178.85	178.85	178.85	465.0
2023-09-20 04:05:00	AAPL	Stock	178.85	178.85	178.85	178.85	1421.0
2023-09-20 04:09:00	AAPL	Stock	178.88	178.93	178.88	178.93	656.0
2023-09-20 04:10:00	AAPL	Stock	178.97	178.97	178.97	178.97	100.0
2023-09-20 04:11:00	AAPL	Stock	179.0	179.0	179.0	179.0	129.0
2023-09-20 04:12:00	AAPL	Stock	179.0	179.0	179.0	179.0	100.0
2023-09-20 04:14:00	AAPL	Stock	178.97	179.0	178.97	179.0	1083.0
2023-09-20 04:15:00	AAPL	Stock	179.0	179.0	179.0	179.0	404.0
2023-09-20 04:16:00	AAPL	Stock	179.0	179.0	179.0	179.0	999.0
2023-09-20 04:19:00	AAPL	Stock	179.06	179.06	179.02	179.06	1161.0
2023-09-20 04:24:00	AAPL	Stock	179.16	179.16	179.16	179.16	112.0
2023-09-20 04:25:00	AAPL	Stock	179.2	179.2	179.2	179.2	233.0
2023-09-20 04:32:00	AAPL	Stock	179.19	179.2	179.19	179.2	573.0
2023-09-20 04:33:00	AAPL	Stock	179.23	179.23	179.23	179.23	100.0
2023-09-20 04:36:00	AAPL	Stock	179.28	179.28	179.28	179.28	100.0
2023-09-20 04:37:00	AAPL	Stock	179.29	179.29	179.28	179.28	208.0
2023-09-20 04:38:00	AAPL	Stock	179.27	179.27	179.27	179.27	100.0
2023-09-20 04:40:00	AAPL	Stock	179.26	179.27	179.26	179.27	420.0
2023-09-20 04:41:00	AAPL	Stock	179.25	179.25	179.25	179.25	100.0
2023-09-20 04:42:00	AAPL	Stock	179.27	179.27	179.27	179.27	181.0
2023-09-20 04:43:00	AAPL	Stock	179.23	179.27	179.23	179.27	2079.0
2023-09-20 04:45:00	AAPL	Stock	179.26	179.36	179.26	179.36	816.0
2023-09-20 04:49:00	AAPL	Stock	179.29	179.29	179.29	179.29	200.0
2023-09-20 04:51:00	AAPL	Stock	179.28	179.29	179.28	179.29	590.0
2023-09-20 04:52:00	AAPL	Stock	179.29	179.29	179.29	179.29	1189.0
2023-09-20 05:00:00	AAPL	Stock	179.33	179.33	179.33	179.33	434.0
2023-09-20 05:02:00	AAPL	Stock	179.36	179.4	179.36	179.4	616.0
2023-09-20 05:04:00	AAPL	Stock	179.44	179.44	179.44	179.44	211.0
2023-09-20 05:08:00	AAPL	Stock	179.45	179.45	179.45	179.45	100.0
2023-09-20 05:19:00	AAPL	Stock	179.28	179.28	179.28	179.28	100.0
2023-09-20 05:21:00	AAPL	Stock	179.3	179.3	179.28	179.28	300.0
2023-09-20 05:25:00	AAPL	Stock	179.25	179.25	179.25	179.25	100.0
2023-09-20 05:36:00	AAPL	Stock	179.25	179.25	179.25	179.25	134.0
2023-09-20 05:37:00	AAPL	Stock	179.27	179.27	179.27	179.27	100.0
2023-09-20 05:38:00	AAPL	Stock	179.29	179.3	179.29	179.3	450.0
2023-09-20 05:56:00	AAPL	Stock	179.35	179.37	179.34	179.37	628.0
2023-09-20 05:57:00	AAPL	Stock	179.38	179.38	179.37	179.38	2066.0
2023-09-20 05:58:00	AAPL	Stock	179.35	179.35	179.35	179.35	750.0
2023-09-20 06:00:00	AAPL	Stock	179.36	179.4	179.36	179.4	1220.0
2023-09-20 06:06:00	AAPL	Stock	179.25	179.25	179.25	179.25	374.0
2023-09-20 06:09:00	AAPL	Stock	179.24	179.24	179.24	179.24	698.0
2023-09-20 06:10:00	AAPL	Stock	179.23	179.23	179.23	179.23	100.0
2023-09-20 06:11:00	AAPL	Stock	179.29	179.29	179.29	179.29	147.0
2023-09-20 06:12:00	AAPL	Stock	179.3	179.3	179.3	179.3	333.0
2023-09-20 06:17:00	AAPL	Stock	179.24	179.24	179.24	179.24	100.0
2023-09-20 06:18:00	AAPL	Stock	179.23	179.23	179.23	179.23	100.0
2023-09-20 06:19:00	AAPL	Stock	179.2	179.23	179.2	179.23	279.0
2023-09-20 06:23:00	AAPL	Stock	179.33	179.33	179.33	179.33	168.0
2023-09-20 06:29:00	AAPL	Stock	179.25	179.25	179.25	179.25	200.0

> showing 50 of 1,159,898 rows — these rows as CSV

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