PREVIEW / etf_daily / 2011-06-14

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-14.parquet
  size:    36 KB
  rows:    853

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-06-14	SPY	ETF	128.87	129.77	128.82	129.32	160570400.0
2011-06-14	QQQ	ETF	55.05	55.47	55.03	55.34	40565261.0
2011-06-14	IWM	ETF	78.44	79.68	78.39	79.45	66662700.0
2011-06-14	DIA	ETF	120.25	121.14	120.21	120.7	4853100.0
2011-06-14	GLD	ETF	147.7	148.73	147.48	148.67	10938500.0
2011-06-14	TLT	ETF	95.74	95.9	95.13	95.19	8672400.0
2011-06-14	AAXJ	ETF	61.58	61.89	61.48	61.68	350000.0
2011-06-14	ACTV	ETF	19.0	19.35	18.74	19.0	127660.0
2011-06-14	ACWI	ETF	47.66	48.0	47.66	47.82	340200.0
2011-06-14	ACWX	ETF	44.84	45.0399	44.82	44.9	48669.0
2011-06-14	ADRE	ETF	45.36	45.7336	45.36	45.63	26431.0
2011-06-14	AFK	ETF	32.41	32.74	32.41	32.62	31500.0
2011-06-14	AGG	ETF	107.15	107.18	107.02	107.05	1199000.0
2011-06-14	AGQ	ETF	330.26	348.76	330.0	347.78	866350.0
2011-06-14	AGZ	ETF	110.85	110.85	110.6	110.642	8069.0
2011-06-14	AIA	ETF	47.02	47.4	47.02	47.1829	31176.0
2011-06-14	AIQ	ETF	18.75	19.2	18.65	19.2	18362.0
2011-06-14	AIS	ETF	1.97	2.02	1.94	2.0	847939.0
2011-06-14	AIVI	ETF	47.43	47.85	47.43	47.7	69500.0
2011-06-14	AMJ	ETF	36.37	36.5	36.05	36.16	450361.0
2011-06-14	AMLP	ETF	79.25	79.25	78.9	79.0	212040.0
2011-06-14	AOA	ETF	35.17	35.3	35.14	35.2	13900.0
2011-06-14	AOK	ETF	29.15	29.21	29.15	29.2	5149.0
2011-06-14	AOM	ETF	30.522	30.5799	30.518	30.54	29031.0
2011-06-14	AOR	ETF	32.18	32.35	32.18	32.3054	40849.0
2011-06-14	ARB	ETF	38.59	39.44	38.59	39.23	133991.0
2011-06-14	ARGT	ETF	28.86	28.86	28.78	28.78	150.0
2011-06-14	ASEA	ETF	16.18	16.18	16.04	16.04	800.0
2011-06-14	BAB	ETF	26.63	26.64	26.5	26.52	77800.0
2011-06-14	BAL	ETF	81.35	82.15	80.25	81.57	18843.0
2011-06-14	BALT	ETF	5.85	6.19	5.82	6.08	182578.0
2011-06-14	BBH	ETF	34.1633	34.32	34.0667	34.28	57000.0
2011-06-14	BCM	ETF	47.858	47.858	47.858	47.858	410.0
2011-06-14	BIB	ETF	9.095	9.2088	8.9563	9.1426	32368.0
2011-06-14	BICK	ETF	31.61	31.8462	31.61	31.8	9265.0
2011-06-14	BIL	ETF	91.7	91.72	91.7	91.72	862400.0
2011-06-14	BIS	ETF	6481.6	6481.6	6288.0	6331.184	23.1
2011-06-14	BITS	ETF	21.56	21.8	20.52	21.68	1092.0
2011-06-14	BIV	ETF	84.34	84.4	84.14	84.22	124500.0
2011-06-14	BJK	ETF	32.42	32.83	32.42	32.74	11400.0
2011-06-14	BKF	ETF	47.54	47.59	47.36	47.37	97998.0
2011-06-14	BKLN	ETF	24.93	24.93	24.88	24.93	92800.0
2011-06-14	BLNG	ETF	48.08	48.33	48.08	48.22	5500.0
2011-06-14	BLV	ETF	81.31	81.41	80.84	80.99	117600.0
2011-06-14	BMVP	ETF	15.01	15.2241	15.01	15.1667	23522.0
2011-06-14	BND	ETF	81.51	81.51	81.37	81.37	860100.0
2011-06-14	BNO	ETF	39.815	40.045	39.655	39.79	218000.0
2011-06-14	BOSS	ETF	56.28	57.24	56.28	56.99	600.0
2011-06-14	BRF	ETF	57.49	57.65	56.91	57.1	118583.0
2011-06-14	BSCE	ETF	21.11	21.159	21.09	21.13	10197.0

> showing 50 of 853 rows — these rows as CSV

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