PREVIEW / etf_daily / 2012-03-12

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-12.parquet
  size:    38 KB
  rows:    919

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-03-12	SPY	ETF	137.55	137.76	137.09	137.58	104003500.0
2012-03-12	QQQ	ETF	64.97	65.11	64.72	65.05	32687292.0
2012-03-12	IWM	ETF	81.74	81.93	81.05	81.44	34084200.0
2012-03-12	DIA	ETF	129.17	129.67	129.1	129.46	5197000.0
2012-03-12	GLD	ETF	165.33	165.58	164.4	165.07	6523800.0
2012-03-12	TLT	ETF	116.32	116.52	115.87	115.95	5280000.0
2012-03-12	AADR	ETF	30.34	30.34	30.31	30.31	500.0
2012-03-12	AAXJ	ETF	57.13	57.13	56.74	56.9	203700.0
2012-03-12	ACTV	ETF	16.64	17.0	16.45	16.99	460892.0
2012-03-12	ACWI	ETF	46.54	46.58	46.32	46.51	667100.0
2012-03-12	ACWV	ETF	53.64	53.93	53.62	53.88	16100.0
2012-03-12	ACWX	ETF	40.64	40.66	40.41	40.63	191985.0
2012-03-12	ADRE	ETF	42.57	42.74	42.29	42.45	35313.0
2012-03-12	AFK	ETF	29.97	29.97	29.73	29.91	17906.0
2012-03-12	AGEM	ETF	23.6227	23.6227	23.6227	23.6227	114.0
2012-03-12	AGG	ETF	110.39	110.45	110.25	110.29	1096600.0
2012-03-12	AGQ	ETF	240.96	241.16	233.76	236.48	385150.0
2012-03-12	AGZ	ETF	112.88	112.88	112.73	112.78	5819.0
2012-03-12	AIA	ETF	44.78	44.78	44.5	44.68	13226.0
2012-03-12	AIQ	ETF	6.85	6.95	6.4	6.7	23152.0
2012-03-12	AIS	ETF	2.72	2.8	2.53	2.72	2409958.0
2012-03-12	AIVI	ETF	41.5	41.61	41.29	41.59	42100.0
2012-03-12	AMJ	ETF	40.53	40.6	40.352	40.43	3166559.0
2012-03-12	AMLP	ETF	84.55	84.95	84.5	84.75	292760.0
2012-03-12	AOA	ETF	35.95	35.97	35.86	35.93	26500.0
2012-03-12	AOK	ETF	30.1	30.1	30.05	30.07	7437.0
2012-03-12	AOM	ETF	31.13	31.13	31.05	31.07	13180.0
2012-03-12	AOR	ETF	33.06	33.06	32.96	33.019	13901.0
2012-03-12	ARB	ETF	34.59	35.06	34.38	34.63	205056.0
2012-03-12	ARGT	ETF	22.14	22.14	21.86	21.86	350.0
2012-03-12	ASEA	ETF	15.73	15.8	15.67	15.8	5800.0
2012-03-12	AWAY	ETF	25.76	26.0	25.38	25.94	522613.0
2012-03-12	BAB	ETF	29.49	29.5	29.4	29.43	113539.0
2012-03-12	BAL	ETF	53.58	53.86	52.84	53.34	27422.0
2012-03-12	BALT	ETF	4.04	4.05	3.91	3.98	89602.0
2012-03-12	BBH	ETF	42.47	42.56	42.31	42.36	4900.0
2012-03-12	BCM	ETF	46.16	46.179	46.16	46.179	3257.0
2012-03-12	BIB	ETF	11.3063	11.3163	11.1725	11.2375	7120.0
2012-03-12	BICK	ETF	26.92	27.1625	26.9101	27.04	6000.0
2012-03-12	BIL	ETF	91.66	91.66	91.64	91.66	124850.0
2012-03-12	BIS	ETF	3924.8	3931.2	3924.8	3931.2	2.5
2012-03-12	BITS	ETF	21.0	21.0	19.48	20.8	5202.0
2012-03-12	BIV	ETF	87.83	87.83	87.68	87.69	518500.0
2012-03-12	BJK	ETF	34.68	34.68	34.37	34.44	4100.0
2012-03-12	BKF	ETF	42.54	42.635	42.23	42.48	102172.0
2012-03-12	BKLN	ETF	24.53	24.54	24.49	24.53	272800.0
2012-03-12	BLNG	ETF	52.27	52.27	52.2501	52.2501	500.0
2012-03-12	BLV	ETF	90.95	91.07	90.69	90.71	33400.0
2012-03-12	BMVP	ETF	15.19	15.25	15.19	15.21	4655.0
2012-03-12	BND	ETF	83.66	83.68	83.57	83.58	1095300.0

> showing 50 of 919 rows — these rows as CSV

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