PREVIEW / etf_daily / 2011-12-19

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-19.parquet
  size:    37 KB
  rows:    896

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-12-19	SPY	ETF	122.06	122.32	120.03	120.29	183903000.0
2011-12-19	QQQ	ETF	55.06	55.2	54.17	54.32	46733812.0
2011-12-19	IWM	ETF	72.93	73.2	70.83	71.01	52897500.0
2011-12-19	DIA	ETF	118.65	118.98	117.05	117.36	7977500.0
2011-12-19	GLD	ETF	155.48	155.86	154.36	154.87	12547200.0
2011-12-19	TLT	ETF	122.32	124.02	122.26	123.87	7845100.0
2011-12-19	AADR	ETF	27.1	27.22	27.02	27.22	1200.0
2011-12-19	AAXJ	ETF	49.02	49.25	48.22	48.45	1662200.0
2011-12-19	ACTV	ETF	13.15	13.34	12.95	13.02	406043.0
2011-12-19	ACWI	ETF	41.3	41.5	40.71	40.84	1071000.0
2011-12-19	ACWV	ETF	49.77	49.77	49.77	49.77	200.0
2011-12-19	ACWX	ETF	36.06	36.21	35.68	35.69	753520.0
2011-12-19	ADRE	ETF	37.1	37.22	36.41	36.49	58098.0
2011-12-19	AFK	ETF	26.22	26.24	25.8	25.81	9364.0
2011-12-19	AGEM	ETF	20.52	20.52	20.091	20.208	3995.0
2011-12-19	AGG	ETF	110.05	110.23	109.96	110.16	1123700.0
2011-12-19	AGQ	ETF	187.16	189.6	182.28	182.6	512400.0
2011-12-19	AGZ	ETF	112.66	113.03	112.66	113.02	9856.0
2011-12-19	AIA	ETF	37.91	37.93	37.34	37.37	16627.0
2011-12-19	AIQ	ETF	4.971	5.05	4.65	4.8875	30217.0
2011-12-19	AIS	ETF	1.79	1.83	1.65	1.7	1592062.0
2011-12-19	AIVI	ETF	38.68	38.76	38.07	38.13	145400.0
2011-12-19	AMJ	ETF	37.51	37.64	37.4	37.49	481010.0
2011-12-19	AMLP	ETF	81.2	81.4	80.75	81.0	286120.0
2011-12-19	AOA	ETF	32.49	32.55	31.97	31.97	3900.0
2011-12-19	AOK	ETF	29.23	29.24	29.1	29.1	13126.0
2011-12-19	AOM	ETF	29.68	29.78	29.58	29.64	54804.0
2011-12-19	AOR	ETF	30.89	30.89	30.53	30.58	16564.0
2011-12-19	ARB	ETF	35.74	36.12	34.44	34.51	101862.0
2011-12-19	ARGT	ETF	21.76	21.76	21.42	21.42	200.0
2011-12-19	ASEA	ETF	14.57	14.57	14.27	14.4	17400.0
2011-12-19	AWAY	ETF	23.3	23.93	19.94	20.88	692275.0
2011-12-19	BAB	ETF	28.85	28.95	28.74	28.9	221966.0
2011-12-19	BAL	ETF	53.65	53.917	53.13	53.51	25911.0
2011-12-19	BALT	ETF	5.13	5.2	4.8	4.8	86771.0
2011-12-19	BBH	ETF	34.24	35.1467	34.1833	34.68	101400.0
2011-12-19	BCM	ETF	41.81	41.81	41.69	41.79	8898.0
2011-12-19	BIB	ETF	8.1587	8.1587	7.96	7.96	5600.0
2011-12-19	BICK	ETF	22.73	22.73	22.158	22.21	18398.0
2011-12-19	BIL	ETF	91.66	91.68	91.66	91.68	348500.0
2011-12-19	BIS	ETF	5611.2	5760.0	5607.68	5760.0	8.8
2011-12-19	BITS	ETF	22.92	23.0	22.36	22.84	3358.0
2011-12-19	BIV	ETF	88.07	88.29	88.02	88.29	120600.0
2011-12-19	BJK	ETF	29.51	29.51	28.77	28.79	9200.0
2011-12-19	BKF	ETF	36.05	36.05	35.2201	35.26	122476.0
2011-12-19	BKLN	ETF	23.79	23.79	23.58	23.72	85600.0
2011-12-19	BLNG	ETF	48.06	48.06	48.06	48.06	500.0
2011-12-19	BLV	ETF	93.0	93.82	92.86	93.79	71000.0
2011-12-19	BMVP	ETF	13.25	13.27	13.03	13.03	5824.0
2011-12-19	BND	ETF	84.07	84.2	84.0	84.02	1316300.0

> showing 50 of 896 rows — these rows as CSV

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