PREVIEW / stock_1min / 2023-09-18

all stock 1-min files

  file:    by_date/stock_1min/2023/2023-09-18.parquet
  size:    19.5 MB
  rows:    1,195,425
  symbols: 1,389

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-09-18 04:00:00	AAPL	Stock	175.9	175.9	175.7	175.71	3591.0
2023-09-18 04:01:00	AAPL	Stock	175.8	175.8	175.69	175.69	1712.0
2023-09-18 04:02:00	AAPL	Stock	175.67	175.67	175.66	175.66	500.0
2023-09-18 04:03:00	AAPL	Stock	175.69	175.69	175.64	175.68	2768.0
2023-09-18 04:04:00	AAPL	Stock	175.67	175.67	175.67	175.67	1550.0
2023-09-18 04:05:00	AAPL	Stock	175.66	175.66	175.57	175.6	2078.0
2023-09-18 04:06:00	AAPL	Stock	175.6	175.6	175.55	175.59	447.0
2023-09-18 04:07:00	AAPL	Stock	175.61	175.61	175.61	175.61	100.0
2023-09-18 04:08:00	AAPL	Stock	175.63	175.64	175.61	175.61	400.0
2023-09-18 04:09:00	AAPL	Stock	175.65	175.65	175.64	175.64	6585.0
2023-09-18 04:10:00	AAPL	Stock	175.65	175.69	175.65	175.69	3255.0
2023-09-18 04:11:00	AAPL	Stock	175.64	175.73	175.64	175.73	1070.0
2023-09-18 04:12:00	AAPL	Stock	175.7	175.72	175.69	175.72	477.0
2023-09-18 04:13:00	AAPL	Stock	175.69	175.72	175.68	175.72	2383.0
2023-09-18 04:14:00	AAPL	Stock	175.7	175.7	175.7	175.7	939.0
2023-09-18 04:15:00	AAPL	Stock	175.7	175.76	175.7	175.76	3473.0
2023-09-18 04:16:00	AAPL	Stock	175.76	175.76	175.73	175.74	1201.0
2023-09-18 04:17:00	AAPL	Stock	175.73	175.73	175.73	175.73	300.0
2023-09-18 04:18:00	AAPL	Stock	175.67	175.67	175.67	175.67	100.0
2023-09-18 04:19:00	AAPL	Stock	175.69	175.69	175.65	175.65	400.0
2023-09-18 04:20:00	AAPL	Stock	175.66	175.66	175.65	175.66	467.0
2023-09-18 04:22:00	AAPL	Stock	175.69	175.69	175.69	175.69	181.0
2023-09-18 04:27:00	AAPL	Stock	175.69	175.69	175.69	175.69	400.0
2023-09-18 04:28:00	AAPL	Stock	175.69	175.69	175.69	175.69	200.0
2023-09-18 04:29:00	AAPL	Stock	175.69	175.69	175.69	175.69	100.0
2023-09-18 04:30:00	AAPL	Stock	175.69	175.69	175.69	175.69	451.0
2023-09-18 04:31:00	AAPL	Stock	175.7	175.7	175.69	175.69	400.0
2023-09-18 04:33:00	AAPL	Stock	175.7	175.7	175.69	175.69	620.0
2023-09-18 04:39:00	AAPL	Stock	175.65	175.65	175.65	175.65	128.0
2023-09-18 04:40:00	AAPL	Stock	175.69	175.8	175.69	175.8	4854.0
2023-09-18 04:41:00	AAPL	Stock	175.8	175.8	175.8	175.8	3978.0
2023-09-18 04:42:00	AAPL	Stock	175.83	175.83	175.83	175.83	100.0
2023-09-18 04:43:00	AAPL	Stock	175.83	175.83	175.8	175.8	1234.0
2023-09-18 04:45:00	AAPL	Stock	175.83	175.83	175.83	175.83	100.0
2023-09-18 04:46:00	AAPL	Stock	175.82	175.82	175.82	175.82	100.0
2023-09-18 04:51:00	AAPL	Stock	175.84	175.85	175.84	175.85	499.0
2023-09-18 04:52:00	AAPL	Stock	175.84	175.85	175.84	175.85	351.0
2023-09-18 04:53:00	AAPL	Stock	175.81	175.81	175.8	175.81	1794.0
2023-09-18 04:54:00	AAPL	Stock	175.78	175.78	175.78	175.78	285.0
2023-09-18 04:55:00	AAPL	Stock	175.79	175.79	175.79	175.79	100.0
2023-09-18 04:56:00	AAPL	Stock	175.81	175.81	175.81	175.81	800.0
2023-09-18 04:57:00	AAPL	Stock	175.77	175.77	175.77	175.77	600.0
2023-09-18 04:59:00	AAPL	Stock	175.77	175.77	175.74	175.75	5833.0
2023-09-18 05:01:00	AAPL	Stock	175.73	175.75	175.67	175.67	1649.0
2023-09-18 05:03:00	AAPL	Stock	175.75	175.75	175.75	175.75	5945.0
2023-09-18 05:06:00	AAPL	Stock	175.78	175.78	175.78	175.78	114.0
2023-09-18 05:07:00	AAPL	Stock	175.8	175.8	175.8	175.8	113.0
2023-09-18 05:08:00	AAPL	Stock	175.81	175.81	175.79	175.79	1876.0
2023-09-18 05:10:00	AAPL	Stock	175.78	175.78	175.78	175.78	250.0
2023-09-18 05:11:00	AAPL	Stock	175.78	175.78	175.78	175.78	126.0

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

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