PREVIEW / etf_1hour / 2005-03-30

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-30.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-03-30 08:00:00	SPY	ETF	116.9	116.93	116.79	116.79	623300.0
2005-03-30 09:00:00	SPY	ETF	116.75	117.1	116.7	116.95	7603200.0
2005-03-30 10:00:00	SPY	ETF	116.96	117.41	116.9	117.289	11664900.0
2005-03-30 11:00:00	SPY	ETF	117.29	117.67	117.18	117.66	6256700.0
2005-03-30 12:00:00	SPY	ETF	117.67	117.81	117.57	117.72	6630000.0
2005-03-30 13:00:00	SPY	ETF	117.71	117.85	117.52	117.73	5791400.0
2005-03-30 14:00:00	SPY	ETF	117.74	117.92	117.42	117.67	10201200.0
2005-03-30 15:00:00	SPY	ETF	117.66	118.13	117.66	118.12	10109700.0
2005-03-30 16:00:00	SPY	ETF	118.12	118.29	118.07	118.2	1785500.0
2005-03-30 17:00:00	SPY	ETF	118.2	118.24	118.2	118.2	15000.0
2005-03-30 18:00:00	SPY	ETF	118.23	118.27	118.2	118.27	7800.0
2005-03-30 19:00:00	SPY	ETF	118.22	118.22	118.22	118.22	900.0
2005-03-30 09:00:00	QQQ	ETF	36.23	36.35	36.22	36.26	14097000.0
2005-03-30 10:00:00	QQQ	ETF	36.26	36.59	36.25	36.54	20813700.0
2005-03-30 11:00:00	QQQ	ETF	36.54	36.73	36.5	36.72	13482000.0
2005-03-30 12:00:00	QQQ	ETF	36.72	37.71	36.65	36.7	13791700.0
2005-03-30 13:00:00	QQQ	ETF	36.7	36.77	36.61	36.66	8723700.0
2005-03-30 14:00:00	QQQ	ETF	36.66	36.75	36.51	36.62	18273700.0
2005-03-30 15:00:00	QQQ	ETF	36.62	36.74	36.61	36.73	18743100.0
2005-03-30 08:00:00	IWM	ETF	60.345	60.435	60.325	60.325	52200.0
2005-03-30 09:00:00	IWM	ETF	60.395	60.625	60.275	60.43	2132800.0
2005-03-30 10:00:00	IWM	ETF	60.43	60.725	60.425	60.65	3527400.0
2005-03-30 11:00:00	IWM	ETF	60.66	60.805	60.475	60.775	2630800.0
2005-03-30 12:00:00	IWM	ETF	60.78	60.95	60.775	60.88	3542800.0
2005-03-30 13:00:00	IWM	ETF	60.86	60.91	60.715	60.835	1124000.0
2005-03-30 14:00:00	IWM	ETF	60.84	60.98	60.69	60.76	1756000.0
2005-03-30 15:00:00	IWM	ETF	60.745	61.12	60.72	61.055	3759400.0
2005-03-30 16:00:00	IWM	ETF	61.045	61.115	61.02	61.075	307200.0
2005-03-30 08:00:00	DIA	ETF	104.28	104.3	104.25	104.28	12800.0
2005-03-30 09:00:00	DIA	ETF	104.2	104.47	104.18	104.4	1044700.0
2005-03-30 10:00:00	DIA	ETF	104.4	104.87	104.36	104.81	1231400.0
2005-03-30 11:00:00	DIA	ETF	104.82	105.07	104.69	105.04	679900.0
2005-03-30 12:00:00	DIA	ETF	105.05	105.17	104.99	105.0	656000.0
2005-03-30 13:00:00	DIA	ETF	105.01	105.15	104.83	105.01	285300.0
2005-03-30 14:00:00	DIA	ETF	104.99	105.19	104.76	104.96	818200.0
2005-03-30 15:00:00	DIA	ETF	104.95	105.39	104.95	105.38	876900.0
2005-03-30 16:00:00	DIA	ETF	105.41	105.45	105.33	105.39	8600.0
2005-03-30 17:00:00	DIA	ETF	105.39	105.45	105.39	105.42	3600.0
2005-03-30 19:00:00	DIA	ETF	105.4	105.4	105.4	105.4	300.0
2005-03-30 08:00:00	GLD	ETF	42.61	42.67	42.61	42.63	4500.0
2005-03-30 09:00:00	GLD	ETF	42.63	42.65	42.6	42.64	85600.0
2005-03-30 10:00:00	GLD	ETF	42.65	42.66	42.61	42.61	95100.0
2005-03-30 11:00:00	GLD	ETF	42.6	42.73	42.58	42.73	124900.0
2005-03-30 12:00:00	GLD	ETF	42.74	42.81	42.72	42.78	702100.0
2005-03-30 13:00:00	GLD	ETF	42.78	42.78	42.64	42.67	90000.0
2005-03-30 14:00:00	GLD	ETF	42.68	42.68	42.56	42.63	139700.0
2005-03-30 15:00:00	GLD	ETF	42.63	42.65	42.58	42.6	80200.0
2005-03-30 08:00:00	TLT	ETF	88.24	88.24	88.24	88.24	100.0
2005-03-30 09:00:00	TLT	ETF	88.2	88.28	88.16	88.22	33200.0
2005-03-30 10:00:00	TLT	ETF	88.22	88.4	88.2	88.4	92500.0

> showing 50 of 870 rows — these rows as CSV

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