PREVIEW / stock_1min / 2023-06-28

all stock 1-min files

  file:    by_date/stock_1min/2023/2023-06-28.parquet
  size:    20.5 MB
  rows:    1,278,792
  symbols: 1,479

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-28 04:00:00	AAPL	Stock	187.98	187.98	187.98	187.98	240.0
2023-06-28 04:03:00	AAPL	Stock	188.06	188.06	188.06	188.06	100.0
2023-06-28 04:04:00	AAPL	Stock	187.98	187.98	187.86	187.91	675.0
2023-06-28 04:05:00	AAPL	Stock	188.02	188.02	188.02	188.02	209.0
2023-06-28 04:06:00	AAPL	Stock	187.94	187.97	187.94	187.97	208.0
2023-06-28 04:07:00	AAPL	Stock	187.88	187.99	187.88	187.99	2090.0
2023-06-28 04:08:00	AAPL	Stock	188.01	188.3	188.01	188.03	1073.0
2023-06-28 04:15:00	AAPL	Stock	188.03	188.03	188.03	188.03	198.0
2023-06-28 04:16:00	AAPL	Stock	188.03	188.03	188.02	188.02	575.0
2023-06-28 04:17:00	AAPL	Stock	188.03	188.03	188.03	188.03	1159.0
2023-06-28 04:20:00	AAPL	Stock	187.93	188.0	187.93	188.0	309.0
2023-06-28 04:21:00	AAPL	Stock	188.0	188.09	188.0	188.09	461.0
2023-06-28 04:22:00	AAPL	Stock	188.09	188.09	188.09	188.09	542.0
2023-06-28 04:25:00	AAPL	Stock	188.2	188.2	188.2	188.2	697.0
2023-06-28 04:27:00	AAPL	Stock	188.13	188.13	188.13	188.13	500.0
2023-06-28 04:31:00	AAPL	Stock	188.14	188.14	188.14	188.14	100.0
2023-06-28 04:33:00	AAPL	Stock	188.06	188.06	188.04	188.04	200.0
2023-06-28 04:34:00	AAPL	Stock	188.02	188.03	188.02	188.03	200.0
2023-06-28 04:38:00	AAPL	Stock	187.89	188.06	187.88	188.03	1554.0
2023-06-28 04:39:00	AAPL	Stock	187.93	187.93	187.93	187.93	500.0
2023-06-28 04:56:00	AAPL	Stock	187.89	187.89	187.89	187.89	162.0
2023-06-28 04:57:00	AAPL	Stock	187.95	187.95	187.95	187.95	400.0
2023-06-28 04:58:00	AAPL	Stock	187.93	187.93	187.93	187.93	209.0
2023-06-28 04:59:00	AAPL	Stock	187.91	187.91	187.91	187.91	219.0
2023-06-28 05:08:00	AAPL	Stock	187.9	187.9	187.9	187.9	199.0
2023-06-28 05:10:00	AAPL	Stock	187.95	187.95	187.95	187.95	200.0
2023-06-28 05:14:00	AAPL	Stock	187.94	187.94	187.94	187.94	100.0
2023-06-28 05:15:00	AAPL	Stock	187.94	187.94	187.92	187.92	250.0
2023-06-28 05:24:00	AAPL	Stock	187.88	187.88	187.88	187.88	320.0
2023-06-28 05:25:00	AAPL	Stock	187.86	187.86	187.86	187.86	100.0
2023-06-28 05:26:00	AAPL	Stock	187.86	187.87	187.86	187.87	2056.0
2023-06-28 05:27:00	AAPL	Stock	187.85	187.88	187.8	187.8	800.0
2023-06-28 05:29:00	AAPL	Stock	187.84	187.84	187.84	187.84	499.0
2023-06-28 05:30:00	AAPL	Stock	187.82	187.82	187.8	187.8	1484.0
2023-06-28 05:31:00	AAPL	Stock	187.8	187.8	187.8	187.8	100.0
2023-06-28 05:33:00	AAPL	Stock	187.72	187.72	187.72	187.72	100.0
2023-06-28 05:34:00	AAPL	Stock	187.73	187.73	187.73	187.73	100.0
2023-06-28 05:35:00	AAPL	Stock	187.75	187.83	187.75	187.83	300.0
2023-06-28 05:38:00	AAPL	Stock	187.83	187.83	187.79	187.8	6420.0
2023-06-28 05:48:00	AAPL	Stock	187.8	187.8	187.8	187.8	464.0
2023-06-28 05:59:00	AAPL	Stock	187.8	187.8	187.8	187.8	881.0
2023-06-28 06:00:00	AAPL	Stock	187.8	187.8	187.8	187.8	1350.0
2023-06-28 06:06:00	AAPL	Stock	187.8	187.8	187.8	187.8	799.0
2023-06-28 06:11:00	AAPL	Stock	187.75	187.75	187.75	187.75	100.0
2023-06-28 06:14:00	AAPL	Stock	187.8	187.8	187.8	187.8	3196.0
2023-06-28 06:15:00	AAPL	Stock	187.8	187.8	187.8	187.8	1900.0
2023-06-28 06:16:00	AAPL	Stock	187.79	187.79	187.78	187.78	400.0
2023-06-28 06:18:00	AAPL	Stock	187.78	187.78	187.78	187.78	100.0
2023-06-28 06:29:00	AAPL	Stock	187.8	187.8	187.8	187.8	2044.0
2023-06-28 06:31:00	AAPL	Stock	187.79	187.79	187.79	187.79	1100.0

> showing 50 of 1,278,792 rows — these rows as CSV

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