PREVIEW / etf_1hour / 2004-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-06.parquet
  size:    27 KB
  rows:    773

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-06 08:00:00	SPY	ETF	119.23	119.23	119.09	119.19	18800.0
2004-12-06 09:00:00	SPY	ETF	119.19	119.27	118.89	119.09	5832000.0
2004-12-06 10:00:00	SPY	ETF	119.08	119.23	118.86	119.06	6642500.0
2004-12-06 11:00:00	SPY	ETF	119.05	119.09	118.84	119.08	3828400.0
2004-12-06 12:00:00	SPY	ETF	119.08	119.43	119.02	119.24	3335400.0
2004-12-06 13:00:00	SPY	ETF	119.23	119.49	119.2	119.48	2078700.0
2004-12-06 14:00:00	SPY	ETF	119.48	119.64	119.4	119.6	2898700.0
2004-12-06 15:00:00	SPY	ETF	119.61	119.62	119.34	119.34	4245100.0
2004-12-06 16:00:00	SPY	ETF	119.33	119.38	119.16	119.25	1454300.0
2004-12-06 17:00:00	SPY	ETF	119.21	119.26	119.2	119.2	25300.0
2004-12-06 18:00:00	SPY	ETF	119.2	119.2	119.2	119.2	2100.0
2004-12-06 19:00:00	SPY	ETF	119.23	119.23	119.23	119.23	600.0
2004-12-06 08:00:00	QQQ	ETF	40.09	40.115	40.01	40.079	328309.0
2004-12-06 09:00:00	QQQ	ETF	40.08	40.15	39.98	40.05	11896998.0
2004-12-06 10:00:00	QQQ	ETF	40.055	40.175	39.91	40.06	16071003.0
2004-12-06 11:00:00	QQQ	ETF	40.06	40.125	39.96	40.122	7349022.0
2004-12-06 12:00:00	QQQ	ETF	40.13	40.31	40.09	40.23	8329343.0
2004-12-06 13:00:00	QQQ	ETF	40.24	40.35	40.21	40.34	4870616.0
2004-12-06 14:00:00	QQQ	ETF	40.34	40.426	40.289	40.411	7051473.0
2004-12-06 15:00:00	QQQ	ETF	40.41	40.42	40.27	40.27	10977893.0
2004-12-06 16:00:00	QQQ	ETF	40.27	40.2935	40.17	40.24	2313227.0
2004-12-06 17:00:00	QQQ	ETF	40.25	40.29	40.23	40.29	87921.0
2004-12-06 18:00:00	QQQ	ETF	40.29	40.29	40.25	40.25	47470.0
2004-12-06 08:00:00	IWM	ETF	63.805	63.805	63.775	63.805	14600.0
2004-12-06 09:00:00	IWM	ETF	63.9	64.075	63.66	63.755	889600.0
2004-12-06 10:00:00	IWM	ETF	63.755	63.805	63.625	63.625	1224200.0
2004-12-06 11:00:00	IWM	ETF	63.62	63.62	63.43	63.6	980600.0
2004-12-06 12:00:00	IWM	ETF	63.595	63.81	63.58	63.75	579400.0
2004-12-06 13:00:00	IWM	ETF	63.75	63.99	63.74	63.97	486400.0
2004-12-06 14:00:00	IWM	ETF	63.975	64.015	63.855	63.94	394000.0
2004-12-06 15:00:00	IWM	ETF	63.95	63.95	63.65	63.67	1311600.0
2004-12-06 16:00:00	IWM	ETF	63.66	63.675	63.505	63.575	212400.0
2004-12-06 17:00:00	IWM	ETF	63.55	63.55	63.49	63.49	32000.0
2004-12-06 18:00:00	IWM	ETF	63.575	63.575	63.55	63.55	5000.0
2004-12-06 08:00:00	DIA	ETF	105.65	105.65	105.61	105.61	5400.0
2004-12-06 09:00:00	DIA	ETF	105.65	105.69	105.28	105.45	379800.0
2004-12-06 10:00:00	DIA	ETF	105.42	105.58	105.27	105.39	903700.0
2004-12-06 11:00:00	DIA	ETF	105.4	105.4	105.24	105.39	374400.0
2004-12-06 12:00:00	DIA	ETF	105.39	105.61	105.35	105.43	335300.0
2004-12-06 13:00:00	DIA	ETF	105.43	105.63	105.38	105.61	413300.0
2004-12-06 14:00:00	DIA	ETF	105.62	105.73	105.54	105.73	307600.0
2004-12-06 15:00:00	DIA	ETF	105.69	105.69	105.42	105.42	439600.0
2004-12-06 16:00:00	DIA	ETF	105.42	105.45	105.28	105.33	325800.0
2004-12-06 17:00:00	DIA	ETF	105.35	105.35	105.35	105.35	1000.0
2004-12-06 09:00:00	GLD	ETF	45.39	45.46	45.31	45.44	259000.0
2004-12-06 10:00:00	GLD	ETF	45.44	45.44	45.11	45.26	526600.0
2004-12-06 11:00:00	GLD	ETF	45.25	45.39	45.21	45.37	327300.0
2004-12-06 12:00:00	GLD	ETF	45.36	45.46	45.29	45.46	253400.0
2004-12-06 13:00:00	GLD	ETF	45.47	45.47	45.36	45.39	401600.0
2004-12-06 14:00:00	GLD	ETF	45.39	45.43	45.34	45.42	368800.0

> showing 50 of 773 rows — these rows as CSV

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