PREVIEW / etf_1hour / 2023-09-05

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-05.parquet
  size:    479 KB
  rows:    17,462

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-09-05 04:00:00	SPY	ETF	449.8	450.07	449.11	449.93	33620.0
2023-09-05 05:00:00	SPY	ETF	449.94	450.55	449.91	450.42	60108.0
2023-09-05 06:00:00	SPY	ETF	450.27	450.73	450.26	450.45	33275.0
2023-09-05 07:00:00	SPY	ETF	450.45	450.68	450.01	450.56	100961.0
2023-09-05 08:00:00	SPY	ETF	450.1786	451.03	449.13	450.91	405080.0
2023-09-05 09:00:00	SPY	ETF	450.98	450.98	449.38	449.5899	4952228.0
2023-09-05 10:00:00	SPY	ETF	449.59	450.43	449.17	450.105	7229068.0
2023-09-05 11:00:00	SPY	ETF	450.11	451.06	449.87	450.22	6094611.0
2023-09-05 12:00:00	SPY	ETF	450.23	450.73	450.18	450.31	3690436.0
2023-09-05 13:00:00	SPY	ETF	450.3	450.34	449.49	450.02	4901027.0
2023-09-05 14:00:00	SPY	ETF	450.03	450.64	449.695	450.62	4504682.0
2023-09-05 15:00:00	SPY	ETF	450.62	450.625	449.17	449.25	9981505.0
2023-09-05 16:00:00	SPY	ETF	449.24	449.44	448.98	449.05	1698756.0
2023-09-05 17:00:00	SPY	ETF	449.07	449.15	449.0	449.0	71260.0
2023-09-05 18:00:00	SPY	ETF	448.91	449.21	448.9	449.2	80944.0
2023-09-05 19:00:00	SPY	ETF	449.19	449.21	449.01	449.15	26844.0
2023-09-05 04:00:00	QQQ	ETF	376.3	376.39	375.29	376.05	57011.0
2023-09-05 05:00:00	QQQ	ETF	376.02	376.64	375.93	376.53	57283.0
2023-09-05 06:00:00	QQQ	ETF	376.38	376.91	376.29	376.58	22060.0
2023-09-05 07:00:00	QQQ	ETF	376.6	376.72	375.9	376.58	124433.0
2023-09-05 08:00:00	QQQ	ETF	376.85	377.5	375.6196	377.02	401228.0
2023-09-05 09:00:00	QQQ	ETF	377.07	377.36	375.9	376.29	3662772.0
2023-09-05 10:00:00	QQQ	ETF	376.28	378.18	375.83	377.67	4946148.0
2023-09-05 11:00:00	QQQ	ETF	377.68	379.06	377.29	377.72	4081481.0
2023-09-05 12:00:00	QQQ	ETF	377.7	378.75	377.6201	378.495	2248194.0
2023-09-05 13:00:00	QQQ	ETF	378.49	378.59	377.8	378.46	2135586.0
2023-09-05 14:00:00	QQQ	ETF	378.47	379.3093	378.265	379.28	2609204.0
2023-09-05 15:00:00	QQQ	ETF	379.29	379.29	377.95	378.06	4652570.0
2023-09-05 16:00:00	QQQ	ETF	378.05	378.418	377.55	377.63	979566.0
2023-09-05 17:00:00	QQQ	ETF	377.61	378.07	377.4501	377.53	90743.0
2023-09-05 18:00:00	QQQ	ETF	377.51	377.81	377.48	377.81	20344.0
2023-09-05 19:00:00	QQQ	ETF	377.78	377.83	377.65	377.72	25978.0
2023-09-05 04:00:00	IWM	ETF	189.19	189.44	188.88	189.44	17424.0
2023-09-05 05:00:00	IWM	ETF	189.38	189.63	189.37	189.52	4823.0
2023-09-05 06:00:00	IWM	ETF	189.47	189.61	189.42	189.42	14469.0
2023-09-05 07:00:00	IWM	ETF	189.47	189.47	189.2	189.361	47795.0
2023-09-05 08:00:00	IWM	ETF	189.27	189.94	188.9696	189.88	97174.0
2023-09-05 09:00:00	IWM	ETF	189.83	190.09	187.12	187.46	5217251.0
2023-09-05 10:00:00	IWM	ETF	187.46	188.19	187.18	187.87	4276222.0
2023-09-05 11:00:00	IWM	ETF	187.87	188.39	187.43	187.5	2883842.0
2023-09-05 12:00:00	IWM	ETF	187.49	187.88	187.445	187.6	1264707.0
2023-09-05 13:00:00	IWM	ETF	187.6	187.6574	187.08	187.24	1679811.0
2023-09-05 14:00:00	IWM	ETF	187.245	187.37	187.015	187.26	1470596.0
2023-09-05 15:00:00	IWM	ETF	187.25	187.33	186.77	186.84	4276554.0
2023-09-05 16:00:00	IWM	ETF	186.83	186.93	186.72	186.76	979177.0
2023-09-05 17:00:00	IWM	ETF	186.78	186.8	186.71	186.75	31731.0
2023-09-05 18:00:00	IWM	ETF	186.78	186.9	186.76	186.9	30134.0
2023-09-05 19:00:00	IWM	ETF	186.84	186.87	186.75	186.81	38482.0
2023-09-05 04:00:00	DIA	ETF	347.96	348.39	347.84	348.39	2103.0
2023-09-05 06:00:00	DIA	ETF	348.73	348.73	348.73	348.73	300.0

> showing 50 of 17,462 rows — these rows as CSV

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