PREVIEW / etf_daily / 2011-12-15

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-15.parquet
  size:    37 KB
  rows:    889

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-12-15	SPY	ETF	123.03	123.2	121.99	122.18	199109200.0
2011-12-15	QQQ	ETF	55.36	55.42	54.66	54.74	58732814.0
2011-12-15	IWM	ETF	72.06	72.11	71.04	71.7	50096100.0
2011-12-15	DIA	ETF	119.59	119.75	118.58	118.81	5261400.0
2011-12-15	GLD	ETF	154.74	154.95	151.71	152.33	21521900.0
2011-12-15	TLT	ETF	120.66	121.32	120.37	120.91	5438700.0
2011-12-15	AAXJ	ETF	49.58	49.76	49.13	49.2	455100.0
2011-12-15	ACTV	ETF	12.95	13.08	12.71	12.87	751182.0
2011-12-15	ACWI	ETF	41.59	41.69	41.25	41.4	532600.0
2011-12-15	ACWV	ETF	49.8	49.8	49.8	49.8	100.0
2011-12-15	ACWX	ETF	36.56	36.56	35.86	35.91	1366810.0
2011-12-15	ADRE	ETF	38.19	38.24	37.5	37.54	12850.0
2011-12-15	AFK	ETF	26.2	26.41	25.94	25.9929	11867.0
2011-12-15	AGEM	ETF	20.66	20.8	20.46	20.47	4258.0
2011-12-15	AGG	ETF	109.86	109.96	109.59	109.68	3769300.0
2011-12-15	AGQ	ETF	190.0	190.56	180.2	186.72	614900.0
2011-12-15	AGZ	ETF	112.91	112.91	112.632	112.831	195493.0
2011-12-15	AIA	ETF	39.08	39.08	38.7	38.77	102300.0
2011-12-15	AIQ	ETF	5.55	5.65	4.7005	5.05	150951.0
2011-12-15	AIS	ETF	1.86	1.9	1.51	1.67	8874772.0
2011-12-15	AIVI	ETF	38.91	38.97	38.51	38.54	111300.0
2011-12-15	AMJ	ETF	37.28	37.34	37.08	37.31	948562.0
2011-12-15	AMLP	ETF	81.35	81.4	80.4	80.7	294720.0
2011-12-15	AOA	ETF	32.41	32.41	32.21	32.23	8400.0
2011-12-15	AOK	ETF	29.14	29.209	29.11	29.15	176303.0
2011-12-15	AOM	ETF	29.76	29.76	29.65	29.67	29251.0
2011-12-15	AOR	ETF	30.75	30.7595	30.64	30.64	25299.0
2011-12-15	ARB	ETF	35.28	35.51	34.57	34.75	124148.0
2011-12-15	ASEA	ETF	14.36	14.48	14.29	14.29	3500.0
2011-12-15	AWAY	ETF	23.18	23.91	22.87	23.31	418464.0
2011-12-15	BAB	ETF	28.52	28.66	28.394	28.64	208599.0
2011-12-15	BAL	ETF	52.82	53.52	52.64	53.01	23936.0
2011-12-15	BALT	ETF	5.16	5.18	4.95	5.12	82780.0
2011-12-15	BBH	ETF	34.19	34.7167	34.19	34.5867	130500.0
2011-12-15	BCM	ETF	42.08	42.08	41.4617	41.4617	725.0
2011-12-15	BIB	ETF	7.8587	7.925	7.8587	7.925	2400.0
2011-12-15	BICK	ETF	23.23	23.23	22.86	22.91	9302.0
2011-12-15	BIL	ETF	91.68	91.68	91.66	91.66	535050.0
2011-12-15	BIS	ETF	5811.2	5811.2	5768.0	5784.0	4.695
2011-12-15	BITS	ETF	21.6	23.0	21.32	22.8	14836.0
2011-12-15	BIV	ETF	87.64	87.8	87.61	87.75	169900.0
2011-12-15	BJK	ETF	29.29	29.38	29.11	29.24	6900.0
2011-12-15	BKF	ETF	36.36	36.39	35.8658	35.96	224449.0
2011-12-15	BKLN	ETF	23.7	23.7	23.62	23.69	86900.0
2011-12-15	BLV	ETF	92.0	92.29	91.75	92.09	71700.0
2011-12-15	BMVP	ETF	13.25	13.2567	13.19	13.2034	4049.0
2011-12-15	BND	ETF	83.78	83.87	83.75	83.82	2590900.0
2011-12-15	BNO	ETF	36.475	36.505	35.81	35.84	182800.0
2011-12-15	BOIL	ETF	2365000.0	2395000.0	2310000.0	2317000.0	0.2
2011-12-15	BRF	ETF	41.89	42.06	41.541	41.68	138176.0

> showing 50 of 889 rows — these rows as CSV

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