PREVIEW / stock_5min / 2023-10-20

all stock 5-min files

  file:    by_date/stock_5min/2023/2023-10-20.parquet
  size:    6.4 MB
  rows:    390,388
  symbols: 1,347

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-10-20 04:00:00	AAPL	Stock	174.95	174.95	174.56	174.65	1622.0
2023-10-20 04:05:00	AAPL	Stock	174.8	174.8	174.72	174.8	1173.0
2023-10-20 04:10:00	AAPL	Stock	174.84	174.88	174.84	174.88	1000.0
2023-10-20 04:15:00	AAPL	Stock	174.88	174.88	174.71	174.82	1292.0
2023-10-20 04:20:00	AAPL	Stock	174.79	174.99	174.79	174.99	1613.0
2023-10-20 04:25:00	AAPL	Stock	175.01	175.01	175.01	175.01	100.0
2023-10-20 04:35:00	AAPL	Stock	175.06	175.07	175.06	175.07	200.0
2023-10-20 04:40:00	AAPL	Stock	175.14	175.14	175.14	175.14	100.0
2023-10-20 04:45:00	AAPL	Stock	175.25	175.27	175.25	175.25	742.0
2023-10-20 04:50:00	AAPL	Stock	175.22	175.32	175.14	175.14	1222.0
2023-10-20 05:05:00	AAPL	Stock	175.07	175.1	175.07	175.1	1919.0
2023-10-20 05:10:00	AAPL	Stock	175.04	175.16	174.85	174.97	2621.0
2023-10-20 05:15:00	AAPL	Stock	175.0	175.0	175.0	175.0	500.0
2023-10-20 05:20:00	AAPL	Stock	174.97	174.97	174.97	174.97	1983.0
2023-10-20 05:25:00	AAPL	Stock	174.87	174.87	174.75	174.75	1289.0
2023-10-20 05:30:00	AAPL	Stock	174.71	174.82	174.71	174.82	527.0
2023-10-20 05:35:00	AAPL	Stock	174.82	174.82	174.8	174.8	262.0
2023-10-20 05:40:00	AAPL	Stock	174.85	174.85	174.85	174.85	250.0
2023-10-20 05:45:00	AAPL	Stock	174.82	174.84	174.71	174.71	6584.0
2023-10-20 05:50:00	AAPL	Stock	174.88	174.88	174.88	174.88	100.0
2023-10-20 05:55:00	AAPL	Stock	174.97	174.97	174.97	174.97	300.0
2023-10-20 06:00:00	AAPL	Stock	174.93	174.93	174.93	174.93	100.0
2023-10-20 06:05:00	AAPL	Stock	174.88	174.88	174.88	174.88	500.0
2023-10-20 06:15:00	AAPL	Stock	174.87	174.87	174.87	174.87	200.0
2023-10-20 06:20:00	AAPL	Stock	174.86	174.86	174.82	174.82	676.0
2023-10-20 06:25:00	AAPL	Stock	174.73	174.73	174.73	174.73	200.0
2023-10-20 06:30:00	AAPL	Stock	174.72	174.72	174.7	174.7	689.0
2023-10-20 06:35:00	AAPL	Stock	174.74	174.74	174.73	174.74	333.0
2023-10-20 06:40:00	AAPL	Stock	174.71	174.71	174.71	174.71	100.0
2023-10-20 06:45:00	AAPL	Stock	174.71	174.72	174.71	174.72	200.0
2023-10-20 07:00:00	AAPL	Stock	174.71	174.79	174.7	174.75	2703.0
2023-10-20 07:05:00	AAPL	Stock	174.81	174.97	174.79	174.97	3544.0
2023-10-20 07:10:00	AAPL	Stock	175.0	175.06	174.98	174.98	402.0
2023-10-20 07:15:00	AAPL	Stock	175.0	175.1	174.95	174.95	1867.0
2023-10-20 07:20:00	AAPL	Stock	175.05	175.05	175.0	175.0	1075.0
2023-10-20 07:25:00	AAPL	Stock	174.95	174.95	174.95	174.95	1000.0
2023-10-20 07:30:00	AAPL	Stock	174.9	174.9	174.9	174.9	100.0
2023-10-20 07:40:00	AAPL	Stock	174.92	174.92	174.85	174.88	2239.0
2023-10-20 07:50:00	AAPL	Stock	175.0	175.01	174.99	175.01	426.0
2023-10-20 07:55:00	AAPL	Stock	175.0	175.18	175.0	175.1	4025.0
2023-10-20 08:00:00	AAPL	Stock	174.77	175.2	174.49	175.2	24742.0
2023-10-20 08:05:00	AAPL	Stock	175.03	175.03	174.75	174.75	2218.0
2023-10-20 08:10:00	AAPL	Stock	174.84	174.85	174.84	174.84	2849.0
2023-10-20 08:15:00	AAPL	Stock	174.83	174.83	174.75	174.75	1346.0
2023-10-20 08:20:00	AAPL	Stock	174.78	174.85	174.7	174.781	4678.0
2023-10-20 08:25:00	AAPL	Stock	174.7	174.7	174.64	174.646	4705.0
2023-10-20 08:30:00	AAPL	Stock	174.65	174.78	174.65	174.74	3028.0
2023-10-20 08:35:00	AAPL	Stock	174.78	174.84	174.78	174.81	1853.0
2023-10-20 08:40:00	AAPL	Stock	174.76	174.84	174.66	174.7514	3675.0
2023-10-20 08:45:00	AAPL	Stock	174.66	174.7	174.65	174.65	1917.0

> showing 50 of 390,388 rows — these rows as CSV

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