PREVIEW / etf_daily / 2012-01-20

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-20.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
2012-01-20	SPY	ETF	131.24	131.95	130.92	131.95	138230200.0
2012-01-20	QQQ	ETF	59.61	59.8	59.56	59.77	41050565.0
2012-01-20	IWM	ETF	78.1	78.51	77.9	78.25	42221200.0
2012-01-20	DIA	ETF	126.04	126.96	125.95	126.96	6995400.0
2012-01-20	GLD	ETF	160.5	162.09	160.0	162.07	11616700.0
2012-01-20	TLT	ETF	117.71	117.96	116.97	116.98	6548200.0
2012-01-20	AADR	ETF	29.09	29.09	29.09	29.09	400.0
2012-01-20	AAXJ	ETF	54.19	54.55	54.13	54.49	293700.0
2012-01-20	ACTV	ETF	14.88	14.88	14.31	14.59	262502.0
2012-01-20	ACWI	ETF	44.12	44.34	44.1	44.3	296200.0
2012-01-20	ACWX	ETF	38.41	38.6	38.35	38.59	514111.0
2012-01-20	ADRE	ETF	41.83	41.92	41.68	41.9	152555.0
2012-01-20	AFK	ETF	26.92	26.95	26.75	26.796	6531.0
2012-01-20	AGEM	ETF	22.73	22.73	22.73	22.73	100.0
2012-01-20	AGG	ETF	110.32	110.32	109.9	109.98	1032600.0
2012-01-20	AGQ	ETF	201.4	222.12	200.04	222.08	777250.0
2012-01-20	AGZ	ETF	112.92	112.96	112.7	112.86	64225.0
2012-01-20	AIA	ETF	42.47	42.5461	42.28	42.5461	15200.0
2012-01-20	AIQ	ETF	5.55	5.8505	5.35	5.75	15330.0
2012-01-20	AIS	ETF	2.25	2.25	2.19	2.21	545891.0
2012-01-20	AIVI	ETF	40.36	40.47	40.21	40.47	61000.0
2012-01-20	AMJ	ETF	39.28	39.49	39.06	39.49	871453.0
2012-01-20	AMLP	ETF	83.55	84.25	83.15	83.75	328180.0
2012-01-20	AOA	ETF	34.48	34.53	34.46	34.53	8000.0
2012-01-20	AOK	ETF	29.65	29.65	29.5704	29.5704	9374.0
2012-01-20	AOM	ETF	30.38	30.39	30.33	30.37	25450.0
2012-01-20	AOR	ETF	32.01	32.04	31.9475	32.04	22221.0
2012-01-20	ARB	ETF	36.75	37.0	36.6	36.81	100374.0
2012-01-20	ARGT	ETF	23.4	23.56	23.4	23.54	300.0
2012-01-20	ASEA	ETF	15.34	15.43	15.27	15.38	3600.0
2012-01-20	AWAY	ETF	25.11	25.51	24.67	25.51	226701.0
2012-01-20	BAB	ETF	28.77	28.8115	28.67	28.67	196328.0
2012-01-20	BAL	ETF	60.9	61.05	60.29	60.94	14528.0
2012-01-20	BALT	ETF	4.44	4.51	4.41	4.48	147421.0
2012-01-20	BBH	ETF	40.5167	40.6567	40.2733	40.3933	19800.0
2012-01-20	BCM	ETF	44.22	44.66	43.94	44.22	17192.0
2012-01-20	BIB	ETF	10.2775	10.2775	10.0666	10.1475	42120.0
2012-01-20	BICK	ETF	26.03	26.18	25.91	26.18	8973.0
2012-01-20	BIL	ETF	91.64	91.66	91.64	91.64	211400.0
2012-01-20	BIS	ETF	4459.2	4491.2	4430.4	4478.4	46.25
2012-01-20	BITS	ETF	22.64	22.8	22.24	22.6	347.0
2012-01-20	BIV	ETF	87.05	87.05	86.85	86.93	160300.0
2012-01-20	BJK	ETF	32.04	32.12	31.93	32.07	18300.0
2012-01-20	BKF	ETF	40.3	40.57	40.14	40.53	192546.0
2012-01-20	BKLN	ETF	24.12	24.15	24.1	24.14	47600.0
2012-01-20	BLNG	ETF	50.82	50.82	50.82	50.82	1000.0
2012-01-20	BLV	ETF	90.9	91.04	90.41	90.48	50400.0
2012-01-20	BMVP	ETF	14.3866	14.3866	14.35	14.37	1530.0
2012-01-20	BND	ETF	83.55	83.56	83.24	83.37	1139400.0
2012-01-20	BNO	ETF	38.645	38.645	38.115	38.34	102000.0

> showing 50 of 896 rows — these rows as CSV

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