PREVIEW / etf_5min / 2024-11-11

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-11-11.parquet
  size:    2.6 MB
  rows:    127,030

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
2024-11-11 04:00:00	SPY	ETF	599.22	599.84	599.0	599.66	5258.0
2024-11-11 04:05:00	SPY	ETF	599.59	599.59	599.5	599.56	1584.0
2024-11-11 04:10:00	SPY	ETF	599.7	599.85	599.65	599.79	824.0
2024-11-11 04:15:00	SPY	ETF	599.85	600.03	599.76	600.02	7384.0
2024-11-11 04:20:00	SPY	ETF	600.0	600.02	599.9	599.91	31137.0
2024-11-11 04:25:00	SPY	ETF	599.88	599.88	599.84	599.88	410.0
2024-11-11 04:30:00	SPY	ETF	599.91	599.98	599.91	599.97	484.0
2024-11-11 04:35:00	SPY	ETF	599.86	599.98	599.86	599.98	329.0
2024-11-11 04:40:00	SPY	ETF	600.0	600.0	599.95	599.95	1070.0
2024-11-11 04:45:00	SPY	ETF	599.91	599.91	599.91	599.91	1796.0
2024-11-11 04:50:00	SPY	ETF	599.88	599.88	599.87	599.87	400.0
2024-11-11 04:55:00	SPY	ETF	599.8	599.83	599.8	599.83	2230.0
2024-11-11 05:00:00	SPY	ETF	599.86	599.86	599.86	599.86	874.0
2024-11-11 05:05:00	SPY	ETF	599.88	599.89	599.88	599.89	830.0
2024-11-11 05:15:00	SPY	ETF	599.85	599.85	599.84	599.84	416.0
2024-11-11 05:20:00	SPY	ETF	599.81	599.95	599.81	599.9	1451.0
2024-11-11 05:25:00	SPY	ETF	599.9	599.9	599.83	599.86	393.0
2024-11-11 05:35:00	SPY	ETF	599.93	599.93	599.93	599.93	100.0
2024-11-11 05:40:00	SPY	ETF	599.87	599.87	599.81	599.85	752.0
2024-11-11 05:45:00	SPY	ETF	599.77	599.77	599.77	599.77	935.0
2024-11-11 05:50:00	SPY	ETF	599.68	599.68	599.68	599.68	104.0
2024-11-11 05:55:00	SPY	ETF	599.65	599.65	599.65	599.65	300.0
2024-11-11 06:00:00	SPY	ETF	599.62	599.62	599.62	599.62	235.0
2024-11-11 06:05:00	SPY	ETF	599.65	599.65	599.65	599.65	406.0
2024-11-11 06:10:00	SPY	ETF	599.64	599.64	599.64	599.64	200.0
2024-11-11 06:15:00	SPY	ETF	599.65	599.65	599.65	599.65	100.0
2024-11-11 06:20:00	SPY	ETF	599.72	599.72	599.71	599.71	496.0
2024-11-11 06:25:00	SPY	ETF	599.76	599.78	599.76	599.78	344.0
2024-11-11 06:30:00	SPY	ETF	599.75	599.95	599.75	599.95	11856.0
2024-11-11 06:35:00	SPY	ETF	599.94	599.96	599.9	599.94	1250.0
2024-11-11 06:40:00	SPY	ETF	599.89	599.89	599.82	599.89	957.0
2024-11-11 06:45:00	SPY	ETF	599.96	599.96	599.92	599.92	1804.0
2024-11-11 06:50:00	SPY	ETF	599.99	600.0	599.98	599.98	2200.0
2024-11-11 06:55:00	SPY	ETF	599.98	599.98	599.89	599.89	652.0
2024-11-11 07:00:00	SPY	ETF	599.9	600.0	599.9	600.0	3352.0
2024-11-11 07:05:00	SPY	ETF	600.0	600.01	599.98	599.98	1795.0
2024-11-11 07:10:00	SPY	ETF	600.1	600.26	600.1	600.26	4994.0
2024-11-11 07:15:00	SPY	ETF	600.26	600.32	600.24	600.299	12404.0
2024-11-11 07:20:00	SPY	ETF	600.3	600.3	600.25	600.3	2462.0
2024-11-11 07:25:00	SPY	ETF	600.26	600.429	600.26	600.381	1991.0
2024-11-11 07:30:00	SPY	ETF	600.38	600.54	600.38	600.52	6662.0
2024-11-11 07:35:00	SPY	ETF	600.51	600.57	600.47	600.54	17501.0
2024-11-11 07:40:00	SPY	ETF	600.54	600.85	600.54	600.85	35612.0
2024-11-11 07:45:00	SPY	ETF	600.78	600.98	600.75	600.82	9165.0
2024-11-11 07:50:00	SPY	ETF	600.86	600.86	600.8	600.8	2500.0
2024-11-11 07:55:00	SPY	ETF	600.8	600.8	600.6	600.67	25150.0
2024-11-11 08:00:00	SPY	ETF	599.9006	600.9286	599.22	600.77	101004.0
2024-11-11 08:05:00	SPY	ETF	600.8209	601.0	600.62	600.66	14681.0
2024-11-11 08:10:00	SPY	ETF	600.66	600.75	600.6209	600.7486	3830.0
2024-11-11 08:15:00	SPY	ETF	600.66	600.66	600.46	600.46	9604.0

> showing 50 of 127,030 rows — these rows as CSV

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