PREVIEW / etf_5min / 2023-07-28

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-28.parquet
  size:    2.0 MB
  rows:    96,341

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-07-28 04:00:00	SPY	ETF	454.21	454.26	454.1	454.25	2722.0
2023-07-28 04:05:00	SPY	ETF	454.34	454.34	454.22	454.22	1174.0
2023-07-28 04:10:00	SPY	ETF	454.16	454.16	454.16	454.16	212.0
2023-07-28 04:20:00	SPY	ETF	454.01	454.01	453.8	453.8	9440.0
2023-07-28 04:25:00	SPY	ETF	453.7	453.7	453.65	453.65	450.0
2023-07-28 04:30:00	SPY	ETF	453.7	453.87	453.7	453.87	280.0
2023-07-28 04:35:00	SPY	ETF	454.05	454.05	454.05	454.05	100.0
2023-07-28 04:40:00	SPY	ETF	454.03	454.03	453.98	453.98	500.0
2023-07-28 04:45:00	SPY	ETF	453.93	454.05	453.92	454.04	5209.0
2023-07-28 04:50:00	SPY	ETF	454.0	454.0	453.97	453.97	500.0
2023-07-28 04:55:00	SPY	ETF	454.11	454.11	454.05	454.11	1901.0
2023-07-28 05:00:00	SPY	ETF	454.14	454.14	454.04	454.08	551.0
2023-07-28 05:05:00	SPY	ETF	454.02	454.08	454.0	454.08	648.0
2023-07-28 05:10:00	SPY	ETF	454.08	454.08	454.08	454.08	400.0
2023-07-28 05:15:00	SPY	ETF	454.05	454.19	454.05	454.19	332.0
2023-07-28 05:20:00	SPY	ETF	454.27	454.28	454.21	454.21	12250.0
2023-07-28 05:25:00	SPY	ETF	454.28	454.28	454.06	454.12	9284.0
2023-07-28 05:30:00	SPY	ETF	454.19	454.21	454.16	454.16	600.0
2023-07-28 05:35:00	SPY	ETF	454.33	454.43	454.33	454.43	24305.0
2023-07-28 05:40:00	SPY	ETF	454.47	454.57	454.44	454.5	10114.0
2023-07-28 05:45:00	SPY	ETF	454.56	454.67	454.55	454.67	16846.0
2023-07-28 05:50:00	SPY	ETF	454.68	454.72	454.55	454.55	3313.0
2023-07-28 05:55:00	SPY	ETF	454.6	454.6	454.48	454.57	4653.0
2023-07-28 06:00:00	SPY	ETF	454.64	454.64	454.46	454.49	1351.0
2023-07-28 06:05:00	SPY	ETF	454.45	454.6	454.45	454.6	1850.0
2023-07-28 06:10:00	SPY	ETF	454.64	454.64	454.54	454.54	2300.0
2023-07-28 06:15:00	SPY	ETF	454.54	454.54	454.43	454.43	3724.0
2023-07-28 06:20:00	SPY	ETF	454.39	454.45	454.39	454.45	245.0
2023-07-28 06:25:00	SPY	ETF	454.37	454.46	454.37	454.42	1531.0
2023-07-28 06:30:00	SPY	ETF	454.45	454.45	454.12	454.17	3327.0
2023-07-28 06:35:00	SPY	ETF	454.17	454.2	454.14	454.15	450.0
2023-07-28 06:40:00	SPY	ETF	454.14	454.32	454.14	454.32	1987.0
2023-07-28 06:45:00	SPY	ETF	454.29	454.4	454.29	454.33	825.0
2023-07-28 06:50:00	SPY	ETF	454.5	454.6	454.45	454.52	11332.0
2023-07-28 06:55:00	SPY	ETF	454.52	454.57	454.44	454.5	41775.0
2023-07-28 07:00:00	SPY	ETF	454.48	454.51	454.0	454.4	67325.0
2023-07-28 07:05:00	SPY	ETF	454.45	454.57	454.45	454.51	7404.0
2023-07-28 07:10:00	SPY	ETF	454.54	454.68	454.5	454.64	10687.0
2023-07-28 07:15:00	SPY	ETF	454.64	454.87	454.64	454.83	20455.0
2023-07-28 07:20:00	SPY	ETF	454.84	454.84	454.7	454.77	15475.0
2023-07-28 07:25:00	SPY	ETF	454.83	454.9	454.8	454.85	19115.0
2023-07-28 07:30:00	SPY	ETF	454.85	454.96	454.8	454.85	20564.0
2023-07-28 07:35:00	SPY	ETF	454.85	455.029	454.81	455.029	5393.0
2023-07-28 07:40:00	SPY	ETF	454.85	455.02	454.76	455.02	18086.0
2023-07-28 07:45:00	SPY	ETF	454.99	455.06	454.93	455.06	17042.0
2023-07-28 07:50:00	SPY	ETF	455.05	455.13	454.92	455.1	29491.0
2023-07-28 07:55:00	SPY	ETF	455.07	455.11	455.0	455.05	9908.0
2023-07-28 08:00:00	SPY	ETF	454.73	455.33	452.17	455.3	53419.0
2023-07-28 08:05:00	SPY	ETF	455.31	455.329	455.15	455.25	9815.0
2023-07-28 08:10:00	SPY	ETF	455.25	455.29	455.06	455.09	24335.0

> showing 50 of 96,341 rows — these rows as CSV

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