PREVIEW / etf_1hour / 2023-07-03

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-03.parquet
  size:    324 KB
  rows:    11,334

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-07-03 04:00:00	SPY	ETF	443.5	443.85	443.5	443.71	27925.0
2023-07-03 05:00:00	SPY	ETF	443.71	443.71	443.51	443.58	16418.0
2023-07-03 06:00:00	SPY	ETF	443.6	443.95	443.31	443.61	183448.0
2023-07-03 07:00:00	SPY	ETF	443.62	443.68	443.1	443.17	46011.0
2023-07-03 08:00:00	SPY	ETF	443.5311	443.89	442.95	443.12	155537.0
2023-07-03 09:00:00	SPY	ETF	443.11	443.55	442.63	443.46	4802104.0
2023-07-03 10:00:00	SPY	ETF	443.5	443.68	443.02	443.2001	5453119.0
2023-07-03 11:00:00	SPY	ETF	443.21	443.72	443.16	443.625	4375855.0
2023-07-03 12:00:00	SPY	ETF	443.6199	444.08	443.55	443.89	7927262.0
2023-07-03 13:00:00	SPY	ETF	443.9	444.03	443.59	443.79	1792237.0
2023-07-03 14:00:00	SPY	ETF	443.71	443.97	443.6991	443.91	74429.0
2023-07-03 15:00:00	SPY	ETF	443.9	444.1	443.9	443.99	13497.0
2023-07-03 16:00:00	SPY	ETF	444.03	444.03	443.75	443.95	14572.0
2023-07-03 04:00:00	QQQ	ETF	370.29	370.99	370.26	370.78	38167.0
2023-07-03 05:00:00	QQQ	ETF	370.71	370.75	370.5	370.56	14957.0
2023-07-03 06:00:00	QQQ	ETF	370.54	370.63	369.87	370.3	33119.0
2023-07-03 07:00:00	QQQ	ETF	370.37	370.4	369.68	369.68	161330.0
2023-07-03 08:00:00	QQQ	ETF	370.39	370.9404	369.55	370.01	164591.0
2023-07-03 09:00:00	QQQ	ETF	369.95	370.93	369.66	370.47	3787046.0
2023-07-03 10:00:00	QQQ	ETF	370.5	370.8601	369.0301	369.14	4334448.0
2023-07-03 11:00:00	QQQ	ETF	369.16	369.59	368.97	369.3062	3152085.0
2023-07-03 12:00:00	QQQ	ETF	369.3	370.3801	369.1808	370.34	3983581.0
2023-07-03 13:00:00	QQQ	ETF	370.35	370.37	369.97	370.0199	340000.0
2023-07-03 14:00:00	QQQ	ETF	370.02	370.09	369.93	370.05	29112.0
2023-07-03 15:00:00	QQQ	ETF	370.02	370.18	370.02	370.15	7622.0
2023-07-03 16:00:00	QQQ	ETF	370.07	370.15	369.98	370.05	8206.0
2023-07-03 04:00:00	IWM	ETF	187.05	187.33	186.95	187.26	15708.0
2023-07-03 05:00:00	IWM	ETF	187.24	187.31	187.19	187.26	3897.0
2023-07-03 06:00:00	IWM	ETF	187.31	187.8	187.2	187.56	238254.0
2023-07-03 07:00:00	IWM	ETF	187.49	187.53	187.16	187.28	35627.0
2023-07-03 08:00:00	IWM	ETF	187.4787	187.5304	187.01	187.29	113667.0
2023-07-03 09:00:00	IWM	ETF	187.29	188.84	186.74	188.09	3185740.0
2023-07-03 10:00:00	IWM	ETF	188.09	188.47	187.53	187.655	2097229.0
2023-07-03 11:00:00	IWM	ETF	187.655	188.2391	187.52	187.7	1926355.0
2023-07-03 12:00:00	IWM	ETF	187.695	188.14	187.45	187.98	2775636.0
2023-07-03 13:00:00	IWM	ETF	187.97	188.11	187.65	187.8	540891.0
2023-07-03 14:00:00	IWM	ETF	187.79	188.19	187.71	188.17	53467.0
2023-07-03 15:00:00	IWM	ETF	188.1	188.24	188.02	188.1	13883.0
2023-07-03 16:00:00	IWM	ETF	188.16	188.19	188.01	188.1	3566.0
2023-07-03 04:00:00	DIA	ETF	343.6	343.75	343.6	343.75	1140.0
2023-07-03 05:00:00	DIA	ETF	343.51	343.51	343.47	343.48	1500.0
2023-07-03 06:00:00	DIA	ETF	343.51	343.79	343.51	343.68	757.0
2023-07-03 07:00:00	DIA	ETF	343.64	343.64	343.4	343.41	6020.0
2023-07-03 08:00:00	DIA	ETF	343.56	343.99	343.271	343.271	4250.0
2023-07-03 09:00:00	DIA	ETF	343.35	343.62	342.78	343.43	372293.0
2023-07-03 10:00:00	DIA	ETF	343.53	343.78	343.33	343.6411	293603.0
2023-07-03 11:00:00	DIA	ETF	343.67	344.44	343.62	344.36	237280.0
2023-07-03 12:00:00	DIA	ETF	344.43	344.53	343.97	344.03	345266.0
2023-07-03 13:00:00	DIA	ETF	344.02	344.79	343.89	344.79	14740.0
2023-07-03 14:00:00	DIA	ETF	343.51	344.11	343.51	344.11	691.0

> showing 50 of 11,334 rows — these rows as CSV

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