PREVIEW / etf_5min / 2023-06-16

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-16.parquet
  size:    2.0 MB
  rows:    96,110

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-16 04:00:00	SPY	ETF	440.77	441.24	440.64	440.7	24756.0
2023-06-16 04:05:00	SPY	ETF	440.67	440.67	440.56	440.64	15842.0
2023-06-16 04:10:00	SPY	ETF	440.63	440.67	440.59	440.62	3581.0
2023-06-16 04:15:00	SPY	ETF	440.58	440.83	440.58	440.81	4262.0
2023-06-16 04:20:00	SPY	ETF	440.83	440.94	440.8	440.93	3771.0
2023-06-16 04:25:00	SPY	ETF	440.91	441.18	440.91	441.15	4307.0
2023-06-16 04:30:00	SPY	ETF	441.18	441.41	441.16	441.41	10020.0
2023-06-16 04:35:00	SPY	ETF	441.26	441.35	441.26	441.35	4380.0
2023-06-16 04:40:00	SPY	ETF	441.4	441.5	441.39	441.5	1770.0
2023-06-16 04:45:00	SPY	ETF	441.53	441.58	441.33	441.33	10902.0
2023-06-16 04:50:00	SPY	ETF	441.34	441.35	441.25	441.35	2254.0
2023-06-16 04:55:00	SPY	ETF	441.47	441.47	441.39	441.47	2979.0
2023-06-16 05:00:00	SPY	ETF	441.49	441.6	441.49	441.6	1764.0
2023-06-16 05:05:00	SPY	ETF	441.6	441.61	441.47	441.54	8443.0
2023-06-16 05:10:00	SPY	ETF	441.54	441.54	441.41	441.41	2400.0
2023-06-16 05:15:00	SPY	ETF	441.46	441.46	441.35	441.43	3679.0
2023-06-16 05:20:00	SPY	ETF	441.46	441.46	441.38	441.42	1850.0
2023-06-16 05:25:00	SPY	ETF	441.4	441.4	441.3	441.3	4237.0
2023-06-16 05:30:00	SPY	ETF	441.27	441.34	441.27	441.34	900.0
2023-06-16 05:35:00	SPY	ETF	441.33	441.35	441.27	441.27	6599.0
2023-06-16 05:40:00	SPY	ETF	441.29	441.4	441.29	441.39	1700.0
2023-06-16 05:45:00	SPY	ETF	441.45	441.45	441.34	441.41	1500.0
2023-06-16 05:50:00	SPY	ETF	441.41	441.41	441.22	441.22	1136.0
2023-06-16 05:55:00	SPY	ETF	441.29	441.29	441.21	441.21	490.0
2023-06-16 06:00:00	SPY	ETF	441.37	441.37	441.31	441.31	1867.0
2023-06-16 06:05:00	SPY	ETF	441.3	441.3	441.22	441.22	3700.0
2023-06-16 06:10:00	SPY	ETF	441.2	441.2	441.03	441.04	4661.0
2023-06-16 06:15:00	SPY	ETF	441.0	441.0	440.91	440.91	2658.0
2023-06-16 06:20:00	SPY	ETF	440.83	441.02	440.8	440.95	14290.0
2023-06-16 06:25:00	SPY	ETF	440.95	440.95	440.81	440.85	3230.0
2023-06-16 06:30:00	SPY	ETF	440.77	440.96	440.77	440.88	5380.0
2023-06-16 06:35:00	SPY	ETF	440.87	440.94	440.86	440.88	1478.0
2023-06-16 06:40:00	SPY	ETF	440.96	440.99	440.91	440.95	849.0
2023-06-16 06:45:00	SPY	ETF	440.95	440.98	440.88	440.88	1652.0
2023-06-16 06:50:00	SPY	ETF	440.88	440.88	440.72	440.83	2497.0
2023-06-16 06:55:00	SPY	ETF	440.88	440.89	440.88	440.89	1400.0
2023-06-16 07:00:00	SPY	ETF	440.96	441.2	440.93	441.14	16961.0
2023-06-16 07:05:00	SPY	ETF	441.19	441.19	441.0	441.01	14985.0
2023-06-16 07:10:00	SPY	ETF	441.0	441.14	441.0	441.14	17287.0
2023-06-16 07:15:00	SPY	ETF	441.16	441.26	441.13	441.14	18037.0
2023-06-16 07:20:00	SPY	ETF	441.14	441.2	441.14	441.15	14084.0
2023-06-16 07:25:00	SPY	ETF	441.121	441.36	441.121	441.33	9857.0
2023-06-16 07:30:00	SPY	ETF	441.35	441.43	441.27	441.43	117780.0
2023-06-16 07:35:00	SPY	ETF	441.45	441.59	441.45	441.47	46140.0
2023-06-16 07:40:00	SPY	ETF	441.48	441.55	441.34	441.36	39883.0
2023-06-16 07:45:00	SPY	ETF	441.35	441.44	441.31	441.43	20318.0
2023-06-16 07:50:00	SPY	ETF	441.39	441.39	441.26	441.26	34100.0
2023-06-16 07:55:00	SPY	ETF	441.27	441.29	441.19	441.24	33149.0
2023-06-16 08:00:00	SPY	ETF	441.17	441.55	440.44	441.25	69628.0
2023-06-16 08:05:00	SPY	ETF	441.25	441.36	440.01	441.35	80560.0

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

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