PREVIEW / etf_5min / 2023-04-05

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-04-05.parquet
  size:    1.9 MB
  rows:    95,788

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-04-05 04:00:00	SPY	ETF	408.43	408.67	408.18	408.18	4584.0
2023-04-05 04:05:00	SPY	ETF	408.19	408.26	408.19	408.21	1230.0
2023-04-05 04:10:00	SPY	ETF	408.06	408.12	408.03	408.08	4007.0
2023-04-05 04:15:00	SPY	ETF	408.05	408.12	407.94	408.12	6460.0
2023-04-05 04:20:00	SPY	ETF	408.14	408.14	408.0	408.01	1014.0
2023-04-05 04:25:00	SPY	ETF	408.0	408.01	407.94	407.94	3109.0
2023-04-05 04:30:00	SPY	ETF	407.96	408.08	407.92	408.02	3412.0
2023-04-05 04:35:00	SPY	ETF	408.06	408.06	408.01	408.01	225.0
2023-04-05 04:40:00	SPY	ETF	408.06	408.11	408.06	408.09	3065.0
2023-04-05 04:45:00	SPY	ETF	407.86	407.98	407.76	407.8	7066.0
2023-04-05 04:50:00	SPY	ETF	407.82	408.01	407.79	407.97	8314.0
2023-04-05 04:55:00	SPY	ETF	408.03	408.03	407.94	407.95	13925.0
2023-04-05 05:00:00	SPY	ETF	407.94	408.11	407.94	408.1	38466.0
2023-04-05 05:05:00	SPY	ETF	408.18	408.34	408.17	408.34	7006.0
2023-04-05 05:15:00	SPY	ETF	408.28	408.28	408.1	408.1	2994.0
2023-04-05 05:20:00	SPY	ETF	408.0	408.0	407.9	407.9	1150.0
2023-04-05 05:25:00	SPY	ETF	407.87	407.87	407.86	407.86	436.0
2023-04-05 05:30:00	SPY	ETF	407.8	407.85	407.78	407.85	1479.0
2023-04-05 05:35:00	SPY	ETF	407.95	407.95	407.95	407.95	380.0
2023-04-05 05:40:00	SPY	ETF	407.94	407.94	407.82	407.9	1211.0
2023-04-05 05:45:00	SPY	ETF	408.05	408.05	408.0	408.0	600.0
2023-04-05 05:50:00	SPY	ETF	407.89	407.89	407.89	407.89	600.0
2023-04-05 05:55:00	SPY	ETF	407.81	407.86	407.81	407.86	1450.0
2023-04-05 06:00:00	SPY	ETF	407.86	407.95	407.74	407.95	304.0
2023-04-05 06:05:00	SPY	ETF	407.9	407.93	407.86	407.86	1054.0
2023-04-05 06:10:00	SPY	ETF	407.87	407.87	407.86	407.86	400.0
2023-04-05 06:15:00	SPY	ETF	408.03	408.04	407.92	407.97	1000.0
2023-04-05 06:20:00	SPY	ETF	408.0	408.0	407.95	407.95	900.0
2023-04-05 06:25:00	SPY	ETF	408.02	408.02	407.99	407.99	800.0
2023-04-05 06:30:00	SPY	ETF	408.06	408.06	408.0	408.0	1100.0
2023-04-05 06:35:00	SPY	ETF	407.93	408.0	407.89	407.97	1810.0
2023-04-05 06:40:00	SPY	ETF	408.06	408.08	408.02	408.08	708.0
2023-04-05 06:45:00	SPY	ETF	408.22	408.33	408.22	408.32	3154.0
2023-04-05 06:50:00	SPY	ETF	408.32	408.36	408.3	408.3	1232.0
2023-04-05 06:55:00	SPY	ETF	408.24	408.35	408.24	408.35	575.0
2023-04-05 07:00:00	SPY	ETF	408.32	408.46	408.29	408.35	23613.0
2023-04-05 07:05:00	SPY	ETF	408.38	408.4	408.25	408.25	6990.0
2023-04-05 07:10:00	SPY	ETF	408.3	408.34	408.24	408.27	10017.0
2023-04-05 07:15:00	SPY	ETF	408.28	408.3	408.2	408.29	4639.0
2023-04-05 07:20:00	SPY	ETF	408.3	408.42	408.3	408.42	5253.0
2023-04-05 07:25:00	SPY	ETF	408.43	408.48	408.43	408.46	10607.0
2023-04-05 07:30:00	SPY	ETF	408.5	408.66	408.5	408.63	12070.0
2023-04-05 07:35:00	SPY	ETF	408.66	408.66	408.55	408.55	745.0
2023-04-05 07:40:00	SPY	ETF	408.54	408.54	408.4	408.43	11101.0
2023-04-05 07:45:00	SPY	ETF	408.43	408.55	408.43	408.55	10388.0
2023-04-05 07:50:00	SPY	ETF	408.54	408.6	408.43	408.44	10922.0
2023-04-05 07:55:00	SPY	ETF	408.41	408.5	408.27	408.28	20197.0
2023-04-05 08:00:00	SPY	ETF	408.43	409.04	407.8204	408.48	44023.0
2023-04-05 08:05:00	SPY	ETF	408.5	408.52	408.34	408.36	15224.0
2023-04-05 08:10:00	SPY	ETF	408.35	408.35	408.24	408.25	2350.0

> showing 50 of 95,788 rows — these rows as CSV

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