PREVIEW / etf_daily / 2011-12-09

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-09.parquet
  size:    37 KB
  rows:    887

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-09	SPY	ETF	124.51	126.37	124.4	126.05	209111400.0
2011-12-09	QQQ	ETF	56.26	57.19	56.24	57.02	55757852.0
2011-12-09	IWM	ETF	72.5	74.97	72.38	74.54	72184900.0
2011-12-09	DIA	ETF	120.47	122.11	120.41	121.78	8999200.0
2011-12-09	GLD	ETF	166.43	167.34	166.12	166.4	8354000.0
2011-12-09	TLT	ETF	119.07	119.13	116.63	116.71	9855100.0
2011-12-09	AADR	ETF	28.2	28.6	28.11	28.6	11000.0
2011-12-09	AAXJ	ETF	50.96	51.81	50.87	51.68	921100.0
2011-12-09	ACTV	ETF	13.0	13.09	12.8	13.01	281618.0
2011-12-09	ACWI	ETF	42.55	43.18	42.52	43.11	331800.0
2011-12-09	ACWV	ETF	50.59	50.82	50.56	50.82	1800.0
2011-12-09	ACWX	ETF	37.6	38.14	37.55	38.1	406350.0
2011-12-09	ADRE	ETF	39.26	39.9612	39.25	39.89	30925.0
2011-12-09	AFK	ETF	27.0	27.349	26.924	27.3412	10047.0
2011-12-09	AGEM	ETF	21.54	21.71	21.54	21.71	4881.0
2011-12-09	AGG	ETF	109.43	109.58	109.26	109.39	934900.0
2011-12-09	AGQ	ETF	227.32	233.48	225.72	231.16	341200.0
2011-12-09	AGZ	ETF	112.486	112.804	112.4523	112.655	12302.0
2011-12-09	AIA	ETF	40.28	40.7688	40.27	40.69	30896.0
2011-12-09	AIQ	ETF	5.6	5.65	5.5	5.6	16941.0
2011-12-09	AIS	ETF	2.56	2.69	2.53	2.68	1314533.0
2011-12-09	AIVI	ETF	39.95	40.5	39.94	40.44	138000.0
2011-12-09	AMJ	ETF	37.25	37.51	37.0	37.42	576509.0
2011-12-09	AMLP	ETF	80.9	80.95	80.35	80.8	220840.0
2011-12-09	AOA	ETF	33.04	33.33	33.03	33.33	4800.0
2011-12-09	AOK	ETF	29.25	29.32	29.25	29.31	96527.0
2011-12-09	AOM	ETF	29.84	30.0112	29.84	29.99	22089.0
2011-12-09	AOR	ETF	31.01	31.35	31.01	31.3384	38623.0
2011-12-09	ARB	ETF	36.49	37.74	36.47	37.14	218058.0
2011-12-09	ARGT	ETF	22.82	22.82	22.82	22.82	100.0
2011-12-09	ASEA	ETF	14.8	14.92	14.68	14.79	7200.0
2011-12-09	AWAY	ETF	25.73	26.3	25.07	25.11	256573.0
2011-12-09	BAB	ETF	28.81	28.81	28.18	28.251	259720.0
2011-12-09	BAL	ETF	56.39	56.42	55.6	55.97	19066.0
2011-12-09	BALT	ETF	4.82	5.12	4.82	5.1	64882.0
2011-12-09	BBH	ETF	34.6067	35.1167	34.6067	35.07	40800.0
2011-12-09	BCM	ETF	43.91	44.029	43.6465	43.7701	5272.0
2011-12-09	BIB	ETF	8.135	8.2425	8.135	8.194	4144.0
2011-12-09	BICK	ETF	23.95	24.68	23.95	24.49	83344.0
2011-12-09	BIL	ETF	91.66	91.68	91.66	91.66	199800.0
2011-12-09	BIS	ETF	5683.2	5683.2	5683.2	5683.2	1.25
2011-12-09	BITS	ETF	21.52	21.6	21.2	21.6	2575.0
2011-12-09	BIV	ETF	87.52	87.52	87.0	87.08	384800.0
2011-12-09	BJK	ETF	30.57	30.88	30.52	30.82	11500.0
2011-12-09	BKF	ETF	37.42	38.09	37.42	37.89	125210.0
2011-12-09	BKLN	ETF	23.86	23.93	23.69	23.91	81000.0
2011-12-09	BLNG	ETF	52.0799	52.0799	52.0799	52.0799	200.0
2011-12-09	BLV	ETF	90.88	90.88	89.78	89.78	35700.0
2011-12-09	BMVP	ETF	13.42	13.65	13.42	13.63	4100.0
2011-12-09	BND	ETF	83.57	83.68	83.37	83.4	1187600.0

> showing 50 of 887 rows — these rows as CSV

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