PREVIEW / etf_1hour / 2005-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-25.parquet
  size:    29 KB
  rows:    832

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-02-25 08:00:00	SPY	ETF	120.41	120.46	120.26	120.27	68300.0
2005-02-25 09:00:00	SPY	ETF	120.29	120.43	120.18	120.27	6722900.0
2005-02-25 10:00:00	SPY	ETF	120.28	120.7	120.18	120.7	10640000.0
2005-02-25 11:00:00	SPY	ETF	120.64	121.27	120.61	121.17	11612100.0
2005-02-25 12:00:00	SPY	ETF	121.171	121.26	121.03	121.05	5528200.0
2005-02-25 13:00:00	SPY	ETF	121.05	121.17	120.93	121.15	4075200.0
2005-02-25 14:00:00	SPY	ETF	121.15	121.44	121.09	121.23	9569200.0
2005-02-25 15:00:00	SPY	ETF	121.23	121.67	121.2	121.38	7767100.0
2005-02-25 16:00:00	SPY	ETF	121.39	121.49	121.29	121.37	3462500.0
2005-02-25 17:00:00	SPY	ETF	121.35	121.38	121.34	121.38	4400.0
2005-02-25 18:00:00	SPY	ETF	121.38	121.4	121.36	121.4	4700.0
2005-02-25 09:00:00	QQQ	ETF	37.36	37.49	37.32	37.35	11262100.0
2005-02-25 10:00:00	QQQ	ETF	37.35	37.49	37.29	37.49	11446700.0
2005-02-25 11:00:00	QQQ	ETF	37.5	37.68	37.43	37.63	14062000.0
2005-02-25 12:00:00	QQQ	ETF	37.63	37.66	37.51	37.52	7116900.0
2005-02-25 13:00:00	QQQ	ETF	37.53	37.58	37.43	37.52	9016200.0
2005-02-25 14:00:00	QQQ	ETF	37.52	37.65	37.49	37.53	7248400.0
2005-02-25 15:00:00	QQQ	ETF	37.52	37.67	37.5	37.63	12324600.0
2005-02-25 08:00:00	IWM	ETF	62.625	62.66	62.625	62.635	25600.0
2005-02-25 09:00:00	IWM	ETF	62.52	62.72	62.4	62.525	2730400.0
2005-02-25 10:00:00	IWM	ETF	62.505	62.875	62.405	62.865	5147800.0
2005-02-25 11:00:00	IWM	ETF	62.9	63.22	62.85	63.16	4877600.0
2005-02-25 12:00:00	IWM	ETF	63.165	63.25	63.11	63.12	1702800.0
2005-02-25 13:00:00	IWM	ETF	63.125	63.2	62.98	63.12	1457600.0
2005-02-25 14:00:00	IWM	ETF	63.12	63.385	63.105	63.275	3082000.0
2005-02-25 15:00:00	IWM	ETF	63.265	63.545	63.225	63.495	3566800.0
2005-02-25 16:00:00	IWM	ETF	63.51	63.57	63.465	63.51	908200.0
2005-02-25 17:00:00	IWM	ETF	63.51	63.51	63.51	63.51	400.0
2005-02-25 08:00:00	DIA	ETF	107.53	107.53	107.52	107.52	1100.0
2005-02-25 09:00:00	DIA	ETF	107.42	107.55	107.33	107.39	699100.0
2005-02-25 10:00:00	DIA	ETF	107.37	107.67	107.3	107.66	572700.0
2005-02-25 11:00:00	DIA	ETF	107.63	108.12	107.63	108.08	951600.0
2005-02-25 12:00:00	DIA	ETF	108.08	108.12	107.98	107.99	323500.0
2005-02-25 13:00:00	DIA	ETF	108.0	108.12	107.89	108.08	500400.0
2005-02-25 14:00:00	DIA	ETF	108.07	108.3	108.06	108.18	798100.0
2005-02-25 15:00:00	DIA	ETF	108.18	108.42	108.14	108.36	996300.0
2005-02-25 16:00:00	DIA	ETF	108.36	108.37	108.3	108.37	63700.0
2005-02-25 18:00:00	DIA	ETF	108.31	108.31	108.31	108.31	100.0
2005-02-25 19:00:00	DIA	ETF	108.35	108.35	108.35	108.35	1000.0
2005-02-25 09:00:00	GLD	ETF	43.41	43.5	43.41	43.42	104500.0
2005-02-25 10:00:00	GLD	ETF	43.44	43.46	43.22	43.28	216600.0
2005-02-25 11:00:00	GLD	ETF	43.29	43.41	43.27	43.4	311900.0
2005-02-25 12:00:00	GLD	ETF	43.4	43.52	43.39	43.46	139800.0
2005-02-25 13:00:00	GLD	ETF	43.49	43.5	43.45	43.48	62200.0
2005-02-25 14:00:00	GLD	ETF	43.48	43.54	43.46	43.53	128400.0
2005-02-25 15:00:00	GLD	ETF	43.54	43.55	43.47	43.5	136700.0
2005-02-25 08:00:00	TLT	ETF	90.75	90.98	90.75	90.92	12200.0
2005-02-25 09:00:00	TLT	ETF	90.89	90.91	90.62	90.65	58900.0
2005-02-25 10:00:00	TLT	ETF	90.69	90.85	90.63	90.79	84500.0
2005-02-25 11:00:00	TLT	ETF	90.75	90.94	90.75	90.88	96500.0

> showing 50 of 832 rows — these rows as CSV

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