PREVIEW / etf_1hour / 2005-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-20.parquet
  size:    33 KB
  rows:    989

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-09-20 07:00:00	SPY	ETF	123.35	123.4	123.33	123.37	90400.0
2005-09-20 08:00:00	SPY	ETF	123.33	123.42	123.24	123.24	1674700.0
2005-09-20 09:00:00	SPY	ETF	123.25	123.39	123.17	123.27	4735100.0
2005-09-20 10:00:00	SPY	ETF	123.29	123.61	123.27	123.45	10662600.0
2005-09-20 11:00:00	SPY	ETF	123.48	123.55	123.33	123.36	2103900.0
2005-09-20 12:00:00	SPY	ETF	123.36	123.37	123.21	123.3	3057200.0
2005-09-20 13:00:00	SPY	ETF	123.3	123.31	123.14	123.19	2777400.0
2005-09-20 14:00:00	SPY	ETF	123.19	123.33	122.16	122.28	29954100.0
2005-09-20 15:00:00	SPY	ETF	122.28	122.29	121.87	122.1	25337300.0
2005-09-20 16:00:00	SPY	ETF	122.11	122.11	122.0	122.0	2213000.0
2005-09-20 17:00:00	SPY	ETF	122.02	122.02	121.89	121.91	426700.0
2005-09-20 18:00:00	SPY	ETF	121.91	121.97	121.9	121.95	42000.0
2005-09-20 19:00:00	SPY	ETF	121.95	121.95	121.95	121.95	2300.0
2005-09-20 09:00:00	QQQ	ETF	39.16	39.31	39.15	39.29	8269000.0
2005-09-20 10:00:00	QQQ	ETF	39.3	39.54	39.29	39.47	21650500.0
2005-09-20 11:00:00	QQQ	ETF	39.47	39.49	39.42	39.44	4966700.0
2005-09-20 12:00:00	QQQ	ETF	39.44	39.45	39.38	39.4	3498400.0
2005-09-20 13:00:00	QQQ	ETF	39.39	39.4	39.3	39.31	6174800.0
2005-09-20 14:00:00	QQQ	ETF	39.3	39.42	38.89	38.97	36127500.0
2005-09-20 15:00:00	QQQ	ETF	38.97	39.02	38.8	38.92	26305800.0
2005-09-20 08:00:00	IWM	ETF	66.76	66.8	66.71	66.8	518000.0
2005-09-20 09:00:00	IWM	ETF	66.76	66.81	66.7	66.71	1710700.0
2005-09-20 10:00:00	IWM	ETF	66.72	66.92	66.68	66.87	3489500.0
2005-09-20 11:00:00	IWM	ETF	66.86	66.89	66.8	66.81	1674900.0
2005-09-20 12:00:00	IWM	ETF	66.82	66.83	66.66	66.7	1137100.0
2005-09-20 13:00:00	IWM	ETF	66.7	66.71	66.58	66.6	737000.0
2005-09-20 14:00:00	IWM	ETF	66.6	66.71	65.7	65.76	10974700.0
2005-09-20 15:00:00	IWM	ETF	65.77	65.86	65.56	65.76	7837300.0
2005-09-20 16:00:00	IWM	ETF	65.76	65.8885	65.61	65.67	820600.0
2005-09-20 17:00:00	IWM	ETF	65.67	65.67	65.59	65.6	162700.0
2005-09-20 18:00:00	IWM	ETF	65.58	65.6	65.58	65.6	23200.0
2005-09-20 07:00:00	DIA	ETF	105.8	105.8	105.8	105.8	500.0
2005-09-20 08:00:00	DIA	ETF	105.82	105.85	105.71	105.71	13300.0
2005-09-20 09:00:00	DIA	ETF	105.7	105.81	105.65	105.75	364800.0
2005-09-20 10:00:00	DIA	ETF	105.79	105.97	105.74	105.89	1501100.0
2005-09-20 11:00:00	DIA	ETF	105.89	105.94	105.82	105.82	176700.0
2005-09-20 12:00:00	DIA	ETF	105.84	105.85	105.67	105.73	787300.0
2005-09-20 13:00:00	DIA	ETF	105.74	105.74	105.57	105.61	536900.0
2005-09-20 14:00:00	DIA	ETF	105.61	105.76	104.77	104.86	3865700.0
2005-09-20 15:00:00	DIA	ETF	104.84	104.89	104.57	104.78	2632100.0
2005-09-20 16:00:00	DIA	ETF	104.78	104.78	104.7	104.7	628300.0
2005-09-20 17:00:00	DIA	ETF	104.68	104.74	104.53	104.53	2100.0
2005-09-20 18:00:00	DIA	ETF	104.7	104.7	104.7	104.7	300.0
2005-09-20 07:00:00	GLD	ETF	46.55	46.6	46.55	46.6	3000.0
2005-09-20 08:00:00	GLD	ETF	46.55	46.65	46.42	46.42	12400.0
2005-09-20 09:00:00	GLD	ETF	46.44	46.52	46.31	46.37	433200.0
2005-09-20 10:00:00	GLD	ETF	46.3695	46.46	46.26	46.42	238100.0
2005-09-20 11:00:00	GLD	ETF	46.43	46.5	46.4	46.42	180000.0
2005-09-20 12:00:00	GLD	ETF	46.44	46.46	46.29	46.35	109900.0
2005-09-20 13:00:00	GLD	ETF	46.34	46.52	46.33	46.45	160900.0

> showing 50 of 989 rows — these rows as CSV

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