PREVIEW / stock_5min / 2023-07-20

all stock 5-min files

  file:    by_date/stock_5min/2023/2023-07-20.parquet
  size:    6.6 MB
  rows:    404,243
  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-20 04:00:00	AAPL	Stock	193.78	193.8	193.78	193.8	1313.0
2023-07-20 04:05:00	AAPL	Stock	193.8	193.81	193.62	193.62	6189.0
2023-07-20 04:10:00	AAPL	Stock	193.64	193.7	193.46	193.46	2522.0
2023-07-20 04:15:00	AAPL	Stock	193.6	193.61	193.46	193.46	5954.0
2023-07-20 04:20:00	AAPL	Stock	193.53	193.53	193.25	193.25	2188.0
2023-07-20 04:25:00	AAPL	Stock	193.37	193.42	193.36	193.37	1040.0
2023-07-20 04:30:00	AAPL	Stock	193.44	193.54	193.37	193.54	2996.0
2023-07-20 04:35:00	AAPL	Stock	193.53	193.54	193.53	193.54	367.0
2023-07-20 04:40:00	AAPL	Stock	193.53	193.53	193.51	193.51	518.0
2023-07-20 04:45:00	AAPL	Stock	193.43	193.51	193.25	193.25	3596.0
2023-07-20 04:50:00	AAPL	Stock	193.44	193.44	193.35	193.35	408.0
2023-07-20 04:55:00	AAPL	Stock	193.33	193.33	193.26	193.29	1464.0
2023-07-20 05:05:00	AAPL	Stock	193.47	193.47	193.47	193.47	100.0
2023-07-20 05:10:00	AAPL	Stock	193.34	193.34	193.34	193.34	300.0
2023-07-20 05:15:00	AAPL	Stock	193.52	193.52	193.52	193.52	168.0
2023-07-20 05:25:00	AAPL	Stock	193.68	193.69	193.68	193.69	308.0
2023-07-20 05:30:00	AAPL	Stock	193.73	193.8	193.73	193.8	350.0
2023-07-20 05:35:00	AAPL	Stock	193.6	193.6	193.6	193.6	139.0
2023-07-20 05:40:00	AAPL	Stock	193.63	193.63	193.55	193.55	1289.0
2023-07-20 06:00:00	AAPL	Stock	193.76	193.76	193.76	193.76	200.0
2023-07-20 06:05:00	AAPL	Stock	193.78	193.78	193.74	193.78	787.0
2023-07-20 06:10:00	AAPL	Stock	193.79	193.92	193.79	193.92	2603.0
2023-07-20 06:15:00	AAPL	Stock	193.9	193.9	193.86	193.86	971.0
2023-07-20 06:20:00	AAPL	Stock	193.88	193.92	193.78	193.78	3775.0
2023-07-20 06:25:00	AAPL	Stock	193.91	193.96	193.9	193.9	606.0
2023-07-20 06:30:00	AAPL	Stock	193.89	193.89	193.89	193.89	100.0
2023-07-20 06:35:00	AAPL	Stock	193.89	194.0	193.89	194.0	1937.0
2023-07-20 06:40:00	AAPL	Stock	194.0	194.0	194.0	194.0	1342.0
2023-07-20 06:50:00	AAPL	Stock	193.87	193.89	193.87	193.89	404.0
2023-07-20 06:55:00	AAPL	Stock	193.88	193.9	193.88	193.9	649.0
2023-07-20 07:00:00	AAPL	Stock	193.9	194.04	193.9	193.95	9849.0
2023-07-20 07:05:00	AAPL	Stock	193.95	193.95	193.65	193.79	6424.0
2023-07-20 07:10:00	AAPL	Stock	193.84	193.87	193.82	193.82	1536.0
2023-07-20 07:15:00	AAPL	Stock	193.74	193.76	193.74	193.76	1138.0
2023-07-20 07:20:00	AAPL	Stock	193.76	193.8	193.74	193.8	3432.0
2023-07-20 07:25:00	AAPL	Stock	193.81	193.95	193.81	193.95	1887.0
2023-07-20 07:30:00	AAPL	Stock	193.91	194.1	193.9	194.1	5745.0
2023-07-20 07:35:00	AAPL	Stock	194.1	194.3	194.1	194.26	3577.0
2023-07-20 07:40:00	AAPL	Stock	194.25	194.36	194.22	194.3	4944.0
2023-07-20 07:45:00	AAPL	Stock	194.26	194.26	194.23	194.23	2032.0
2023-07-20 07:50:00	AAPL	Stock	194.28	194.38	194.28	194.36	2866.0
2023-07-20 07:55:00	AAPL	Stock	194.33	194.33	194.23	194.3	4071.0
2023-07-20 08:00:00	AAPL	Stock	193.95	194.7	193.74	194.43	60633.0
2023-07-20 08:05:00	AAPL	Stock	194.44	194.44	194.31	194.34	3847.0
2023-07-20 08:10:00	AAPL	Stock	194.28	194.28	194.08	194.12	8888.0
2023-07-20 08:15:00	AAPL	Stock	194.1399	194.17	194.12	194.16	3231.0
2023-07-20 08:20:00	AAPL	Stock	194.1702	194.1702	194.04	194.08	3600.0
2023-07-20 08:25:00	AAPL	Stock	194.13	194.19	194.13	194.15	2911.0
2023-07-20 08:30:00	AAPL	Stock	194.03	194.1165	193.93	193.93	14422.0
2023-07-20 08:35:00	AAPL	Stock	193.93	194.14	193.93	194.02	10990.0

> showing 50 of 404,243 rows — these rows as CSV

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