PREVIEW / stock_5min / 2023-07-31

all stock 5-min files

  file:    by_date/stock_5min/2023/2023-07-31.parquet
  size:    6.9 MB
  rows:    418,268
  symbols: 1,567

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.39	195.5	3777.0
2023-07-31 04:05:00	AAPL	Stock	195.59	195.69	195.59	195.69	677.0
2023-07-31 04:10:00	AAPL	Stock	195.59	195.74	195.59	195.74	666.0
2023-07-31 04:15:00	AAPL	Stock	195.61	195.61	195.61	195.61	246.0
2023-07-31 04:25:00	AAPL	Stock	195.69	195.69	195.69	195.69	379.0
2023-07-31 04:30:00	AAPL	Stock	195.74	195.74	195.71	195.71	470.0
2023-07-31 04:35: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.75	195.75	1083.0
2023-07-31 04:45:00	AAPL	Stock	195.75	195.75	195.62	195.66	1892.0
2023-07-31 04:50:00	AAPL	Stock	195.74	195.75	195.73	195.75	686.0
2023-07-31 04:55:00	AAPL	Stock	195.78	195.81	195.78	195.81	1340.0
2023-07-31 05:00:00	AAPL	Stock	195.78	195.8	195.75	195.78	1012.0
2023-07-31 05:05:00	AAPL	Stock	195.8	195.95	195.8	195.95	1787.0
2023-07-31 05:10:00	AAPL	Stock	195.91	195.91	195.91	195.91	360.0
2023-07-31 05:20:00	AAPL	Stock	195.86	195.86	195.8	195.8	402.0
2023-07-31 05:30:00	AAPL	Stock	195.75	195.75	195.57	195.57	962.0
2023-07-31 05:35:00	AAPL	Stock	195.66	195.66	195.66	195.66	301.0
2023-07-31 05:40:00	AAPL	Stock	195.7	195.7	195.7	195.7	227.0
2023-07-31 05:45:00	AAPL	Stock	195.7	195.7	195.7	195.7	305.0
2023-07-31 05:50: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.7	195.7	1790.0
2023-07-31 06:00:00	AAPL	Stock	195.7	195.7	195.7	195.7	156.0
2023-07-31 06:10:00	AAPL	Stock	195.83	195.83	195.83	195.83	132.0
2023-07-31 06:20:00	AAPL	Stock	195.85	195.85	195.85	195.85	137.0
2023-07-31 06:25: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	810.0
2023-07-31 06:35:00	AAPL	Stock	195.89	195.89	195.79	195.79	1135.0
2023-07-31 06:40:00	AAPL	Stock	195.76	195.78	195.76	195.78	352.0
2023-07-31 06:45:00	AAPL	Stock	195.76	195.76	195.75	195.75	874.0
2023-07-31 06:50:00	AAPL	Stock	195.74	195.78	195.74	195.78	232.0
2023-07-31 06:55:00	AAPL	Stock	195.78	195.8	195.78	195.8	1685.0
2023-07-31 07:00:00	AAPL	Stock	195.83	195.98	195.78	195.98	8695.0
2023-07-31 07:05:00	AAPL	Stock	195.98	196.22	195.98	196.21	10099.0
2023-07-31 07:10:00	AAPL	Stock	196.22	196.22	196.1	196.1	4006.0
2023-07-31 07:15:00	AAPL	Stock	196.14	196.14	196.09	196.1	3721.0
2023-07-31 07:20:00	AAPL	Stock	196.1	196.13	196.0	196.06	11381.0
2023-07-31 07:25:00	AAPL	Stock	196.1	196.15	196.1	196.15	2565.0
2023-07-31 07:30:00	AAPL	Stock	196.18	196.18	196.02	196.04	2636.0
2023-07-31 07:35:00	AAPL	Stock	196.03	196.13	196.02	196.11	7977.0
2023-07-31 07:40:00	AAPL	Stock	196.07	196.08	196.04	196.08	864.0
2023-07-31 07:45:00	AAPL	Stock	196.14	196.2	196.11	196.2	3368.0
2023-07-31 07:50:00	AAPL	Stock	196.2	196.2	196.13	196.2	2956.0
2023-07-31 07:55:00	AAPL	Stock	196.21	196.25	196.21	196.25	6943.0
2023-07-31 08:00:00	AAPL	Stock	196.0	196.54	195.51	196.3	57279.0
2023-07-31 08:05:00	AAPL	Stock	196.34	196.39	196.2606	196.34	11274.0
2023-07-31 08:10:00	AAPL	Stock	196.34	196.42	196.34	196.42	8293.0
2023-07-31 08:15:00	AAPL	Stock	196.4186	196.42	196.22	196.22	22063.0
2023-07-31 08:20:00	AAPL	Stock	196.22	196.29	196.21	196.27	10832.0
2023-07-31 08:25:00	AAPL	Stock	196.3	196.42	196.28	196.42	11408.0
2023-07-31 08:30:00	AAPL	Stock	196.44	196.4692	196.3	196.34	5247.0

> showing 50 of 418,268 rows — these rows as CSV

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