PREVIEW / etf_5min / 2024-04-18

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-04-18.parquet
  size:    2.2 MB
  rows:    109,291

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-04-18 04:00:00	SPY	ETF	502.68	502.7	502.56	502.57	2093.0
2024-04-18 04:05:00	SPY	ETF	502.6	502.64	502.33	502.33	1363.0
2024-04-18 04:10:00	SPY	ETF	502.39	502.39	502.08	502.26	3411.0
2024-04-18 04:15:00	SPY	ETF	502.15	502.16	502.02	502.02	976.0
2024-04-18 04:20:00	SPY	ETF	501.86	502.02	501.82	501.82	1858.0
2024-04-18 04:25:00	SPY	ETF	502.1	502.17	502.08	502.17	552.0
2024-04-18 04:30:00	SPY	ETF	502.22	502.29	502.22	502.29	400.0
2024-04-18 04:35:00	SPY	ETF	502.1	502.26	502.1	502.26	825.0
2024-04-18 04:40:00	SPY	ETF	502.01	502.01	502.01	502.01	200.0
2024-04-18 04:45:00	SPY	ETF	502.03	502.08	502.03	502.08	225.0
2024-04-18 04:50:00	SPY	ETF	502.29	502.29	502.29	502.29	136.0
2024-04-18 04:55:00	SPY	ETF	502.09	502.09	501.89	501.99	725.0
2024-04-18 05:00:00	SPY	ETF	502.04	502.19	502.04	502.19	500.0
2024-04-18 05:05:00	SPY	ETF	502.1	502.19	502.02	502.19	1475.0
2024-04-18 05:15:00	SPY	ETF	501.84	501.84	501.84	501.84	200.0
2024-04-18 05:20:00	SPY	ETF	501.8	501.8	501.53	501.53	1053.0
2024-04-18 05:25:00	SPY	ETF	501.43	501.43	501.17	501.17	1875.0
2024-04-18 05:30:00	SPY	ETF	501.18	501.33	501.1	501.33	2290.0
2024-04-18 05:35:00	SPY	ETF	501.32	501.43	501.23	501.43	8450.0
2024-04-18 05:40:00	SPY	ETF	501.58	501.58	501.58	501.58	300.0
2024-04-18 05:45:00	SPY	ETF	501.7	501.7	501.7	501.7	100.0
2024-04-18 05:50:00	SPY	ETF	501.66	501.75	501.65	501.75	807.0
2024-04-18 05:55:00	SPY	ETF	501.75	501.81	501.74	501.81	1236.0
2024-04-18 06:00:00	SPY	ETF	501.7	501.85	501.7	501.85	1906.0
2024-04-18 06:05:00	SPY	ETF	501.88	501.88	501.88	501.88	100.0
2024-04-18 06:10:00	SPY	ETF	501.81	501.82	501.63	501.63	3458.0
2024-04-18 06:15:00	SPY	ETF	501.62	501.62	501.42	501.42	558.0
2024-04-18 06:20:00	SPY	ETF	501.68	501.68	501.68	501.68	100.0
2024-04-18 06:25:00	SPY	ETF	501.92	502.01	501.92	501.97	3100.0
2024-04-18 06:30:00	SPY	ETF	502.11	502.24	502.05	502.2	8550.0
2024-04-18 06:35:00	SPY	ETF	502.16	502.26	502.16	502.26	10445.0
2024-04-18 06:40:00	SPY	ETF	502.28	502.33	502.1	502.14	6705.0
2024-04-18 06:45:00	SPY	ETF	502.16	502.25	502.11	502.14	3800.0
2024-04-18 06:50:00	SPY	ETF	502.11	502.12	502.07	502.07	600.0
2024-04-18 06:55:00	SPY	ETF	502.08	502.08	501.99	502.04	2300.0
2024-04-18 07:00:00	SPY	ETF	501.99	502.17	501.4	502.17	94630.0
2024-04-18 07:05:00	SPY	ETF	502.13	502.38	502.09	502.31	14788.0
2024-04-18 07:10:00	SPY	ETF	502.19	502.19	501.79	501.79	7526.0
2024-04-18 07:15:00	SPY	ETF	501.94	501.94	501.81	501.94	32041.0
2024-04-18 07:20:00	SPY	ETF	501.95	502.19	501.95	502.0	15084.0
2024-04-18 07:25:00	SPY	ETF	502.09	502.09	502.0	502.0	4544.0
2024-04-18 07:30:00	SPY	ETF	502.04	502.33	502.04	502.33	12850.0
2024-04-18 07:35:00	SPY	ETF	502.31	502.36	502.031	502.15	10371.0
2024-04-18 07:40:00	SPY	ETF	502.11	502.33	502.09	502.25	39560.0
2024-04-18 07:45:00	SPY	ETF	502.36	502.52	502.27	502.27	11521.0
2024-04-18 07:50:00	SPY	ETF	502.25	502.35	502.2	502.3	11706.0
2024-04-18 07:55:00	SPY	ETF	502.281	502.34	502.21	502.24	17117.0
2024-04-18 08:00:00	SPY	ETF	502.19	502.86	501.13	502.06	57039.0
2024-04-18 08:05:00	SPY	ETF	501.97	502.85	501.82	501.96	26858.0
2024-04-18 08:10:00	SPY	ETF	501.9	501.93	501.69	501.74	21369.0

> showing 50 of 109,291 rows — these rows as CSV

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