PREVIEW / etf_1hour / 2005-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-09.parquet
  size:    30 KB
  rows:    864

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-03-09 08:00:00	SPY	ETF	122.13	122.14	121.7	121.91	530800.0
2005-03-09 09:00:00	SPY	ETF	121.92	122.16	121.79	121.82	7208200.0
2005-03-09 10:00:00	SPY	ETF	121.79	122.29	121.65	122.09	14103900.0
2005-03-09 11:00:00	SPY	ETF	122.11	122.2	121.91	121.94	3832200.0
2005-03-09 12:00:00	SPY	ETF	121.96	121.97	121.35	121.35	10725200.0
2005-03-09 13:00:00	SPY	ETF	121.37	121.72	121.34	121.59	7321400.0
2005-03-09 14:00:00	SPY	ETF	121.6	121.84	121.34	121.54	8558800.0
2005-03-09 15:00:00	SPY	ETF	121.56	121.59	120.98	121.03	15610000.0
2005-03-09 16:00:00	SPY	ETF	121.0	121.08	120.96	121.03	1158600.0
2005-03-09 17:00:00	SPY	ETF	122.15	122.15	121.0	121.03	41600.0
2005-03-09 18:00:00	SPY	ETF	121.03	121.07	121.03	121.06	3400.0
2005-03-09 19:00:00	SPY	ETF	121.02	121.08	121.02	121.08	4100.0
2005-03-09 09:00:00	QQQ	ETF	37.67	37.76	37.58	37.59	10931000.0
2005-03-09 10:00:00	QQQ	ETF	37.59	37.93	37.56	37.83	21664000.0
2005-03-09 11:00:00	QQQ	ETF	37.84	37.89	37.76	37.81	8147800.0
2005-03-09 12:00:00	QQQ	ETF	37.81	37.81	37.5	37.53	16138900.0
2005-03-09 13:00:00	QQQ	ETF	37.52	37.66	37.51	37.65	10352200.0
2005-03-09 14:00:00	QQQ	ETF	37.65	37.72	37.53	37.67	8462300.0
2005-03-09 15:00:00	QQQ	ETF	37.67	37.71	37.47	37.57	15084200.0
2005-03-09 08:00:00	IWM	ETF	63.5	63.5	63.3	63.335	5000.0
2005-03-09 09:00:00	IWM	ETF	63.38	63.505	63.055	63.06	2718000.0
2005-03-09 10:00:00	IWM	ETF	63.05	63.495	62.92	63.4	5114200.0
2005-03-09 11:00:00	IWM	ETF	63.4	63.57	63.31	63.405	2845600.0
2005-03-09 12:00:00	IWM	ETF	63.405	63.435	63.075	63.105	4165000.0
2005-03-09 13:00:00	IWM	ETF	63.08	63.3	63.08	63.28	1129000.0
2005-03-09 14:00:00	IWM	ETF	63.28	63.43	63.16	63.33	2185000.0
2005-03-09 15:00:00	IWM	ETF	63.315	63.345	62.89	62.93	3843600.0
2005-03-09 16:00:00	IWM	ETF	62.94	62.94	62.85	62.855	997600.0
2005-03-09 17:00:00	IWM	ETF	62.855	63.0	62.85	62.865	46600.0
2005-03-09 08:00:00	DIA	ETF	108.87	108.87	108.71	108.77	6700.0
2005-03-09 09:00:00	DIA	ETF	108.85	109.01	108.76	108.8	394200.0
2005-03-09 10:00:00	DIA	ETF	108.78	109.23	108.69	109.09	800400.0
2005-03-09 11:00:00	DIA	ETF	109.09	109.13	108.86	108.86	458300.0
2005-03-09 12:00:00	DIA	ETF	108.87	108.87	108.23	108.25	1208500.0
2005-03-09 13:00:00	DIA	ETF	108.27	108.45	108.25	108.45	444900.0
2005-03-09 14:00:00	DIA	ETF	108.45	108.66	108.27	108.42	544400.0
2005-03-09 15:00:00	DIA	ETF	108.43	108.45	108.0	108.05	1135600.0
2005-03-09 16:00:00	DIA	ETF	108.09	108.09	107.99	108.06	8100.0
2005-03-09 17:00:00	DIA	ETF	108.05	108.05	108.01	108.05	800.0
2005-03-09 08:00:00	GLD	ETF	44.07	44.07	43.92	43.92	800.0
2005-03-09 09:00:00	GLD	ETF	43.96	44.04	43.89	43.99	856600.0
2005-03-09 10:00:00	GLD	ETF	43.99	44.04	43.94	43.99	347000.0
2005-03-09 11:00:00	GLD	ETF	43.98	44.08	43.94	44.07	257400.0
2005-03-09 12:00:00	GLD	ETF	44.06	44.2	44.02	44.18	285900.0
2005-03-09 13:00:00	GLD	ETF	44.18	44.2	44.14	44.17	150900.0
2005-03-09 14:00:00	GLD	ETF	44.17	44.18	44.129	44.14	786300.0
2005-03-09 15:00:00	GLD	ETF	44.15	44.16	44.02	44.04	337200.0
2005-03-09 16:00:00	GLD	ETF	43.97	43.97	43.97	43.97	200.0
2005-03-09 08:00:00	TLT	ETF	89.16	89.2	88.76	89.19	150300.0
2005-03-09 09:00:00	TLT	ETF	89.19	89.2	89.0	89.05	255200.0

> showing 50 of 864 rows — these rows as CSV

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