PREVIEW / etf_daily / 2012-01-03

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-03.parquet
  size:    37 KB
  rows:    900

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
2012-01-03	SPY	ETF	127.76	128.38	127.43	127.5	193697900.0
2012-01-03	QQQ	ETF	56.91	57.19	56.75	56.9	39512874.0
2012-01-03	IWM	ETF	75.68	75.87	74.77	74.97	60504700.0
2012-01-03	DIA	ETF	123.94	124.53	123.61	123.63	7175100.0
2012-01-03	GLD	ETF	154.76	156.3	154.55	155.92	13385800.0
2012-01-03	TLT	ETF	119.42	120.2	118.93	119.43	9076900.0
2012-01-03	AADR	ETF	28.97	28.97	28.64	28.64	1100.0
2012-01-03	AAXJ	ETF	50.84	51.49	50.84	51.24	379700.0
2012-01-03	ACTV	ETF	13.74	13.8	13.34	13.43	275538.0
2012-01-03	ACWI	ETF	42.95	43.3	42.95	42.98	638000.0
2012-01-03	ACWV	ETF	52.06	52.06	51.79	51.79	500.0
2012-01-03	ACWX	ETF	37.5	37.89	37.5	37.71	515781.0
2012-01-03	ADRE	ETF	38.97	39.61	38.97	39.53	61371.0
2012-01-03	AFK	ETF	25.95	26.24	25.88	26.2	34111.0
2012-01-03	AGEM	ETF	21.16	21.33	21.13	21.24	1300.0
2012-01-03	AGG	ETF	110.2	110.2	109.92	110.03	1994600.0
2012-01-03	AGQ	ETF	179.84	191.88	179.28	190.8	1035050.0
2012-01-03	AGZ	ETF	112.69	113.48	112.62	112.829	21424.0
2012-01-03	AIA	ETF	40.25	40.54	40.15	40.34	18899.0
2012-01-03	AIQ	ETF	6.5	6.5	6.05	6.2	9801.0
2012-01-03	AIS	ETF	2.215	2.25	2.13	2.17	824144.0
2012-01-03	AIVI	ETF	40.36	40.82	40.36	40.72	58900.0
2012-01-03	AMJ	ETF	39.47	39.47	39.01	39.08	1938133.0
2012-01-03	AMLP	ETF	83.9	83.9	83.05	83.2	373120.0
2012-01-03	AOA	ETF	33.64	33.74	33.44	33.49	63200.0
2012-01-03	AOK	ETF	29.39	29.45	29.36	29.36	56466.0
2012-01-03	AOM	ETF	30.08	30.13	30.02	30.02	66571.0
2012-01-03	AOR	ETF	31.42	31.54	31.36	31.43	36512.0
2012-01-03	ARB	ETF	35.32	36.61	35.32	36.31	244447.0
2012-01-03	ARGT	ETF	21.7	22.02	21.7	21.98	900.0
2012-01-03	ASEA	ETF	14.75	14.82	14.65	14.79	50400.0
2012-01-03	AWAY	ETF	23.49	24.01	21.63	23.74	527725.0
2012-01-03	BAB	ETF	28.5	28.65	28.42	28.56	157227.0
2012-01-03	BAL	ETF	57.1046	59.36	57.06	59.28	48694.0
2012-01-03	BALT	ETF	4.9	4.97	4.6	4.69	156515.0
2012-01-03	BBH	ETF	37.0667	37.1967	36.7533	36.7533	25200.0
2012-01-03	BIB	ETF	8.9437	8.9437	8.75	8.798	19688.0
2012-01-03	BICK	ETF	23.33	23.78	23.33	23.6	25291.0
2012-01-03	BIL	ETF	91.66	91.68	91.64	91.64	4246650.0
2012-01-03	BIS	ETF	5131.2	5131.2	5070.4	5096.0	4.06
2012-01-03	BITS	ETF	23.0	23.0	22.68	22.8	4359.0
2012-01-03	BIV	ETF	86.62	87.01	86.62	86.9	379600.0
2012-01-03	BJK	ETF	30.93	31.05	30.76	30.92	57500.0
2012-01-03	BKF	ETF	37.19	37.76	37.19	37.64	106487.0
2012-01-03	BKLN	ETF	23.84	23.96	23.84	23.93	199800.0
2012-01-03	BLV	ETF	91.24	91.85	90.88	91.51	171000.0
2012-01-03	BMVP	ETF	13.87	13.92	13.82	13.82	27904.0
2012-01-03	BND	ETF	83.43	83.43	83.18	83.28	2282600.0
2012-01-03	BNO	ETF	38.46	38.995	38.325	38.955	56600.0
2012-01-03	BOIL	ETF	2055000.0	2073000.0	1980000.0	2041000.0	0.4

> showing 50 of 900 rows — these rows as CSV

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