PREVIEW / etf_5min / 2023-07-31

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-31.parquet
  size:    2.0 MB
  rows:    98,215

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-31 04:00:00	SPY	ETF	456.63	456.86	456.63	456.83	14270.0
2023-07-31 04:05:00	SPY	ETF	456.85	457.0	456.82	456.97	1900.0
2023-07-31 04:10:00	SPY	ETF	457.05	457.05	456.91	456.91	534.0
2023-07-31 04:15:00	SPY	ETF	456.82	456.95	456.8	456.95	888.0
2023-07-31 04:20:00	SPY	ETF	456.85	456.85	456.83	456.83	684.0
2023-07-31 04:25:00	SPY	ETF	456.76	456.84	456.76	456.84	334.0
2023-07-31 04:30:00	SPY	ETF	457.07	457.07	457.07	457.07	100.0
2023-07-31 04:35:00	SPY	ETF	457.04	457.04	457.03	457.03	2525.0
2023-07-31 04:40:00	SPY	ETF	457.03	457.15	457.03	457.08	1300.0
2023-07-31 04:45:00	SPY	ETF	457.13	457.13	457.13	457.13	125.0
2023-07-31 04:50:00	SPY	ETF	457.1	457.17	457.1	457.15	730.0
2023-07-31 04:55:00	SPY	ETF	457.18	457.29	457.18	457.29	1804.0
2023-07-31 05:00:00	SPY	ETF	457.32	457.32	457.28	457.31	1725.0
2023-07-31 05:05:00	SPY	ETF	457.35	457.43	457.35	457.39	2226.0
2023-07-31 05:10:00	SPY	ETF	457.34	457.34	457.23	457.23	425.0
2023-07-31 05:15:00	SPY	ETF	457.34	457.34	457.27	457.32	384.0
2023-07-31 05:20:00	SPY	ETF	457.32	457.32	457.3	457.3	503.0
2023-07-31 05:25:00	SPY	ETF	457.32	457.32	457.32	457.32	204.0
2023-07-31 05:30:00	SPY	ETF	457.27	457.27	457.11	457.11	471.0
2023-07-31 05:35:00	SPY	ETF	457.21	457.21	457.21	457.21	200.0
2023-07-31 05:40:00	SPY	ETF	457.2	457.22	457.12	457.12	800.0
2023-07-31 05:45:00	SPY	ETF	456.94	457.09	456.94	457.09	1775.0
2023-07-31 05:50:00	SPY	ETF	457.08	457.08	457.03	457.03	1280.0
2023-07-31 05:55:00	SPY	ETF	457.04	457.04	457.04	457.04	500.0
2023-07-31 06:00:00	SPY	ETF	457.07	457.07	457.07	457.07	500.0
2023-07-31 06:05:00	SPY	ETF	456.99	457.03	456.95	457.03	650.0
2023-07-31 06:10:00	SPY	ETF	457.1	457.1	457.06	457.06	200.0
2023-07-31 06:15:00	SPY	ETF	457.1	457.1	457.06	457.06	895.0
2023-07-31 06:20:00	SPY	ETF	457.2	457.21	457.09	457.2	1904.0
2023-07-31 06:25:00	SPY	ETF	457.22	457.23	457.22	457.23	624.0
2023-07-31 06:30:00	SPY	ETF	457.12	457.2	457.12	457.2	725.0
2023-07-31 06:35:00	SPY	ETF	457.2	457.22	457.2	457.22	1100.0
2023-07-31 06:40:00	SPY	ETF	457.21	457.27	457.21	457.27	325.0
2023-07-31 06:45:00	SPY	ETF	457.24	457.25	457.23	457.25	350.0
2023-07-31 06:50:00	SPY	ETF	457.32	457.32	457.32	457.32	125.0
2023-07-31 06:55:00	SPY	ETF	457.3	457.3	457.29	457.29	425.0
2023-07-31 07:00:00	SPY	ETF	457.32	457.42	457.32	457.42	3822.0
2023-07-31 07:05:00	SPY	ETF	457.42	457.46	457.41	457.44	14085.0
2023-07-31 07:10:00	SPY	ETF	457.45	457.57	457.441	457.5	29149.0
2023-07-31 07:15:00	SPY	ETF	457.56	457.56	457.43	457.46	3410.0
2023-07-31 07:20:00	SPY	ETF	457.45	457.45	457.34	457.41	10693.0
2023-07-31 07:25:00	SPY	ETF	457.48	457.51	457.39	457.51	20819.0
2023-07-31 07:30:00	SPY	ETF	457.5	457.5	457.35	457.35	12008.0
2023-07-31 07:35:00	SPY	ETF	457.39	457.5	457.36	457.43	1500.0
2023-07-31 07:40:00	SPY	ETF	457.45	457.49	457.45	457.45	5500.0
2023-07-31 07:45:00	SPY	ETF	457.45	457.52	457.43	457.52	11036.0
2023-07-31 07:50:00	SPY	ETF	457.5	457.619	457.49	457.619	9962.0
2023-07-31 07:55:00	SPY	ETF	457.619	457.63	457.59	457.63	4603.0
2023-07-31 08:00:00	SPY	ETF	457.3399	457.69	456.1	457.63	30263.0
2023-07-31 08:05:00	SPY	ETF	457.65	457.7	457.58	457.58	6053.0

> showing 50 of 98,215 rows — these rows as CSV

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