PREVIEW / stock_1min / 2023-04-20

all stock 1-min files

  file:    by_date/stock_1min/2023/2023-04-20.parquet
  size:    19.9 MB
  rows:    1,218,425
  symbols: 1,583

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-04-20 04:00:00	AAPL	Stock	167.0	167.0	166.62	166.62	2039.0
2023-04-20 04:03:00	AAPL	Stock	166.62	166.65	166.3	166.36	1187.0
2023-04-20 04:04:00	AAPL	Stock	166.37	166.37	166.37	166.37	100.0
2023-04-20 04:05:00	AAPL	Stock	166.38	166.58	166.1	166.58	6094.0
2023-04-20 04:06:00	AAPL	Stock	166.46	166.46	166.46	166.46	100.0
2023-04-20 04:07:00	AAPL	Stock	166.46	166.46	166.46	166.46	200.0
2023-04-20 04:09:00	AAPL	Stock	166.2	166.2	166.13	166.13	1009.0
2023-04-20 04:13:00	AAPL	Stock	166.28	166.28	166.28	166.28	147.0
2023-04-20 04:14:00	AAPL	Stock	166.27	166.31	166.27	166.31	295.0
2023-04-20 04:15:00	AAPL	Stock	166.31	166.31	166.31	166.31	290.0
2023-04-20 04:16:00	AAPL	Stock	166.33	166.33	166.33	166.33	300.0
2023-04-20 04:17:00	AAPL	Stock	166.34	166.34	166.34	166.34	750.0
2023-04-20 04:21:00	AAPL	Stock	166.49	166.5	166.47	166.47	848.0
2023-04-20 04:22:00	AAPL	Stock	166.46	166.46	166.46	166.46	200.0
2023-04-20 04:25:00	AAPL	Stock	166.37	166.37	166.35	166.35	200.0
2023-04-20 04:26:00	AAPL	Stock	166.35	166.35	166.35	166.35	247.0
2023-04-20 04:27:00	AAPL	Stock	166.32	166.32	166.31	166.31	350.0
2023-04-20 04:28:00	AAPL	Stock	166.32	166.32	166.32	166.32	255.0
2023-04-20 04:30:00	AAPL	Stock	166.35	166.35	166.35	166.35	100.0
2023-04-20 04:31:00	AAPL	Stock	166.35	166.35	166.28	166.28	1118.0
2023-04-20 04:32:00	AAPL	Stock	166.3	166.34	166.3	166.34	315.0
2023-04-20 04:34:00	AAPL	Stock	166.33	166.33	166.33	166.33	100.0
2023-04-20 04:37:00	AAPL	Stock	166.31	166.31	166.28	166.28	1181.0
2023-04-20 04:38:00	AAPL	Stock	166.17	166.17	166.17	166.17	200.0
2023-04-20 04:40:00	AAPL	Stock	166.2	166.22	166.2	166.2	1413.0
2023-04-20 04:42:00	AAPL	Stock	166.16	166.16	166.16	166.16	683.0
2023-04-20 04:43:00	AAPL	Stock	166.16	166.16	166.11	166.11	1836.0
2023-04-20 04:44:00	AAPL	Stock	166.11	166.13	166.1	166.1	1935.0
2023-04-20 04:45:00	AAPL	Stock	166.02	166.09	165.93	165.93	4250.0
2023-04-20 04:46:00	AAPL	Stock	165.86	165.93	165.86	165.92	604.0
2023-04-20 04:48:00	AAPL	Stock	166.0	166.0	166.0	166.0	150.0
2023-04-20 04:49:00	AAPL	Stock	166.03	166.03	166.03	166.03	289.0
2023-04-20 04:51:00	AAPL	Stock	166.07	166.13	166.07	166.1	867.0
2023-04-20 04:52:00	AAPL	Stock	166.13	166.13	166.11	166.11	309.0
2023-04-20 04:54:00	AAPL	Stock	166.1	166.1	166.1	166.1	205.0
2023-04-20 04:55:00	AAPL	Stock	166.15	166.15	166.15	166.15	138.0
2023-04-20 04:57:00	AAPL	Stock	166.14	166.14	166.14	166.14	100.0
2023-04-20 04:58:00	AAPL	Stock	166.11	166.11	166.1	166.1	200.0
2023-04-20 04:59:00	AAPL	Stock	166.11	166.11	166.11	166.11	150.0
2023-04-20 05:00:00	AAPL	Stock	166.1	166.1	166.08	166.08	759.0
2023-04-20 05:03:00	AAPL	Stock	166.09	166.09	166.09	166.09	113.0
2023-04-20 05:04:00	AAPL	Stock	166.09	166.1	166.05	166.05	667.0
2023-04-20 05:06:00	AAPL	Stock	166.05	166.05	166.01	166.01	1311.0
2023-04-20 05:07:00	AAPL	Stock	166.02	166.02	166.01	166.01	378.0
2023-04-20 05:08:00	AAPL	Stock	166.01	166.01	166.01	166.01	500.0
2023-04-20 05:09:00	AAPL	Stock	166.03	166.03	166.03	166.03	115.0
2023-04-20 05:11:00	AAPL	Stock	166.04	166.04	166.04	166.04	150.0
2023-04-20 05:12:00	AAPL	Stock	166.1	166.1	166.1	166.1	283.0
2023-04-20 05:13:00	AAPL	Stock	166.1	166.1	166.1	166.1	128.0
2023-04-20 05:15:00	AAPL	Stock	166.05	166.05	166.05	166.05	461.0

> showing 50 of 1,218,425 rows — these rows as CSV

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