PREVIEW / etf_1hour / 2005-05-11

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-11.parquet
  size:    30 KB
  rows:    853

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-05-11 05:00:00	SPY	ETF	117.06	117.06	116.99	116.99	500.0
2005-05-11 06:00:00	SPY	ETF	117.01	117.01	117.01	117.01	2000.0
2005-05-11 07:00:00	SPY	ETF	116.9	116.97	116.86	116.87	190900.0
2005-05-11 08:00:00	SPY	ETF	116.8	117.01	116.77	116.96	503700.0
2005-05-11 09:00:00	SPY	ETF	116.96	117.01	116.66	116.71	9997900.0
2005-05-11 10:00:00	SPY	ETF	116.69	116.84	116.26	116.36	18065800.0
2005-05-11 11:00:00	SPY	ETF	116.36	116.5567	116.14	116.38	11016100.0
2005-05-11 12:00:00	SPY	ETF	116.38	116.6	115.85	116.52	23680600.0
2005-05-11 13:00:00	SPY	ETF	116.52	116.9	116.5	116.64	6441700.0
2005-05-11 14:00:00	SPY	ETF	116.64	117.38	116.62	117.16	10720100.0
2005-05-11 15:00:00	SPY	ETF	117.16	117.4	116.98	117.2	8898400.0
2005-05-11 16:00:00	SPY	ETF	117.24	117.33	116.4738	117.3	644800.0
2005-05-11 17:00:00	SPY	ETF	117.3	117.32	117.3	117.32	175900.0
2005-05-11 18:00:00	SPY	ETF	117.28	117.3	117.25	117.26	1800.0
2005-05-11 19:00:00	SPY	ETF	117.25	117.3	117.22	117.3	31500.0
2005-05-11 09:00:00	QQQ	ETF	35.82	35.89	35.71	35.72	10351200.0
2005-05-11 10:00:00	QQQ	ETF	35.72	35.78	35.47	35.5	23962000.0
2005-05-11 11:00:00	QQQ	ETF	35.5	35.52	35.37	35.48	14991100.0
2005-05-11 12:00:00	QQQ	ETF	35.48	35.55	35.3	35.54	20136300.0
2005-05-11 13:00:00	QQQ	ETF	35.54	35.68	35.52	35.63	10301300.0
2005-05-11 14:00:00	QQQ	ETF	35.63	36.03	35.62	35.88	25637600.0
2005-05-11 15:00:00	QQQ	ETF	35.87	35.99	35.82	35.95	17877200.0
2005-05-11 07:00:00	IWM	ETF	59.395	59.395	59.395	59.395	1000.0
2005-05-11 08:00:00	IWM	ETF	59.375	59.45	59.335	59.375	135800.0
2005-05-11 09:00:00	IWM	ETF	59.375	59.42	59.05	59.06	4211000.0
2005-05-11 10:00:00	IWM	ETF	59.065	59.105	58.655	58.71	7339400.0
2005-05-11 11:00:00	IWM	ETF	58.71	58.82	58.55	58.705	3100800.0
2005-05-11 12:00:00	IWM	ETF	58.705	58.9	58.505	58.865	3292200.0
2005-05-11 13:00:00	IWM	ETF	58.855	59.06	58.785	58.865	3101400.0
2005-05-11 14:00:00	IWM	ETF	58.86	59.385	58.845	59.205	4518000.0
2005-05-11 15:00:00	IWM	ETF	59.21	59.37	59.115	59.22	4965200.0
2005-05-11 16:00:00	IWM	ETF	59.24	59.285	59.18	59.235	192800.0
2005-05-11 07:00:00	DIA	ETF	102.98	102.98	102.92	102.97	11800.0
2005-05-11 08:00:00	DIA	ETF	102.88	103.02	102.8	103.01	57500.0
2005-05-11 09:00:00	DIA	ETF	103.02	103.09	102.72	102.75	668400.0
2005-05-11 10:00:00	DIA	ETF	102.73	102.83	102.31	102.43	1601100.0
2005-05-11 11:00:00	DIA	ETF	102.42	102.46	102.2	102.33	862900.0
2005-05-11 12:00:00	DIA	ETF	102.34	102.5	100.6	102.44	1584200.0
2005-05-11 13:00:00	DIA	ETF	102.43	102.85	102.42	102.58	734000.0
2005-05-11 14:00:00	DIA	ETF	102.57	103.25	102.54	103.04	1215400.0
2005-05-11 15:00:00	DIA	ETF	103.05	103.24	102.86	103.06	884000.0
2005-05-11 16:00:00	DIA	ETF	103.1	103.13	103.1	103.13	2700.0
2005-05-11 17:00:00	DIA	ETF	103.15	103.15	103.15	103.15	100.0
2005-05-11 19:00:00	DIA	ETF	103.15	103.15	103.15	103.15	900.0
2005-05-11 08:00:00	GLD	ETF	42.64	42.64	42.51	42.54	44500.0
2005-05-11 09:00:00	GLD	ETF	42.55	42.61	42.5	42.58	165100.0
2005-05-11 10:00:00	GLD	ETF	42.58	42.69	42.51	42.69	117700.0
2005-05-11 11:00:00	GLD	ETF	42.69	42.73	42.66	42.68	95500.0
2005-05-11 12:00:00	GLD	ETF	42.66	42.83	42.63	42.67	183200.0
2005-05-11 13:00:00	GLD	ETF	42.67	42.73	42.64	42.7	54000.0

> showing 50 of 853 rows — these rows as CSV

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