PREVIEW / etf_5min / 2023-06-09

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-09.parquet
  size:    1.9 MB
  rows:    93,257

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-06-09 04:00:00	SPY	ETF	428.41	428.52	428.39	428.45	3021.0
2023-06-09 04:05:00	SPY	ETF	428.5	428.5	428.23	428.23	5077.0
2023-06-09 04:10:00	SPY	ETF	428.24	428.45	428.24	428.45	2900.0
2023-06-09 04:15:00	SPY	ETF	428.43	428.43	428.36	428.36	2586.0
2023-06-09 04:20:00	SPY	ETF	428.36	428.43	428.34	428.43	554.0
2023-06-09 04:25:00	SPY	ETF	428.43	428.55	428.43	428.55	3118.0
2023-06-09 04:30:00	SPY	ETF	428.62	428.62	428.41	428.41	2407.0
2023-06-09 04:35:00	SPY	ETF	428.5	428.54	428.5	428.54	1150.0
2023-06-09 04:40:00	SPY	ETF	428.5	428.59	428.5	428.54	1739.0
2023-06-09 04:45:00	SPY	ETF	428.56	428.65	428.56	428.64	4090.0
2023-06-09 04:50:00	SPY	ETF	428.67	428.77	428.67	428.74	2390.0
2023-06-09 04:55:00	SPY	ETF	428.79	428.87	428.79	428.87	2357.0
2023-06-09 05:00:00	SPY	ETF	428.84	429.13	428.84	429.13	2229.0
2023-06-09 05:05:00	SPY	ETF	429.14	429.14	429.03	429.1	3060.0
2023-06-09 05:10:00	SPY	ETF	429.08	429.08	429.07	429.07	612.0
2023-06-09 05:15:00	SPY	ETF	429.07	429.1	429.07	429.07	1400.0
2023-06-09 05:20:00	SPY	ETF	429.06	429.09	428.98	428.98	1456.0
2023-06-09 05:25:00	SPY	ETF	428.99	429.14	428.99	429.14	2115.0
2023-06-09 05:30:00	SPY	ETF	429.1	429.1	429.1	429.1	100.0
2023-06-09 05:35:00	SPY	ETF	428.92	428.92	428.92	428.92	100.0
2023-06-09 05:40:00	SPY	ETF	428.9	428.9	428.85	428.88	3318.0
2023-06-09 05:45:00	SPY	ETF	428.92	428.96	428.8	428.8	4143.0
2023-06-09 05:50:00	SPY	ETF	428.71	428.79	428.62	428.62	2613.0
2023-06-09 05:55:00	SPY	ETF	428.72	428.73	428.62	428.7	1930.0
2023-06-09 06:00:00	SPY	ETF	428.75	428.75	428.74	428.74	10980.0
2023-06-09 06:05:00	SPY	ETF	428.77	428.81	428.77	428.79	39391.0
2023-06-09 06:10:00	SPY	ETF	428.79	428.8	428.44	428.6	29245.0
2023-06-09 06:15:00	SPY	ETF	428.54	428.63	428.54	428.63	1833.0
2023-06-09 06:20:00	SPY	ETF	428.77	428.81	428.77	428.77	2259.0
2023-06-09 06:25:00	SPY	ETF	428.74	428.83	428.74	428.83	1100.0
2023-06-09 06:30:00	SPY	ETF	428.61	428.61	428.59	428.59	998.0
2023-06-09 06:35:00	SPY	ETF	428.55	428.55	428.55	428.55	132.0
2023-06-09 06:40:00	SPY	ETF	428.5	428.56	428.5	428.56	900.0
2023-06-09 06:45:00	SPY	ETF	428.53	428.72	428.51	428.72	3120.0
2023-06-09 06:50:00	SPY	ETF	428.71	428.79	428.71	428.79	1300.0
2023-06-09 06:55:00	SPY	ETF	428.75	428.75	428.65	428.7	6749.0
2023-06-09 07:00:00	SPY	ETF	428.7	428.8	428.7	428.79	4679.0
2023-06-09 07:05:00	SPY	ETF	428.72	428.79	428.72	428.79	982.0
2023-06-09 07:10:00	SPY	ETF	428.83	429.1	428.78	429.1	8898.0
2023-06-09 07:15:00	SPY	ETF	429.09	429.1	428.95	429.09	6694.0
2023-06-09 07:20:00	SPY	ETF	429.04	429.05	429.0	429.041	3750.0
2023-06-09 07:25:00	SPY	ETF	429.05	429.06	429.04	429.04	1398.0
2023-06-09 07:30:00	SPY	ETF	429.0	429.02	428.91	429.02	8114.0
2023-06-09 07:35:00	SPY	ETF	429.0	429.05	429.0	429.01	2796.0
2023-06-09 07:40:00	SPY	ETF	429.0	429.15	429.0	429.15	2941.0
2023-06-09 07:45:00	SPY	ETF	429.11	429.35	429.11	429.28	76484.0
2023-06-09 07:50:00	SPY	ETF	429.23	429.23	429.15	429.17	3459.0
2023-06-09 07:55:00	SPY	ETF	429.2	429.2	429.12	429.14	8419.0
2023-06-09 08:00:00	SPY	ETF	428.6703	429.33	428.0	429.25	136295.0
2023-06-09 08:05:00	SPY	ETF	429.22	429.41	429.2	429.41	11385.0

> showing 50 of 93,257 rows — these rows as CSV

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