PREVIEW / etf_1hour / 2023-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-12.parquet
  size:    465 KB
  rows:    16,911

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-12 04:00:00	SPY	ETF	447.6	447.76	447.2	447.39	25980.0
2023-09-12 05:00:00	SPY	ETF	447.39	447.63	447.15	447.63	7074.0
2023-09-12 06:00:00	SPY	ETF	447.53	447.83	447.42	447.7	15106.0
2023-09-12 07:00:00	SPY	ETF	447.72	447.74	447.07	447.14	165641.0
2023-09-12 08:00:00	SPY	ETF	447.7203	448.22	447.05	447.19	148683.0
2023-09-12 09:00:00	SPY	ETF	447.18	447.82	446.6	447.65	4794636.0
2023-09-12 10:00:00	SPY	ETF	447.66	447.67	446.22	446.24	7040393.0
2023-09-12 11:00:00	SPY	ETF	446.24	447.22	446.095	447.06	5583263.0
2023-09-12 12:00:00	SPY	ETF	447.07	447.54	446.96	447.26	3747849.0
2023-09-12 13:00:00	SPY	ETF	447.27	448.53	446.89	447.0329	6613432.0
2023-09-12 14:00:00	SPY	ETF	447.03	447.11	445.94	446.07	5589457.0
2023-09-12 15:00:00	SPY	ETF	446.07	446.21	445.39	445.97	13262527.0
2023-09-12 16:00:00	SPY	ETF	445.96	447.2668	445.91	445.99	2575520.0
2023-09-12 17:00:00	SPY	ETF	445.97	446.06	445.83	445.9	84519.0
2023-09-12 18:00:00	SPY	ETF	445.9	446.001	445.79	445.98	69664.0
2023-09-12 19:00:00	SPY	ETF	445.85	446.08	445.82	446.05	28703.0
2023-09-12 04:00:00	QQQ	ETF	376.21	376.21	375.71	375.85	50679.0
2023-09-12 05:00:00	QQQ	ETF	375.86	376.22	375.68	376.19	27559.0
2023-09-12 06:00:00	QQQ	ETF	376.05	376.55	376.05	376.4	17877.0
2023-09-12 07:00:00	QQQ	ETF	376.45	376.46	375.72	375.75	113034.0
2023-09-12 08:00:00	QQQ	ETF	377.04	377.252	375.57	375.65	216979.0
2023-09-12 09:00:00	QQQ	ETF	375.65	376.675	374.93	376.4731	3455409.0
2023-09-12 10:00:00	QQQ	ETF	376.47	376.575	373.9	373.95	5257858.0
2023-09-12 11:00:00	QQQ	ETF	373.93	374.465	373.3	374.168	3931637.0
2023-09-12 12:00:00	QQQ	ETF	374.18	374.72	374.05	374.31	2037021.0
2023-09-12 13:00:00	QQQ	ETF	374.31	375.64	373.6	373.9	3407600.0
2023-09-12 14:00:00	QQQ	ETF	373.88	373.98	372.85	372.945	3695428.0
2023-09-12 15:00:00	QQQ	ETF	372.96	373.18	372.5	372.81	6814667.0
2023-09-12 16:00:00	QQQ	ETF	372.81	373.08	372.69	372.96	2160691.0
2023-09-12 17:00:00	QQQ	ETF	372.97	373.06	372.86	372.86	39091.0
2023-09-12 18:00:00	QQQ	ETF	372.92	373.09	372.87	373.08	62562.0
2023-09-12 19:00:00	QQQ	ETF	372.92	373.1	372.9	373.0	38783.0
2023-09-12 04:00:00	IWM	ETF	184.08	184.22	184.03	184.1	12536.0
2023-09-12 05:00:00	IWM	ETF	184.1	184.16	184.03	184.16	3018.0
2023-09-12 06:00:00	IWM	ETF	184.19	184.22	184.1	184.17	2227.0
2023-09-12 07:00:00	IWM	ETF	184.22	184.24	183.9	183.91	35225.0
2023-09-12 08:00:00	IWM	ETF	184.07	184.38	183.86	184.16	24694.0
2023-09-12 09:00:00	IWM	ETF	184.11	185.12	183.74	184.93	2053345.0
2023-09-12 10:00:00	IWM	ETF	184.93	185.145	184.075	184.075	2623268.0
2023-09-12 11:00:00	IWM	ETF	184.07	184.86	184.045	184.7922	1469566.0
2023-09-12 12:00:00	IWM	ETF	184.8	185.13	184.74	184.85	785881.0
2023-09-12 13:00:00	IWM	ETF	184.86	185.335	184.79	184.85	1220938.0
2023-09-12 14:00:00	IWM	ETF	184.85	184.85	184.39	184.43	1154579.0
2023-09-12 15:00:00	IWM	ETF	184.43	184.45	184.06	184.22	3185373.0
2023-09-12 16:00:00	IWM	ETF	184.18	184.45	184.18	184.3	671338.0
2023-09-12 17:00:00	IWM	ETF	184.29	184.3	184.22	184.23	3500.0
2023-09-12 18:00:00	IWM	ETF	184.3	184.3	184.18	184.249	18777.0
2023-09-12 19:00:00	IWM	ETF	184.23	184.27	184.17	184.2104	7706.0
2023-09-12 04:00:00	DIA	ETF	346.69	346.69	346.68	346.68	286.0
2023-09-12 07:00:00	DIA	ETF	346.89	346.89	346.74	346.74	1414.0

> showing 50 of 16,911 rows — these rows as CSV

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