PREVIEW / etf_1hour / 2023-07-05

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-05.parquet
  size:    480 KB
  rows:    17,735

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-05 04:00:00	SPY	ETF	442.93	443.31	442.69	442.7	30074.0
2023-07-05 05:00:00	SPY	ETF	442.75	442.75	441.59	441.91	36567.0
2023-07-05 06:00:00	SPY	ETF	441.94	442.31	441.86	442.19	24298.0
2023-07-05 07:00:00	SPY	ETF	442.21	442.22	441.69	441.69	139666.0
2023-07-05 08:00:00	SPY	ETF	442.19	443.79	441.44	441.63	385921.0
2023-07-05 09:00:00	SPY	ETF	441.62	443.32	441.55	443.22	4959468.0
2023-07-05 10:00:00	SPY	ETF	443.23	443.83	442.93	443.79	6211098.0
2023-07-05 11:00:00	SPY	ETF	443.795	443.889	443.16	443.29	4759177.0
2023-07-05 12:00:00	SPY	ETF	443.295	443.3701	442.73	443.17	4548922.0
2023-07-05 13:00:00	SPY	ETF	443.16	443.39	442.99	443.2801	2714432.0
2023-07-05 14:00:00	SPY	ETF	443.2999	443.605	442.31	443.5	5547766.0
2023-07-05 15:00:00	SPY	ETF	443.5	443.76	443.09	443.14	8383292.0
2023-07-05 16:00:00	SPY	ETF	443.14	443.22	443.03	443.03	2097358.0
2023-07-05 17:00:00	SPY	ETF	443.01	443.08	442.95	443.02	47927.0
2023-07-05 18:00:00	SPY	ETF	442.91	443.09	442.88	442.88	37866.0
2023-07-05 19:00:00	SPY	ETF	442.9	443.05	442.81	442.83	16932.0
2023-07-05 04:00:00	QQQ	ETF	368.85	370.29	368.7	368.78	75002.0
2023-07-05 05:00:00	QQQ	ETF	368.77	368.88	367.81	368.07	43193.0
2023-07-05 06:00:00	QQQ	ETF	368.04	368.69	367.94	368.61	34060.0
2023-07-05 07:00:00	QQQ	ETF	368.63	368.68	368.15	368.15	95768.0
2023-07-05 08:00:00	QQQ	ETF	368.6291	369.93	367.95	368.46	174634.0
2023-07-05 09:00:00	QQQ	ETF	368.48	371.15	368.31	370.65	4841866.0
2023-07-05 10:00:00	QQQ	ETF	370.62	372.01	370.44	371.595	4562733.0
2023-07-05 11:00:00	QQQ	ETF	371.6	371.61	369.97	370.09	3783132.0
2023-07-05 12:00:00	QQQ	ETF	370.09	370.67	369.76	370.38	2771510.0
2023-07-05 13:00:00	QQQ	ETF	370.39	370.761	370.13	370.53	1660323.0
2023-07-05 14:00:00	QQQ	ETF	370.535	370.95	369.425	370.66	4321414.0
2023-07-05 15:00:00	QQQ	ETF	370.66	371.05	370.22	370.28	4485507.0
2023-07-05 16:00:00	QQQ	ETF	370.28	370.35	370.08	370.16	643979.0
2023-07-05 17:00:00	QQQ	ETF	370.18	370.29	370.14	370.24	36190.0
2023-07-05 18:00:00	QQQ	ETF	370.2	370.28	370.08	370.11	53580.0
2023-07-05 19:00:00	QQQ	ETF	370.1	370.4	370.1	370.16	28908.0
2023-07-05 04:00:00	IWM	ETF	187.65	187.65	187.14	187.25	21745.0
2023-07-05 05:00:00	IWM	ETF	187.28	187.28	186.42	186.69	18817.0
2023-07-05 06:00:00	IWM	ETF	186.63	186.95	186.61	186.78	9185.0
2023-07-05 07:00:00	IWM	ETF	186.81	186.87	186.47	186.68	69415.0
2023-07-05 08:00:00	IWM	ETF	186.8084	187.88	186.42	186.6	214304.0
2023-07-05 09:00:00	IWM	ETF	186.58	187.22	185.44	186.1778	4393533.0
2023-07-05 10:00:00	IWM	ETF	186.17	186.88	185.76	186.4	2873580.0
2023-07-05 11:00:00	IWM	ETF	186.4	186.82	186.015	186.5	2033128.0
2023-07-05 12:00:00	IWM	ETF	186.49	186.635	186.07	186.23	1422460.0
2023-07-05 13:00:00	IWM	ETF	186.24	186.53	186.03	186.51	1309483.0
2023-07-05 14:00:00	IWM	ETF	186.51	186.65	185.95	186.6299	1555037.0
2023-07-05 15:00:00	IWM	ETF	186.62	186.69	185.735	185.78	4698874.0
2023-07-05 16:00:00	IWM	ETF	185.78	186.35	185.59	185.59	866093.0
2023-07-05 17:00:00	IWM	ETF	185.61	185.76	185.61	185.71	32283.0
2023-07-05 18:00:00	IWM	ETF	185.63	185.7	185.55	185.55	55459.0
2023-07-05 19:00:00	IWM	ETF	185.59	185.63	185.41	185.45	33060.0
2023-07-05 04:00:00	DIA	ETF	343.29	343.29	343.29	343.29	200.0
2023-07-05 05:00:00	DIA	ETF	343.07	343.07	342.58	342.58	2640.0

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

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