PREVIEW / etf_daily / 2011-08-25

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-25.parquet
  size:    36 KB
  rows:    866

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-08-25	SPY	ETF	118.73	119.4	115.87	116.28	312365400.0
2011-08-25	QQQ	ETF	52.64	52.905	51.65	51.83	93623637.0
2011-08-25	IWM	ETF	69.98	70.29	67.25	67.5	80732900.0
2011-08-25	DIA	ETF	113.39	113.78	110.81	111.26	10391700.0
2011-08-25	GLD	ETF	167.0	172.81	165.88	172.36	43273700.0
2011-08-25	TLT	ETF	106.69	107.9	106.36	107.43	10565900.0
2011-08-25	AAXJ	ETF	53.93	54.08	52.74	52.8	801900.0
2011-08-25	ACTV	ETF	16.97	16.97	15.95	16.04	80962.0
2011-08-25	ACWI	ETF	42.45	42.59	41.42	41.57	987800.0
2011-08-25	ACWX	ETF	38.76	38.83	37.854	38.02	86552.0
2011-08-25	ADRE	ETF	40.14	40.27	39.502	39.7	54285.0
2011-08-25	AFK	ETF	28.55	28.57	27.97	28.02	63735.0
2011-08-25	AGEM	ETF	22.6	22.65	22.05	22.116	1302.0
2011-08-25	AGG	ETF	109.14	109.33	109.03	109.23	647100.0
2011-08-25	AGQ	ETF	407.68	442.8	400.18	440.54	649900.0
2011-08-25	AGZ	ETF	112.21	112.32	112.08	112.152	18413.0
2011-08-25	AIA	ETF	40.44	40.47	39.56	39.58	25421.0
2011-08-25	AIQ	ETF	7.15	7.15	6.8	6.8	16247.0
2011-08-25	AIS	ETF	2.39	2.43	2.3	2.3	671386.0
2011-08-25	AIVI	ETF	41.56	41.65	40.52	40.63	60400.0
2011-08-25	AMJ	ETF	33.92	34.83	33.675	33.92	1299534.0
2011-08-25	AMLP	ETF	76.4	76.85	74.7	75.05	287400.0
2011-08-25	AOA	ETF	32.06	32.06	31.32	31.34	21300.0
2011-08-25	AOK	ETF	28.8	28.97	28.411	28.71	60406.0
2011-08-25	AOM	ETF	29.58	29.58	29.3	29.3	13354.0
2011-08-25	AOR	ETF	30.52	30.52	30.09	30.17	4718.0
2011-08-25	ARB	ETF	34.52	34.93	32.86	33.12	137682.0
2011-08-25	ARGT	ETF	24.66	24.66	24.62	24.62	500.0
2011-08-25	ASEA	ETF	15.66	15.66	15.41	15.59	4600.0
2011-08-25	AWAY	ETF	37.21	39.39	36.74	37.05	269223.0
2011-08-25	BAB	ETF	27.39	27.5565	27.24	27.46	96744.0
2011-08-25	BAL	ETF	64.0	64.45	63.04	64.28	93022.0
2011-08-25	BALT	ETF	4.51	4.56	4.39	4.39	146444.0
2011-08-25	BBH	ETF	32.1233	32.17	31.64	31.64	9600.0
2011-08-25	BIB	ETF	6.9013	6.9375	6.605	6.6615	100360.0
2011-08-25	BICK	ETF	25.8	25.8	25.26	25.45	10790.0
2011-08-25	BIL	ETF	91.72	91.72	91.68	91.68	334800.0
2011-08-25	BIS	ETF	7264.0	7641.6	7260.8	7641.6	3.75
2011-08-25	BITS	ETF	22.2	22.2	21.12	22.16	950.0
2011-08-25	BIV	ETF	87.36	87.8	87.33	87.64	99100.0
2011-08-25	BJK	ETF	31.21	31.3	30.76	30.76	15200.0
2011-08-25	BKF	ETF	39.89	40.11	39.01	39.27	140357.0
2011-08-25	BKLN	ETF	22.8	23.57	22.77	22.85	71300.0
2011-08-25	BLNG	ETF	52.78	55.6	52.77	55.6	1280.0
2011-08-25	BLV	ETF	86.18	86.83	86.11	86.67	35100.0
2011-08-25	BMVP	ETF	13.32	13.36	12.94	12.94	5378.0
2011-08-25	BND	ETF	83.21	83.34	83.12	83.3	2174800.0
2011-08-25	BNO	ETF	37.225	37.245	36.48	36.94	105000.0
2011-08-25	BRF	ETF	47.74	47.77	46.89	47.18	77817.0
2011-08-25	BSCE	ETF	20.98	21.09	20.95	21.01	18238.0

> showing 50 of 866 rows — these rows as CSV

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