PREVIEW / etf_5min / 2024-11-01

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-11-01.parquet
  size:    2.4 MB
  rows:    118,644

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-01 04:00:00	SPY	ETF	570.19	570.68	570.19	570.68	4332.0
2024-11-01 04:05:00	SPY	ETF	570.55	570.6	570.43	570.53	2251.0
2024-11-01 04:10:00	SPY	ETF	570.6	570.75	570.5	570.67	6323.0
2024-11-01 04:15:00	SPY	ETF	570.79	570.79	570.44	570.5	11377.0
2024-11-01 04:20:00	SPY	ETF	570.52	570.56	570.45	570.49	4434.0
2024-11-01 04:25:00	SPY	ETF	570.45	570.6	570.45	570.59	650.0
2024-11-01 04:30:00	SPY	ETF	570.6	570.75	570.52	570.75	4372.0
2024-11-01 04:35:00	SPY	ETF	570.57	570.94	570.57	570.94	1910.0
2024-11-01 04:40:00	SPY	ETF	570.82	570.84	570.5	570.78	3324.0
2024-11-01 04:45:00	SPY	ETF	570.77	570.77	570.57	570.57	687.0
2024-11-01 04:50:00	SPY	ETF	570.59	570.61	570.52	570.54	2284.0
2024-11-01 04:55:00	SPY	ETF	570.4	570.52	570.39	570.52	1148.0
2024-11-01 05:00:00	SPY	ETF	570.59	570.69	570.58	570.58	1243.0
2024-11-01 05:05:00	SPY	ETF	570.64	570.71	570.55	570.55	755.0
2024-11-01 05:15:00	SPY	ETF	570.63	570.74	570.6	570.74	1181.0
2024-11-01 05:20:00	SPY	ETF	570.81	570.84	570.75	570.84	800.0
2024-11-01 05:25:00	SPY	ETF	570.88	571.0	570.88	570.96	1237.0
2024-11-01 05:30:00	SPY	ETF	570.9	570.9	570.66	570.68	7253.0
2024-11-01 05:35:00	SPY	ETF	570.78	570.78	570.76	570.76	2386.0
2024-11-01 05:40:00	SPY	ETF	570.63	570.75	570.63	570.75	387.0
2024-11-01 05:45:00	SPY	ETF	570.84	570.84	570.8	570.8	200.0
2024-11-01 05:50:00	SPY	ETF	570.75	570.77	570.75	570.77	661.0
2024-11-01 05:55:00	SPY	ETF	570.78	570.78	570.78	570.78	100.0
2024-11-01 06:00:00	SPY	ETF	570.88	571.04	570.88	571.04	7231.0
2024-11-01 06:05:00	SPY	ETF	570.95	571.1	570.9	571.05	45748.0
2024-11-01 06:10:00	SPY	ETF	571.07	571.21	571.07	571.21	57032.0
2024-11-01 06:15:00	SPY	ETF	571.11	571.17	571.06	571.17	707.0
2024-11-01 06:20:00	SPY	ETF	571.18	571.18	571.15	571.15	1400.0
2024-11-01 06:25:00	SPY	ETF	571.13	571.28	571.13	571.28	487.0
2024-11-01 06:35:00	SPY	ETF	571.11	571.11	571.0	571.07	4374.0
2024-11-01 06:40:00	SPY	ETF	571.08	571.14	571.04	571.11	43968.0
2024-11-01 06:45:00	SPY	ETF	571.15	571.3	571.15	571.3	43721.0
2024-11-01 06:50:00	SPY	ETF	571.3	571.51	571.25	571.5	59291.0
2024-11-01 06:55:00	SPY	ETF	571.44	571.59	571.43	571.43	5166.0
2024-11-01 07:00:00	SPY	ETF	571.42	571.43	570.8	571.22	212397.0
2024-11-01 07:05:00	SPY	ETF	571.23	571.24	570.84	570.99	28483.0
2024-11-01 07:10:00	SPY	ETF	571.01	571.17	570.94	571.16	12767.0
2024-11-01 07:15:00	SPY	ETF	571.18	571.35	571.18	571.29	10079.0
2024-11-01 07:20:00	SPY	ETF	571.3	571.38	571.29	571.32	7644.0
2024-11-01 07:25:00	SPY	ETF	571.36	571.36	571.2	571.26	1824.0
2024-11-01 07:30:00	SPY	ETF	571.28	571.42	571.28	571.4	6950.0
2024-11-01 07:35:00	SPY	ETF	571.42	571.55	571.42	571.46	4151.0
2024-11-01 07:40:00	SPY	ETF	571.48	571.65	571.46	571.58	23277.0
2024-11-01 07:45:00	SPY	ETF	571.5	571.5	571.19	571.27	1085.0
2024-11-01 07:50:00	SPY	ETF	571.35	571.51	571.34	571.43	24050.0
2024-11-01 07:55:00	SPY	ETF	571.44	571.53	571.37	571.37	4405.0
2024-11-01 08:00:00	SPY	ETF	571.4	571.5901	569.37	571.4	53618.0
2024-11-01 08:05:00	SPY	ETF	571.38	571.38	571.3	571.32	14109.0
2024-11-01 08:10:00	SPY	ETF	571.34	571.49	571.3103	571.43	7440.0
2024-11-01 08:15:00	SPY	ETF	571.41	571.43	571.21	571.32	11655.0

> showing 50 of 118,644 rows — these rows as CSV

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