PREVIEW / stock_1min / 2023-09-19

all stock 1-min files

  file:    by_date/stock_1min/2023/2023-09-19.parquet
  size:    19.1 MB
  rows:    1,165,380
  symbols: 1,374

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-19 04:00:00	AAPL	Stock	178.57	178.59	178.57	178.59	259.0
2023-09-19 04:01:00	AAPL	Stock	178.54	178.54	178.48	178.5	1777.0
2023-09-19 04:02:00	AAPL	Stock	178.44	178.46	178.44	178.46	244.0
2023-09-19 04:03:00	AAPL	Stock	178.46	178.46	178.46	178.46	114.0
2023-09-19 04:05:00	AAPL	Stock	178.49	178.49	178.49	178.49	100.0
2023-09-19 04:11:00	AAPL	Stock	178.47	178.47	178.47	178.47	224.0
2023-09-19 04:12:00	AAPL	Stock	178.48	178.5	178.48	178.5	1230.0
2023-09-19 04:17:00	AAPL	Stock	178.61	178.61	178.61	178.61	100.0
2023-09-19 04:19:00	AAPL	Stock	178.56	178.56	178.52	178.52	689.0
2023-09-19 04:20:00	AAPL	Stock	178.5	178.5	178.5	178.5	100.0
2023-09-19 04:24:00	AAPL	Stock	178.55	178.55	178.55	178.55	797.0
2023-09-19 04:30:00	AAPL	Stock	178.55	178.55	178.55	178.55	100.0
2023-09-19 04:32:00	AAPL	Stock	178.59	178.6	178.59	178.6	360.0
2023-09-19 04:33:00	AAPL	Stock	178.57	178.57	178.57	178.57	168.0
2023-09-19 04:35:00	AAPL	Stock	178.59	178.59	178.59	178.59	100.0
2023-09-19 04:43:00	AAPL	Stock	178.56	178.56	178.55	178.55	500.0
2023-09-19 04:45:00	AAPL	Stock	178.55	178.55	178.5	178.5	204.0
2023-09-19 04:51:00	AAPL	Stock	178.55	178.55	178.55	178.55	156.0
2023-09-19 04:52:00	AAPL	Stock	178.55	178.55	178.55	178.55	100.0
2023-09-19 04:58:00	AAPL	Stock	178.58	178.58	178.58	178.58	100.0
2023-09-19 05:00:00	AAPL	Stock	178.55	178.55	178.55	178.55	106.0
2023-09-19 05:06:00	AAPL	Stock	178.5	178.5	178.46	178.46	411.0
2023-09-19 05:21:00	AAPL	Stock	178.52	178.53	178.52	178.53	200.0
2023-09-19 05:25:00	AAPL	Stock	178.5	178.5	178.5	178.5	100.0
2023-09-19 05:26:00	AAPL	Stock	178.55	178.55	178.55	178.55	200.0
2023-09-19 05:28:00	AAPL	Stock	178.59	178.6	178.59	178.6	421.0
2023-09-19 05:29:00	AAPL	Stock	178.65	178.75	178.65	178.75	1296.0
2023-09-19 05:30:00	AAPL	Stock	178.77	178.77	178.75	178.75	4130.0
2023-09-19 05:37:00	AAPL	Stock	178.73	178.73	178.7	178.7	1125.0
2023-09-19 05:39:00	AAPL	Stock	178.7	178.7	178.7	178.7	327.0
2023-09-19 05:42:00	AAPL	Stock	178.72	178.75	178.72	178.75	289.0
2023-09-19 05:49:00	AAPL	Stock	178.82	178.82	178.78	178.78	400.0
2023-09-19 05:57:00	AAPL	Stock	178.71	178.73	178.71	178.73	255.0
2023-09-19 05:58:00	AAPL	Stock	178.73	178.73	178.73	178.73	100.0
2023-09-19 06:00:00	AAPL	Stock	178.7	178.7	178.7	178.7	100.0
2023-09-19 06:18:00	AAPL	Stock	178.75	178.75	178.75	178.75	122.0
2023-09-19 06:19:00	AAPL	Stock	178.7	178.7	178.7	178.7	100.0
2023-09-19 06:25:00	AAPL	Stock	178.61	178.61	178.58	178.58	1025.0
2023-09-19 06:26:00	AAPL	Stock	178.55	178.55	178.55	178.55	400.0
2023-09-19 06:28:00	AAPL	Stock	178.52	178.52	178.46	178.46	1105.0
2023-09-19 06:29:00	AAPL	Stock	178.49	178.49	178.49	178.49	128.0
2023-09-19 06:30:00	AAPL	Stock	178.5	178.5	178.48	178.48	700.0
2023-09-19 06:31:00	AAPL	Stock	178.48	178.5	178.48	178.5	393.0
2023-09-19 06:34:00	AAPL	Stock	178.53	178.53	178.53	178.53	198.0
2023-09-19 06:38:00	AAPL	Stock	178.66	178.66	178.62	178.62	1088.0
2023-09-19 06:39:00	AAPL	Stock	178.54	178.54	178.5	178.52	1919.0
2023-09-19 06:51:00	AAPL	Stock	178.59	178.59	178.59	178.59	321.0
2023-09-19 06:54:00	AAPL	Stock	178.49	178.49	178.47	178.47	289.0
2023-09-19 06:58:00	AAPL	Stock	178.53	178.53	178.51	178.51	1336.0
2023-09-19 07:00:00	AAPL	Stock	178.5	178.53	178.5	178.5	2734.0

> showing 50 of 1,165,380 rows — these rows as CSV

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