PREVIEW / etf_daily / 2010-03-15

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-15.parquet
  size:    32 KB
  rows:    732

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-15	SPY	ETF	115.26	115.57	114.6	115.49	146816800.0
2010-03-15	QQQ	ETF	47.26	47.38	46.91	47.24	60150419.0
2010-03-15	IWM	ETF	67.68	67.81	67.0	67.49	49862700.0
2010-03-15	DIA	ETF	106.3	106.63	105.87	106.57	6760400.0
2010-03-15	GLD	ETF	108.16	108.56	107.82	108.36	7698600.0
2010-03-15	TLT	ETF	90.35	90.47	90.05	90.36	1936800.0
2010-03-15	AAXJ	ETF	55.58	55.58	54.97	55.36	100700.0
2010-03-15	ACWI	ETF	42.77	42.95	42.59	42.93	88300.0
2010-03-15	ACWX	ETF	41.0	41.04	40.7241	41.03	301913.0
2010-03-15	ADRE	ETF	43.58	43.58	43.082	43.44	55155.0
2010-03-15	AFK	ETF	30.6	30.61	29.86	30.32	14891.0
2010-03-15	AGG	ETF	104.62	104.66	104.5	104.65	832600.0
2010-03-15	AGQ	ETF	110.54	112.02	110.02	110.7	250900.0
2010-03-15	AGZ	ETF	108.21	108.36	108.2	108.3	16048.0
2010-03-15	AIA	ETF	39.49	39.54	39.27	39.38	37244.0
2010-03-15	AIQ	ETF	27.35	27.35	25.95	26.8	40431.0
2010-03-15	AIS	ETF	1.48	1.49	1.4499	1.4801	286437.0
2010-03-15	AIVI	ETF	42.43	42.43	42.04	42.35	11100.0
2010-03-15	AMJ	ETF	30.54	30.6	30.12	30.47	666911.0
2010-03-15	AOA	ETF	31.18	31.18	30.91	31.13	14200.0
2010-03-15	AOK	ETF	27.7	27.79	27.6701	27.79	4634.0
2010-03-15	AOM	ETF	28.62	28.63	28.48	28.63	10651.0
2010-03-15	AOR	ETF	29.59	29.59	29.39	29.58	9358.0
2010-03-15	ARB	ETF	24.09	24.6	24.0	24.55	195442.0
2010-03-15	BAB	ETF	24.89	24.89	24.78	24.88	160107.0
2010-03-15	BAL	ETF	39.14	39.15	38.53	38.863	6156.0
2010-03-15	BALT	ETF	14.24	14.24	13.75	13.85	706792.0
2010-03-15	BBH	ETF	34.6067	34.7933	34.51	34.65	110100.0
2010-03-15	BIL	ETF	91.68	91.7	91.68	91.68	143500.0
2010-03-15	BITS	ETF	31.92	32.4	31.88	32.36	404.0
2010-03-15	BIV	ETF	80.57	80.59	80.42	80.52	93200.0
2010-03-15	BJK	ETF	24.77	24.77	24.25	24.52	4200.0
2010-03-15	BKF	ETF	45.6	45.76	45.24	45.66	96652.0
2010-03-15	BLV	ETF	77.11	77.23	76.84	77.11	26000.0
2010-03-15	BMVP	ETF	13.03	13.0325	12.96	13.03	11530.0
2010-03-15	BND	ETF	79.44	79.47	79.36	79.46	459600.0
2010-03-15	BNE	ETF	11.26	11.33	11.25	11.3	466595.0
2010-03-15	BRF	ETF	47.36	47.36	46.455	46.85	372999.0
2010-03-15	BSV	ETF	80.11	80.12	80.04	80.11	416200.0
2010-03-15	BTF	ETF	73.49999999999999	73.7495	73.0	73.7	12570.2
2010-03-15	BWX	ETF	28.105	28.25	28.105	28.25	245474.0
2010-03-15	BWZ	ETF	35.9896	35.9896	35.858	35.9306	13023.0
2010-03-15	BZQ	ETF	3664.0	3740.8	3628.8	3649.6	307.0
2010-03-15	CEF	ETF	13.94	13.99	13.82	13.92	472400.0
2010-03-15	CEW	ETF	22.17	22.18	22.0978	22.11	92108.0
2010-03-15	CGO	ETF	14.39	14.4	14.22	14.24	26649.0
2010-03-15	CGW	ETF	18.1	18.14	18.0	18.1101	19670.0
2010-03-15	CHI	ETF	12.63	12.63	12.55	12.56	107445.0
2010-03-15	CHIE	ETF	14.27	14.35	14.27	14.2999	1270.0
2010-03-15	CHII	ETF	15.13	15.23	15.01	15.0725	7369.0

> showing 50 of 732 rows — these rows as CSV

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