PREVIEW / stock_1min / 2023-10-19

all stock 1-min files

  file:    by_date/stock_1min/2023/2023-10-19.parquet
  size:    19.6 MB
  rows:    1,226,516
  symbols: 1,307

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-19 04:00:00	AAPL	Stock	175.24	175.24	175.2	175.2	425.0
2023-10-19 04:01:00	AAPL	Stock	175.32	175.39	175.32	175.39	4376.0
2023-10-19 04:02:00	AAPL	Stock	175.14	175.16	175.11	175.11	414.0
2023-10-19 04:03:00	AAPL	Stock	175.15	175.15	175.15	175.15	113.0
2023-10-19 04:05:00	AAPL	Stock	175.19	175.19	175.16	175.16	325.0
2023-10-19 04:07:00	AAPL	Stock	175.35	175.35	175.35	175.35	480.0
2023-10-19 04:13:00	AAPL	Stock	175.15	175.15	175.1	175.1	680.0
2023-10-19 04:14:00	AAPL	Stock	175.0	175.0	174.95	174.95	470.0
2023-10-19 04:15:00	AAPL	Stock	174.95	174.95	174.95	174.95	619.0
2023-10-19 04:16:00	AAPL	Stock	175.0	175.08	175.0	175.08	829.0
2023-10-19 04:18:00	AAPL	Stock	175.01	175.2	175.01	175.2	612.0
2023-10-19 04:19:00	AAPL	Stock	175.04	175.04	175.0	175.0	2563.0
2023-10-19 04:20:00	AAPL	Stock	175.0	175.0	174.95	174.95	2115.0
2023-10-19 04:22:00	AAPL	Stock	174.95	174.95	174.92	174.92	206.0
2023-10-19 04:23:00	AAPL	Stock	174.91	174.91	174.91	174.91	101.0
2023-10-19 04:24:00	AAPL	Stock	174.95	174.95	174.95	174.95	172.0
2023-10-19 04:26:00	AAPL	Stock	175.0	175.0	175.0	175.0	1131.0
2023-10-19 04:27:00	AAPL	Stock	175.0	175.0	175.0	175.0	522.0
2023-10-19 04:29:00	AAPL	Stock	175.01	175.01	175.0	175.0	1900.0
2023-10-19 04:30:00	AAPL	Stock	175.0	175.0	174.95	174.95	1134.0
2023-10-19 04:31:00	AAPL	Stock	175.0	175.0	175.0	175.0	490.0
2023-10-19 04:32:00	AAPL	Stock	175.0	175.14	175.0	175.14	734.0
2023-10-19 04:33:00	AAPL	Stock	175.11	175.11	175.1	175.1	1003.0
2023-10-19 04:35:00	AAPL	Stock	175.17	175.17	175.15	175.15	407.0
2023-10-19 04:38:00	AAPL	Stock	175.06	175.06	175.06	175.06	198.0
2023-10-19 04:39:00	AAPL	Stock	175.0	175.0	175.0	175.0	125.0
2023-10-19 04:49:00	AAPL	Stock	175.1	175.11	175.1	175.11	961.0
2023-10-19 04:59:00	AAPL	Stock	174.96	174.96	174.96	174.96	114.0
2023-10-19 05:01:00	AAPL	Stock	174.91	174.91	174.91	174.91	102.0
2023-10-19 05:03:00	AAPL	Stock	174.96	174.98	174.96	174.98	303.0
2023-10-19 05:07:00	AAPL	Stock	174.92	174.92	174.92	174.92	100.0
2023-10-19 05:09:00	AAPL	Stock	175.0	175.0	174.98	175.0	1100.0
2023-10-19 05:15:00	AAPL	Stock	175.05	175.05	175.05	175.05	500.0
2023-10-19 05:23:00	AAPL	Stock	175.03	175.03	175.02	175.02	615.0
2023-10-19 05:25:00	AAPL	Stock	175.05	175.06	175.05	175.06	207.0
2023-10-19 05:28:00	AAPL	Stock	175.06	175.12	175.06	175.12	1176.0
2023-10-19 05:30:00	AAPL	Stock	175.19	175.2	175.19	175.2	296.0
2023-10-19 05:31:00	AAPL	Stock	175.2	175.27	175.2	175.27	460.0
2023-10-19 05:32:00	AAPL	Stock	175.34	175.34	175.34	175.34	125.0
2023-10-19 05:33:00	AAPL	Stock	175.27	175.27	175.27	175.27	198.0
2023-10-19 05:37:00	AAPL	Stock	175.3	175.32	175.3	175.32	500.0
2023-10-19 05:40:00	AAPL	Stock	175.37	175.39	175.36	175.36	710.0
2023-10-19 05:41:00	AAPL	Stock	175.39	175.39	175.35	175.39	630.0
2023-10-19 05:42:00	AAPL	Stock	175.38	175.38	175.38	175.38	100.0
2023-10-19 05:43:00	AAPL	Stock	175.39	175.39	175.39	175.39	364.0
2023-10-19 05:45:00	AAPL	Stock	175.4	175.45	175.4	175.45	300.0
2023-10-19 05:46:00	AAPL	Stock	175.45	175.45	175.45	175.45	100.0
2023-10-19 05:50:00	AAPL	Stock	175.35	175.35	175.35	175.35	178.0
2023-10-19 05:52:00	AAPL	Stock	175.44	175.49	175.44	175.48	1380.0
2023-10-19 05:53:00	AAPL	Stock	175.48	175.48	175.48	175.48	100.0

> showing 50 of 1,226,516 rows — these rows as CSV

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