PREVIEW / stock_5min / 2023-07-27

all stock 5-min files

  file:    by_date/stock_5min/2023/2023-07-27.parquet
  size:    6.8 MB
  rows:    415,963
  symbols: 1,537

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-27 04:00:00	AAPL	Stock	195.42	196.34	195.42	196.22	7751.0
2023-07-27 04:05:00	AAPL	Stock	196.19	196.2	196.05	196.1	2427.0
2023-07-27 04:10:00	AAPL	Stock	196.1	196.2	196.06	196.2	1283.0
2023-07-27 04:15:00	AAPL	Stock	196.19	196.2	196.19	196.2	1863.0
2023-07-27 04:20:00	AAPL	Stock	196.2	196.26	196.14	196.15	3307.0
2023-07-27 04:25:00	AAPL	Stock	196.15	196.23	196.15	196.23	1540.0
2023-07-27 04:30:00	AAPL	Stock	196.25	196.25	196.2	196.21	778.0
2023-07-27 04:35:00	AAPL	Stock	196.16	196.16	196.04	196.04	2477.0
2023-07-27 04:40:00	AAPL	Stock	196.04	196.1	196.04	196.04	2113.0
2023-07-27 04:45:00	AAPL	Stock	196.04	196.09	196.04	196.09	363.0
2023-07-27 04:50:00	AAPL	Stock	196.05	196.05	195.98	196.03	5492.0
2023-07-27 04:55:00	AAPL	Stock	196.03	196.2	196.03	196.12	4741.0
2023-07-27 05:00:00	AAPL	Stock	196.19	196.2	196.03	196.03	4491.0
2023-07-27 05:05:00	AAPL	Stock	196.12	196.12	196.12	196.12	650.0
2023-07-27 05:10:00	AAPL	Stock	196.05	196.18	196.04	196.18	2012.0
2023-07-27 05:15:00	AAPL	Stock	196.08	196.16	196.08	196.16	587.0
2023-07-27 05:20:00	AAPL	Stock	196.05	196.07	196.01	196.01	6537.0
2023-07-27 05:30:00	AAPL	Stock	196.1	196.12	196.1	196.12	200.0
2023-07-27 05:35:00	AAPL	Stock	196.21	196.21	196.21	196.21	749.0
2023-07-27 05:40:00	AAPL	Stock	196.24	196.24	196.24	196.24	391.0
2023-07-27 05:45:00	AAPL	Stock	196.15	196.23	196.15	196.23	2637.0
2023-07-27 05:50:00	AAPL	Stock	196.23	196.25	196.23	196.24	1270.0
2023-07-27 06:00:00	AAPL	Stock	196.22	196.22	196.22	196.22	158.0
2023-07-27 06:15:00	AAPL	Stock	196.17	196.23	196.17	196.23	1340.0
2023-07-27 06:20:00	AAPL	Stock	196.23	196.25	196.23	196.25	524.0
2023-07-27 06:25:00	AAPL	Stock	196.27	196.34	196.27	196.33	862.0
2023-07-27 06:30:00	AAPL	Stock	196.29	196.29	196.01	196.01	12006.0
2023-07-27 06:35:00	AAPL	Stock	196.1	196.2	196.06	196.06	1825.0
2023-07-27 06:40:00	AAPL	Stock	196.16	196.27	196.16	196.27	759.0
2023-07-27 06:45:00	AAPL	Stock	196.35	196.36	196.35	196.36	288.0
2023-07-27 06:50:00	AAPL	Stock	196.27	196.28	196.2	196.2	4885.0
2023-07-27 06:55:00	AAPL	Stock	196.25	196.25	196.25	196.25	1205.0
2023-07-27 07:00:00	AAPL	Stock	196.19	196.24	196.0	196.17	11192.0
2023-07-27 07:05:00	AAPL	Stock	196.2	196.24	196.2	196.24	356.0
2023-07-27 07:10:00	AAPL	Stock	196.24	196.25	196.16	196.16	8732.0
2023-07-27 07:15:00	AAPL	Stock	196.15	196.2	196.12	196.12	20246.0
2023-07-27 07:20:00	AAPL	Stock	196.12	196.18	196.1	196.18	3957.0
2023-07-27 07:25:00	AAPL	Stock	196.18	196.19	196.16	196.16	990.0
2023-07-27 07:30:00	AAPL	Stock	196.2	196.25	196.2	196.21	8893.0
2023-07-27 07:35:00	AAPL	Stock	196.22	196.32	196.22	196.28	3908.0
2023-07-27 07:45:00	AAPL	Stock	196.28	196.32	196.25	196.25	2234.0
2023-07-27 07:50:00	AAPL	Stock	196.32	196.44	196.32	196.4	4580.0
2023-07-27 07:55:00	AAPL	Stock	196.36	196.4	196.2	196.2	9033.0
2023-07-27 08:00:00	AAPL	Stock	196.09	196.4201	194.5	196.17	64638.0
2023-07-27 08:05:00	AAPL	Stock	196.2	196.22	196.0	196.0	24142.0
2023-07-27 08:10:00	AAPL	Stock	196.05	196.19	195.9	196.15	18956.0
2023-07-27 08:15:00	AAPL	Stock	196.13	196.27	196.1	196.26	12895.0
2023-07-27 08:20:00	AAPL	Stock	196.25	196.26	196.15	196.24	5855.0
2023-07-27 08:25:00	AAPL	Stock	196.24	196.25	196.19	196.2	5418.0
2023-07-27 08:30:00	AAPL	Stock	196.19	196.35	196.1266	196.35	11817.0

> showing 50 of 415,963 rows — these rows as CSV

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