PREVIEW / etf_daily / 2006-12-21

all etf daily files

  file:    by_date/etf_daily/2006/2006-12-21.parquet
  size:    19 KB
  rows:    389

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
2006-12-21	SPY	ETF	142.27	142.43	141.32	141.62	48698400.0
2006-12-21	QQQ	ETF	43.76	43.79	43.21	43.38	102981861.0
2006-12-21	IWM	ETF	77.99	78.35	77.31	77.62	49951400.0
2006-12-21	DIA	ETF	124.45	124.6	123.72	123.99	5991800.0
2006-12-21	GLD	ETF	61.58	61.7	61.27	61.38	2483300.0
2006-12-21	TLT	ETF	89.71	90.19	89.6	90.08	770700.0
2006-12-21	AAA	ETF	62.0	62.47	61.97	62.35	8000.0
2006-12-21	ADRE	ETF	37.84	37.85	37.44	37.7	132332.0
2006-12-21	AGG	ETF	100.48	100.66	100.23	100.6	306000.0
2006-12-21	AIQ	ETF	32.1	32.85	32.0	32.75	25420.0
2006-12-21	AIS	ETF	1.18	1.22	1.15	1.16	302200.0
2006-12-21	ARB	ETF	43.99	44.21	43.29	43.62	158000.0
2006-12-21	BAB	ETF	102.81	102.97	101.23	101.4	114700.0
2006-12-21	BBC	ETF	4.15	4.15	4.0	4.05	337400.0
2006-12-21	BBH	ETF	61.7667	61.8233	61.1467	61.5567	1318500.0
2006-12-21	BITS	ETF	32.68	34.0	32.32	34.0	13384.0
2006-12-21	BNE	ETF	15.33	15.82	15.3	15.5	206100.0
2006-12-21	BRF	ETF	14.28	14.34	14.28	14.31	14600.0
2006-12-21	BTF	ETF	108.24999999999999	108.74499999999999	107.6835	107.6835	840.0
2006-12-21	CBON	ETF	29.89	30.48	29.88	30.15	59327.0
2006-12-21	CDL	ETF	9.64	9.7	9.49	9.63	297300.0
2006-12-21	CEF	ETF	9.15	9.15	9.03	9.07	375200.0
2006-12-21	CEW	ETF	26.05	26.05	26.0	26.0	800.0
2006-12-21	CFO	ETF	11.12	11.12	11.12	11.12	500.0
2006-12-21	CGO	ETF	16.48	16.69	16.45	16.69	19600.0
2006-12-21	CHB	ETF	9.49	9.57	9.1	9.31	888300.0
2006-12-21	CHI	ETF	20.11	20.35	20.11	20.3	91800.0
2006-12-21	CHIC	ETF	31.42	31.462	30.19	30.23	509944.0
2006-12-21	CHY	ETF	17.04	17.25	17.04	17.17	132000.0
2006-12-21	CIL	ETF	25.27	25.27	25.17	25.17	1300.0
2006-12-21	CN	ETF	48.85	50.0	48.65	48.73	50800.0
2006-12-21	CNXT	ETF	2.11	2.13	2.05	2.06	7396654.0
2006-12-21	CPST	ETF	1.25	1.28	1.25	1.25	775831.0
2006-12-21	CSA	ETF	20.32	20.5856	20.05	20.55	19800.0
2006-12-21	CSB	ETF	33.42	33.52	33.3	33.47	17900.0
2006-12-21	CSD	ETF	25.0	25.01	24.86	24.9	18100.0
2006-12-21	CSQ	ETF	15.7	15.71	15.52	15.54	295000.0
2006-12-21	CTEC	ETF	94.3	94.89999999999999	92.50049999999999	92.85	34178.6
2006-12-21	CVY	ETF	26.95	26.95	26.7	26.76	36000.0
2006-12-21	DBC	ETF	24.85	24.85	24.47	24.56	285100.0
2006-12-21	DBV	ETF	25.64	25.67	25.6	25.63	120200.0
2006-12-21	DDM	ETF	6.9083	6.9175	6.8325	6.8642	541200.0
2006-12-21	DEF	ETF	25.22	25.22	24.9889	24.99	57900.0
2006-12-21	DES	ETF	18.99	19.13	18.91	18.9533	102300.0
2006-12-21	DEW	ETF	61.4	61.58	61.31	61.36	6800.0
2006-12-21	DFE	ETF	64.7	64.95	64.62	64.66	10700.0
2006-12-21	DFJ	ETF	50.79	51.16	50.74	50.82	29400.0
2006-12-21	DGT	ETF	75.95	76.14	75.78	75.97	9300.0
2006-12-21	DHS	ETF	57.85	57.85	57.49	57.6	61600.0
2006-12-21	DIM	ETF	63.2	63.32	63.04	63.15	12800.0

> showing 50 of 389 rows — these rows as CSV

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