PREVIEW / etf_5min / 2023-06-21

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-21.parquet
  size:    2.0 MB
  rows:    96,800

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-06-21 04:00:00	SPY	ETF	437.01	437.07	436.96	437.03	4895.0
2023-06-21 04:05:00	SPY	ETF	437.02	437.11	437.01	437.11	1457.0
2023-06-21 04:10:00	SPY	ETF	437.18	437.31	437.15	437.15	13217.0
2023-06-21 04:15:00	SPY	ETF	437.2	437.2	437.2	437.2	200.0
2023-06-21 04:20:00	SPY	ETF	437.3	437.3	437.22	437.22	330.0
2023-06-21 04:30:00	SPY	ETF	437.36	437.52	437.36	437.51	2854.0
2023-06-21 04:35:00	SPY	ETF	437.55	437.55	437.49	437.5	713.0
2023-06-21 04:40:00	SPY	ETF	437.33	437.33	437.28	437.3	683.0
2023-06-21 04:45:00	SPY	ETF	437.28	437.35	437.25	437.35	3406.0
2023-06-21 04:50:00	SPY	ETF	437.32	437.32	437.3	437.3	900.0
2023-06-21 04:55:00	SPY	ETF	437.3	437.3	437.3	437.3	346.0
2023-06-21 05:00:00	SPY	ETF	437.34	437.34	437.21	437.21	1200.0
2023-06-21 05:05:00	SPY	ETF	437.25	437.32	437.13	437.13	2896.0
2023-06-21 05:10:00	SPY	ETF	437.23	437.23	437.23	437.23	318.0
2023-06-21 05:15:00	SPY	ETF	437.24	437.29	437.21	437.23	3400.0
2023-06-21 05:20:00	SPY	ETF	437.28	437.28	437.04	437.04	2800.0
2023-06-21 05:25:00	SPY	ETF	437.03	437.25	437.03	437.24	1682.0
2023-06-21 05:30:00	SPY	ETF	437.26	437.28	437.26	437.27	5232.0
2023-06-21 05:35:00	SPY	ETF	437.21	437.43	437.21	437.43	994.0
2023-06-21 05:40:00	SPY	ETF	437.42	437.42	437.4	437.4	1138.0
2023-06-21 05:45:00	SPY	ETF	437.45	437.56	437.45	437.48	2600.0
2023-06-21 05:50:00	SPY	ETF	437.49	437.51	437.47	437.48	500.0
2023-06-21 06:05:00	SPY	ETF	437.44	437.49	437.44	437.49	1100.0
2023-06-21 06:15:00	SPY	ETF	437.54	437.54	437.5	437.53	2600.0
2023-06-21 06:20:00	SPY	ETF	437.51	437.61	437.51	437.61	950.0
2023-06-21 06:25:00	SPY	ETF	437.55	437.55	437.54	437.55	400.0
2023-06-21 06:35:00	SPY	ETF	437.51	437.64	437.51	437.6	3275.0
2023-06-21 06:40:00	SPY	ETF	437.5	437.5	437.5	437.5	250.0
2023-06-21 06:45:00	SPY	ETF	437.31	437.37	437.31	437.35	909.0
2023-06-21 06:50:00	SPY	ETF	437.38	437.43	437.38	437.43	1200.0
2023-06-21 06:55:00	SPY	ETF	437.37	437.37	437.27	437.27	1838.0
2023-06-21 07:00:00	SPY	ETF	437.34	437.36	437.21	437.23	3320.0
2023-06-21 07:05:00	SPY	ETF	437.27	437.28	437.22	437.28	3499.0
2023-06-21 07:10:00	SPY	ETF	437.3	437.3	437.18	437.18	4373.0
2023-06-21 07:15:00	SPY	ETF	437.18	437.18	437.03	437.08	4527.0
2023-06-21 07:20:00	SPY	ETF	437.04	437.09	436.99	437.09	10568.0
2023-06-21 07:25:00	SPY	ETF	437.09	437.11	437.09	437.11	1613.0
2023-06-21 07:30:00	SPY	ETF	437.03	437.06	437.01	437.03	7023.0
2023-06-21 07:35:00	SPY	ETF	436.97	437.08	436.97	437.03	3750.0
2023-06-21 07:40:00	SPY	ETF	436.94	437.11	436.94	437.11	5877.0
2023-06-21 07:45:00	SPY	ETF	437.14	437.16	437.12	437.16	3662.0
2023-06-21 07:50:00	SPY	ETF	437.06	437.14	437.06	437.131	6197.0
2023-06-21 07:55:00	SPY	ETF	437.13	437.15	437.08	437.09	2700.0
2023-06-21 08:00:00	SPY	ETF	437.07	437.5696	436.44	436.91	24751.0
2023-06-21 08:05:00	SPY	ETF	436.9	436.94	436.76	436.81	15402.0
2023-06-21 08:10:00	SPY	ETF	436.81	436.81	436.6	436.62	12783.0
2023-06-21 08:15:00	SPY	ETF	436.62	436.67	436.539	436.56	10421.0
2023-06-21 08:20:00	SPY	ETF	436.53	436.54	436.44	436.47	40123.0
2023-06-21 08:25:00	SPY	ETF	436.4518	436.48	436.2	436.21	56686.0
2023-06-21 08:30:00	SPY	ETF	436.25	436.61	436.05	436.18	210964.0

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

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