PREVIEW / etf_5min / 2024-05-06

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-05-06.parquet
  size:    2.2 MB
  rows:    110,270

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
2024-05-06 04:00:00	SPY	ETF	511.93	511.95	511.85	511.92	5089.0
2024-05-06 04:05:00	SPY	ETF	511.96	511.96	511.91	511.91	325.0
2024-05-06 04:10:00	SPY	ETF	511.99	512.17	511.99	512.13	1532.0
2024-05-06 04:15:00	SPY	ETF	512.15	512.15	512.07	512.11	1769.0
2024-05-06 04:20:00	SPY	ETF	512.17	512.28	512.16	512.28	600.0
2024-05-06 04:25:00	SPY	ETF	512.28	512.37	512.26	512.37	2242.0
2024-05-06 04:30:00	SPY	ETF	512.37	512.47	512.34	512.44	625.0
2024-05-06 04:35:00	SPY	ETF	512.42	512.46	512.37	512.37	786.0
2024-05-06 04:40:00	SPY	ETF	512.33	512.33	512.33	512.33	579.0
2024-05-06 04:45:00	SPY	ETF	512.33	512.33	512.33	512.33	250.0
2024-05-06 04:50:00	SPY	ETF	512.32	512.32	512.32	512.32	911.0
2024-05-06 04:55:00	SPY	ETF	512.28	512.29	512.28	512.29	800.0
2024-05-06 05:00:00	SPY	ETF	512.38	512.42	512.38	512.42	1397.0
2024-05-06 05:05:00	SPY	ETF	512.45	512.45	512.45	512.45	225.0
2024-05-06 05:10:00	SPY	ETF	512.4	512.52	512.4	512.52	300.0
2024-05-06 05:15:00	SPY	ETF	512.47	512.48	512.47	512.48	300.0
2024-05-06 05:20:00	SPY	ETF	512.5	512.58	512.5	512.57	1349.0
2024-05-06 05:25:00	SPY	ETF	512.65	512.66	512.65	512.66	200.0
2024-05-06 05:30:00	SPY	ETF	512.61	512.66	512.61	512.66	700.0
2024-05-06 05:35:00	SPY	ETF	512.69	512.73	512.6	512.73	1908.0
2024-05-06 05:40:00	SPY	ETF	512.7	512.72	512.67	512.67	1224.0
2024-05-06 05:45:00	SPY	ETF	512.7	512.7	512.67	512.68	700.0
2024-05-06 05:50:00	SPY	ETF	512.7	512.72	512.7	512.72	875.0
2024-05-06 05:55:00	SPY	ETF	512.72	512.73	512.72	512.72	2003.0
2024-05-06 06:00:00	SPY	ETF	512.72	512.8	512.72	512.73	887.0
2024-05-06 06:05:00	SPY	ETF	512.77	512.89	512.77	512.89	5935.0
2024-05-06 06:10:00	SPY	ETF	512.85	512.85	512.82	512.82	319.0
2024-05-06 06:15:00	SPY	ETF	512.83	512.9	512.83	512.9	236.0
2024-05-06 06:20:00	SPY	ETF	512.92	512.95	512.91	512.94	4700.0
2024-05-06 06:25:00	SPY	ETF	512.91	512.91	512.91	512.91	314.0
2024-05-06 06:30:00	SPY	ETF	512.99	513.1	512.97	512.97	4417.0
2024-05-06 06:35:00	SPY	ETF	512.9	512.97	512.88	512.97	812.0
2024-05-06 06:40:00	SPY	ETF	512.93	512.99	512.93	512.99	4445.0
2024-05-06 06:45:00	SPY	ETF	512.99	512.99	512.96	512.98	4959.0
2024-05-06 06:50:00	SPY	ETF	512.98	512.98	512.98	512.98	4000.0
2024-05-06 06:55:00	SPY	ETF	513.1	513.35	513.09	513.27	10060.0
2024-05-06 07:00:00	SPY	ETF	513.23	513.23	512.65	513.05	87922.0
2024-05-06 07:05:00	SPY	ETF	513.05	513.15	513.02	513.11	10704.0
2024-05-06 07:10:00	SPY	ETF	513.1	513.1	513.05	513.06	1942.0
2024-05-06 07:15:00	SPY	ETF	513.06	513.09	512.96	513.09	11375.0
2024-05-06 07:20:00	SPY	ETF	513.11	513.11	512.99	513.03	2874.0
2024-05-06 07:25:00	SPY	ETF	513.06	513.12	513.06	513.11	3055.0
2024-05-06 07:30:00	SPY	ETF	513.12	513.13	513.06	513.06	3248.0
2024-05-06 07:35:00	SPY	ETF	513.02	513.09	513.0	513.09	839.0
2024-05-06 07:40:00	SPY	ETF	513.12	513.16	513.12	513.16	2200.0
2024-05-06 07:45:00	SPY	ETF	513.14	513.14	513.03	513.05	900.0
2024-05-06 07:50:00	SPY	ETF	513.03	513.16	513.02	513.16	4723.0
2024-05-06 07:55:00	SPY	ETF	513.07	513.11	513.07	513.11	3559.0
2024-05-06 08:00:00	SPY	ETF	513.02	513.3296	511.68	513.17	48203.0
2024-05-06 08:05:00	SPY	ETF	513.18	513.31	511.72	513.3	12375.0

> showing 50 of 110,270 rows — these rows as CSV

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