PREVIEW / etf_5min / 2023-04-19

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-04-19.parquet
  size:    1.9 MB
  rows:    93,969

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-19 04:00:00	SPY	ETF	413.09	413.09	412.9	413.03	9559.0
2023-04-19 04:05:00	SPY	ETF	413.01	413.01	412.85	412.87	1900.0
2023-04-19 04:10:00	SPY	ETF	412.8	412.81	412.32	412.32	3199.0
2023-04-19 04:15:00	SPY	ETF	412.33	412.47	412.32	412.45	1500.0
2023-04-19 04:20:00	SPY	ETF	412.47	412.65	412.47	412.65	5178.0
2023-04-19 04:25:00	SPY	ETF	412.64	412.72	412.63	412.67	2355.0
2023-04-19 04:30:00	SPY	ETF	412.66	412.74	412.59	412.59	5594.0
2023-04-19 04:35:00	SPY	ETF	412.59	412.65	412.57	412.6	2318.0
2023-04-19 04:40:00	SPY	ETF	412.72	412.72	412.6	412.62	620.0
2023-04-19 04:45:00	SPY	ETF	412.61	412.61	412.61	412.61	400.0
2023-04-19 04:50:00	SPY	ETF	412.69	412.72	412.64	412.64	1009.0
2023-04-19 04:55:00	SPY	ETF	412.64	412.64	412.64	412.64	500.0
2023-04-19 05:00:00	SPY	ETF	412.48	412.48	412.35	412.35	2364.0
2023-04-19 05:05:00	SPY	ETF	412.38	412.38	412.09	412.09	7442.0
2023-04-19 05:10:00	SPY	ETF	412.04	412.05	411.98	411.98	1671.0
2023-04-19 05:15:00	SPY	ETF	412.2	412.24	412.2	412.21	1626.0
2023-04-19 05:20:00	SPY	ETF	412.26	412.4	412.21	412.4	11371.0
2023-04-19 05:25:00	SPY	ETF	412.4	412.44	412.22	412.26	3009.0
2023-04-19 05:30:00	SPY	ETF	412.17	412.17	411.98	412.15	1048.0
2023-04-19 05:35:00	SPY	ETF	412.08	412.18	412.07	412.16	1900.0
2023-04-19 05:40:00	SPY	ETF	412.22	412.25	411.99	411.99	13000.0
2023-04-19 05:45:00	SPY	ETF	412.01	412.01	411.82	411.82	2000.0
2023-04-19 05:50:00	SPY	ETF	411.84	411.91	411.7	411.7	5975.0
2023-04-19 05:55:00	SPY	ETF	411.69	411.74	411.69	411.74	607.0
2023-04-19 06:00:00	SPY	ETF	411.84	411.89	411.82	411.89	1400.0
2023-04-19 06:05:00	SPY	ETF	411.91	411.91	411.83	411.83	1658.0
2023-04-19 06:10:00	SPY	ETF	411.8	411.88	411.8	411.88	2070.0
2023-04-19 06:15:00	SPY	ETF	411.82	411.92	411.8	411.92	2313.0
2023-04-19 06:20:00	SPY	ETF	411.77	411.9	411.77	411.9	1933.0
2023-04-19 06:25:00	SPY	ETF	411.98	412.05	411.98	412.0	1941.0
2023-04-19 06:30:00	SPY	ETF	412.11	412.2	412.11	412.16	3699.0
2023-04-19 06:35:00	SPY	ETF	412.16	412.16	411.9	411.9	18367.0
2023-04-19 06:40:00	SPY	ETF	411.96	412.07	411.88	412.07	5844.0
2023-04-19 06:45:00	SPY	ETF	412.07	412.23	412.03	412.03	4788.0
2023-04-19 06:50:00	SPY	ETF	412.13	412.2	412.1	412.2	2989.0
2023-04-19 06:55:00	SPY	ETF	412.2	412.29	412.2	412.29	5266.0
2023-04-19 07:00:00	SPY	ETF	412.3	412.34	412.13	412.19	15939.0
2023-04-19 07:05:00	SPY	ETF	412.15	412.3	412.12	412.29	4662.0
2023-04-19 07:10:00	SPY	ETF	412.23	412.28	412.15	412.27	9540.0
2023-04-19 07:15:00	SPY	ETF	412.2	412.28	412.18	412.18	10962.0
2023-04-19 07:20:00	SPY	ETF	412.15	412.2	412.09	412.16	10047.0
2023-04-19 07:25:00	SPY	ETF	412.16	412.31	412.05	412.28	13442.0
2023-04-19 07:30:00	SPY	ETF	412.28	412.55	412.28	412.52	21175.0
2023-04-19 07:35:00	SPY	ETF	412.49	412.51	412.44	412.47	11326.0
2023-04-19 07:40:00	SPY	ETF	412.49	412.5	412.36	412.45	12122.0
2023-04-19 07:45:00	SPY	ETF	412.37	412.44	412.0	412.02	35083.0
2023-04-19 07:50:00	SPY	ETF	412.02	412.28	412.01	412.28	23409.0
2023-04-19 07:55:00	SPY	ETF	412.25	412.25	412.11	412.14	8136.0
2023-04-19 08:00:00	SPY	ETF	412.33	413.85	411.75	411.8	133937.0
2023-04-19 08:05:00	SPY	ETF	411.78	411.92	411.78	411.89	23522.0

> showing 50 of 93,969 rows — these rows as CSV

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