PREVIEW / etf_1hour / 2005-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-08.parquet
  size:    39 KB
  rows:    1,163

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
2005-12-08 06:00:00	SPY	ETF	125.79	125.79	125.79	125.79	300.0
2005-12-08 07:00:00	SPY	ETF	125.86	125.88	125.79	125.84	108600.0
2005-12-08 08:00:00	SPY	ETF	125.82	126.18	125.79	126.18	1341900.0
2005-12-08 09:00:00	SPY	ETF	126.16	126.29	125.86	125.94	7419700.0
2005-12-08 10:00:00	SPY	ETF	125.95	126.52	125.86	126.49	10203800.0
2005-12-08 11:00:00	SPY	ETF	126.5	126.82	126.1675	126.73	10381800.0
2005-12-08 12:00:00	SPY	ETF	126.73	126.74	126.28	126.39	5639000.0
2005-12-08 13:00:00	SPY	ETF	126.4	126.41	125.94	126.07	7758200.0
2005-12-08 14:00:00	SPY	ETF	126.08	126.4	125.48	125.74	9574400.0
2005-12-08 15:00:00	SPY	ETF	125.75	126.09	125.69	126.05	7714900.0
2005-12-08 16:00:00	SPY	ETF	126.05	126.08	125.77	125.78	1137000.0
2005-12-08 17:00:00	SPY	ETF	125.84	125.84	125.74	125.75	356900.0
2005-12-08 18:00:00	SPY	ETF	125.78	125.9	125.77	125.84	37500.0
2005-12-08 19:00:00	SPY	ETF	125.84	125.86	125.84	125.86	700.0
2005-12-08 09:00:00	QQQ	ETF	41.96	42.0	41.66	41.68	10976300.0
2005-12-08 10:00:00	QQQ	ETF	41.69	41.94	41.67	41.92	12742400.0
2005-12-08 11:00:00	QQQ	ETF	41.92	41.98	41.88	41.93	11939700.0
2005-12-08 12:00:00	QQQ	ETF	41.93	41.94	41.67	41.73	8147500.0
2005-12-08 13:00:00	QQQ	ETF	41.72	41.73	41.51	41.57	11912400.0
2005-12-08 14:00:00	QQQ	ETF	41.57	41.58	41.0	41.39	19978500.0
2005-12-08 15:00:00	QQQ	ETF	41.39	41.59	41.38	41.56	19030700.0
2005-12-08 07:00:00	IWM	ETF	67.97	67.97	67.97	67.97	5000.0
2005-12-08 08:00:00	IWM	ETF	67.97	68.17	67.93	68.17	135400.0
2005-12-08 09:00:00	IWM	ETF	68.18	68.29	67.89	67.92	2253700.0
2005-12-08 10:00:00	IWM	ETF	67.92	68.45	67.91	68.44	5038700.0
2005-12-08 11:00:00	IWM	ETF	68.44	68.81	68.43	68.77	8898600.0
2005-12-08 12:00:00	IWM	ETF	68.76	68.78	68.49	68.53	3385900.0
2005-12-08 13:00:00	IWM	ETF	68.53	68.53	68.26	68.38	2368200.0
2005-12-08 14:00:00	IWM	ETF	68.37	68.37	67.7	67.87	4865600.0
2005-12-08 15:00:00	IWM	ETF	67.87	68.26	67.84	68.24	4558100.0
2005-12-08 16:00:00	IWM	ETF	68.24	68.3	67.83	68.12	160700.0
2005-12-08 17:00:00	IWM	ETF	68.13	68.13	68.03	68.12	3600.0
2005-12-08 18:00:00	IWM	ETF	68.08	68.15	68.08	68.15	2100.0
2005-12-08 08:00:00	DIA	ETF	108.02	108.14	108.02	108.14	700.0
2005-12-08 09:00:00	DIA	ETF	108.14	108.19	107.82	107.89	838900.0
2005-12-08 10:00:00	DIA	ETF	107.87	108.31	107.82	108.28	939000.0
2005-12-08 11:00:00	DIA	ETF	108.28	108.53	108.23	108.42	1329600.0
2005-12-08 12:00:00	DIA	ETF	108.42	108.45	108.15	108.21	866400.0
2005-12-08 13:00:00	DIA	ETF	108.2	108.2	107.77	107.89	961900.0
2005-12-08 14:00:00	DIA	ETF	107.89	107.91	107.37	107.53	1261500.0
2005-12-08 15:00:00	DIA	ETF	107.54	107.72	107.49	107.65	1018700.0
2005-12-08 16:00:00	DIA	ETF	107.66	107.66	107.35	107.5	63000.0
2005-12-08 17:00:00	DIA	ETF	107.45	107.45	107.45	107.45	1000.0
2005-12-08 07:00:00	GLD	ETF	51.45	51.45	51.45	51.45	100.0
2005-12-08 08:00:00	GLD	ETF	51.45	51.45	51.05	51.05	35200.0
2005-12-08 09:00:00	GLD	ETF	51.15	51.49	51.15	51.45	443900.0
2005-12-08 10:00:00	GLD	ETF	51.45	51.66	51.38	51.5	474200.0
2005-12-08 11:00:00	GLD	ETF	51.51	51.71	51.49	51.64	410100.0
2005-12-08 12:00:00	GLD	ETF	51.61	51.86	51.61	51.74	291500.0
2005-12-08 13:00:00	GLD	ETF	51.74	51.85	51.7	51.79	300000.0

> showing 50 of 1,163 rows — these rows as CSV

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