PREVIEW / stock_1min / 2024-06-18

all stock 1-min files

  file:    by_date/stock_1min/2024/2024-06-18.parquet
  size:    20.5 MB
  rows:    1,224,045
  symbols: 939

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
2024-06-18 04:00:00	AAPL	Stock	216.81	217.5	215.0	217.12	5928.0
2024-06-18 04:01:00	AAPL	Stock	217.13	217.13	217.13	217.13	100.0
2024-06-18 04:02:00	AAPL	Stock	217.29	217.29	217.14	217.14	3077.0
2024-06-18 04:03:00	AAPL	Stock	217.2	217.2	217.19	217.2	1655.0
2024-06-18 04:04:00	AAPL	Stock	217.15	217.25	217.15	217.15	855.0
2024-06-18 04:05:00	AAPL	Stock	217.22	217.22	217.2	217.2	380.0
2024-06-18 04:06:00	AAPL	Stock	217.2	217.2	217.2	217.2	128.0
2024-06-18 04:09:00	AAPL	Stock	217.2	217.2	217.2	217.2	575.0
2024-06-18 04:11:00	AAPL	Stock	217.23	217.23	217.16	217.16	2341.0
2024-06-18 04:12:00	AAPL	Stock	217.15	217.2	217.0	217.0	2752.0
2024-06-18 04:15:00	AAPL	Stock	217.03	217.03	217.03	217.03	483.0
2024-06-18 04:16:00	AAPL	Stock	217.09	217.09	217.0	217.0	4103.0
2024-06-18 04:17:00	AAPL	Stock	217.0	217.0	217.0	217.0	1261.0
2024-06-18 04:18:00	AAPL	Stock	217.08	217.08	217.07	217.07	200.0
2024-06-18 04:20:00	AAPL	Stock	217.09	217.09	217.04	217.04	299.0
2024-06-18 04:22:00	AAPL	Stock	217.0	217.0	216.98	216.98	860.0
2024-06-18 04:23:00	AAPL	Stock	216.86	216.86	216.86	216.86	321.0
2024-06-18 04:25:00	AAPL	Stock	216.91	216.91	216.91	216.91	200.0
2024-06-18 04:28:00	AAPL	Stock	217.0	217.0	217.0	217.0	574.0
2024-06-18 04:36:00	AAPL	Stock	216.92	217.0	216.91	217.0	2760.0
2024-06-18 04:37:00	AAPL	Stock	217.0	217.0	216.9	216.9	778.0
2024-06-18 04:40:00	AAPL	Stock	216.9	216.9	216.9	216.9	144.0
2024-06-18 04:41:00	AAPL	Stock	216.85	216.85	216.83	216.83	619.0
2024-06-18 04:46:00	AAPL	Stock	217.0	217.0	217.0	217.0	513.0
2024-06-18 04:47:00	AAPL	Stock	217.0	217.0	217.0	217.0	196.0
2024-06-18 04:51:00	AAPL	Stock	217.01	217.03	217.01	217.03	300.0
2024-06-18 04:53:00	AAPL	Stock	217.01	217.01	217.01	217.01	100.0
2024-06-18 04:57:00	AAPL	Stock	216.98	216.98	216.96	216.96	359.0
2024-06-18 04:58:00	AAPL	Stock	216.91	216.91	216.91	216.91	145.0
2024-06-18 04:59:00	AAPL	Stock	216.9	216.9	216.9	216.9	100.0
2024-06-18 05:03:00	AAPL	Stock	216.96	217.08	216.96	217.07	6198.0
2024-06-18 05:04:00	AAPL	Stock	217.08	217.15	216.93	217.15	13979.0
2024-06-18 05:05:00	AAPL	Stock	217.19	217.45	217.19	217.45	6696.0
2024-06-18 05:06:00	AAPL	Stock	217.53	217.67	217.5	217.67	2381.0
2024-06-18 05:07:00	AAPL	Stock	217.67	217.7	217.62	217.62	5443.0
2024-06-18 05:08:00	AAPL	Stock	217.63	217.68	217.63	217.68	600.0
2024-06-18 05:09:00	AAPL	Stock	217.74	217.77	217.7	217.7	2576.0
2024-06-18 05:11:00	AAPL	Stock	217.75	218.05	217.75	218.01	7397.0
2024-06-18 05:13:00	AAPL	Stock	218.12	218.25	218.1	218.25	4096.0
2024-06-18 05:14:00	AAPL	Stock	218.25	218.36	218.18	218.33	3395.0
2024-06-18 05:15:00	AAPL	Stock	218.34	218.34	218.23	218.23	658.0
2024-06-18 05:16:00	AAPL	Stock	218.23	218.23	218.1	218.1	900.0
2024-06-18 05:17:00	AAPL	Stock	218.2	218.22	218.12	218.16	2472.0
2024-06-18 05:18:00	AAPL	Stock	218.26	218.29	218.11	218.11	2243.0
2024-06-18 05:19:00	AAPL	Stock	218.1	218.21	218.0	218.21	2927.0
2024-06-18 05:20:00	AAPL	Stock	218.33	218.36	218.25	218.25	1700.0
2024-06-18 05:21:00	AAPL	Stock	218.3	218.33	218.3	218.33	200.0
2024-06-18 05:23:00	AAPL	Stock	218.21	218.21	218.21	218.21	100.0
2024-06-18 05:24:00	AAPL	Stock	218.26	218.26	218.26	218.26	186.0
2024-06-18 05:25:00	AAPL	Stock	218.22	218.27	218.16	218.16	1350.0

> showing 50 of 1,224,045 rows — these rows as CSV

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