PREVIEW / etf_5min / 2023-06-22

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-22.parquet
  size:    1.9 MB
  rows:    94,842

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-22 04:00:00	SPY	ETF	434.46	434.46	433.76	433.91	2306.0
2023-06-22 04:05:00	SPY	ETF	433.99	434.22	433.99	434.22	1809.0
2023-06-22 04:10:00	SPY	ETF	434.06	434.19	434.03	434.15	4318.0
2023-06-22 04:15:00	SPY	ETF	434.1	434.28	434.1	434.28	2200.0
2023-06-22 04:20:00	SPY	ETF	434.3	434.38	434.22	434.22	1804.0
2023-06-22 04:25:00	SPY	ETF	434.19	434.23	434.19	434.23	815.0
2023-06-22 04:30:00	SPY	ETF	434.01	434.01	434.01	434.01	729.0
2023-06-22 04:35:00	SPY	ETF	434.31	434.31	434.17	434.23	1430.0
2023-06-22 04:40:00	SPY	ETF	434.25	434.25	434.16	434.21	2600.0
2023-06-22 04:45:00	SPY	ETF	434.25	434.25	434.17	434.17	600.0
2023-06-22 04:50:00	SPY	ETF	434.17	434.17	434.0	434.0	4960.0
2023-06-22 04:55:00	SPY	ETF	434.07	434.16	434.07	434.1	1100.0
2023-06-22 05:00:00	SPY	ETF	434.17	434.17	434.11	434.11	3000.0
2023-06-22 05:05:00	SPY	ETF	434.18	434.18	434.18	434.18	1000.0
2023-06-22 05:10:00	SPY	ETF	434.25	434.25	434.25	434.25	600.0
2023-06-22 05:15:00	SPY	ETF	434.33	434.33	434.3	434.3	800.0
2023-06-22 05:20:00	SPY	ETF	434.33	434.35	434.2	434.2	930.0
2023-06-22 05:25:00	SPY	ETF	434.2	434.2	434.09	434.09	3880.0
2023-06-22 05:35:00	SPY	ETF	434.25	434.25	434.23	434.23	1800.0
2023-06-22 05:40:00	SPY	ETF	434.3	434.35	434.3	434.35	848.0
2023-06-22 05:45:00	SPY	ETF	434.33	434.58	434.33	434.58	2650.0
2023-06-22 05:50:00	SPY	ETF	434.5	434.5	434.5	434.5	100.0
2023-06-22 05:55:00	SPY	ETF	434.4	434.4	434.35	434.35	200.0
2023-06-22 06:00:00	SPY	ETF	434.35	434.39	434.15	434.15	4175.0
2023-06-22 06:05:00	SPY	ETF	434.14	434.16	434.11	434.14	1251.0
2023-06-22 06:10:00	SPY	ETF	434.15	434.15	434.15	434.15	696.0
2023-06-22 06:15:00	SPY	ETF	434.1	434.1	433.93	433.93	2605.0
2023-06-22 06:20:00	SPY	ETF	433.97	434.09	433.97	434.07	1349.0
2023-06-22 06:25:00	SPY	ETF	434.18	434.25	434.15	434.15	2785.0
2023-06-22 06:30:00	SPY	ETF	434.12	434.16	434.08	434.08	16303.0
2023-06-22 06:35:00	SPY	ETF	434.07	434.07	433.92	433.92	9980.0
2023-06-22 06:40:00	SPY	ETF	433.87	433.98	433.83	433.86	27320.0
2023-06-22 06:45:00	SPY	ETF	433.81	433.81	433.71	433.79	30018.0
2023-06-22 06:50:00	SPY	ETF	433.8	433.82	433.64	433.64	5637.0
2023-06-22 06:55:00	SPY	ETF	433.69	433.85	433.69	433.85	777.0
2023-06-22 07:00:00	SPY	ETF	433.88	433.88	433.55	433.65	39994.0
2023-06-22 07:05:00	SPY	ETF	433.63	433.8	433.48	433.76	239545.0
2023-06-22 07:10:00	SPY	ETF	433.8	433.8	433.57	433.65	31908.0
2023-06-22 07:15:00	SPY	ETF	433.58	433.8	433.51	433.8	19956.0
2023-06-22 07:20:00	SPY	ETF	433.84	433.96	433.79	433.79	5325.0
2023-06-22 07:25:00	SPY	ETF	433.73	433.74	433.66	433.74	11205.0
2023-06-22 07:30:00	SPY	ETF	433.58	433.91	433.55	433.91	6067.0
2023-06-22 07:35:00	SPY	ETF	433.89	433.89	433.83	433.87	1400.0
2023-06-22 07:40:00	SPY	ETF	433.86	433.91	433.8	433.91	7293.0
2023-06-22 07:45:00	SPY	ETF	433.94	433.95	433.86	433.95	6837.0
2023-06-22 07:50:00	SPY	ETF	433.94	434.07	433.94	434.07	5597.0
2023-06-22 07:55:00	SPY	ETF	434.02	434.02	433.88	434.02	15492.0
2023-06-22 08:00:00	SPY	ETF	433.8	434.94	433.56	433.98	45556.0
2023-06-22 08:05:00	SPY	ETF	433.95	434.03	433.91	434.03	7488.0
2023-06-22 08:10:00	SPY	ETF	434.06	434.1	433.97	433.97	28973.0

> showing 50 of 94,842 rows — these rows as CSV

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