PREVIEW / etf_1hour / 2023-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-14.parquet
  size:    486 KB
  rows:    17,615

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-14 04:00:00	SPY	ETF	437.53	437.87	437.37	437.73	31998.0
2023-06-14 05:00:00	SPY	ETF	437.66	437.79	437.21	437.27	15130.0
2023-06-14 06:00:00	SPY	ETF	437.26	437.68	437.21	437.58	27049.0
2023-06-14 07:00:00	SPY	ETF	437.53	437.79	437.2	437.31	94867.0
2023-06-14 08:00:00	SPY	ETF	437.5317	437.8	436.64	437.15	283774.0
2023-06-14 09:00:00	SPY	ETF	437.15	437.69	436.51	437.5	4635046.0
2023-06-14 10:00:00	SPY	ETF	437.51	438.35	437.35	437.865	6977228.0
2023-06-14 11:00:00	SPY	ETF	437.865	439.0612	437.74	438.25	5328338.0
2023-06-14 12:00:00	SPY	ETF	438.25	438.4	437.57	438.075	3825639.0
2023-06-14 13:00:00	SPY	ETF	438.08	438.09	436.94	437.29	5001856.0
2023-06-14 14:00:00	SPY	ETF	437.29	437.32	433.59	436.352	23616960.0
2023-06-14 15:00:00	SPY	ETF	436.37	438.15	435.13	437.18	18517681.0
2023-06-14 16:00:00	SPY	ETF	437.17	437.88	437.01	437.65	3569416.0
2023-06-14 17:00:00	SPY	ETF	437.64	437.72	437.18	437.53	111374.0
2023-06-14 18:00:00	SPY	ETF	437.5	437.76	437.4	437.52	84832.0
2023-06-14 19:00:00	SPY	ETF	437.5	437.52	437.24	437.24	40381.0
2023-06-14 04:00:00	QQQ	ETF	364.42	364.67	363.78	364.34	40081.0
2023-06-14 05:00:00	QQQ	ETF	364.29	364.5	363.98	364.0	62365.0
2023-06-14 06:00:00	QQQ	ETF	364.08	364.3	363.7	363.83	36218.0
2023-06-14 07:00:00	QQQ	ETF	363.83	364.1	363.71	363.91	90649.0
2023-06-14 08:00:00	QQQ	ETF	363.7809	364.45	362.988	363.56	479385.0
2023-06-14 09:00:00	QQQ	ETF	363.48	363.98	362.26	363.87	4391806.0
2023-06-14 10:00:00	QQQ	ETF	363.88	365.29	363.57	364.58	4842680.0
2023-06-14 11:00:00	QQQ	ETF	364.58	366.19	364.2017	365.19	3894744.0
2023-06-14 12:00:00	QQQ	ETF	365.18	365.56	364.56	365.265	2719842.0
2023-06-14 13:00:00	QQQ	ETF	365.27	365.28	363.83	364.2899	3052010.0
2023-06-14 14:00:00	QQQ	ETF	364.2055	365.08	360.42	364.24	15297168.0
2023-06-14 15:00:00	QQQ	ETF	364.27	366.16	363.39	365.9	10815750.0
2023-06-14 16:00:00	QQQ	ETF	365.9	366.88	363.8091	366.65	2069884.0
2023-06-14 17:00:00	QQQ	ETF	366.63	366.7	365.9	366.34	226654.0
2023-06-14 18:00:00	QQQ	ETF	366.34	366.51	366.2	366.41	129665.0
2023-06-14 19:00:00	QQQ	ETF	366.4	366.4	366.13	366.18	68628.0
2023-06-14 04:00:00	IWM	ETF	188.66	189.04	188.57	188.95	23434.0
2023-06-14 05:00:00	IWM	ETF	188.96	188.96	188.55	188.55	14347.0
2023-06-14 06:00:00	IWM	ETF	188.58	188.91	188.48	188.89	13372.0
2023-06-14 07:00:00	IWM	ETF	188.8	189.12	188.73	188.77	44349.0
2023-06-14 08:00:00	IWM	ETF	188.9392	189.15	188.42	188.58	188095.0
2023-06-14 09:00:00	IWM	ETF	188.44	189.24	187.82	188.11	2921370.0
2023-06-14 10:00:00	IWM	ETF	188.13	188.285	187.55	187.7	2878818.0
2023-06-14 11:00:00	IWM	ETF	187.69	188.29	187.58	187.7	1993883.0
2023-06-14 12:00:00	IWM	ETF	187.69	187.74	187.15	187.29	1600230.0
2023-06-14 13:00:00	IWM	ETF	187.29	187.29	186.43	186.67	2545329.0
2023-06-14 14:00:00	IWM	ETF	186.6863	186.6863	184.55	186.04	8110989.0
2023-06-14 15:00:00	IWM	ETF	186.09	186.9	185.01	185.94	7417791.0
2023-06-14 16:00:00	IWM	ETF	185.91	186.27	185.82	185.96	1667432.0
2023-06-14 17:00:00	IWM	ETF	186.05	186.27	185.91	186.27	133009.0
2023-06-14 18:00:00	IWM	ETF	186.09	186.1	185.95	185.97	12210.0
2023-06-14 19:00:00	IWM	ETF	185.95	185.97	185.8	185.83	46565.0
2023-06-14 04:00:00	DIA	ETF	342.3	342.5	342.26	342.43	2204.0
2023-06-14 05:00:00	DIA	ETF	342.39	342.39	342.39	342.39	115.0

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

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