PREVIEW / etf_daily / 2011-10-03

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-03.parquet
  size:    37 KB
  rows:    874

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
2011-10-03	SPY	ETF	112.49	113.95	109.81	109.93	365136800.0
2011-10-03	QQQ	ETF	52.04	52.85	51.11	51.14	99147909.0
2011-10-03	IWM	ETF	63.81	64.96	60.85	60.99	119485000.0
2011-10-03	DIA	ETF	108.21	109.61	106.3	106.36	13520400.0
2011-10-03	GLD	ETF	161.09	161.56	159.93	160.96	14200400.0
2011-10-03	TLT	ETF	121.88	123.81	121.11	123.81	15882000.0
2011-10-03	AAXJ	ETF	46.22	46.86	45.29	45.36	505200.0
2011-10-03	ACTV	ETF	14.71	14.71	14.03	14.22	123937.0
2011-10-03	ACWI	ETF	38.73	39.29	37.97	38.0	1040300.0
2011-10-03	ACWX	ETF	34.79	35.22	34.05	34.05	141030.0
2011-10-03	ADRE	ETF	35.69	36.07	34.99	35.03	91921.0
2011-10-03	AFK	ETF	25.88	26.0	25.52	25.58	12440.0
2011-10-03	AGEM	ETF	19.5	19.71	19.26	19.26	5805.0
2011-10-03	AGG	ETF	110.11	110.39	109.94	110.34	2372400.0
2011-10-03	AGQ	ETF	223.72	226.2	214.82	215.5	624900.0
2011-10-03	AGZ	ETF	112.67	112.95	112.47	112.92	331587.0
2011-10-03	AIA	ETF	36.01	36.7124	35.48	35.48	47068.0
2011-10-03	AIQ	ETF	5.75	5.9	5.6	5.65	51769.0
2011-10-03	AIS	ETF	2.27	2.32	2.14	2.14	1038958.0
2011-10-03	AIVI	ETF	38.1	38.42	37.18	37.18	234400.0
2011-10-03	AMJ	ETF	33.83	33.97	33.07	33.19	1004928.0
2011-10-03	AMLP	ETF	76.25	76.25	74.75	75.0	120660.0
2011-10-03	AOA	ETF	30.15	30.3	29.3	29.3	25800.0
2011-10-03	AOK	ETF	28.5	28.65	28.48	28.48	14240.0
2011-10-03	AOM	ETF	28.83	28.876	28.6544	28.672	8548.0
2011-10-03	AOR	ETF	29.37	29.69	28.82	28.82	7213.0
2011-10-03	ARB	ETF	32.71	34.24	32.71	32.9	288948.0
2011-10-03	ARGT	ETF	19.8	19.8	18.88	18.88	1300.0
2011-10-03	ASEA	ETF	13.47	13.54	13.22	13.22	12300.0
2011-10-03	AWAY	ETF	33.1	33.8	32.25	33.05	307727.0
2011-10-03	BAB	ETF	29.04	29.42	28.78	29.24	949878.0
2011-10-03	BAL	ETF	61.16	62.0488	60.92	61.27	111787.0
2011-10-03	BALT	ETF	4.59	4.8	4.25	4.25	116927.0
2011-10-03	BBH	ETF	32.1533	32.4933	31.4533	31.4567	32700.0
2011-10-03	BCM	ETF	41.44	41.44	41.44	41.44	100.0
2011-10-03	BIB	ETF	6.9325	6.9837	6.4375	6.4375	73080.0
2011-10-03	BICK	ETF	21.83	21.96	21.32	21.32	13942.0
2011-10-03	BIL	ETF	91.7	91.7	91.68	91.7	13151250.0
2011-10-03	BIS	ETF	7147.2	7564.8	7147.2	7564.8	19.05
2011-10-03	BITS	ETF	22.12	23.0	21.28	21.56	5069.0
2011-10-03	BIV	ETF	87.65	88.01	87.5	87.97	367500.0
2011-10-03	BJK	ETF	27.04	27.33	26.31	26.47	48700.0
2011-10-03	BKF	ETF	33.52	33.99	32.92	32.9771	224284.0
2011-10-03	BKLN	ETF	23.1	23.1	22.77	22.79	37900.0
2011-10-03	BLNG	ETF	50.12	50.13	50.12	50.13	600.0
2011-10-03	BLV	ETF	92.23	93.31	91.74	93.26	149600.0
2011-10-03	BMVP	ETF	12.08	12.19	11.68	11.68	18074.0
2011-10-03	BND	ETF	83.7	84.01	83.61	84.0	2078800.0
2011-10-03	BNO	ETF	33.985	34.525	33.7	33.7	441400.0
2011-10-03	BRF	ETF	39.1	39.3055	37.73	37.96	307356.0

> showing 50 of 874 rows — these rows as CSV

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