PREVIEW / etf_1hour / 2005-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-12.parquet
  size:    37 KB
  rows:    1,167

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-12 04:00:00	SPY	ETF	126.86	126.86	126.86	126.86	200.0
2005-12-12 05:00:00	SPY	ETF	126.84	126.84	126.84	126.84	200.0
2005-12-12 06:00:00	SPY	ETF	126.84	126.86	126.84	126.84	50000.0
2005-12-12 07:00:00	SPY	ETF	126.79	126.84	126.74	126.74	71900.0
2005-12-12 08:00:00	SPY	ETF	126.74	126.85	126.59	126.74	544300.0
2005-12-12 09:00:00	SPY	ETF	126.74	126.86	126.64	126.68	5082600.0
2005-12-12 10:00:00	SPY	ETF	126.69	126.83	126.5	126.71	9122800.0
2005-12-12 11:00:00	SPY	ETF	126.72	126.78	126.48	126.51	5895400.0
2005-12-12 12:00:00	SPY	ETF	126.51	126.58	126.09	126.22	8705700.0
2005-12-12 13:00:00	SPY	ETF	126.22	126.22	125.96	126.12	6406400.0
2005-12-12 14:00:00	SPY	ETF	126.13	126.43	126.07	126.34	5018400.0
2005-12-12 15:00:00	SPY	ETF	126.34	126.59	126.3	126.48	5647500.0
2005-12-12 16:00:00	SPY	ETF	126.47	126.58	126.39	126.54	722600.0
2005-12-12 17:00:00	SPY	ETF	126.51	126.54	126.5	126.52	133300.0
2005-12-12 18:00:00	SPY	ETF	126.47	126.48	126.43	126.48	3500.0
2005-12-12 19:00:00	SPY	ETF	126.47	126.49	126.47	126.49	400.0
2005-12-12 09:00:00	QQQ	ETF	41.87	41.92	41.83	41.85	6694200.0
2005-12-12 10:00:00	QQQ	ETF	41.85	41.93	41.79	41.91	8356000.0
2005-12-12 11:00:00	QQQ	ETF	41.92	41.94	41.87	41.89	4014800.0
2005-12-12 12:00:00	QQQ	ETF	41.89	41.9	41.73	41.78	7604600.0
2005-12-12 13:00:00	QQQ	ETF	41.77	41.78	41.68	41.78	4523000.0
2005-12-12 14:00:00	QQQ	ETF	41.78	41.87	41.76	41.84	4997200.0
2005-12-12 15:00:00	QQQ	ETF	41.84	41.89	41.83	41.87	6544900.0
2005-12-12 08:00:00	IWM	ETF	68.82	68.84	68.82	68.84	5000.0
2005-12-12 09:00:00	IWM	ETF	68.84	68.97	68.7	68.75	2925400.0
2005-12-12 10:00:00	IWM	ETF	68.75	68.92	68.6	68.77	4298400.0
2005-12-12 11:00:00	IWM	ETF	68.78	68.93	68.73	68.75	1981100.0
2005-12-12 12:00:00	IWM	ETF	68.76	68.78	68.47	68.53	2053200.0
2005-12-12 13:00:00	IWM	ETF	68.53	68.53	68.28	68.47	2868200.0
2005-12-12 14:00:00	IWM	ETF	68.48	68.72	68.46	68.68	4927600.0
2005-12-12 15:00:00	IWM	ETF	68.68	68.81	68.59	68.69	2589800.0
2005-12-12 16:00:00	IWM	ETF	68.73	68.85	68.67	68.67	25500.0
2005-12-12 07:00:00	DIA	ETF	107.91	107.91	107.91	107.91	500.0
2005-12-12 08:00:00	DIA	ETF	107.91	108.21	107.91	108.19	99100.0
2005-12-12 09:00:00	DIA	ETF	108.18	108.2	108.0	108.04	701600.0
2005-12-12 10:00:00	DIA	ETF	108.04	108.16	107.9	108.08	601900.0
2005-12-12 11:00:00	DIA	ETF	108.06	108.11	107.92	107.93	381300.0
2005-12-12 12:00:00	DIA	ETF	107.94	107.94	107.55	107.6	402800.0
2005-12-12 13:00:00	DIA	ETF	107.6	107.6	107.42	107.52	771200.0
2005-12-12 14:00:00	DIA	ETF	107.53	107.7	107.45	107.6	1100100.0
2005-12-12 15:00:00	DIA	ETF	107.61	107.81	107.6	107.78	668500.0
2005-12-12 16:00:00	DIA	ETF	107.75	107.78	107.6	107.74	16700.0
2005-12-12 17:00:00	DIA	ETF	107.72	107.72	107.72	107.72	1000.0
2005-12-12 18:00:00	DIA	ETF	107.75	107.75	107.75	107.75	500.0
2005-12-12 07:00:00	GLD	ETF	53.9	53.9	52.52	53.55	54100.0
2005-12-12 08:00:00	GLD	ETF	53.51	53.65	52.55	53.25	98500.0
2005-12-12 09:00:00	GLD	ETF	53.26	53.37	53.05	53.28	957400.0
2005-12-12 10:00:00	GLD	ETF	53.26	53.76	53.26	53.5	1350400.0
2005-12-12 11:00:00	GLD	ETF	53.5	53.52	53.35	53.45	477600.0
2005-12-12 12:00:00	GLD	ETF	53.46	53.49	52.51	52.67	1249200.0

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

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