PREVIEW / etf_5min / 2024-07-17

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-07-17.parquet
  size:    2.4 MB
  rows:    118,616

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-07-17 04:00:00	SPY	ETF	562.5	562.5	561.01	561.32	21308.0
2024-07-17 04:05:00	SPY	ETF	561.14	561.14	560.85	560.88	1958.0
2024-07-17 04:10:00	SPY	ETF	560.98	560.98	560.37	560.37	2195.0
2024-07-17 04:15:00	SPY	ETF	560.53	560.53	560.29	560.36	3295.0
2024-07-17 04:20:00	SPY	ETF	560.25	560.36	560.13	560.13	1506.0
2024-07-17 04:25:00	SPY	ETF	560.17	560.36	560.15	560.27	9368.0
2024-07-17 04:30:00	SPY	ETF	560.4	560.52	560.4	560.5	5695.0
2024-07-17 04:35:00	SPY	ETF	560.47	560.6	560.37	560.37	8416.0
2024-07-17 04:40:00	SPY	ETF	560.36	560.38	560.3	560.3	751.0
2024-07-17 04:45:00	SPY	ETF	560.33	560.62	560.33	560.62	763.0
2024-07-17 04:50:00	SPY	ETF	560.77	560.9	560.77	560.88	1300.0
2024-07-17 04:55:00	SPY	ETF	560.78	560.78	560.71	560.71	770.0
2024-07-17 05:00:00	SPY	ETF	560.86	560.88	560.79	560.8	11078.0
2024-07-17 05:05:00	SPY	ETF	560.74	560.79	560.74	560.79	512.0
2024-07-17 05:10:00	SPY	ETF	560.89	560.99	560.88	560.88	3517.0
2024-07-17 05:15:00	SPY	ETF	560.88	560.88	560.83	560.88	1050.0
2024-07-17 05:20:00	SPY	ETF	560.93	560.93	560.82	560.82	248.0
2024-07-17 05:25:00	SPY	ETF	560.75	560.75	560.66	560.66	742.0
2024-07-17 05:30:00	SPY	ETF	560.62	560.62	560.47	560.47	3367.0
2024-07-17 05:40:00	SPY	ETF	560.79	560.79	560.79	560.79	230.0
2024-07-17 05:45:00	SPY	ETF	560.87	561.0	560.85	560.85	1397.0
2024-07-17 05:50:00	SPY	ETF	560.77	560.82	560.77	560.8	10372.0
2024-07-17 05:55:00	SPY	ETF	560.9	560.92	560.9	560.92	433.0
2024-07-17 06:00:00	SPY	ETF	560.88	560.96	560.88	560.9	1289.0
2024-07-17 06:05:00	SPY	ETF	560.9	560.96	560.9	560.92	758.0
2024-07-17 06:10:00	SPY	ETF	560.92	561.0	560.89	560.98	20300.0
2024-07-17 06:15:00	SPY	ETF	560.98	560.98	560.86	560.89	2413.0
2024-07-17 06:20:00	SPY	ETF	560.84	560.84	560.71	560.81	7327.0
2024-07-17 06:25:00	SPY	ETF	560.91	560.98	560.91	560.98	300.0
2024-07-17 06:30:00	SPY	ETF	560.81	560.99	560.81	560.99	600.0
2024-07-17 06:35:00	SPY	ETF	560.97	560.97	560.86	560.86	1380.0
2024-07-17 06:40:00	SPY	ETF	560.97	560.97	560.87	560.87	520.0
2024-07-17 06:45:00	SPY	ETF	560.94	560.94	560.77	560.77	15387.0
2024-07-17 06:50:00	SPY	ETF	560.66	560.66	560.29	560.41	3107.0
2024-07-17 06:55:00	SPY	ETF	560.29	560.43	560.18	560.43	17471.0
2024-07-17 07:00:00	SPY	ETF	560.42	560.65	560.1	560.11	22702.0
2024-07-17 07:05:00	SPY	ETF	560.04	560.08	559.62	559.78	123652.0
2024-07-17 07:10:00	SPY	ETF	559.75	559.93	559.58	559.61	61688.0
2024-07-17 07:15:00	SPY	ETF	559.57	559.59	559.25	559.32	40090.0
2024-07-17 07:20:00	SPY	ETF	559.3	559.37	559.07	559.1	68207.0
2024-07-17 07:25:00	SPY	ETF	559.05	559.28	559.05	559.21	32363.0
2024-07-17 07:30:00	SPY	ETF	559.21	559.25	558.8	558.8	41183.0
2024-07-17 07:35:00	SPY	ETF	558.84	559.03	558.8	559.03	21128.0
2024-07-17 07:40:00	SPY	ETF	559.12	559.33	558.93	559.25	23910.0
2024-07-17 07:45:00	SPY	ETF	559.22	559.53	559.17	559.36	113054.0
2024-07-17 07:50:00	SPY	ETF	559.4	559.55	559.33	559.51	11933.0
2024-07-17 07:55:00	SPY	ETF	559.54	559.73	559.53	559.6	19480.0
2024-07-17 08:00:00	SPY	ETF	559.57	564.18	558.87	562.7	118962.0
2024-07-17 08:05:00	SPY	ETF	559.51	562.0	559.3	559.41	51244.0
2024-07-17 08:10:00	SPY	ETF	559.44	559.8	559.44	559.79	51726.0

> showing 50 of 118,616 rows — these rows as CSV

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