PREVIEW / etf_daily / 2011-10-14

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-14.parquet
  size:    37 KB
  rows:    874

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-10-14	SPY	ETF	121.91	122.6	121.23	122.57	211397600.0
2011-10-14	QQQ	ETF	57.84	58.19	57.51	58.18	65643503.0
2011-10-14	IWM	ETF	70.58	71.34	69.81	71.14	69768200.0
2011-10-14	DIA	ETF	115.82	116.35	115.16	116.34	5256900.0
2011-10-14	GLD	ETF	163.33	163.82	162.25	163.4	9737900.0
2011-10-14	TLT	ETF	113.88	114.61	113.61	113.95	8411000.0
2011-10-14	AADR	ETF	28.12	28.12	28.12	28.12	200.0
2011-10-14	AAXJ	ETF	51.66	52.26	51.61	52.15	791800.0
2011-10-14	ACTV	ETF	14.58	14.94	14.42	14.75	72049.0
2011-10-14	ACWI	ETF	42.75	42.95	42.46	42.94	599200.0
2011-10-14	ACWX	ETF	38.37	38.482	38.14	38.48	109051.0
2011-10-14	ADRE	ETF	39.18	39.41	38.9829	39.36	29614.0
2011-10-14	AFK	ETF	27.3	27.57	27.24	27.443	11391.0
2011-10-14	AGEM	ETF	21.704	21.704	21.64	21.64	358.0
2011-10-14	AGG	ETF	108.78	109.1	108.78	108.94	587500.0
2011-10-14	AGQ	ETF	239.44	244.0	232.84	239.36	393175.0
2011-10-14	AGZ	ETF	112.2	112.2	111.8823	112.0148	16784.0
2011-10-14	AIA	ETF	39.83	40.2	39.7229	40.2	38980.0
2011-10-14	AIQ	ETF	6.45	6.6	6.05	6.35	24894.0
2011-10-14	AIS	ETF	2.31	2.33	2.27	2.32	504883.0
2011-10-14	AIVI	ETF	42.13	42.2	41.78	42.18	53300.0
2011-10-14	AMJ	ETF	35.51	35.7	35.25	35.64	877319.0
2011-10-14	AMLP	ETF	78.1	78.45	77.8	78.3	128000.0
2011-10-14	AOA	ETF	32.4	32.58	32.37	32.58	12900.0
2011-10-14	AOK	ETF	28.95	28.99	28.912	28.99	12793.0
2011-10-14	AOM	ETF	29.59	29.84	29.52	29.61	125881.0
2011-10-14	AOR	ETF	30.67	30.78	30.593	30.78	39400.0
2011-10-14	ARB	ETF	38.21	38.2278	37.34	37.9	124170.0
2011-10-14	ARGT	ETF	22.0	22.08	22.0	22.08	2400.0
2011-10-14	ASEA	ETF	14.97	14.97	14.76	14.89	1900.0
2011-10-14	AWAY	ETF	35.63	37.48	35.4	37.28	130596.0
2011-10-14	BAB	ETF	27.85	28.18	27.7	28.07	203439.0
2011-10-14	BAL	ETF	63.3801	64.0	62.98	63.41	24973.0
2011-10-14	BALT	ETF	5.82	5.94	5.65	5.69	177040.0
2011-10-14	BBH	ETF	34.13	34.27	33.8733	34.26	95700.0
2011-10-14	BIB	ETF	7.785	7.785	7.4887	7.5778	51968.0
2011-10-14	BICK	ETF	24.93	24.98	24.795	24.8524	11516.0
2011-10-14	BIL	ETF	91.7	91.7	91.68	91.68	459250.0
2011-10-14	BIS	ETF	6406.4	6406.4	6318.4	6318.4	5.95
2011-10-14	BITS	ETF	23.4	23.44	22.4	22.44	562.0
2011-10-14	BIV	ETF	86.43	86.59	86.3	86.48	166100.0
2011-10-14	BJK	ETF	31.24	31.34	30.89	31.34	9300.0
2011-10-14	BKF	ETF	37.96	38.1187	37.58	38.1187	213420.0
2011-10-14	BKLN	ETF	23.47	23.47	23.23	23.41	123700.0
2011-10-14	BLV	ETF	88.57	89.12	88.39	88.71	31400.0
2011-10-14	BMVP	ETF	13.38	13.48	13.35	13.48	6897.0
2011-10-14	BND	ETF	82.78	82.95	82.75	82.85	861400.0
2011-10-14	BNO	ETF	38.42	38.68	38.26	38.66	222800.0
2011-10-14	BOIL	ETF	3788000.0	3976000.0	3788000.0	3937000.0	0.2
2011-10-14	BRF	ETF	43.97	44.4576	43.66	44.33	57144.0

> showing 50 of 874 rows — these rows as CSV

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