PREVIEW / etf_daily / 2010-01-19

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-19.parquet
  size:    31 KB
  rows:    720

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
2010-01-19	SPY	ETF	113.62	115.13	113.59	115.06	139172700.0
2010-01-19	QQQ	ETF	45.96	46.64	45.95	46.59	84388146.0
2010-01-19	IWM	ETF	63.92	64.87	63.92	64.85	46839000.0
2010-01-19	DIA	ETF	105.9	107.23	105.86	107.17	10877400.0
2010-01-19	GLD	ETF	110.95	111.75	110.83	111.52	10468200.0
2010-01-19	TLT	ETF	90.72	91.12	90.42	90.82	2496000.0
2010-01-19	AAXJ	ETF	57.24	57.94	57.18	57.94	296100.0
2010-01-19	ACWI	ETF	43.2	43.82	43.01	43.82	203700.0
2010-01-19	ACWX	ETF	42.1	42.59	42.0399	42.58	402426.0
2010-01-19	ADRE	ETF	44.28	44.71	44.132	44.59	99239.0
2010-01-19	AFK	ETF	29.79	30.48	29.79	30.306	3850.0
2010-01-19	AGG	ETF	104.2	104.26	104.0	104.1	754800.0
2010-01-19	AGQ	ETF	135.06	138.82	134.84	138.76	210750.0
2010-01-19	AGZ	ETF	108.17	108.27	108.14	108.14	15184.0
2010-01-19	AIA	ETF	41.0	41.04	40.71	40.988	136926.0
2010-01-19	AIQ	ETF	26.7	27.25	26.7	27.25	44473.0
2010-01-19	AIS	ETF	1.25	1.25	1.2	1.23	333604.0
2010-01-19	AIVI	ETF	44.02	44.64	44.02	44.45	53900.0
2010-01-19	AMJ	ETF	29.3	30.0	29.3	29.91	367516.0
2010-01-19	AOA	ETF	30.6	30.89	30.6	30.89	2700.0
2010-01-19	AOK	ETF	27.65	27.72	27.65	27.67	9855.0
2010-01-19	AOM	ETF	28.57	28.72	28.57	28.692	14213.0
2010-01-19	AOR	ETF	29.5	29.69	29.5	29.69	24345.0
2010-01-19	ARB	ETF	25.25	25.82	24.98	25.68	206645.0
2010-01-19	BAB	ETF	24.7	24.73	24.61	24.68	69542.0
2010-01-19	BAL	ETF	36.49	36.49	35.08	35.202	13273.0
2010-01-19	BBH	ETF	33.2533	33.87	33.2533	33.8067	573900.0
2010-01-19	BIL	ETF	91.72	91.72	91.7	91.7	61250.0
2010-01-19	BITS	ETF	32.52	32.952	31.8	31.8	2929.0
2010-01-19	BIV	ETF	80.12	80.17	80.0	80.16	116100.0
2010-01-19	BJK	ETF	25.48	25.65	25.31	25.64	11200.0
2010-01-19	BKF	ETF	46.66	47.2	46.26	47.07	201486.0
2010-01-19	BLV	ETF	76.84	77.07	76.47	77.07	28800.0
2010-01-19	BMVP	ETF	12.94	13.1	12.94	13.1	9597.0
2010-01-19	BND	ETF	79.34	79.39	79.23	79.25	782000.0
2010-01-19	BNE	ETF	7.07	7.07	6.82	7.0	181628.0
2010-01-19	BOSS	ETF	19.2	19.86	19.2	19.86	100.0
2010-01-19	BRF	ETF	48.74	49.54	48.74	49.24	540222.0
2010-01-19	BSV	ETF	80.12	80.15	80.03	80.12	440400.0
2010-01-19	BTF	ETF	63.8	65.3	63.8	64.91499999999999	6012.8
2010-01-19	BWX	ETF	28.795	28.875	28.6	28.765	357732.0
2010-01-19	BWZ	ETF	36.7	36.84	36.7	36.82	25500.0
2010-01-19	BZQ	ETF	3760.0	3784.0	3660.8	3680.0	267.5
2010-01-19	CEF	ETF	14.44	14.56	14.38	14.48	853300.0
2010-01-19	CEW	ETF	22.3	22.35	22.2601	22.34	141472.0
2010-01-19	CGO	ETF	15.09	15.2	15.02	15.09	22118.0
2010-01-19	CGW	ETF	18.82	18.95	18.76	18.9	122722.0
2010-01-19	CHI	ETF	12.69	12.75	12.67	12.73	134312.0
2010-01-19	CHIE	ETF	15.27	15.32	15.05	15.3	15396.0
2010-01-19	CHII	ETF	16.07	16.37	15.97	16.35	35319.0

> showing 50 of 720 rows — these rows as CSV

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