PREVIEW / etf_1hour / 2023-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-07.parquet
  size:    509 KB
  rows:    18,599

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-12-07 04:00:00	SPY	ETF	454.47	454.81	454.2	454.78	26386.0
2023-12-07 05:00:00	SPY	ETF	454.92	454.92	454.64	454.79	4960.0
2023-12-07 06:00:00	SPY	ETF	454.89	455.13	454.87	454.99	60674.0
2023-12-07 07:00:00	SPY	ETF	454.99	455.35	454.81	455.33	122610.0
2023-12-07 08:00:00	SPY	ETF	454.9995	456.3	454.4	456.2699	835604.0
2023-12-07 09:00:00	SPY	ETF	456.25	457.23	456.13	456.46	6608380.0
2023-12-07 10:00:00	SPY	ETF	456.46	458.145	456.4	457.87	8298976.0
2023-12-07 11:00:00	SPY	ETF	457.88	458.12	456.512	458.08	6841994.0
2023-12-07 12:00:00	SPY	ETF	458.1	458.45	457.645	458.1385	5382592.0
2023-12-07 13:00:00	SPY	ETF	458.135	458.55	457.945	458.31	3599452.0
2023-12-07 14:00:00	SPY	ETF	458.3	458.9	457.9932	458.03	5375526.0
2023-12-07 15:00:00	SPY	ETF	458.04	458.51	457.93	458.21	10652072.0
2023-12-07 16:00:00	SPY	ETF	458.2	458.308	456.7175	457.81	3408836.0
2023-12-07 17:00:00	SPY	ETF	457.89	458.23	457.83	458.0	407324.0
2023-12-07 18:00:00	SPY	ETF	458.0	458.05	457.7247	457.8	36634.0
2023-12-07 19:00:00	SPY	ETF	457.81	458.13	457.77	458.05	38601.0
2023-12-07 04:00:00	QQQ	ETF	385.36	386.1	384.96	385.94	34344.0
2023-12-07 05:00:00	QQQ	ETF	385.95	386.05	385.71	386.01	32714.0
2023-12-07 06:00:00	QQQ	ETF	385.96	386.21	385.73	386.09	20738.0
2023-12-07 07:00:00	QQQ	ETF	386.07	386.28	385.79	386.24	178538.0
2023-12-07 08:00:00	QQQ	ETF	385.97	387.64	384.84	387.5	391399.0
2023-12-07 09:00:00	QQQ	ETF	387.49	389.2299	386.96	387.4301	6485098.0
2023-12-07 10:00:00	QQQ	ETF	387.42	389.8281	387.36	389.58	6311694.0
2023-12-07 11:00:00	QQQ	ETF	389.59	390.32	388.0	390.28	6000551.0
2023-12-07 12:00:00	QQQ	ETF	390.29	391.06	389.89	390.47	4883241.0
2023-12-07 13:00:00	QQQ	ETF	390.47	390.91	390.05	390.49	2608628.0
2023-12-07 14:00:00	QQQ	ETF	390.49	391.27	390.215	390.24	4540877.0
2023-12-07 15:00:00	QQQ	ETF	390.25	390.92	390.15	390.57	6175717.0
2023-12-07 16:00:00	QQQ	ETF	390.56	390.707	389.86	390.11	2556464.0
2023-12-07 17:00:00	QQQ	ETF	390.12	390.37	390.02	390.37	23269.0
2023-12-07 18:00:00	QQQ	ETF	390.3	390.35	390.13	390.19	24444.0
2023-12-07 19:00:00	QQQ	ETF	390.24	390.43	390.16	390.3	25445.0
2023-12-07 04:00:00	IWM	ETF	183.81	183.91	183.43	183.64	13384.0
2023-12-07 05:00:00	IWM	ETF	183.58	183.69	183.34	183.69	5915.0
2023-12-07 06:00:00	IWM	ETF	183.82	183.86	183.44	183.52	47625.0
2023-12-07 07:00:00	IWM	ETF	183.46	183.59	183.36	183.47	33024.0
2023-12-07 08:00:00	IWM	ETF	183.6	184.1	183.2	184.03	357017.0
2023-12-07 09:00:00	IWM	ETF	184.1	184.87	183.39	184.495	5182583.0
2023-12-07 10:00:00	IWM	ETF	184.49	185.21	184.08	184.82	4737443.0
2023-12-07 11:00:00	IWM	ETF	184.83	185.16	184.1	184.62	2917967.0
2023-12-07 12:00:00	IWM	ETF	184.625	185.36	184.42	184.93	2973119.0
2023-12-07 13:00:00	IWM	ETF	184.93	185.265	184.89	185.09	1706507.0
2023-12-07 14:00:00	IWM	ETF	185.1	185.49	184.92	184.95	2540562.0
2023-12-07 15:00:00	IWM	ETF	184.95	185.56	184.88	185.47	3894185.0
2023-12-07 16:00:00	IWM	ETF	185.39	185.63	185.38	185.42	1185777.0
2023-12-07 17:00:00	IWM	ETF	185.54	185.5495	185.35	185.48	14986.0
2023-12-07 18:00:00	IWM	ETF	185.45	185.55	185.34	185.39	7158.0
2023-12-07 19:00:00	IWM	ETF	185.44	185.68	185.39	185.62	20008.0
2023-12-07 04:00:00	DIA	ETF	360.73	360.81	360.59	360.6	2525.0
2023-12-07 05:00:00	DIA	ETF	360.56	360.56	360.56	360.56	300.0

> showing 50 of 18,599 rows — these rows as CSV

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