PREVIEW / etf_1hour / 2004-11-23

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-23.parquet
  size:    27 KB
  rows:    768

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
2004-11-23 08:00:00	SPY	ETF	117.92	117.95	117.89	117.94	27000.0
2004-11-23 09:00:00	SPY	ETF	117.95	118.0	117.75	117.89	4135700.0
2004-11-23 10:00:00	SPY	ETF	117.86	118.24	117.51	117.55	9426800.0
2004-11-23 11:00:00	SPY	ETF	117.55	117.61	117.37	117.51	6347200.0
2004-11-23 12:00:00	SPY	ETF	117.51	117.65	117.43	117.54	3943300.0
2004-11-23 13:00:00	SPY	ETF	117.53	117.72	117.46	117.69	2278700.0
2004-11-23 14:00:00	SPY	ETF	117.68	118.26	117.67	117.93	6518400.0
2004-11-23 15:00:00	SPY	ETF	117.93	118.06	117.72	118.0	5999300.0
2004-11-23 16:00:00	SPY	ETF	117.97	118.24	117.8778	118.19	2137900.0
2004-11-23 17:00:00	SPY	ETF	118.19	118.19	118.13	118.18	14800.0
2004-11-23 18:00:00	SPY	ETF	118.2	118.2	118.15	118.2	4700.0
2004-11-23 08:00:00	QQQ	ETF	38.98	39.01	38.97	38.99	74100.0
2004-11-23 09:00:00	QQQ	ETF	38.99	39.03	38.87	38.96	9013300.0
2004-11-23 10:00:00	QQQ	ETF	38.95	39.15	38.75	38.79	18829800.0
2004-11-23 11:00:00	QQQ	ETF	38.79	38.8	38.61	38.68	12138400.0
2004-11-23 12:00:00	QQQ	ETF	38.68	38.73	38.63	38.69	6140700.0
2004-11-23 13:00:00	QQQ	ETF	38.69	38.75	38.659	38.735	5308100.0
2004-11-23 14:00:00	QQQ	ETF	38.734	39.0	38.734	38.87	20252000.0
2004-11-23 15:00:00	QQQ	ETF	38.87	38.95	38.8	38.89	11997600.0
2004-11-23 16:00:00	QQQ	ETF	38.9	39.06	38.895	39.05	3113000.0
2004-11-23 17:00:00	QQQ	ETF	39.04	39.06	39.03	39.05	310600.0
2004-11-23 18:00:00	QQQ	ETF	39.06	39.07	39.03	39.05	7000.0
2004-11-23 19:00:00	QQQ	ETF	39.06	39.1	39.04	39.1	10700.0
2004-11-23 08:00:00	IWM	ETF	61.975	61.975	61.975	61.975	23800.0
2004-11-23 09:00:00	IWM	ETF	62.0	62.1	61.83	62.04	1012600.0
2004-11-23 10:00:00	IWM	ETF	62.06	62.295	61.79	61.825	3314800.0
2004-11-23 11:00:00	IWM	ETF	61.805	61.84	61.395	61.585	4864600.0
2004-11-23 12:00:00	IWM	ETF	61.59	61.95	61.59	61.875	2272600.0
2004-11-23 13:00:00	IWM	ETF	61.87	62.17	61.77	62.11	1884000.0
2004-11-23 14:00:00	IWM	ETF	62.115	62.32	61.97	61.97	2416800.0
2004-11-23 15:00:00	IWM	ETF	61.975	62.255	61.945	62.245	1214000.0
2004-11-23 16:00:00	IWM	ETF	62.255	62.39	62.25	62.38	234800.0
2004-11-23 17:00:00	IWM	ETF	62.415	62.415	62.375	62.375	7200.0
2004-11-23 18:00:00	IWM	ETF	62.35	62.35	62.35	62.35	400.0
2004-11-23 08:00:00	DIA	ETF	104.79	104.8	104.73	104.74	6600.0
2004-11-23 09:00:00	DIA	ETF	104.75	104.86	104.61	104.67	545500.0
2004-11-23 10:00:00	DIA	ETF	104.67	105.03	104.36	104.43	1509300.0
2004-11-23 11:00:00	DIA	ETF	104.43	104.45	104.26	104.39	942300.0
2004-11-23 12:00:00	DIA	ETF	104.37	104.46	104.28	104.36	469800.0
2004-11-23 13:00:00	DIA	ETF	104.38	104.51	104.3	104.45	496300.0
2004-11-23 14:00:00	DIA	ETF	104.44	104.97	104.44	104.75	1406000.0
2004-11-23 15:00:00	DIA	ETF	104.73	104.85	104.54	104.83	1282600.0
2004-11-23 16:00:00	DIA	ETF	104.84	105.0	104.81	105.0	132100.0
2004-11-23 17:00:00	DIA	ETF	104.91	104.93	104.91	104.91	500.0
2004-11-23 18:00:00	DIA	ETF	104.93	104.93	104.93	104.93	100.0
2004-11-23 09:00:00	GLD	ETF	44.88	44.88	44.82	44.84	527100.0
2004-11-23 10:00:00	GLD	ETF	44.84	44.92	44.83	44.86	760400.0
2004-11-23 11:00:00	GLD	ETF	44.87	44.91	44.86	44.88	539400.0
2004-11-23 12:00:00	GLD	ETF	44.88	44.9	44.86	44.87	192900.0
2004-11-23 13:00:00	GLD	ETF	44.87	44.87	44.78	44.79	260700.0

> showing 50 of 768 rows — these rows as CSV

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