PREVIEW / etf_5min / 2024-07-19

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-07-19.parquet
  size:    2.0 MB
  rows:    102,217

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-07-19 04:00:00	SPY	ETF	551.62	552.05	551.32	552.03	3532.0
2024-07-19 04:05:00	SPY	ETF	552.04	552.29	551.81	551.86	2501.0
2024-07-19 04:10:00	SPY	ETF	551.83	551.83	551.57	551.57	400.0
2024-07-19 04:15:00	SPY	ETF	551.75	551.93	551.75	551.77	1174.0
2024-07-19 04:20:00	SPY	ETF	551.46	551.86	551.07	551.86	1983.0
2024-07-19 04:25:00	SPY	ETF	551.74	552.08	551.65	552.08	11181.0
2024-07-19 04:30:00	SPY	ETF	552.0	552.0	552.0	552.0	124.0
2024-07-19 04:35:00	SPY	ETF	551.9	552.36	551.9	552.35	1693.0
2024-07-19 04:40:00	SPY	ETF	552.22	552.26	552.15	552.26	1134.0
2024-07-19 04:45:00	SPY	ETF	552.26	552.28	552.26	552.28	378.0
2024-07-19 04:50:00	SPY	ETF	552.31	552.4	552.15	552.15	1106.0
2024-07-19 04:55:00	SPY	ETF	551.89	552.15	551.89	552.02	694.0
2024-07-19 05:00:00	SPY	ETF	552.14	552.72	552.14	552.44	10384.0
2024-07-19 05:05:00	SPY	ETF	552.41	552.41	552.41	552.41	100.0
2024-07-19 05:10:00	SPY	ETF	552.35	552.47	552.28	552.34	1299.0
2024-07-19 05:15:00	SPY	ETF	552.32	552.48	552.3	552.41	6602.0
2024-07-19 05:20:00	SPY	ETF	552.26	552.26	551.68	551.68	4748.0
2024-07-19 05:25:00	SPY	ETF	551.65	551.82	551.65	551.75	1628.0
2024-07-19 05:30:00	SPY	ETF	551.7	552.48	551.7	552.35	1868.0
2024-07-19 05:35:00	SPY	ETF	551.8	551.8	551.8	551.8	200.0
2024-07-19 05:40:00	SPY	ETF	551.6	551.67	551.56	551.67	329.0
2024-07-19 05:45:00	SPY	ETF	552.02	552.55	552.02	552.48	1787.0
2024-07-19 05:50:00	SPY	ETF	552.49	552.52	552.33	552.33	543.0
2024-07-19 05:55:00	SPY	ETF	552.35	552.36	552.34	552.34	878.0
2024-07-19 06:00:00	SPY	ETF	552.6	552.84	552.6	552.84	606.0
2024-07-19 06:05:00	SPY	ETF	553.08	553.19	553.02	553.19	1600.0
2024-07-19 06:10:00	SPY	ETF	553.17	553.25	553.15	553.15	1634.0
2024-07-19 06:15:00	SPY	ETF	553.2	553.36	553.19	553.36	700.0
2024-07-19 06:20:00	SPY	ETF	553.23	553.23	553.21	553.21	255.0
2024-07-19 06:25:00	SPY	ETF	553.24	553.44	553.24	553.44	1961.0
2024-07-19 06:30:00	SPY	ETF	553.28	553.28	553.28	553.28	100.0
2024-07-19 06:35:00	SPY	ETF	553.18	553.2	553.18	553.2	205.0
2024-07-19 06:40:00	SPY	ETF	553.08	553.08	553.02	553.08	444.0
2024-07-19 06:45:00	SPY	ETF	552.91	553.11	552.73	552.96	4728.0
2024-07-19 06:50:00	SPY	ETF	552.94	552.94	552.67	552.7	18202.0
2024-07-19 06:55:00	SPY	ETF	552.76	552.83	552.73	552.81	4100.0
2024-07-19 07:00:00	SPY	ETF	552.76	553.0	552.65	552.95	5973.0
2024-07-19 07:05:00	SPY	ETF	553.0	553.15	553.0	553.03	5340.0
2024-07-19 07:10:00	SPY	ETF	553.03	553.43	552.98	553.24	46580.0
2024-07-19 07:15:00	SPY	ETF	553.2	553.42	553.2	553.4	6530.0
2024-07-19 07:20:00	SPY	ETF	553.48	553.78	553.47	553.78	33808.0
2024-07-19 07:25:00	SPY	ETF	553.58	553.64	553.5	553.58	5130.0
2024-07-19 07:30:00	SPY	ETF	553.66	553.73	553.55	553.55	10938.0
2024-07-19 07:35:00	SPY	ETF	553.54	553.72	553.53	553.64	5181.0
2024-07-19 07:40:00	SPY	ETF	553.69	553.69	553.53	553.69	4089.0
2024-07-19 07:45:00	SPY	ETF	553.68	553.69	553.55	553.6	18898.0
2024-07-19 07:50:00	SPY	ETF	553.6	553.65	553.38	553.51	49108.0
2024-07-19 07:55:00	SPY	ETF	553.58	553.58	553.46	553.55	5135.0
2024-07-19 08:00:00	SPY	ETF	552.98	554.33	551.11	553.86	73954.0
2024-07-19 08:05:00	SPY	ETF	553.8	553.82	553.44	553.45	17481.0

> showing 50 of 102,217 rows — these rows as CSV

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