PREVIEW / stock_1min / 2021-07-20

all stock 1-min files

  file:    by_date/stock_1min/2021/2021-07-20.parquet
  size:    24.1 MB
  rows:    1,427,534
  symbols: 2,430

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
2021-07-20 04:00:00	AAPL	Stock	143.3	143.6	143.3	143.6	2917.0
2021-07-20 04:01:00	AAPL	Stock	143.57	143.57	143.0	143.38	8712.0
2021-07-20 04:03:00	AAPL	Stock	143.38	143.38	143.3	143.3	1246.0
2021-07-20 04:04:00	AAPL	Stock	143.2	143.2	143.2	143.2	220.0
2021-07-20 04:05:00	AAPL	Stock	143.29	143.3	143.29	143.3	1949.0
2021-07-20 04:07:00	AAPL	Stock	143.25	143.3	143.25	143.3	2445.0
2021-07-20 04:08:00	AAPL	Stock	143.26	143.3	143.25	143.25	659.0
2021-07-20 04:09:00	AAPL	Stock	143.19	143.22	143.19	143.22	720.0
2021-07-20 04:10:00	AAPL	Stock	143.19	143.19	143.18	143.18	200.0
2021-07-20 04:11:00	AAPL	Stock	143.18	143.18	143.18	143.18	100.0
2021-07-20 04:13:00	AAPL	Stock	143.3	143.3	143.16	143.16	2838.0
2021-07-20 04:15:00	AAPL	Stock	143.28	143.3	143.28	143.3	496.0
2021-07-20 04:22:00	AAPL	Stock	143.19	143.19	143.19	143.19	200.0
2021-07-20 04:25:00	AAPL	Stock	143.17	143.17	143.07	143.07	711.0
2021-07-20 04:26:00	AAPL	Stock	143.08	143.08	143.07	143.07	1843.0
2021-07-20 04:27:00	AAPL	Stock	143.09	143.09	142.99	143.02	16003.0
2021-07-20 04:28:00	AAPL	Stock	143.07	143.07	143.07	143.07	200.0
2021-07-20 04:29:00	AAPL	Stock	143.0	143.0	143.0	143.0	735.0
2021-07-20 04:30:00	AAPL	Stock	143.07	143.1	143.07	143.1	414.0
2021-07-20 04:33:00	AAPL	Stock	143.11	143.12	143.1	143.12	893.0
2021-07-20 04:39:00	AAPL	Stock	143.1	143.1	143.1	143.1	221.0
2021-07-20 04:41:00	AAPL	Stock	143.18	143.18	143.18	143.18	311.0
2021-07-20 04:43:00	AAPL	Stock	143.17	143.17	143.17	143.17	200.0
2021-07-20 04:49:00	AAPL	Stock	143.15	143.15	143.15	143.15	243.0
2021-07-20 04:52:00	AAPL	Stock	143.11	143.11	143.08	143.08	639.0
2021-07-20 04:55:00	AAPL	Stock	143.13	143.13	143.13	143.13	398.0
2021-07-20 04:57:00	AAPL	Stock	143.08	143.08	143.08	143.08	427.0
2021-07-20 05:01:00	AAPL	Stock	143.1	143.1	143.1	143.1	198.0
2021-07-20 05:04:00	AAPL	Stock	143.16	143.16	143.16	143.16	317.0
2021-07-20 05:05:00	AAPL	Stock	143.15	143.15	143.15	143.15	100.0
2021-07-20 05:08:00	AAPL	Stock	143.1	143.1	143.1	143.1	129.0
2021-07-20 05:10:00	AAPL	Stock	143.17	143.17	143.17	143.17	649.0
2021-07-20 05:12:00	AAPL	Stock	143.15	143.15	143.15	143.15	136.0
2021-07-20 05:14:00	AAPL	Stock	143.15	143.15	143.15	143.15	119.0
2021-07-20 05:22:00	AAPL	Stock	143.13	143.13	143.13	143.13	100.0
2021-07-20 05:23:00	AAPL	Stock	143.13	143.13	143.13	143.13	333.0
2021-07-20 05:26:00	AAPL	Stock	143.15	143.15	143.15	143.15	127.0
2021-07-20 05:30:00	AAPL	Stock	143.19	143.19	143.19	143.19	199.0
2021-07-20 05:32:00	AAPL	Stock	143.2	143.2	143.2	143.2	100.0
2021-07-20 05:34:00	AAPL	Stock	143.2	143.2	143.2	143.2	100.0
2021-07-20 05:35:00	AAPL	Stock	143.23	143.23	143.23	143.23	200.0
2021-07-20 05:36:00	AAPL	Stock	143.25	143.25	143.25	143.25	100.0
2021-07-20 05:38:00	AAPL	Stock	143.27	143.29	143.25	143.29	1005.0
2021-07-20 05:39:00	AAPL	Stock	143.22	143.22	143.22	143.22	100.0
2021-07-20 05:40:00	AAPL	Stock	143.2	143.2	143.2	143.2	100.0
2021-07-20 05:41:00	AAPL	Stock	143.16	143.16	143.15	143.15	262.0
2021-07-20 05:42:00	AAPL	Stock	143.14	143.14	143.12	143.12	838.0
2021-07-20 05:43:00	AAPL	Stock	143.12	143.12	143.12	143.12	100.0
2021-07-20 05:44:00	AAPL	Stock	143.11	143.11	143.1	143.1	529.0
2021-07-20 05:45:00	AAPL	Stock	143.09	143.09	143.09	143.09	648.0

> showing 50 of 1,427,534 rows — these rows as CSV

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