PREVIEW / etf_daily / 2006-10-27

all etf daily files

  file:    by_date/etf_daily/2006/2006-10-27.parquet
  size:    19 KB
  rows:    377

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-10-27	SPY	ETF	138.61	138.75	137.63	137.91	80238000.0
2006-10-27	QQQ	ETF	42.73	42.82	42.08	42.21	129378221.0
2006-10-27	IWM	ETF	76.89	77.11	75.94	76.14	51799300.0
2006-10-27	DIA	ETF	121.25	121.41	120.63	120.86	8672500.0
2006-10-27	GLD	ETF	59.43	59.57	59.04	59.4	3080700.0
2006-10-27	TLT	ETF	89.02	89.05	88.7	88.87	1601500.0
2006-10-27	AAA	ETF	55.45	55.6	55.32	55.5	5100.0
2006-10-27	ADRE	ETF	34.82	34.82	34.24	34.29	189067.0
2006-10-27	AGG	ETF	100.12	100.12	99.82	100.04	266300.0
2006-10-27	AIQ	ETF	41.85	42.2	41.4	42.0	7440.0
2006-10-27	AIS	ETF	1.19	1.23	1.15	1.23	149000.0
2006-10-27	ARB	ETF	41.62	41.89	41.32	41.5	215400.0
2006-10-27	BAB	ETF	87.52	88.14	87.2	87.3	26500.0
2006-10-27	BBC	ETF	9.15	9.37	9.13	9.16	251400.0
2006-10-27	BBH	ETF	64.3233	64.41	63.76	63.7933	718500.0
2006-10-27	BITS	ETF	42.0	42.44	39.6	39.92	52140.0
2006-10-27	BNE	ETF	15.99	16.04	15.86	15.9	73700.0
2006-10-27	BRF	ETF	14.3	14.33	14.25	14.26	3300.0
2006-10-27	BTF	ETF	101.95	102.05	101.3	101.35	3040.0
2006-10-27	CBON	ETF	29.31	29.45	28.97	29.16	41686.0
2006-10-27	CDL	ETF	10.39	10.39	10.01	10.1	476600.0
2006-10-27	CEF	ETF	8.4	8.42	8.31	8.36	257100.0
2006-10-27	CEW	ETF	25.55	25.75	25.55	25.62	3300.0
2006-10-27	CFO	ETF	10.6	10.6487	10.6	10.6487	5100.0
2006-10-27	CGO	ETF	15.67	15.73	15.65	15.7	13900.0
2006-10-27	CHB	ETF	9.36	9.38	8.85	9.09	1545500.0
2006-10-27	CHI	ETF	19.7	19.81	19.61	19.7	82700.0
2006-10-27	CHIC	ETF	28.84	29.25	28.37	28.54	192393.0
2006-10-27	CHY	ETF	17.23	17.25	17.05	17.07	115300.0
2006-10-27	CIL	ETF	25.85	25.85	25.8	25.8	1900.0
2006-10-27	CN	ETF	35.7	36.2	35.68	35.93	30600.0
2006-10-27	CNXT	ETF	1.9	2.03	1.88	1.91	38555522.0
2006-10-27	COMB	ETF	10.02	10.3	10.0	10.0	4722.0
2006-10-27	CPST	ETF	1.5	1.5	1.449	1.45	804340.0
2006-10-27	CSA	ETF	22.66	22.75	22.561	22.68	13000.0
2006-10-27	CSB	ETF	31.01	31.04	30.83	30.83	33800.0
2006-10-27	CSQ	ETF	14.97	14.98	14.9	14.94	297400.0
2006-10-27	CTEC	ETF	74.05	75.5	71.95	73.55	61021.600000000006
2006-10-27	CVY	ETF	26.12	26.15	26.01	26.02	59800.0
2006-10-27	CYB	ETF	7.34	7.37	7.0	7.37	80400.0
2006-10-27	DBC	ETF	24.7	24.7	24.31	24.6	379900.0
2006-10-27	DBV	ETF	25.37	25.41	25.3	25.39	28100.0
2006-10-27	DDM	ETF	7.0633	7.0975	7.0142	7.0383	646800.0
2006-10-27	DES	ETF	18.7667	18.8133	18.5867	18.61	54600.0
2006-10-27	DEW	ETF	58.17	58.22	58.09	58.21	67700.0
2006-10-27	DFE	ETF	58.53	58.58	58.24	58.24	11100.0
2006-10-27	DFJ	ETF	50.07	50.12	49.77	49.78	60000.0
2006-10-27	DGT	ETF	74.2	74.2	73.54	73.64	5800.0
2006-10-27	DHS	ETF	56.6	56.6	56.25	56.36	50900.0
2006-10-27	DIM	ETF	58.78	58.87	58.45	58.5	25000.0

> showing 50 of 377 rows — these rows as CSV

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