PREVIEW / etf_1hour / 2005-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-15.parquet
  size:    29 KB
  rows:    861

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-06-15 08:00:00	SPY	ETF	120.88	121.27	120.75	121.26	714300.0
2005-06-15 09:00:00	SPY	ETF	121.24	121.27	120.94	121.0	5176700.0
2005-06-15 10:00:00	SPY	ETF	120.96	121.12	120.29	120.35	12782500.0
2005-06-15 11:00:00	SPY	ETF	120.35	120.62	120.23	120.29	8195200.0
2005-06-15 12:00:00	SPY	ETF	120.29	120.54	120.27	120.45	4935200.0
2005-06-15 13:00:00	SPY	ETF	120.45	120.61	120.25	120.56	4734600.0
2005-06-15 14:00:00	SPY	ETF	120.57	120.89	120.47	120.73	5347400.0
2005-06-15 15:00:00	SPY	ETF	120.74	121.12	120.59	121.06	8038300.0
2005-06-15 16:00:00	SPY	ETF	121.05	121.1	121.0	121.05	2012600.0
2005-06-15 17:00:00	SPY	ETF	121.06	121.09	121.02	121.07	631500.0
2005-06-15 18:00:00	SPY	ETF	121.05	121.06	121.02	121.04	50000.0
2005-06-15 19:00:00	SPY	ETF	121.03	121.05	121.03	121.05	1000.0
2005-06-15 09:00:00	QQQ	ETF	37.83	37.87	37.73	37.76	10977200.0
2005-06-15 10:00:00	QQQ	ETF	37.75	37.77	37.33	37.37	25163400.0
2005-06-15 11:00:00	QQQ	ETF	37.37	37.43	37.26	37.26	10744700.0
2005-06-15 12:00:00	QQQ	ETF	37.27	37.34	37.25	37.33	8505500.0
2005-06-15 13:00:00	QQQ	ETF	37.32	37.41	37.28	37.37	6158500.0
2005-06-15 14:00:00	QQQ	ETF	37.38	37.55	37.35	37.49	11575200.0
2005-06-15 15:00:00	QQQ	ETF	37.49	37.73	37.44	37.7	18851500.0
2005-06-15 07:00:00	IWM	ETF	63.28	63.31	63.28	63.3	87000.0
2005-06-15 08:00:00	IWM	ETF	63.22	63.46	63.22	63.44	7600.0
2005-06-15 09:00:00	IWM	ETF	63.5	63.52	63.1	63.13	2669600.0
2005-06-15 10:00:00	IWM	ETF	63.13	63.15	62.64	62.68	4540300.0
2005-06-15 11:00:00	IWM	ETF	62.68	62.96	62.64	62.81	3280500.0
2005-06-15 12:00:00	IWM	ETF	62.81	63.02	62.8	62.96	984100.0
2005-06-15 13:00:00	IWM	ETF	62.97	63.06	62.85	63.0	1795100.0
2005-06-15 14:00:00	IWM	ETF	63.0	63.24	62.95	63.14	2562000.0
2005-06-15 15:00:00	IWM	ETF	63.14	63.44	63.07	63.39	3105100.0
2005-06-15 16:00:00	IWM	ETF	63.39	63.94	63.39	63.45	324000.0
2005-06-15 17:00:00	IWM	ETF	63.5	63.5	63.5	63.5	2000.0
2005-06-15 19:00:00	IWM	ETF	63.5	63.5	63.5	63.5	2000.0
2005-06-15 08:00:00	DIA	ETF	105.63	105.89	105.54	105.89	12300.0
2005-06-15 09:00:00	DIA	ETF	105.86	105.94	105.71	105.73	863600.0
2005-06-15 10:00:00	DIA	ETF	105.73	105.73	105.04	105.08	1532200.0
2005-06-15 11:00:00	DIA	ETF	105.06	105.26	104.99	105.01	911800.0
2005-06-15 12:00:00	DIA	ETF	105.02	105.25	105.01	105.17	327200.0
2005-06-15 13:00:00	DIA	ETF	105.17	105.29	105.0	105.27	841400.0
2005-06-15 14:00:00	DIA	ETF	105.28	105.58	105.16	105.44	923300.0
2005-06-15 15:00:00	DIA	ETF	105.44	105.74	105.33	105.7	562500.0
2005-06-15 16:00:00	DIA	ETF	105.71	105.75	105.63	105.7	118700.0
2005-06-15 19:00:00	DIA	ETF	105.71	105.71	105.71	105.71	200.0
2005-06-15 09:00:00	GLD	ETF	42.65	42.78	42.65	42.78	847300.0
2005-06-15 10:00:00	GLD	ETF	42.75	42.79	42.67	42.75	100400.0
2005-06-15 11:00:00	GLD	ETF	42.734	42.88	42.73	42.85	92300.0
2005-06-15 12:00:00	GLD	ETF	42.85	42.89	42.83	42.88	456700.0
2005-06-15 13:00:00	GLD	ETF	42.87	42.88	42.79	42.8	78800.0
2005-06-15 14:00:00	GLD	ETF	42.82	42.83	42.75	42.75	629600.0
2005-06-15 15:00:00	GLD	ETF	42.77	42.78	42.71	42.74	106300.0
2005-06-15 08:00:00	TLT	ETF	93.72	93.9	93.66	93.88	16000.0
2005-06-15 09:00:00	TLT	ETF	93.5	93.54	93.33	93.47	447800.0

> showing 50 of 861 rows — these rows as CSV

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