PREVIEW / etf_5min / 2023-05-26

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-05-26.parquet
  size:    2.0 MB
  rows:    95,360

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-05-26 04:00:00	SPY	ETF	413.84	414.19	413.8	414.15	2600.0
2023-05-26 04:05:00	SPY	ETF	414.03	414.14	414.03	414.11	1300.0
2023-05-26 04:10:00	SPY	ETF	414.16	414.16	414.16	414.16	100.0
2023-05-26 04:15:00	SPY	ETF	414.3	414.3	414.3	414.3	100.0
2023-05-26 04:20:00	SPY	ETF	414.32	414.49	414.32	414.39	2500.0
2023-05-26 04:25:00	SPY	ETF	414.41	414.41	414.26	414.29	1121.0
2023-05-26 04:30:00	SPY	ETF	414.32	414.32	414.32	414.32	107.0
2023-05-26 04:35:00	SPY	ETF	414.12	414.14	414.12	414.14	463.0
2023-05-26 04:40:00	SPY	ETF	414.15	414.4	414.15	414.4	1457.0
2023-05-26 04:45:00	SPY	ETF	414.5	414.5	414.45	414.45	1444.0
2023-05-26 04:50:00	SPY	ETF	414.39	414.48	414.39	414.48	905.0
2023-05-26 05:00:00	SPY	ETF	414.4	414.4	414.4	414.4	400.0
2023-05-26 05:05:00	SPY	ETF	414.33	414.33	414.18	414.18	327.0
2023-05-26 05:10:00	SPY	ETF	414.15	414.15	413.91	413.94	4900.0
2023-05-26 05:15:00	SPY	ETF	413.86	414.09	413.86	414.09	3099.0
2023-05-26 05:20:00	SPY	ETF	414.05	414.16	414.05	414.15	1368.0
2023-05-26 05:30:00	SPY	ETF	413.98	414.04	413.84	414.03	1696.0
2023-05-26 05:35:00	SPY	ETF	414.1	414.15	414.1	414.12	547.0
2023-05-26 05:45:00	SPY	ETF	414.0	414.0	414.0	414.0	1200.0
2023-05-26 05:55:00	SPY	ETF	414.02	414.15	414.02	414.12	47924.0
2023-05-26 06:00:00	SPY	ETF	414.1	414.1	413.93	414.05	54651.0
2023-05-26 06:10:00	SPY	ETF	413.89	414.0	413.89	414.0	2280.0
2023-05-26 06:15:00	SPY	ETF	414.0	414.2	413.97	414.2	1550.0
2023-05-26 06:20:00	SPY	ETF	414.24	414.32	414.24	414.24	3800.0
2023-05-26 06:25:00	SPY	ETF	414.36	414.57	414.33	414.57	9453.0
2023-05-26 06:30:00	SPY	ETF	414.51	414.78	414.47	414.78	5250.0
2023-05-26 06:35:00	SPY	ETF	414.74	415.05	414.74	415.03	7816.0
2023-05-26 06:40:00	SPY	ETF	415.02	415.2	415.01	415.2	7984.0
2023-05-26 06:45:00	SPY	ETF	415.32	415.35	415.19	415.19	9400.0
2023-05-26 06:50:00	SPY	ETF	415.33	415.4	415.3	415.38	7989.0
2023-05-26 06:55:00	SPY	ETF	415.4	415.51	415.3	415.34	2446.0
2023-05-26 07:00:00	SPY	ETF	415.44	415.61	415.4	415.5	9558.0
2023-05-26 07:05:00	SPY	ETF	415.55	415.57	415.45	415.47	2700.0
2023-05-26 07:10:00	SPY	ETF	415.44	415.5	415.4	415.4	2076.0
2023-05-26 07:15:00	SPY	ETF	415.36	415.53	415.33	415.44	5523.0
2023-05-26 07:20:00	SPY	ETF	415.45	415.57	415.39	415.57	3364.0
2023-05-26 07:25:00	SPY	ETF	415.64	415.72	415.54	415.7	21481.0
2023-05-26 07:30:00	SPY	ETF	415.62	415.7	415.61	415.7	1850.0
2023-05-26 07:35:00	SPY	ETF	415.67	415.67	415.57	415.57	37720.0
2023-05-26 07:40:00	SPY	ETF	415.59	415.67	415.58	415.58	18175.0
2023-05-26 07:45:00	SPY	ETF	415.54	415.71	415.48	415.68	8085.0
2023-05-26 07:50:00	SPY	ETF	415.7	415.84	415.63	415.63	15973.0
2023-05-26 07:55:00	SPY	ETF	415.64	415.74	415.58	415.71	8773.0
2023-05-26 08:00:00	SPY	ETF	415.4893	415.83	413.81	415.71	40530.0
2023-05-26 08:05:00	SPY	ETF	415.64	415.64	415.37	415.37	13288.0
2023-05-26 08:10:00	SPY	ETF	415.37	415.56	415.37	415.51	10896.0
2023-05-26 08:15:00	SPY	ETF	415.48	415.48	415.42	415.42	7275.0
2023-05-26 08:20:00	SPY	ETF	415.4701	415.57	415.4101	415.51	3877.0
2023-05-26 08:25:00	SPY	ETF	415.41	415.48	415.36	415.47	16756.0
2023-05-26 08:30:00	SPY	ETF	415.44	415.9	414.78	414.95	156451.0

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

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