PREVIEW / etf_1hour / 2005-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-22.parquet
  size:    36 KB
  rows:    1,151

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-22 07:00:00	SPY	ETF	126.21	126.21	126.12	126.14	190500.0
2005-12-22 08:00:00	SPY	ETF	126.13	126.34	126.12	126.34	371900.0
2005-12-22 09:00:00	SPY	ETF	126.36	126.47	126.04	126.29	4771400.0
2005-12-22 10:00:00	SPY	ETF	126.29	126.39	126.08	126.35	5560200.0
2005-12-22 11:00:00	SPY	ETF	126.32	126.49	126.19	126.38	4985100.0
2005-12-22 12:00:00	SPY	ETF	126.39	126.42	126.23	126.37	2672300.0
2005-12-22 13:00:00	SPY	ETF	126.36	126.51	126.22	126.45	2835900.0
2005-12-22 14:00:00	SPY	ETF	126.46	126.57	126.35	126.53	2961300.0
2005-12-22 15:00:00	SPY	ETF	126.53	126.66	126.45	126.65	6227300.0
2005-12-22 16:00:00	SPY	ETF	126.64	126.7	126.54	126.67	915700.0
2005-12-22 17:00:00	SPY	ETF	126.67	126.73	126.67	126.7	4300.0
2005-12-22 18:00:00	SPY	ETF	126.69	126.69	126.67	126.67	2100.0
2005-12-22 19:00:00	SPY	ETF	126.68	126.68	126.68	126.68	100.0
2005-12-22 09:00:00	QQQ	ETF	41.12	41.22	41.1	41.15	6090600.0
2005-12-22 10:00:00	QQQ	ETF	41.16	41.25	40.98	41.22	8289000.0
2005-12-22 11:00:00	QQQ	ETF	41.22	41.27	41.17	41.25	7390500.0
2005-12-22 12:00:00	QQQ	ETF	41.25	42.23	41.17	41.2	3528700.0
2005-12-22 13:00:00	QQQ	ETF	41.2	41.28	41.19	41.25	4555800.0
2005-12-22 14:00:00	QQQ	ETF	41.25	41.3	41.23	41.3	3791700.0
2005-12-22 15:00:00	QQQ	ETF	41.3	41.46	41.29	41.39	12306400.0
2005-12-22 07:00:00	IWM	ETF	67.67	67.68	67.66	67.67	40000.0
2005-12-22 08:00:00	IWM	ETF	67.69	67.72	67.64	67.71	34200.0
2005-12-22 09:00:00	IWM	ETF	67.75	67.89	67.61	67.64	1722000.0
2005-12-22 10:00:00	IWM	ETF	67.64	67.73	67.39	67.57	3400700.0
2005-12-22 11:00:00	IWM	ETF	67.57	67.8	67.48	67.77	2604600.0
2005-12-22 12:00:00	IWM	ETF	67.77	67.78	67.57	67.71	1466500.0
2005-12-22 13:00:00	IWM	ETF	67.72	67.76	67.55	67.75	2004500.0
2005-12-22 14:00:00	IWM	ETF	67.75	67.83	67.66	67.81	2379900.0
2005-12-22 15:00:00	IWM	ETF	67.81	67.93	67.74	67.92	3235900.0
2005-12-22 16:00:00	IWM	ETF	67.91	68.01	67.88	67.98	2567000.0
2005-12-22 17:00:00	IWM	ETF	68.04	68.06	68.04	68.06	5600.0
2005-12-22 18:00:00	IWM	ETF	68.07	68.07	68.07	68.07	100.0
2005-12-22 08:00:00	DIA	ETF	108.24	108.41	108.24	108.4	9100.0
2005-12-22 09:00:00	DIA	ETF	108.42	108.52	108.32	108.39	708300.0
2005-12-22 10:00:00	DIA	ETF	108.39	108.47	108.16	108.4	987300.0
2005-12-22 11:00:00	DIA	ETF	108.37	108.54	108.32	108.41	719200.0
2005-12-22 12:00:00	DIA	ETF	108.41	108.41	108.24	108.38	205300.0
2005-12-22 13:00:00	DIA	ETF	108.39	108.58	108.34	108.56	576500.0
2005-12-22 14:00:00	DIA	ETF	108.56	108.67	108.45	108.64	342700.0
2005-12-22 15:00:00	DIA	ETF	108.64	108.75	108.58	108.7	630300.0
2005-12-22 16:00:00	DIA	ETF	108.7	108.76	108.69	108.74	16600.0
2005-12-22 08:00:00	GLD	ETF	49.46	49.49	49.34	49.48	75500.0
2005-12-22 09:00:00	GLD	ETF	49.48	49.59	49.46	49.53	575000.0
2005-12-22 10:00:00	GLD	ETF	49.53	50.07	49.53	49.9699	865300.0
2005-12-22 11:00:00	GLD	ETF	49.97	50.3	49.92	50.17	490000.0
2005-12-22 12:00:00	GLD	ETF	50.18	50.18	50.03	50.06	217900.0
2005-12-22 13:00:00	GLD	ETF	50.06	50.2	50.04	50.15	133100.0
2005-12-22 14:00:00	GLD	ETF	50.15	50.27	50.14	50.24	109800.0
2005-12-22 15:00:00	GLD	ETF	50.24	50.3	50.15	50.24	330000.0
2005-12-22 16:00:00	GLD	ETF	50.15	50.2	50.15	50.2	40300.0

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

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