PREVIEW / etf_5min / 2023-05-18

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-05-18.parquet
  size:    2.0 MB
  rows:    96,375

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-05-18 04:00:00	SPY	ETF	415.69	416.02	415.2	415.96	14769.0
2023-05-18 04:05:00	SPY	ETF	416.02	416.24	416.02	416.21	1610.0
2023-05-18 04:10:00	SPY	ETF	416.22	416.3	416.19	416.19	400.0
2023-05-18 04:15:00	SPY	ETF	416.13	416.22	416.06	416.21	1556.0
2023-05-18 04:20:00	SPY	ETF	416.05	416.08	416.05	416.08	870.0
2023-05-18 04:25:00	SPY	ETF	416.11	416.11	416.09	416.09	400.0
2023-05-18 04:30:00	SPY	ETF	416.0	416.03	416.0	416.03	340.0
2023-05-18 04:35:00	SPY	ETF	415.97	415.97	415.91	415.91	500.0
2023-05-18 04:40:00	SPY	ETF	415.91	415.91	415.84	415.84	950.0
2023-05-18 04:45:00	SPY	ETF	415.98	415.98	415.94	415.94	2800.0
2023-05-18 04:50:00	SPY	ETF	415.95	415.95	415.95	415.95	112.0
2023-05-18 04:55:00	SPY	ETF	415.88	415.93	415.87	415.93	3070.0
2023-05-18 05:05:00	SPY	ETF	415.74	415.74	415.72	415.72	311.0
2023-05-18 05:10:00	SPY	ETF	415.76	415.76	415.76	415.76	100.0
2023-05-18 05:15:00	SPY	ETF	415.76	415.78	415.76	415.76	600.0
2023-05-18 05:20:00	SPY	ETF	415.75	415.9	415.75	415.86	1401.0
2023-05-18 05:25:00	SPY	ETF	415.93	415.94	415.93	415.94	500.0
2023-05-18 05:30:00	SPY	ETF	415.88	415.88	415.88	415.88	105.0
2023-05-18 05:35:00	SPY	ETF	415.99	415.99	415.95	415.99	1754.0
2023-05-18 05:40:00	SPY	ETF	416.0	416.1	416.0	416.07	4681.0
2023-05-18 05:45:00	SPY	ETF	416.04	416.1	416.04	416.1	3602.0
2023-05-18 05:50:00	SPY	ETF	416.09	416.19	416.09	416.13	2965.0
2023-05-18 05:55:00	SPY	ETF	416.14	416.15	416.12	416.12	1317.0
2023-05-18 06:00:00	SPY	ETF	416.11	416.19	416.11	416.19	475.0
2023-05-18 06:05:00	SPY	ETF	416.2	416.2	416.2	416.2	201.0
2023-05-18 06:10:00	SPY	ETF	416.06	416.06	416.01	416.04	3218.0
2023-05-18 06:15:00	SPY	ETF	416.06	416.1	416.05	416.05	6964.0
2023-05-18 06:20:00	SPY	ETF	416.1	416.12	416.1	416.12	999.0
2023-05-18 06:25:00	SPY	ETF	416.11	416.12	416.07	416.08	2325.0
2023-05-18 06:30:00	SPY	ETF	416.09	416.18	416.09	416.18	1525.0
2023-05-18 06:35:00	SPY	ETF	416.19	416.22	416.13	416.22	2515.0
2023-05-18 06:40:00	SPY	ETF	416.23	416.32	416.21	416.32	5477.0
2023-05-18 06:45:00	SPY	ETF	416.36	416.47	416.36	416.4	5061.0
2023-05-18 06:50:00	SPY	ETF	416.36	416.38	416.32	416.34	8385.0
2023-05-18 06:55:00	SPY	ETF	416.25	416.25	416.19	416.25	102886.0
2023-05-18 07:00:00	SPY	ETF	416.24	416.52	416.22	416.49	68283.0
2023-05-18 07:05:00	SPY	ETF	416.43	416.48	416.31	416.31	8883.0
2023-05-18 07:10:00	SPY	ETF	416.35	416.37	416.31	416.32	11050.0
2023-05-18 07:15:00	SPY	ETF	416.35	416.37	416.32	416.37	2421.0
2023-05-18 07:20:00	SPY	ETF	416.35	416.35	416.24	416.26	10544.0
2023-05-18 07:25:00	SPY	ETF	416.29	416.29	416.2	416.21	6507.0
2023-05-18 07:30:00	SPY	ETF	416.21	416.25	416.19	416.21	15484.0
2023-05-18 07:35:00	SPY	ETF	416.26	416.26	416.16	416.2	4926.0
2023-05-18 07:40:00	SPY	ETF	416.15	416.15	416.09	416.1	6089.0
2023-05-18 07:45:00	SPY	ETF	416.09	416.14	416.07	416.12	8572.0
2023-05-18 07:50:00	SPY	ETF	416.12	416.3	416.1	416.16	31829.0
2023-05-18 07:55:00	SPY	ETF	416.17	416.19	416.11	416.13	39641.0
2023-05-18 08:00:00	SPY	ETF	416.2213	416.5	414.96	416.03	24288.0
2023-05-18 08:05:00	SPY	ETF	416.0	416.05	415.97	415.98	11991.0
2023-05-18 08:10:00	SPY	ETF	415.98	416.02	415.95	415.97	89284.0

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

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