PREVIEW / etf_daily / 2006-07-13

all etf daily files

  file:    by_date/etf_daily/2006/2006-07-13.parquet
  size:    18 KB
  rows:    355

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-07-13	SPY	ETF	125.45	125.68	124.0	124.0	102405700.0
2006-07-13	QQQ	ETF	36.66	37.04	36.31	36.31	177745415.0
2006-07-13	IWM	ETF	69.18	69.69	68.02	68.07	80467000.0
2006-07-13	DIA	ETF	109.76	109.79	108.26	108.3	16123600.0
2006-07-13	GLD	ETF	65.09	65.68	64.11	65.55	12226800.0
2006-07-13	TLT	ETF	84.7	85.05	84.68	84.99	1347400.0
2006-07-13	AAA	ETF	55.48	55.66	55.48	55.58	2200.0
2006-07-13	ADRE	ETF	30.51	30.66	29.83	29.862	704730.0
2006-07-13	AFK	ETF	25.07	25.08	24.98	24.9901	13700.0
2006-07-13	AGG	ETF	97.53	97.8	97.53	97.75	499200.0
2006-07-13	AIQ	ETF	31.25	31.75	30.5	31.0	29140.0
2006-07-13	AIS	ETF	1.08	1.1099	1.02	1.04	141100.0
2006-07-13	AOM	ETF	6.54	6.55	6.3	6.4	14000.0
2006-07-13	ARB	ETF	36.8	36.99	36.23	36.33	319600.0
2006-07-13	BAB	ETF	65.8	65.8	64.17	64.4	108900.0
2006-07-13	BBC	ETF	12.57	12.99	12.55	12.7	155400.0
2006-07-13	BBH	ETF	58.5167	58.8967	58.23	58.4233	1595100.0
2006-07-13	BITS	ETF	18.28	18.84	17.8	17.84	7828.0
2006-07-13	BKF	ETF	5.93	6.0	5.82	5.82	7400.0
2006-07-13	BNE	ETF	13.44	13.76	13.3	13.35	184900.0
2006-07-13	BRF	ETF	13.88	13.9	13.88	13.89	6200.0
2006-07-13	BTF	ETF	88.39999999999999	88.39999999999999	87.69999999999999	87.69999999999999	800.0
2006-07-13	CBON	ETF	31.79	32.2	31.51	31.58	25685.0
2006-07-13	CDL	ETF	8.79	8.89	8.57	8.62	228700.0
2006-07-13	CEF	ETF	9.17	9.26	8.95	9.23	334400.0
2006-07-13	CEW	ETF	26.12	26.12	26.12	26.12	700.0
2006-07-13	CFO	ETF	10.0	10.02	10.0	10.02	30500.0
2006-07-13	CGO	ETF	14.86	14.86	14.53	14.75	16500.0
2006-07-13	CHB	ETF	9.75	9.79	9.05	9.06	1564400.0
2006-07-13	CHI	ETF	19.45	19.68	19.4	19.54	69000.0
2006-07-13	CHIC	ETF	22.37	22.74	21.81	22.41	347367.0
2006-07-13	CHY	ETF	16.09	16.09	16.01	16.05	83600.0
2006-07-13	CIL	ETF	25.25	25.33	25.25	25.33	1800.0
2006-07-13	CN	ETF	35.3	35.5	34.99	35.1	101700.0
2006-07-13	CNXT	ETF	2.09	2.17	2.06	2.06	10312368.0
2006-07-13	COMB	ETF	9.891	9.891	9.84	9.84	1100.0
2006-07-13	CPST	ETF	2.25	2.29	2.11	2.15	1314016.0
2006-07-13	CSA	ETF	18.74	18.74	18.74	18.74	800.0
2006-07-13	CSB	ETF	27.38	27.45	27.22	27.23	2700.0
2006-07-13	CSQ	ETF	13.92	13.92	13.8	13.86	280300.0
2006-07-13	CTEC	ETF	64.5	65.05	63.099999999999994	64.05	4853.6
2006-07-13	CYB	ETF	5.96	5.96	5.7	5.94	77000.0
2006-07-13	DBC	ETF	26.43	26.53	26.27	26.38	418000.0
2006-07-13	DDM	ETF	5.8292	5.835	5.6917	5.6975	2526000.0
2006-07-13	DES	ETF	17.0233	17.0233	16.8167	16.84	25200.0
2006-07-13	DEW	ETF	50.98	50.98	50.94	50.94	600.0
2006-07-13	DFE	ETF	52.52	52.52	52.18	52.18	5100.0
2006-07-13	DFJ	ETF	49.28	49.28	49.28	49.28	200.0
2006-07-13	DGT	ETF	67.0	67.0	66.25	66.35	3500.0
2006-07-13	DHS	ETF	51.02	51.02	50.66	50.72	8300.0

> showing 50 of 355 rows — these rows as CSV

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