PREVIEW / etf_5min / 2023-07-17

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-17.parquet
  size:    2.0 MB
  rows:    96,380

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-07-17 04:00:00	SPY	ETF	449.22	449.22	449.1	449.13	2555.0
2023-07-17 04:05:00	SPY	ETF	449.15	449.2	449.15	449.15	1777.0
2023-07-17 04:10:00	SPY	ETF	449.17	449.23	449.14	449.23	877.0
2023-07-17 04:15:00	SPY	ETF	449.24	449.32	449.2	449.2	3554.0
2023-07-17 04:20:00	SPY	ETF	449.33	449.33	449.28	449.32	1600.0
2023-07-17 04:25:00	SPY	ETF	449.33	449.33	449.3	449.3	2728.0
2023-07-17 04:30:00	SPY	ETF	449.28	449.32	449.28	449.32	800.0
2023-07-17 04:35:00	SPY	ETF	449.26	449.3	449.26	449.3	464.0
2023-07-17 04:40:00	SPY	ETF	449.24	449.24	449.04	449.05	3420.0
2023-07-17 04:45:00	SPY	ETF	448.97	449.0	448.97	448.99	2289.0
2023-07-17 04:50:00	SPY	ETF	449.05	449.05	448.96	448.96	1613.0
2023-07-17 04:55:00	SPY	ETF	448.92	448.97	448.92	448.92	3290.0
2023-07-17 05:00:00	SPY	ETF	448.93	448.93	448.92	448.92	1900.0
2023-07-17 05:05:00	SPY	ETF	449.0	449.04	448.94	448.94	600.0
2023-07-17 05:15:00	SPY	ETF	448.97	449.09	448.97	449.07	705.0
2023-07-17 05:20:00	SPY	ETF	449.06	449.06	449.0	449.0	500.0
2023-07-17 05:25:00	SPY	ETF	448.91	448.91	448.91	448.91	200.0
2023-07-17 05:30:00	SPY	ETF	448.97	448.97	448.97	448.97	600.0
2023-07-17 05:35:00	SPY	ETF	448.92	448.92	448.83	448.83	739.0
2023-07-17 05:40:00	SPY	ETF	448.81	448.81	448.81	448.81	1000.0
2023-07-17 05:45:00	SPY	ETF	448.8	448.8	448.48	448.48	9163.0
2023-07-17 05:50:00	SPY	ETF	448.45	448.5	448.43	448.49	5155.0
2023-07-17 05:55:00	SPY	ETF	448.49	448.57	448.44	448.47	1202.0
2023-07-17 06:00:00	SPY	ETF	448.51	448.57	448.51	448.57	313.0
2023-07-17 06:05:00	SPY	ETF	448.51	448.56	448.51	448.56	600.0
2023-07-17 06:10:00	SPY	ETF	448.52	448.52	448.5	448.5	500.0
2023-07-17 06:15:00	SPY	ETF	448.42	448.5	448.42	448.5	466.0
2023-07-17 06:25:00	SPY	ETF	448.54	448.54	448.54	448.54	100.0
2023-07-17 06:30:00	SPY	ETF	448.52	448.6	448.52	448.6	795.0
2023-07-17 06:35:00	SPY	ETF	448.62	448.62	448.54	448.54	19805.0
2023-07-17 06:40:00	SPY	ETF	448.54	448.56	448.54	448.54	30133.0
2023-07-17 06:45:00	SPY	ETF	448.55	448.65	448.55	448.65	17812.0
2023-07-17 06:50:00	SPY	ETF	448.61	448.61	448.55	448.58	2500.0
2023-07-17 06:55:00	SPY	ETF	448.58	448.58	448.38	448.38	5281.0
2023-07-17 07:00:00	SPY	ETF	448.39	448.6	448.39	448.6	4392.0
2023-07-17 07:05:00	SPY	ETF	448.61	448.8	448.61	448.74	22276.0
2023-07-17 07:10:00	SPY	ETF	448.74	448.74	448.65	448.68	2400.0
2023-07-17 07:15:00	SPY	ETF	448.72	448.78	448.72	448.76	2448.0
2023-07-17 07:20:00	SPY	ETF	448.77	448.77	448.59	448.59	2321.0
2023-07-17 07:25:00	SPY	ETF	448.65	448.65	448.59	448.63	1440.0
2023-07-17 07:30:00	SPY	ETF	448.61	448.7	448.6	448.6	6327.0
2023-07-17 07:35:00	SPY	ETF	448.63	448.66	448.56	448.56	2730.0
2023-07-17 07:40:00	SPY	ETF	448.53	448.6	448.53	448.6	2386.0
2023-07-17 07:45:00	SPY	ETF	448.6	448.6	448.52	448.52	11101.0
2023-07-17 07:50:00	SPY	ETF	448.52	448.52	448.35	448.38	16304.0
2023-07-17 07:55:00	SPY	ETF	448.42	448.47	448.42	448.45	42386.0
2023-07-17 08:00:00	SPY	ETF	448.45	449.1	448.36	448.6	60745.0
2023-07-17 08:05:00	SPY	ETF	448.56	448.56	448.35	448.36	5824.0
2023-07-17 08:10:00	SPY	ETF	448.31	448.4298	448.25	448.4298	39600.0
2023-07-17 08:15:00	SPY	ETF	448.44	448.48	448.44	448.48	5288.0

> showing 50 of 96,380 rows — these rows as CSV

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