PREVIEW / stock_1min / 2023-08-04

all stock 1-min files

  file:    by_date/stock_1min/2023/2023-08-04.parquet
  size:    20.8 MB
  rows:    1,272,628
  symbols: 1,421

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-04 04:00:00	AAPL	Stock	187.31	188.02	187.04	187.84	6816.0
2023-08-04 04:01:00	AAPL	Stock	187.83	188.02	187.82	188.02	1692.0
2023-08-04 04:02:00	AAPL	Stock	188.36	188.92	188.36	188.5	12339.0
2023-08-04 04:03:00	AAPL	Stock	188.5	188.5	188.48	188.5	2045.0
2023-08-04 04:04:00	AAPL	Stock	188.53	188.55	188.4	188.55	2960.0
2023-08-04 04:05:00	AAPL	Stock	188.6	188.61	188.52	188.6	1913.0
2023-08-04 04:06:00	AAPL	Stock	188.6	188.7	188.6	188.7	1770.0
2023-08-04 04:07:00	AAPL	Stock	188.8	188.8	188.78	188.78	2293.0
2023-08-04 04:08:00	AAPL	Stock	188.78	188.8	188.34	188.34	2468.0
2023-08-04 04:09:00	AAPL	Stock	188.3	188.42	188.3	188.35	4158.0
2023-08-04 04:10:00	AAPL	Stock	188.45	188.45	188.3	188.3	604.0
2023-08-04 04:11:00	AAPL	Stock	188.21	188.21	188.0	188.0	1944.0
2023-08-04 04:12:00	AAPL	Stock	188.0	188.38	188.0	188.3	1488.0
2023-08-04 04:13:00	AAPL	Stock	188.39	188.5	188.39	188.5	1167.0
2023-08-04 04:14:00	AAPL	Stock	188.46	188.46	188.44	188.44	344.0
2023-08-04 04:17:00	AAPL	Stock	188.4	188.41	188.3	188.33	1185.0
2023-08-04 04:18:00	AAPL	Stock	188.33	188.4	188.32	188.4	989.0
2023-08-04 04:19:00	AAPL	Stock	188.4	188.4	188.4	188.4	500.0
2023-08-04 04:20:00	AAPL	Stock	188.4	188.4	188.33	188.33	687.0
2023-08-04 04:21:00	AAPL	Stock	188.3	188.3	188.0	188.0	1708.0
2023-08-04 04:22:00	AAPL	Stock	187.9	187.9	187.7	187.8	2829.0
2023-08-04 04:23:00	AAPL	Stock	187.75	187.75	187.6	187.6	2121.0
2023-08-04 04:24:00	AAPL	Stock	187.61	187.84	187.6	187.84	3806.0
2023-08-04 04:25:00	AAPL	Stock	187.99	188.15	187.99	188.15	1144.0
2023-08-04 04:26:00	AAPL	Stock	188.0	188.0	187.88	187.88	712.0
2023-08-04 04:27:00	AAPL	Stock	187.88	187.88	187.88	187.88	300.0
2023-08-04 04:28:00	AAPL	Stock	187.9	187.9	187.88	187.88	527.0
2023-08-04 04:29:00	AAPL	Stock	187.86	187.86	187.84	187.84	300.0
2023-08-04 04:30:00	AAPL	Stock	187.8	187.85	187.55	187.64	657.0
2023-08-04 04:31:00	AAPL	Stock	187.56	187.56	187.55	187.55	710.0
2023-08-04 04:33:00	AAPL	Stock	187.67	187.67	187.67	187.67	100.0
2023-08-04 04:34:00	AAPL	Stock	187.71	187.71	187.71	187.71	308.0
2023-08-04 04:35:00	AAPL	Stock	187.8	187.84	187.8	187.84	669.0
2023-08-04 04:36:00	AAPL	Stock	187.81	187.86	187.75	187.86	1236.0
2023-08-04 04:37:00	AAPL	Stock	187.9	187.9	187.9	187.9	441.0
2023-08-04 04:39:00	AAPL	Stock	187.9	187.9	187.83	187.83	1219.0
2023-08-04 04:40:00	AAPL	Stock	187.95	188.25	187.92	188.25	4333.0
2023-08-04 04:41:00	AAPL	Stock	188.22	188.22	188.22	188.22	100.0
2023-08-04 04:42:00	AAPL	Stock	188.22	188.22	188.22	188.22	100.0
2023-08-04 04:44:00	AAPL	Stock	188.12	188.12	188.12	188.12	200.0
2023-08-04 04:45:00	AAPL	Stock	188.19	188.19	188.19	188.19	100.0
2023-08-04 04:46:00	AAPL	Stock	188.17	188.19	188.11	188.19	892.0
2023-08-04 04:48:00	AAPL	Stock	188.18	188.18	188.15	188.15	1150.0
2023-08-04 04:49:00	AAPL	Stock	188.04	188.04	188.04	188.04	188.0
2023-08-04 04:52:00	AAPL	Stock	188.1	188.1	188.1	188.1	100.0
2023-08-04 04:53:00	AAPL	Stock	188.1	188.1	188.1	188.1	600.0
2023-08-04 04:54:00	AAPL	Stock	188.13	188.13	188.13	188.13	339.0
2023-08-04 04:57:00	AAPL	Stock	188.07	188.07	188.07	188.07	100.0
2023-08-04 04:58:00	AAPL	Stock	187.93	187.93	187.81	187.81	1191.0
2023-08-04 05:00:00	AAPL	Stock	187.83	187.83	187.83	187.83	100.0

> showing 50 of 1,272,628 rows — these rows as CSV

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