PREVIEW / stock_1min / 2023-07-31

all stock 1-min files

  file:    by_date/stock_1min/2023/2023-07-31.parquet
  size:    21.6 MB
  rows:    1,287,162
  symbols: 1,496

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-07-31 04:00:00	AAPL	Stock	195.89	195.9	195.53	195.53	2670.0
2023-07-31 04:01:00	AAPL	Stock	195.67	195.7	195.67	195.7	332.0
2023-07-31 04:02:00	AAPL	Stock	195.7	195.7	195.39	195.39	500.0
2023-07-31 04:03:00	AAPL	Stock	195.54	195.54	195.5	195.5	275.0
2023-07-31 04:05:00	AAPL	Stock	195.59	195.59	195.59	195.59	277.0
2023-07-31 04:07:00	AAPL	Stock	195.69	195.69	195.69	195.69	400.0
2023-07-31 04:12:00	AAPL	Stock	195.59	195.59	195.59	195.59	566.0
2023-07-31 04:14:00	AAPL	Stock	195.74	195.74	195.74	195.74	100.0
2023-07-31 04:16:00	AAPL	Stock	195.61	195.61	195.61	195.61	100.0
2023-07-31 04:17:00	AAPL	Stock	195.61	195.61	195.61	195.61	146.0
2023-07-31 04:25:00	AAPL	Stock	195.69	195.69	195.69	195.69	379.0
2023-07-31 04:32:00	AAPL	Stock	195.74	195.74	195.71	195.71	470.0
2023-07-31 04:37:00	AAPL	Stock	195.79	195.79	195.79	195.79	412.0
2023-07-31 04:40:00	AAPL	Stock	195.78	195.78	195.78	195.78	413.0
2023-07-31 04:43:00	AAPL	Stock	195.75	195.75	195.75	195.75	100.0
2023-07-31 04:44:00	AAPL	Stock	195.75	195.75	195.75	195.75	570.0
2023-07-31 04:45:00	AAPL	Stock	195.75	195.75	195.71	195.71	1046.0
2023-07-31 04:46:00	AAPL	Stock	195.64	195.64	195.64	195.64	146.0
2023-07-31 04:48:00	AAPL	Stock	195.63	195.63	195.62	195.62	400.0
2023-07-31 04:49:00	AAPL	Stock	195.64	195.66	195.64	195.66	300.0
2023-07-31 04:54:00	AAPL	Stock	195.74	195.75	195.73	195.75	686.0
2023-07-31 04:57:00	AAPL	Stock	195.78	195.78	195.78	195.78	100.0
2023-07-31 04:59:00	AAPL	Stock	195.8	195.81	195.8	195.81	1240.0
2023-07-31 05:00:00	AAPL	Stock	195.78	195.78	195.75	195.75	586.0
2023-07-31 05:01:00	AAPL	Stock	195.8	195.8	195.8	195.8	115.0
2023-07-31 05:02:00	AAPL	Stock	195.8	195.8	195.8	195.8	100.0
2023-07-31 05:03:00	AAPL	Stock	195.78	195.78	195.78	195.78	211.0
2023-07-31 05:06:00	AAPL	Stock	195.8	195.8	195.8	195.8	699.0
2023-07-31 05:07:00	AAPL	Stock	195.85	195.95	195.85	195.95	1088.0
2023-07-31 05:11:00	AAPL	Stock	195.91	195.91	195.91	195.91	260.0
2023-07-31 05:14:00	AAPL	Stock	195.91	195.91	195.91	195.91	100.0
2023-07-31 05:21:00	AAPL	Stock	195.86	195.86	195.81	195.81	299.0
2023-07-31 05:24:00	AAPL	Stock	195.8	195.8	195.8	195.8	103.0
2023-07-31 05:32:00	AAPL	Stock	195.75	195.75	195.75	195.75	134.0
2023-07-31 05:33:00	AAPL	Stock	195.75	195.75	195.62	195.62	421.0
2023-07-31 05:34:00	AAPL	Stock	195.64	195.64	195.57	195.57	407.0
2023-07-31 05:37:00	AAPL	Stock	195.66	195.66	195.66	195.66	301.0
2023-07-31 05:43:00	AAPL	Stock	195.7	195.7	195.7	195.7	107.0
2023-07-31 05:44:00	AAPL	Stock	195.7	195.7	195.7	195.7	120.0
2023-07-31 05:45:00	AAPL	Stock	195.7	195.7	195.7	195.7	305.0
2023-07-31 05:54:00	AAPL	Stock	195.83	195.84	195.83	195.84	526.0
2023-07-31 05:55:00	AAPL	Stock	195.83	195.84	195.82	195.82	1084.0
2023-07-31 05:56:00	AAPL	Stock	195.8	195.8	195.75	195.75	514.0
2023-07-31 05:58:00	AAPL	Stock	195.7	195.7	195.7	195.7	192.0
2023-07-31 06:00:00	AAPL	Stock	195.7	195.7	195.7	195.7	156.0
2023-07-31 06:13:00	AAPL	Stock	195.83	195.83	195.83	195.83	132.0
2023-07-31 06:22:00	AAPL	Stock	195.85	195.85	195.85	195.85	137.0
2023-07-31 06:26:00	AAPL	Stock	195.89	195.89	195.89	195.89	520.0
2023-07-31 06:30:00	AAPL	Stock	195.89	195.89	195.89	195.89	212.0
2023-07-31 06:31:00	AAPL	Stock	195.89	195.89	195.89	195.89	598.0

> showing 50 of 1,287,162 rows — these rows as CSV

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