PREVIEW / etf_5min / 2023-02-01

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-02-01.parquet
  size:    2.1 MB
  rows:    104,644

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-02-01 04:00:00	SPY	ETF	405.23	405.24	404.9	405.09	16246.0
2023-02-01 04:05:00	SPY	ETF	405.09	405.09	405.09	405.09	200.0
2023-02-01 04:10:00	SPY	ETF	405.19	405.2	405.06	405.06	2501.0
2023-02-01 04:15:00	SPY	ETF	405.18	405.31	405.14	405.27	2607.0
2023-02-01 04:20:00	SPY	ETF	405.32	405.32	405.24	405.24	701.0
2023-02-01 04:25:00	SPY	ETF	405.28	405.3	405.26	405.26	683.0
2023-02-01 04:30:00	SPY	ETF	405.04	405.04	404.85	404.95	3265.0
2023-02-01 04:35:00	SPY	ETF	404.97	405.02	404.97	405.02	1968.0
2023-02-01 04:40:00	SPY	ETF	405.0	405.03	404.96	404.96	1000.0
2023-02-01 04:45:00	SPY	ETF	404.92	405.1	404.92	405.1	3225.0
2023-02-01 04:50:00	SPY	ETF	405.14	405.16	405.1	405.1	1990.0
2023-02-01 04:55:00	SPY	ETF	405.07	405.07	404.87	404.87	400.0
2023-02-01 05:00:00	SPY	ETF	404.96	405.15	404.9	404.9	3050.0
2023-02-01 05:05:00	SPY	ETF	405.0	405.0	404.97	404.97	700.0
2023-02-01 05:10:00	SPY	ETF	404.8	404.85	404.69	404.69	4134.0
2023-02-01 05:15:00	SPY	ETF	404.71	404.8	404.68	404.8	2673.0
2023-02-01 05:20:00	SPY	ETF	404.8	404.92	404.74	404.74	2884.0
2023-02-01 05:25:00	SPY	ETF	404.82	404.87	404.82	404.85	1226.0
2023-02-01 05:30:00	SPY	ETF	404.75	404.81	404.75	404.81	1000.0
2023-02-01 05:35:00	SPY	ETF	404.68	404.7	404.65	404.68	1489.0
2023-02-01 05:40:00	SPY	ETF	404.66	404.74	404.61	404.74	1500.0
2023-02-01 05:45:00	SPY	ETF	404.79	404.79	404.7	404.71	500.0
2023-02-01 05:50:00	SPY	ETF	404.69	404.81	404.69	404.81	2400.0
2023-02-01 05:55:00	SPY	ETF	404.86	404.86	404.74	404.8	700.0
2023-02-01 06:00:00	SPY	ETF	404.8	404.9	404.8	404.9	2401.0
2023-02-01 06:05:00	SPY	ETF	404.88	404.88	404.69	404.75	1500.0
2023-02-01 06:10:00	SPY	ETF	404.79	404.86	404.79	404.8	811.0
2023-02-01 06:15:00	SPY	ETF	404.87	405.0	404.87	405.0	3659.0
2023-02-01 06:20:00	SPY	ETF	405.04	405.19	405.04	405.19	3761.0
2023-02-01 06:25:00	SPY	ETF	405.18	405.22	405.1	405.21	2281.0
2023-02-01 06:30:00	SPY	ETF	405.18	405.23	405.12	405.23	9300.0
2023-02-01 06:35:00	SPY	ETF	405.23	405.32	405.12	405.15	21345.0
2023-02-01 06:40:00	SPY	ETF	405.15	405.25	405.13	405.22	9899.0
2023-02-01 06:45:00	SPY	ETF	405.22	405.25	405.1	405.12	1600.0
2023-02-01 06:50:00	SPY	ETF	405.11	405.17	405.11	405.17	500.0
2023-02-01 06:55:00	SPY	ETF	405.18	405.25	405.18	405.25	2200.0
2023-02-01 07:00:00	SPY	ETF	405.22	405.29	405.11	405.26	34492.0
2023-02-01 07:05:00	SPY	ETF	405.36	405.47	405.3	405.47	19397.0
2023-02-01 07:10:00	SPY	ETF	405.52	405.7	405.43	405.64	22148.0
2023-02-01 07:15:00	SPY	ETF	405.66	405.66	405.52	405.64	10906.0
2023-02-01 07:20:00	SPY	ETF	405.631	405.9	405.63	405.85	16762.0
2023-02-01 07:25:00	SPY	ETF	405.82	405.82	405.7	405.77	11643.0
2023-02-01 07:30:00	SPY	ETF	405.75	405.87	405.7	405.82	16123.0
2023-02-01 07:35:00	SPY	ETF	405.83	405.88	405.72	405.8	9149.0
2023-02-01 07:40:00	SPY	ETF	405.85	405.86	405.75	405.75	14872.0
2023-02-01 07:45:00	SPY	ETF	405.8	405.83	405.64	405.64	6358.0
2023-02-01 07:50:00	SPY	ETF	405.51	405.69	405.39	405.69	33014.0
2023-02-01 07:55:00	SPY	ETF	405.7	405.86	405.7	405.76	10397.0
2023-02-01 08:00:00	SPY	ETF	405.3799	405.89	404.83	405.45	32603.0
2023-02-01 08:05:00	SPY	ETF	405.47	405.55	405.43	405.52	24524.0

> showing 50 of 104,644 rows — these rows as CSV

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