PREVIEW / etf_daily / 2011-11-04

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-04.parquet
  size:    37 KB
  rows:    880

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-11-04	SPY	ETF	125.23	125.7	124.01	125.48	249401600.0
2011-11-04	QQQ	ETF	57.79	58.05	57.22	57.8	61527707.0
2011-11-04	IWM	ETF	74.18	74.82	73.55	74.6	65262500.0
2011-11-04	DIA	ETF	119.4	119.68	118.24	119.6	7021900.0
2011-11-04	GLD	ETF	171.03	171.34	170.16	170.85	11060400.0
2011-11-04	TLT	ETF	115.72	117.05	115.53	116.48	7583700.0
2011-11-04	AADR	ETF	28.72	28.72	28.72	28.72	300.0
2011-11-04	AAXJ	ETF	54.44	54.5	53.62	54.35	310200.0
2011-11-04	ACTV	ETF	12.96	13.29	12.89	13.24	83235.0
2011-11-04	ACWI	ETF	43.49	43.59	42.99	43.45	476200.0
2011-11-04	ACWV	ETF	50.64	50.7	50.64	50.66	700.0
2011-11-04	ACWX	ETF	38.63	38.87	38.25	38.74	394462.0
2011-11-04	ADRE	ETF	41.05	41.334	40.67	41.24	36965.0
2011-11-04	AFK	ETF	28.7	28.82	28.67	28.8	3325.0
2011-11-04	AGEM	ETF	22.79	22.8065	22.79	22.79	1676.0
2011-11-04	AGG	ETF	110.03	110.2	109.96	110.0	2040100.0
2011-11-04	AGQ	ETF	266.0	268.88	259.96	264.2	307625.0
2011-11-04	AGZ	ETF	112.29	112.5735	112.17	112.33	100765.0
2011-11-04	AIA	ETF	42.11	42.26	41.62	42.13	34082.0
2011-11-04	AIQ	ETF	6.15	6.25	5.9	6.1	6873.0
2011-11-04	AIS	ETF	2.295	2.3	2.24	2.3	381678.0
2011-11-04	AIVI	ETF	41.42	41.44	40.85	41.28	55700.0
2011-11-04	AMJ	ETF	37.19	37.63	36.99	37.63	498737.0
2011-11-04	AMLP	ETF	80.5	80.95	80.1	80.95	258060.0
2011-11-04	AOA	ETF	33.4	33.51	33.21	33.51	4500.0
2011-11-04	AOK	ETF	29.39	29.42	29.3468	29.42	13881.0
2011-11-04	AOM	ETF	30.05	30.15	29.99	30.09	28642.0
2011-11-04	AOR	ETF	31.376	31.44	31.3	31.41	12319.0
2011-11-04	ARB	ETF	41.55	42.21	41.09	41.94	112934.0
2011-11-04	ARGT	ETF	23.04	23.04	23.04	23.04	300.0
2011-11-04	ASEA	ETF	15.27	15.27	15.02	15.2	5700.0
2011-11-04	AWAY	ETF	33.94	34.4	32.85	34.21	129702.0
2011-11-04	BAB	ETF	28.38	28.38	28.17	28.38	82429.0
2011-11-04	BAL	ETF	61.2	61.222	60.59	60.9499	10836.0
2011-11-04	BALT	ETF	5.7	5.8	5.69	5.71	45614.0
2011-11-04	BBH	ETF	34.9	34.9	34.5233	34.6967	11400.0
2011-11-04	BCM	ETF	44.79	45.0	44.79	45.0	2145.0
2011-11-04	BIB	ETF	7.475	7.4887	7.31	7.365	21600.0
2011-11-04	BICK	ETF	26.03	26.3377	25.9756	26.32	10152.0
2011-11-04	BIL	ETF	91.7	91.7	91.68	91.68	203000.0
2011-11-04	BITS	ETF	22.8	23.36	21.56	22.2	6591.0
2011-11-04	BIV	ETF	87.83	87.97	87.63	87.94	326900.0
2011-11-04	BJK	ETF	33.01	33.14	32.62	32.93	119900.0
2011-11-04	BKF	ETF	40.53	40.53	39.75	40.43	109952.0
2011-11-04	BKLN	ETF	24.03	24.13	23.9	24.03	109900.0
2011-11-04	BLV	ETF	90.86	91.63	90.71	91.37	114000.0
2011-11-04	BMVP	ETF	13.853	13.987	13.81	13.927	3530.0
2011-11-04	BND	ETF	83.75	83.92	83.73	83.89	2324000.0
2011-11-04	BNO	ETF	38.225	38.49	37.885	38.48	43600.0
2011-11-04	BRF	ETF	44.92	45.218	44.39	44.92	75092.0

> showing 50 of 880 rows — these rows as CSV

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