PREVIEW / etf_1hour / 2004-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-30.parquet
  size:    27 KB
  rows:    775

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-30 08:00:00	SPY	ETF	117.69	117.98	117.69	117.9	240700.0
2004-11-30 09:00:00	SPY	ETF	117.95	118.2	117.75	117.93	8143700.0
2004-11-30 10:00:00	SPY	ETF	117.92	118.19	117.64	117.76	9677500.0
2004-11-30 11:00:00	SPY	ETF	117.76	118.02	117.68	117.94	3769800.0
2004-11-30 12:00:00	SPY	ETF	117.94	118.24	117.85	117.94	7053800.0
2004-11-30 13:00:00	SPY	ETF	117.94	118.08	117.77	117.87	3446200.0
2004-11-30 14:00:00	SPY	ETF	117.86	118.0	117.71	117.8	4415100.0
2004-11-30 15:00:00	SPY	ETF	117.81	118.09	117.72	117.73	7565700.0
2004-11-30 16:00:00	SPY	ETF	117.72	118.0	117.64	118.0	4860800.0
2004-11-30 17:00:00	SPY	ETF	118.0	118.12	117.71	118.06	978500.0
2004-11-30 18:00:00	SPY	ETF	118.06	118.06	118.02	118.02	2000.0
2004-11-30 19:00:00	SPY	ETF	117.96	117.96	117.96	117.96	200.0
2004-11-30 08:00:00	QQQ	ETF	39.19	39.3	39.16	39.29	484800.0
2004-11-30 09:00:00	QQQ	ETF	39.29	39.3	39.27	39.3	191800.0
2004-11-30 08:00:00	IWM	ETF	63.07	63.125	63.05	63.05	42000.0
2004-11-30 09:00:00	IWM	ETF	63.22	63.345	63.06	63.195	1886600.0
2004-11-30 10:00:00	IWM	ETF	63.205	63.345	63.13	63.17	2824400.0
2004-11-30 11:00:00	IWM	ETF	63.155	63.435	63.11	63.425	1454600.0
2004-11-30 12:00:00	IWM	ETF	63.415	63.49	63.33	63.36	1440400.0
2004-11-30 13:00:00	IWM	ETF	63.355	63.455	63.185	63.295	864200.0
2004-11-30 14:00:00	IWM	ETF	63.275	63.36	63.185	63.25	1048000.0
2004-11-30 15:00:00	IWM	ETF	63.25	63.435	63.15	63.15	2252000.0
2004-11-30 16:00:00	IWM	ETF	63.135	63.44	63.065	63.415	738800.0
2004-11-30 17:00:00	IWM	ETF	63.46	63.47	63.36	63.36	60200.0
2004-11-30 18:00:00	IWM	ETF	63.405	63.405	63.405	63.405	800.0
2004-11-30 08:00:00	DIA	ETF	104.55	104.59	104.47	104.47	9700.0
2004-11-30 09:00:00	DIA	ETF	104.58	104.76	104.34	104.49	900800.0
2004-11-30 10:00:00	DIA	ETF	104.51	104.75	104.21	104.27	1556900.0
2004-11-30 11:00:00	DIA	ETF	104.29	104.5	104.2	104.44	736000.0
2004-11-30 12:00:00	DIA	ETF	104.43	104.73	104.39	104.5	741800.0
2004-11-30 13:00:00	DIA	ETF	104.49	104.6	104.29	104.34	831600.0
2004-11-30 14:00:00	DIA	ETF	104.34	104.43	104.2	104.3	996400.0
2004-11-30 15:00:00	DIA	ETF	104.3	104.54	104.27	104.3	1363300.0
2004-11-30 16:00:00	DIA	ETF	104.25	104.4	104.19	104.4	175100.0
2004-11-30 18:00:00	DIA	ETF	104.5	104.5	104.4	104.4	1100.0
2004-11-30 19:00:00	DIA	ETF	104.41	104.48	104.41	104.48	3000.0
2004-11-30 09:00:00	GLD	ETF	45.37	45.41	45.33	45.35	471800.0
2004-11-30 10:00:00	GLD	ETF	45.33	45.37	44.9	45.0	1075900.0
2004-11-30 11:00:00	GLD	ETF	45.0	45.06	44.82	44.9	714800.0
2004-11-30 12:00:00	GLD	ETF	44.92	45.18	44.88	45.08	853700.0
2004-11-30 13:00:00	GLD	ETF	45.06	45.16	44.95	45.16	249800.0
2004-11-30 14:00:00	GLD	ETF	45.14	45.17	45.1	45.14	160500.0
2004-11-30 15:00:00	GLD	ETF	45.12	45.15	45.1	45.12	162800.0
2004-11-30 16:00:00	GLD	ETF	45.11	45.17	45.1	45.17	5000.0
2004-11-30 08:00:00	TLT	ETF	87.32	87.32	86.87	86.87	30800.0
2004-11-30 09:00:00	TLT	ETF	86.98	87.04	86.87	87.01	255600.0
2004-11-30 10:00:00	TLT	ETF	87.0	87.16	86.94	87.0	314400.0
2004-11-30 11:00:00	TLT	ETF	86.97	87.0	86.63	86.69	253600.0
2004-11-30 12:00:00	TLT	ETF	86.75	86.91	86.72	86.91	126800.0
2004-11-30 13:00:00	TLT	ETF	86.89	86.97	86.82	86.97	137300.0

> showing 50 of 775 rows — these rows as CSV

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