PREVIEW / etf_daily / 2012-01-19

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-19.parquet
  size:    37 KB
  rows:    903

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-19	SPY	ETF	131.22	131.57	130.8	131.46	126328900.0
2012-01-19	QQQ	ETF	59.76	59.97	59.65	59.86	47774414.0
2012-01-19	IWM	ETF	78.13	78.36	77.66	78.2	35830500.0
2012-01-19	DIA	ETF	125.99	126.18	125.52	126.17	8095300.0
2012-01-19	GLD	ETF	160.96	161.45	160.33	161.22	8114200.0
2012-01-19	TLT	ETF	119.33	119.56	117.92	118.32	8625700.0
2012-01-19	AADR	ETF	29.08	29.17	29.08	29.17	400.0
2012-01-19	AAXJ	ETF	54.21	54.37	53.96	54.28	416400.0
2012-01-19	ACTV	ETF	15.01	15.01	14.75	14.93	97693.0
2012-01-19	ACWI	ETF	44.14	44.3	44.0	44.22	320700.0
2012-01-19	ACWX	ETF	38.37	38.53	38.24	38.49	208740.0
2012-01-19	ADRE	ETF	41.6	41.9699	41.6	41.91	44022.0
2012-01-19	AFK	ETF	27.14	27.15	27.0	27.1	16013.0
2012-01-19	AGEM	ETF	22.98	22.98	22.78	22.78	1456.0
2012-01-19	AGG	ETF	110.43	110.47	110.17	110.26	1032300.0
2012-01-19	AGQ	ETF	200.72	203.2	199.04	202.36	404250.0
2012-01-19	AGZ	ETF	113.04	113.04	112.69	112.89	25707.0
2012-01-19	AIA	ETF	42.01	42.28	42.01	42.22	13508.0
2012-01-19	AIQ	ETF	5.55	5.693	5.4	5.55	9872.0
2012-01-19	AIS	ETF	2.28	2.28	2.24	2.24	493726.0
2012-01-19	AIVI	ETF	40.09	40.35	39.93	40.35	103400.0
2012-01-19	AMJ	ETF	39.39	39.44	39.104	39.31	1242322.0
2012-01-19	AMLP	ETF	83.5	83.6	83.05	83.6	559900.0
2012-01-19	AOA	ETF	34.46	34.57	34.46	34.54	11600.0
2012-01-19	AOK	ETF	29.66	29.66	29.6	29.61	28031.0
2012-01-19	AOM	ETF	30.39	30.42	30.33	30.37	22073.0
2012-01-19	AOR	ETF	32.01	32.06	31.95	32.04	100600.0
2012-01-19	ARB	ETF	36.88	37.0	36.63	36.72	90861.0
2012-01-19	ASEA	ETF	15.25	15.42	15.2	15.38	182500.0
2012-01-19	AWAY	ETF	25.2	25.71	25.01	25.21	331611.0
2012-01-19	BAB	ETF	28.98	28.98	28.75	28.8	342165.0
2012-01-19	BAL	ETF	60.4	60.903	60.4	60.66	26574.0
2012-01-19	BALT	ETF	4.46	4.51	4.37	4.43	162427.0
2012-01-19	BBH	ETF	40.76	40.7667	40.5067	40.5767	49200.0
2012-01-19	BCM	ETF	44.33	44.33	44.15	44.15	400.0
2012-01-19	BIB	ETF	10.49	10.49	10.2637	10.2637	98752.0
2012-01-19	BICK	ETF	25.64	26.03	25.64	25.98	38703.0
2012-01-19	BIL	ETF	91.64	91.66	91.64	91.64	728100.0
2012-01-19	BIS	ETF	4379.2	4411.2	4337.6	4411.2	186.0
2012-01-19	BITS	ETF	22.8	22.8	22.4	22.76	550.0
2012-01-19	BIV	ETF	87.34	87.37	86.9	86.96	766200.0
2012-01-19	BJK	ETF	31.97	32.16	31.97	32.02	13400.0
2012-01-19	BKF	ETF	40.46	40.66	40.32	40.55	131331.0
2012-01-19	BKLN	ETF	24.12	24.15	24.06	24.07	128500.0
2012-01-19	BLV	ETF	91.85	91.93	90.97	91.15	37100.0
2012-01-19	BMVP	ETF	14.3633	14.4036	14.3433	14.396	5624.0
2012-01-19	BND	ETF	83.61	83.68	83.47	83.53	1783800.0
2012-01-19	BNO	ETF	38.72	38.845	38.485	38.84	82800.0
2012-01-19	BOIL	ETF	1338000.0	1351000.0	1212000.0	1233000.0	3.6
2012-01-19	BRF	ETF	40.52	40.85	40.37	40.8	277354.0

> showing 50 of 903 rows — these rows as CSV

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