PREVIEW / stock_1min / 2023-06-20

all stock 1-min files

  file:    by_date/stock_1min/2023/2023-06-20.parquet
  size:    21.7 MB
  rows:    1,345,847
  symbols: 1,525

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-06-20 04:00:00	AAPL	Stock	184.77	184.77	184.5	184.5	500.0
2023-06-20 04:01:00	AAPL	Stock	184.5	184.63	184.5	184.63	396.0
2023-06-20 04:02:00	AAPL	Stock	184.63	184.64	184.51	184.51	600.0
2023-06-20 04:03:00	AAPL	Stock	184.54	184.54	184.5	184.5	915.0
2023-06-20 04:04:00	AAPL	Stock	184.5	184.5	184.34	184.34	915.0
2023-06-20 04:09:00	AAPL	Stock	184.28	184.28	184.28	184.28	169.0
2023-06-20 04:10:00	AAPL	Stock	184.39	184.4	184.39	184.4	1468.0
2023-06-20 04:12:00	AAPL	Stock	184.28	184.28	184.2	184.2	2255.0
2023-06-20 04:14:00	AAPL	Stock	184.15	184.15	184.15	184.15	250.0
2023-06-20 04:16:00	AAPL	Stock	184.16	184.16	184.11	184.11	394.0
2023-06-20 04:17:00	AAPL	Stock	184.2	184.2	184.2	184.2	217.0
2023-06-20 04:21:00	AAPL	Stock	184.18	184.18	184.18	184.18	100.0
2023-06-20 04:22:00	AAPL	Stock	184.19	184.19	184.15	184.15	400.0
2023-06-20 04:23:00	AAPL	Stock	184.11	184.11	184.11	184.11	305.0
2023-06-20 04:24:00	AAPL	Stock	184.15	184.19	184.15	184.19	928.0
2023-06-20 04:26:00	AAPL	Stock	184.14	184.14	184.14	184.14	100.0
2023-06-20 04:27:00	AAPL	Stock	184.19	184.19	184.19	184.19	100.0
2023-06-20 04:29:00	AAPL	Stock	184.13	184.13	184.13	184.13	150.0
2023-06-20 04:32:00	AAPL	Stock	184.14	184.15	184.1	184.11	935.0
2023-06-20 04:33:00	AAPL	Stock	184.03	184.03	184.02	184.02	858.0
2023-06-20 04:34:00	AAPL	Stock	184.0	184.02	184.0	184.02	371.0
2023-06-20 04:35:00	AAPL	Stock	184.05	184.05	184.05	184.05	100.0
2023-06-20 04:36:00	AAPL	Stock	184.0	184.0	184.0	184.0	1505.0
2023-06-20 04:37:00	AAPL	Stock	184.0	184.0	184.0	184.0	8803.0
2023-06-20 04:39:00	AAPL	Stock	183.9	183.97	183.9	183.97	1000.0
2023-06-20 04:40:00	AAPL	Stock	184.08	184.08	184.08	184.08	108.0
2023-06-20 04:41:00	AAPL	Stock	184.09	184.1	184.08	184.1	1274.0
2023-06-20 04:42:00	AAPL	Stock	184.1	184.1	184.06	184.07	870.0
2023-06-20 04:43:00	AAPL	Stock	184.08	184.12	184.06	184.12	904.0
2023-06-20 04:44:00	AAPL	Stock	184.19	184.2	184.19	184.2	700.0
2023-06-20 04:48:00	AAPL	Stock	184.16	184.16	184.15	184.16	581.0
2023-06-20 04:51:00	AAPL	Stock	184.01	184.01	184.0	184.0	400.0
2023-06-20 04:54:00	AAPL	Stock	183.91	183.91	183.91	183.91	266.0
2023-06-20 04:55:00	AAPL	Stock	183.99	184.0	183.99	184.0	618.0
2023-06-20 04:56:00	AAPL	Stock	183.99	184.05	183.99	184.05	200.0
2023-06-20 04:57:00	AAPL	Stock	184.1	184.1	184.1	184.1	100.0
2023-06-20 04:58:00	AAPL	Stock	184.09	184.09	184.09	184.09	119.0
2023-06-20 04:59:00	AAPL	Stock	184.1	184.1	184.08	184.08	500.0
2023-06-20 05:01:00	AAPL	Stock	184.15	184.15	184.15	184.15	380.0
2023-06-20 05:11:00	AAPL	Stock	184.07	184.07	184.07	184.07	393.0
2023-06-20 05:16:00	AAPL	Stock	184.17	184.17	184.17	184.17	200.0
2023-06-20 05:20:00	AAPL	Stock	184.14	184.14	184.14	184.14	149.0
2023-06-20 05:21:00	AAPL	Stock	184.13	184.13	184.13	184.13	300.0
2023-06-20 05:22:00	AAPL	Stock	184.16	184.23	184.16	184.23	336.0
2023-06-20 05:27:00	AAPL	Stock	184.23	184.25	184.23	184.25	549.0
2023-06-20 05:28:00	AAPL	Stock	184.2	184.2	184.13	184.13	2189.0
2023-06-20 05:29:00	AAPL	Stock	184.13	184.13	184.13	184.13	500.0
2023-06-20 05:35:00	AAPL	Stock	184.18	184.18	184.18	184.18	354.0
2023-06-20 05:37:00	AAPL	Stock	184.21	184.21	184.21	184.21	100.0
2023-06-20 05:38:00	AAPL	Stock	184.18	184.18	184.18	184.18	200.0

> showing 50 of 1,345,847 rows — these rows as CSV

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