PREVIEW / etf_5min / 2024-08-06

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-08-06.parquet
  size:    2.5 MB
  rows:    126,571

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-08-06 04:00:00	SPY	ETF	523.91	523.91	522.07	522.1	10137.0
2024-08-06 04:05:00	SPY	ETF	522.01	522.2	521.43	521.57	7904.0
2024-08-06 04:10:00	SPY	ETF	521.55	521.77	520.55	520.63	4260.0
2024-08-06 04:15:00	SPY	ETF	520.86	521.14	520.42	520.59	5427.0
2024-08-06 04:20:00	SPY	ETF	520.62	521.14	520.62	521.14	858.0
2024-08-06 04:25:00	SPY	ETF	521.39	521.67	521.39	521.62	857.0
2024-08-06 04:30:00	SPY	ETF	521.94	522.14	521.74	521.79	3636.0
2024-08-06 04:35:00	SPY	ETF	521.77	521.77	521.24	521.24	2039.0
2024-08-06 04:40:00	SPY	ETF	521.26	521.61	521.14	521.61	309.0
2024-08-06 04:45:00	SPY	ETF	521.38	521.59	521.16	521.59	833.0
2024-08-06 04:50:00	SPY	ETF	521.99	522.25	521.88	522.25	2259.0
2024-08-06 04:55:00	SPY	ETF	522.31	522.31	521.43	521.43	700.0
2024-08-06 05:00:00	SPY	ETF	521.23	521.23	519.52	519.52	4736.0
2024-08-06 05:05:00	SPY	ETF	519.84	520.3	519.65	520.13	2991.0
2024-08-06 05:10:00	SPY	ETF	520.29	520.3	519.54	519.92	3495.0
2024-08-06 05:15:00	SPY	ETF	519.72	519.73	518.97	519.73	21623.0
2024-08-06 05:20:00	SPY	ETF	520.08	520.29	520.04	520.11	7679.0
2024-08-06 05:25:00	SPY	ETF	520.24	520.51	520.01	520.4	15045.0
2024-08-06 05:30:00	SPY	ETF	520.01	520.01	519.17	519.2	4708.0
2024-08-06 05:35:00	SPY	ETF	518.93	519.02	518.6	518.6	7232.0
2024-08-06 05:40:00	SPY	ETF	518.56	519.68	518.5	519.66	6084.0
2024-08-06 05:45:00	SPY	ETF	519.31	519.6	519.0	519.25	5551.0
2024-08-06 05:50:00	SPY	ETF	519.0	519.4	518.93	519.36	3697.0
2024-08-06 05:55:00	SPY	ETF	519.56	520.1	519.56	519.88	8499.0
2024-08-06 06:00:00	SPY	ETF	519.5	519.97	519.5	519.6	6184.0
2024-08-06 06:05:00	SPY	ETF	519.19	519.5	519.0	519.5	3738.0
2024-08-06 06:10:00	SPY	ETF	519.55	520.19	519.55	520.19	2532.0
2024-08-06 06:15:00	SPY	ETF	520.34	520.34	519.9	519.9	1109.0
2024-08-06 06:20:00	SPY	ETF	519.85	519.93	519.64	519.66	2860.0
2024-08-06 06:25:00	SPY	ETF	519.9	520.51	519.88	520.35	1980.0
2024-08-06 06:30:00	SPY	ETF	520.49	521.35	520.49	521.0	20703.0
2024-08-06 06:35:00	SPY	ETF	521.48	521.76	521.24	521.46	2376.0
2024-08-06 06:40:00	SPY	ETF	521.73	522.06	521.35	521.35	8276.0
2024-08-06 06:45:00	SPY	ETF	521.27	521.96	521.25	521.96	3583.0
2024-08-06 06:50:00	SPY	ETF	522.0	522.08	521.93	521.93	2954.0
2024-08-06 06:55:00	SPY	ETF	522.02	522.17	521.54	521.82	11148.0
2024-08-06 07:00:00	SPY	ETF	521.88	522.43	521.74	521.9	156046.0
2024-08-06 07:05:00	SPY	ETF	521.98	522.51	521.98	522.34	33765.0
2024-08-06 07:10:00	SPY	ETF	522.4	522.44	522.0	522.0	20104.0
2024-08-06 07:15:00	SPY	ETF	522.259	522.3	521.94	522.05	14846.0
2024-08-06 07:20:00	SPY	ETF	521.91	522.22	521.87	521.87	19549.0
2024-08-06 07:25:00	SPY	ETF	521.92	522.5	521.86	522.5	8645.0
2024-08-06 07:30:00	SPY	ETF	522.73	523.12	521.86	522.34	25680.0
2024-08-06 07:35:00	SPY	ETF	522.3	522.3	521.91	521.93	3040.0
2024-08-06 07:40:00	SPY	ETF	521.9	521.9	520.99	521.03	42683.0
2024-08-06 07:45:00	SPY	ETF	521.15	521.15	520.41	521.08	65933.0
2024-08-06 07:50:00	SPY	ETF	521.21	521.44	520.92	521.12	30340.0
2024-08-06 07:55:00	SPY	ETF	521.5	521.65	521.27	521.54	22063.0
2024-08-06 08:00:00	SPY	ETF	522.49	525.5	518.8096	521.56	64713.0
2024-08-06 08:05:00	SPY	ETF	521.56	521.56	520.56	521.12	43963.0

> showing 50 of 126,571 rows — these rows as CSV

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