PREVIEW / etf_1hour / 2005-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-08.parquet
  size:    30 KB
  rows:    870

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-04-08 08:00:00	SPY	ETF	119.2	119.2	119.16	119.19	13100.0
2005-04-08 09:00:00	SPY	ETF	119.19	119.21	119.04	119.13	5323200.0
2005-04-08 10:00:00	SPY	ETF	119.13	119.19	118.66	118.81	10694300.0
2005-04-08 11:00:00	SPY	ETF	118.81	118.92	118.52	118.66	10035900.0
2005-04-08 12:00:00	SPY	ETF	118.67	118.87	118.53	118.55	3812600.0
2005-04-08 13:00:00	SPY	ETF	118.56	118.79	118.54	118.71	9259300.0
2005-04-08 14:00:00	SPY	ETF	118.71	118.72	118.34	118.44	8310300.0
2005-04-08 15:00:00	SPY	ETF	118.449	118.47	118.08	118.09	11251200.0
2005-04-08 16:00:00	SPY	ETF	118.12	118.17	117.75	117.83	3264200.0
2005-04-08 17:00:00	SPY	ETF	117.84	117.94	117.75	117.78	98000.0
2005-04-08 18:00:00	SPY	ETF	117.77	117.8	117.7	117.78	14300.0
2005-04-08 19:00:00	SPY	ETF	117.78	117.85	117.73	117.73	5600.0
2005-04-08 09:00:00	QQQ	ETF	37.01	37.04	36.95	37.03	11590400.0
2005-04-08 10:00:00	QQQ	ETF	37.03	37.07	36.86	36.91	16916900.0
2005-04-08 11:00:00	QQQ	ETF	36.91	36.93	36.78	36.82	8459500.0
2005-04-08 12:00:00	QQQ	ETF	36.81	36.88	36.73	36.73	6960100.0
2005-04-08 13:00:00	QQQ	ETF	36.73	36.85	36.72	36.81	7607600.0
2005-04-08 14:00:00	QQQ	ETF	36.81	36.82	36.65	36.72	15162600.0
2005-04-08 15:00:00	QQQ	ETF	36.71	36.72	36.6	36.64	17740600.0
2005-04-08 09:00:00	IWM	ETF	61.605	61.66	61.35	61.48	1172400.0
2005-04-08 10:00:00	IWM	ETF	61.475	61.52	61.115	61.215	5378400.0
2005-04-08 11:00:00	IWM	ETF	61.215	61.25	60.935	61.01	3287800.0
2005-04-08 12:00:00	IWM	ETF	61.01	61.13	60.94	60.965	1369600.0
2005-04-08 13:00:00	IWM	ETF	60.96	61.125	60.945	61.0	1308400.0
2005-04-08 14:00:00	IWM	ETF	60.985	60.995	60.765	60.87	2216000.0
2005-04-08 15:00:00	IWM	ETF	60.86	60.89	60.63	60.66	3467600.0
2005-04-08 16:00:00	IWM	ETF	60.67	60.71	60.475	60.5	532400.0
2005-04-08 17:00:00	IWM	ETF	60.5	60.5	60.5	60.5	3000.0
2005-04-08 18:00:00	IWM	ETF	60.5	60.5	60.5	60.5	2000.0
2005-04-08 19:00:00	IWM	ETF	60.5	60.5	60.5	60.5	200.0
2005-04-08 08:00:00	DIA	ETF	105.51	105.53	105.51	105.53	2300.0
2005-04-08 09:00:00	DIA	ETF	105.52	105.54	105.38	105.51	364600.0
2005-04-08 10:00:00	DIA	ETF	105.51	105.52	105.04	105.19	941600.0
2005-04-08 11:00:00	DIA	ETF	105.16	105.24	104.89	104.97	719400.0
2005-04-08 12:00:00	DIA	ETF	104.98	105.13	104.93	104.95	246700.0
2005-04-08 13:00:00	DIA	ETF	104.95	105.14	104.94	105.09	280200.0
2005-04-08 14:00:00	DIA	ETF	105.08	105.08	104.8	104.85	351600.0
2005-04-08 15:00:00	DIA	ETF	104.84	104.88	104.58	104.61	568600.0
2005-04-08 16:00:00	DIA	ETF	104.61	104.61	104.4	104.42	93100.0
2005-04-08 17:00:00	DIA	ETF	104.44	104.44	104.37	104.4	1700.0
2005-04-08 18:00:00	DIA	ETF	104.35	104.4	104.35	104.4	300.0
2005-04-08 09:00:00	GLD	ETF	42.48	42.53	42.459	42.51	58600.0
2005-04-08 10:00:00	GLD	ETF	42.51	42.6	42.46	42.56	471700.0
2005-04-08 11:00:00	GLD	ETF	42.55	42.71	42.55	42.7	211300.0
2005-04-08 12:00:00	GLD	ETF	42.69	42.7	42.65	42.65	52400.0
2005-04-08 13:00:00	GLD	ETF	42.66	42.71	42.653	42.67	15100.0
2005-04-08 14:00:00	GLD	ETF	42.66	42.69	42.64	42.68	97700.0
2005-04-08 15:00:00	GLD	ETF	42.68	42.7	42.67	42.67	83900.0
2005-04-08 16:00:00	GLD	ETF	42.69	42.69	42.69	42.69	1000.0
2005-04-08 17:00:00	GLD	ETF	42.7	42.7	42.7	42.7	200.0

> showing 50 of 870 rows — these rows as CSV

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