PREVIEW / etf_5min / 2023-01-20

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-01-20.parquet
  size:    2.0 MB
  rows:    94,873

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-01-20 04:00:00	SPY	ETF	389.37	389.42	389.22	389.22	1365.0
2023-01-20 04:05:00	SPY	ETF	389.15	389.15	388.78	388.85	10745.0
2023-01-20 04:10:00	SPY	ETF	388.87	388.87	388.65	388.66	1956.0
2023-01-20 04:15:00	SPY	ETF	388.72	389.17	388.72	389.17	1059.0
2023-01-20 04:20:00	SPY	ETF	389.44	389.46	389.28	389.28	600.0
2023-01-20 04:25:00	SPY	ETF	389.44	389.44	389.28	389.28	1400.0
2023-01-20 04:30:00	SPY	ETF	389.23	389.39	389.2	389.36	1466.0
2023-01-20 04:35:00	SPY	ETF	389.36	389.36	389.28	389.28	1600.0
2023-01-20 04:40:00	SPY	ETF	389.25	389.25	389.12	389.15	3300.0
2023-01-20 04:45:00	SPY	ETF	389.1	389.1	388.98	388.98	3725.0
2023-01-20 04:50:00	SPY	ETF	388.99	389.14	388.99	389.13	1910.0
2023-01-20 04:55:00	SPY	ETF	389.0	389.0	388.79	388.8	4264.0
2023-01-20 05:00:00	SPY	ETF	388.76	388.76	388.62	388.62	3328.0
2023-01-20 05:05:00	SPY	ETF	388.68	388.69	388.5	388.57	4218.0
2023-01-20 05:10:00	SPY	ETF	388.52	388.98	388.36	388.98	2621.0
2023-01-20 05:15:00	SPY	ETF	388.98	389.19	388.98	389.19	4284.0
2023-01-20 05:20:00	SPY	ETF	389.12	389.12	389.05	389.05	3800.0
2023-01-20 05:25:00	SPY	ETF	388.95	388.95	388.83	388.85	11268.0
2023-01-20 05:30:00	SPY	ETF	389.03	389.22	389.01	389.22	3601.0
2023-01-20 05:35:00	SPY	ETF	389.26	389.26	389.06	389.06	10874.0
2023-01-20 05:40:00	SPY	ETF	389.09	389.09	388.8	388.8	6445.0
2023-01-20 05:45:00	SPY	ETF	388.89	389.15	388.89	389.14	8876.0
2023-01-20 05:50:00	SPY	ETF	389.3	389.3	389.26	389.26	1477.0
2023-01-20 05:55:00	SPY	ETF	389.19	389.43	389.16	389.42	3494.0
2023-01-20 06:00:00	SPY	ETF	389.3	389.3	388.95	388.95	5750.0
2023-01-20 06:05:00	SPY	ETF	389.04	389.14	389.02	389.04	1369.0
2023-01-20 06:10:00	SPY	ETF	389.02	389.02	389.02	389.02	1000.0
2023-01-20 06:15:00	SPY	ETF	389.02	389.02	389.02	389.02	3000.0
2023-01-20 06:20:00	SPY	ETF	389.01	389.01	388.88	388.88	2118.0
2023-01-20 06:25:00	SPY	ETF	388.8	388.82	388.74	388.82	3700.0
2023-01-20 06:30:00	SPY	ETF	389.09	389.29	389.03	389.24	4061.0
2023-01-20 06:35:00	SPY	ETF	389.2	389.2	389.04	389.04	1895.0
2023-01-20 06:40:00	SPY	ETF	389.0	389.04	388.98	389.04	2065.0
2023-01-20 06:45:00	SPY	ETF	389.13	389.13	389.02	389.02	1000.0
2023-01-20 06:50:00	SPY	ETF	388.92	388.92	388.92	388.92	500.0
2023-01-20 06:55:00	SPY	ETF	388.92	389.19	388.9	389.05	3645.0
2023-01-20 07:00:00	SPY	ETF	389.05	389.06	388.89	388.92	4675.0
2023-01-20 07:05:00	SPY	ETF	388.93	389.07	388.85	388.97	7043.0
2023-01-20 07:10:00	SPY	ETF	389.05	389.24	389.05	389.24	4844.0
2023-01-20 07:15:00	SPY	ETF	389.24	389.25	389.03	389.03	6082.0
2023-01-20 07:20:00	SPY	ETF	389.14	389.19	388.96	389.03	6311.0
2023-01-20 07:25:00	SPY	ETF	389.02	389.27	389.02	389.2	25559.0
2023-01-20 07:30:00	SPY	ETF	389.28	389.52	389.28	389.51	27449.0
2023-01-20 07:35:00	SPY	ETF	389.52	389.691	389.52	389.69	15262.0
2023-01-20 07:40:00	SPY	ETF	389.71	389.96	389.68	389.78	30702.0
2023-01-20 07:45:00	SPY	ETF	389.8	389.95	389.77	389.9	17578.0
2023-01-20 07:50:00	SPY	ETF	389.93	390.02	389.81	389.98	16710.0
2023-01-20 07:55:00	SPY	ETF	389.94	390.03	389.83	389.83	47472.0
2023-01-20 08:00:00	SPY	ETF	389.07	390.18	388.6204	390.05	150131.0
2023-01-20 08:05:00	SPY	ETF	389.96	390.2	389.93	389.95	24062.0

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

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