PREVIEW / etf_daily / 2010-03-18

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-18.parquet
  size:    32 KB
  rows:    727

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-03-18	SPY	ETF	117.11	117.27	116.57	117.04	196509100.0
2010-03-18	QQQ	ETF	47.72	47.88	47.6	47.83	77829361.0
2010-03-18	IWM	ETF	68.44	68.78	68.14	68.26	71527500.0
2010-03-18	DIA	ETF	107.53	108.03	107.46	107.95	7495600.0
2010-03-18	GLD	ETF	110.1	110.61	109.5	110.34	13848400.0
2010-03-18	TLT	ETF	91.42	91.48	91.01	91.17	2750300.0
2010-03-18	AAXJ	ETF	56.7	56.7	56.1	56.19	596100.0
2010-03-18	ACWI	ETF	43.67	43.67	43.32	43.41	227500.0
2010-03-18	ACWX	ETF	41.75	41.75	41.42	41.56	38416.0
2010-03-18	ADRE	ETF	44.16	44.16	43.45	43.68	71673.0
2010-03-18	AFK	ETF	30.98	31.0	30.7	30.85	5860.0
2010-03-18	AGG	ETF	104.91	104.92	104.79	104.83	618200.0
2010-03-18	AGQ	ETF	115.88	117.06	114.08	115.48	237550.0
2010-03-18	AGZ	ETF	108.54	108.56	108.34	108.44	41175.0
2010-03-18	AIA	ETF	40.44	40.44	40.1001	40.21	48701.0
2010-03-18	AIQ	ETF	28.15	28.85	27.9075	28.65	39210.0
2010-03-18	AIS	ETF	1.48	1.49	1.44	1.48	248451.0
2010-03-18	AIVI	ETF	42.94	42.94	42.47	42.83	10700.0
2010-03-18	AMJ	ETF	30.57	30.58	30.32	30.46	590991.0
2010-03-18	AOA	ETF	31.58	31.65	31.42	31.52	12500.0
2010-03-18	AOK	ETF	27.97	27.97	27.89	27.9	7338.0
2010-03-18	AOM	ETF	28.87	28.87	28.75	28.808	8206.0
2010-03-18	AOR	ETF	29.96	29.96	29.7728	29.85	43357.0
2010-03-18	ARB	ETF	25.08	25.42	24.96	25.19	135596.0
2010-03-18	BAB	ETF	25.1	25.1099	25.02	25.04	143425.0
2010-03-18	BAL	ETF	39.4901	39.67	39.4901	39.612	867.0
2010-03-18	BALT	ETF	13.98	13.98	13.62	13.76	213911.0
2010-03-18	BBH	ETF	34.82	35.0367	34.65	34.97	114000.0
2010-03-18	BIL	ETF	91.68	91.7	91.68	91.68	83400.0
2010-03-18	BITS	ETF	32.8	33.42	32.64	32.76	1937.0
2010-03-18	BIV	ETF	81.05	81.05	80.68	80.76	100000.0
2010-03-18	BJK	ETF	25.06	25.06	24.8	24.87	7600.0
2010-03-18	BKF	ETF	46.31	46.39	45.81	45.9	175162.0
2010-03-18	BLV	ETF	78.04	78.14	77.72	77.74	22800.0
2010-03-18	BMVP	ETF	13.2637	13.2639	13.2142	13.2503	11719.0
2010-03-18	BND	ETF	79.64	79.66	79.44	79.48	594000.0
2010-03-18	BNE	ETF	11.28	11.31	11.28	11.29	620276.0
2010-03-18	BRF	ETF	46.25	46.6	45.75	46.02	454044.0
2010-03-18	BSV	ETF	80.24	80.24	80.13	80.18	386000.0
2010-03-18	BTF	ETF	74.85	74.85	73.49999999999999	73.55499999999999	4457.400000000001
2010-03-18	BWX	ETF	28.48	28.505	28.325	28.365	256750.0
2010-03-18	BWZ	ETF	36.5	36.5	35.91	36.01	39886.0
2010-03-18	BZQ	ETF	3667.2	3756.8	3622.4	3715.2	444.5
2010-03-18	CEF	ETF	14.2	14.2	14.1	14.18	506400.0
2010-03-18	CEW	ETF	22.16	22.18	22.106	22.14	97914.0
2010-03-18	CGO	ETF	14.73	14.75	14.62	14.64	45140.0
2010-03-18	CGW	ETF	18.4	18.4	18.23	18.3	38740.0
2010-03-18	CHI	ETF	12.72	12.74	12.59	12.6	180833.0
2010-03-18	CHIE	ETF	14.39	14.39	14.268	14.268	800.0
2010-03-18	CHII	ETF	15.3	15.3	15.184	15.1868	1047.0

> showing 50 of 727 rows — these rows as CSV

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