PREVIEW / etf_daily / 2005-12-27

all etf daily files

  file:    by_date/etf_daily/2005/2005-12-27.parquet
  size:    16 KB
  rows:    301

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2005-12-27	SPY	ETF	126.96	127.05	125.38	125.47	44499500.0
2005-12-27	QQQ	ETF	41.52	41.68	40.97	41.038	55669207.0
2005-12-27	IWM	ETF	68.35	68.43	67.07	67.11	26201500.0
2005-12-27	DIA	ETF	108.94	109.25	107.64	107.75	8654300.0
2005-12-27	GLD	ETF	50.65	50.7	50.5	50.64	4403700.0
2005-12-27	TLT	ETF	91.97	92.59	91.8	92.55	519500.0
2005-12-27	AAA	ETF	54.69	54.75	54.65	54.65	1100.0
2005-12-27	ADRE	ETF	117.19	117.19	115.01	115.09	42680.0
2005-12-27	AFK	ETF	25.15	25.26	25.15	25.16	9300.0
2005-12-27	AGG	ETF	100.86	101.14	100.8	101.14	204100.0
2005-12-27	AIQ	ETF	29.25	29.25	28.15	28.75	5640.0
2005-12-27	AIS	ETF	1.43	1.45	1.3801	1.43	136800.0
2005-12-27	AOM	ETF	4.0	4.05	3.95	4.05	5400.0
2005-12-27	ARB	ETF	38.97	39.03	38.49	38.5	78900.0
2005-12-27	BAB	ETF	58.31	58.96	58.09	58.17	12400.0
2005-12-27	BBC	ETF	14.8	15.2	14.75	15.15	114200.0
2005-12-27	BBH	ETF	69.0833	69.0833	67.44	67.6267	1164300.0
2005-12-27	BCM	ETF	66.32	66.43	65.88	65.88	5000.0
2005-12-27	BITS	ETF	14.4	15.2	14.12	14.84	16316.0
2005-12-27	BKF	ETF	20.6	20.6	20.0	20.0	31900.0
2005-12-27	BNE	ETF	15.06	15.2	14.89	14.89	75100.0
2005-12-27	BOSS	ETF	30.6	30.6	30.6	30.6	300.0
2005-12-27	BRF	ETF	15.17	15.24	15.05	15.24	15300.0
2005-12-27	BTF	ETF	85.0	85.5	85.0	85.5	1880.0
2005-12-27	CBON	ETF	32.19	32.19	31.805	31.83	2216.0
2005-12-27	CDL	ETF	13.2	13.46	13.15	13.23	301200.0
2005-12-27	CEF	ETF	6.47	6.5	6.44	6.48	311300.0
2005-12-27	CEW	ETF	26.01	26.01	25.97	25.97	900.0
2005-12-27	CFO	ETF	10.0	10.0	10.0	10.0	100.0
2005-12-27	CGO	ETF	13.68	13.77	13.35	13.46	64300.0
2005-12-27	CHB	ETF	14.04	14.19	13.64	13.67	811900.0
2005-12-27	CHI	ETF	20.16	20.43	20.07	20.15	107600.0
2005-12-27	CHIC	ETF	20.0	20.27	19.56	19.57	226281.0
2005-12-27	CHIR	ETF	44.6499	44.7	44.52	44.52	691722.0
2005-12-27	CHY	ETF	15.93	16.07	15.87	16.03	104400.0
2005-12-27	CIL	ETF	25.25	25.28	25.23	25.28	4700.0
2005-12-27	CN	ETF	32.75	32.79	32.25	32.25	45400.0
2005-12-27	CNXT	ETF	2.345	2.35	2.26	2.27	7257520.0
2005-12-27	COMB	ETF	8.01	8.2474	7.9	8.2474	7361.0
2005-12-27	CPST	ETF	3.09	3.1	2.86	2.88	4350469.0
2005-12-27	CSA	ETF	16.9	16.9	16.76	16.83	27500.0
2005-12-27	CSB	ETF	32.0	32.04	31.74	31.81	14400.0
2005-12-27	CSM	ETF	2.4525	2.4525	2.4525	2.4525	400.0
2005-12-27	CSQ	ETF	13.47	13.48	13.3	13.42	603000.0
2005-12-27	CTEC	ETF	47.099999999999994	47.8	47.0	47.449999999999996	6091.0
2005-12-27	CURE	ETF	0.0325	0.0375	0.0325	0.0362	4914832.0
2005-12-27	CYB	ETF	3.57	3.58	3.52	3.52	2600.0
2005-12-27	DGT	ETF	65.2	65.2	65.0	65.13	600.0
2005-12-27	DIG	ETF	15.7	15.7	15.7	15.7	1120.0
2005-12-27	DIV	ETF	12.06	12.19	12.04	12.09	49700.0

> showing 50 of 301 rows — these rows as CSV

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