PREVIEW / etf_1hour / 2004-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-23.parquet
  size:    26 KB
  rows:    780

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-12-23 08:00:00	SPY	ETF	120.79	120.97	120.77	120.89	162100.0
2004-12-23 09:00:00	SPY	ETF	120.91	121.09	120.83	120.98	3249700.0
2004-12-23 10:00:00	SPY	ETF	120.98	121.28	120.86	121.1	5938600.0
2004-12-23 11:00:00	SPY	ETF	121.11	121.22	121.04	121.06	3515000.0
2004-12-23 12:00:00	SPY	ETF	121.05	121.1	120.92	120.96	2655500.0
2004-12-23 13:00:00	SPY	ETF	120.95	121.1	120.87	121.01	2402800.0
2004-12-23 14:00:00	SPY	ETF	121.01	121.1	120.81	120.9	3369200.0
2004-12-23 15:00:00	SPY	ETF	120.89	121.04	120.82	120.99	2901200.0
2004-12-23 16:00:00	SPY	ETF	121.0	121.02	120.66	120.8	1125300.0
2004-12-23 17:00:00	SPY	ETF	120.81	120.83	120.8	120.83	1600.0
2004-12-23 18:00:00	SPY	ETF	120.83	120.83	120.83	120.83	800.0
2004-12-23 08:00:00	QQQ	ETF	39.62	39.691	39.6	39.68	379209.0
2004-12-23 09:00:00	QQQ	ETF	39.69	39.77	39.54	39.73	6357046.0
2004-12-23 10:00:00	QQQ	ETF	39.728	39.862	39.67	39.82	12796441.0
2004-12-23 11:00:00	QQQ	ETF	39.82	39.9	39.779	39.8	6620134.0
2004-12-23 12:00:00	QQQ	ETF	39.8	39.83	39.77	39.79	3158499.0
2004-12-23 13:00:00	QQQ	ETF	39.78	39.83	39.735	39.8	3369057.0
2004-12-23 14:00:00	QQQ	ETF	39.804	39.828	39.72	39.74	4167139.0
2004-12-23 15:00:00	QQQ	ETF	39.74	39.81	39.73	39.781	6031832.0
2004-12-23 16:00:00	QQQ	ETF	39.78	39.8	39.65	39.75	1511682.0
2004-12-23 17:00:00	QQQ	ETF	39.75	39.76	39.74	39.74	54200.0
2004-12-23 18:00:00	QQQ	ETF	39.74	39.75	39.74	39.75	3300.0
2004-12-23 08:00:00	IWM	ETF	64.59	64.59	64.55	64.55	16000.0
2004-12-23 09:00:00	IWM	ETF	64.56	64.695	64.505	64.63	588200.0
2004-12-23 10:00:00	IWM	ETF	64.625	64.8	64.54	64.76	1940400.0
2004-12-23 11:00:00	IWM	ETF	64.755	64.85	64.6299	64.665	1625400.0
2004-12-23 12:00:00	IWM	ETF	64.66	64.71	64.61	64.63	717200.0
2004-12-23 13:00:00	IWM	ETF	64.635	64.75	64.595	64.705	473000.0
2004-12-23 14:00:00	IWM	ETF	64.715	64.74	64.63	64.64	523600.0
2004-12-23 15:00:00	IWM	ETF	64.64	64.71	64.61	64.645	643600.0
2004-12-23 16:00:00	IWM	ETF	64.64	64.665	64.565	64.565	179400.0
2004-12-23 17:00:00	IWM	ETF	64.665	64.665	64.665	64.665	1349000.0
2004-12-23 08:00:00	DIA	ETF	108.11	108.21	108.06	108.15	2000.0
2004-12-23 09:00:00	DIA	ETF	108.15	108.31	108.08	108.25	863000.0
2004-12-23 10:00:00	DIA	ETF	108.25	108.55	108.17	108.41	811700.0
2004-12-23 11:00:00	DIA	ETF	108.41	108.47	108.3	108.31	260300.0
2004-12-23 12:00:00	DIA	ETF	108.31	108.33	108.22	108.25	264300.0
2004-12-23 13:00:00	DIA	ETF	108.24	108.34	108.19	108.27	388800.0
2004-12-23 14:00:00	DIA	ETF	108.27	108.31	108.1	108.15	311400.0
2004-12-23 15:00:00	DIA	ETF	108.14	108.27	108.1	108.25	354400.0
2004-12-23 16:00:00	DIA	ETF	108.26	108.27	108.09	108.18	51600.0
2004-12-23 09:00:00	GLD	ETF	44.17	44.18	44.1	44.14	116700.0
2004-12-23 10:00:00	GLD	ETF	44.15	44.23	44.1	44.12	135600.0
2004-12-23 11:00:00	GLD	ETF	44.14	44.15	44.05	44.13	160100.0
2004-12-23 12:00:00	GLD	ETF	44.14	44.18	44.11	44.15	26500.0
2004-12-23 13:00:00	GLD	ETF	44.16	44.28	44.13	44.18	55800.0
2004-12-23 14:00:00	GLD	ETF	44.22	44.35	44.21	44.34	66700.0
2004-12-23 15:00:00	GLD	ETF	44.34	44.34	44.27	44.29	77200.0
2004-12-23 16:00:00	GLD	ETF	44.27	44.27	44.27	44.27	1200.0
2004-12-23 08:00:00	TLT	ETF	88.75	88.76	88.6	88.6	15900.0

> showing 50 of 780 rows — these rows as CSV

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