PREVIEW / etf_1hour / 2005-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-28.parquet
  size:    29 KB
  rows:    855

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-28 08:00:00	SPY	ETF	117.4	117.45	117.38	117.41	191300.0
2005-03-28 09:00:00	SPY	ETF	117.41	117.71	117.34	117.66	8087100.0
2005-03-28 10:00:00	SPY	ETF	117.67	117.88	117.55	117.72	7510200.0
2005-03-28 11:00:00	SPY	ETF	117.72	117.77	117.48	117.53	6531400.0
2005-03-28 12:00:00	SPY	ETF	117.53	117.64	117.38	117.57	3722400.0
2005-03-28 13:00:00	SPY	ETF	117.56	117.76	117.55	117.68	2538000.0
2005-03-28 14:00:00	SPY	ETF	117.68	117.94	117.47	117.83	7651700.0
2005-03-28 15:00:00	SPY	ETF	117.82	117.88	117.33	117.37	7414400.0
2005-03-28 16:00:00	SPY	ETF	117.38	117.46	117.18	117.35	1763500.0
2005-03-28 17:00:00	SPY	ETF	117.32	117.35	117.29	117.32	22600.0
2005-03-28 18:00:00	SPY	ETF	117.31	117.31	116.9	117.3	11900.0
2005-03-28 19:00:00	SPY	ETF	117.31	117.35	117.31	117.31	1200.0
2005-03-28 09:00:00	QQQ	ETF	36.41	36.54	36.37	36.5	9915300.0
2005-03-28 10:00:00	QQQ	ETF	36.5	36.61	36.41	36.55	12811800.0
2005-03-28 11:00:00	QQQ	ETF	36.55	36.58	36.44	36.47	5752800.0
2005-03-28 12:00:00	QQQ	ETF	36.47	36.53	36.41	36.48	4086500.0
2005-03-28 13:00:00	QQQ	ETF	36.49	36.58	36.47	36.49	5319800.0
2005-03-28 14:00:00	QQQ	ETF	36.49	36.55	36.38	36.5	9935900.0
2005-03-28 15:00:00	QQQ	ETF	36.5	36.52	36.31	36.33	9156100.0
2005-03-28 08:00:00	IWM	ETF	61.25	61.305	61.25	61.305	25000.0
2005-03-28 09:00:00	IWM	ETF	61.315	61.5	61.2	61.455	2315800.0
2005-03-28 10:00:00	IWM	ETF	61.45	61.505	61.3	61.3	2236000.0
2005-03-28 11:00:00	IWM	ETF	61.295	61.355	61.13	61.16	1163400.0
2005-03-28 12:00:00	IWM	ETF	61.16	61.16	60.97	61.09	1279000.0
2005-03-28 13:00:00	IWM	ETF	61.09	61.23	61.055	61.165	909400.0
2005-03-28 14:00:00	IWM	ETF	61.15	61.29	61.005	61.225	1295600.0
2005-03-28 15:00:00	IWM	ETF	61.215	61.255	61.0695	61.14	2742000.0
2005-03-28 16:00:00	IWM	ETF	61.135	61.205	60.755	61.125	398600.0
2005-03-28 17:00:00	IWM	ETF	61.125	61.16	61.1	61.16	39400.0
2005-03-28 08:00:00	DIA	ETF	104.61	104.61	104.61	104.61	2000.0
2005-03-28 09:00:00	DIA	ETF	104.61	104.88	104.56	104.84	1271900.0
2005-03-28 10:00:00	DIA	ETF	104.85	105.06	104.76	104.92	905600.0
2005-03-28 11:00:00	DIA	ETF	104.91	104.97	104.82	104.87	448600.0
2005-03-28 12:00:00	DIA	ETF	104.85	104.93	104.74	104.85	446400.0
2005-03-28 13:00:00	DIA	ETF	104.85	105.04	104.85	104.98	391100.0
2005-03-28 14:00:00	DIA	ETF	104.97	105.23	104.84	105.15	561500.0
2005-03-28 15:00:00	DIA	ETF	105.13	105.17	104.75	104.77	816800.0
2005-03-28 16:00:00	DIA	ETF	104.75	104.81	104.74	104.81	22200.0
2005-03-28 17:00:00	DIA	ETF	104.8	104.8	104.77	104.8	3500.0
2005-03-28 18:00:00	DIA	ETF	104.85	105.27	104.77	104.77	1900.0
2005-03-28 19:00:00	DIA	ETF	104.77	104.77	104.77	104.77	100.0
2005-03-28 08:00:00	GLD	ETF	42.39	42.39	42.3	42.3	12500.0
2005-03-28 09:00:00	GLD	ETF	42.3	42.54	42.3	42.46	161000.0
2005-03-28 10:00:00	GLD	ETF	42.45	42.48	42.41	42.45	112200.0
2005-03-28 11:00:00	GLD	ETF	42.45	42.53	42.43	42.51	45700.0
2005-03-28 12:00:00	GLD	ETF	42.51	42.58	42.49	42.58	28800.0
2005-03-28 13:00:00	GLD	ETF	42.57	42.58	42.52	42.54	125900.0
2005-03-28 14:00:00	GLD	ETF	42.54	42.58	42.53	42.57	34700.0
2005-03-28 15:00:00	GLD	ETF	42.56	42.58	42.53	42.54	60300.0
2005-03-28 08:00:00	TLT	ETF	88.1	88.14	88.09	88.09	13800.0

> showing 50 of 855 rows — these rows as CSV

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