PREVIEW / etf_daily / 2011-04-12

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-12.parquet
  size:    36 KB
  rows:    838

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-04-12	SPY	ETF	131.72	131.98	130.99	131.47	161187400.0
2011-04-12	QQQ	ETF	56.52	56.64	56.15	56.37	50642854.0
2011-04-12	IWM	ETF	82.79	83.05	82.05	82.14	58103300.0
2011-04-12	DIA	ETF	122.92	123.1	122.17	122.46	5161400.0
2011-04-12	GLD	ETF	142.74	142.82	140.75	141.61	14948100.0
2011-04-12	TLT	ETF	90.61	91.24	90.56	90.93	7686500.0
2011-04-12	AAXJ	ETF	63.35	63.5	62.88	63.06	278400.0
2011-04-12	ACWI	ETF	48.67	48.67	48.21	48.4	142300.0
2011-04-12	ACWX	ETF	45.92	45.92	45.441	45.58	67600.0
2011-04-12	ADRE	ETF	48.61	48.61	47.84	47.986	139257.0
2011-04-12	AFK	ETF	33.75	33.75	33.041	33.1501	13826.0
2011-04-12	AGG	ETF	104.83	105.12	104.83	105.06	563000.0
2011-04-12	AGQ	ETF	519.5	520.76	496.02	505.86	962900.0
2011-04-12	AGZ	ETF	109.27	109.42	109.22	109.35	59939.0
2011-04-12	AIA	ETF	47.9	47.93	47.491	47.57	10848.0
2011-04-12	AIQ	ETF	22.05	23.25	21.8	22.5	168338.0
2011-04-12	AIS	ETF	1.65	1.65	1.6	1.6	353224.0
2011-04-12	AIVI	ETF	48.3	48.3	47.74	47.89	3900.0
2011-04-12	AMJ	ETF	37.81	38.04	37.12	37.59	652324.0
2011-04-12	AMLP	ETF	81.95	81.95	80.8	81.65	115880.0
2011-04-12	AOA	ETF	35.79	35.9	35.67	35.79	9400.0
2011-04-12	AOK	ETF	29.12	29.18	29.12	29.18	7697.0
2011-04-12	AOM	ETF	30.54	30.55	30.45	30.52	14479.0
2011-04-12	AOR	ETF	32.51	32.51	32.3785	32.452	18541.0
2011-04-12	ARB	ETF	37.47	37.73	37.16	37.27	84321.0
2011-04-12	ARGT	ETF	30.94	30.94	30.32	30.54	5800.0
2011-04-12	ASEA	ETF	16.05	16.05	15.91	16.02	6000.0
2011-04-12	BAB	ETF	25.34	25.4	25.271	25.31	110374.0
2011-04-12	BAL	ETF	104.84	104.84	101.51	102.899	93275.0
2011-04-12	BALT	ETF	8.79	8.84	8.66	8.67	198383.0
2011-04-12	BBH	ETF	35.84	36.02	35.84	35.96	44100.0
2011-04-12	BIB	ETF	9.0638	9.0638	8.761	8.8488	59064.0
2011-04-12	BICK	ETF	33.61	33.74	33.42	33.483	15067.0
2011-04-12	BIL	ETF	91.72	91.74	91.7	91.72	61100.0
2011-04-12	BIS	ETF	6748.8	6748.8	6748.8	6748.8	1.25
2011-04-12	BITS	ETF	25.24	25.36	24.8	24.8	2225.0
2011-04-12	BIV	ETF	81.73	82.0	81.73	81.88	107900.0
2011-04-12	BJK	ETF	32.55	32.58	32.08	32.18	26700.0
2011-04-12	BKF	ETF	50.73	50.9799	50.27	50.5299	150858.0
2011-04-12	BKLN	ETF	25.27	25.32	25.27	25.28	71400.0
2011-04-12	BLV	ETF	77.6	77.96	77.52	77.63	14900.0
2011-04-12	BMVP	ETF	15.56	15.58	15.49	15.53	7228.0
2011-04-12	BND	ETF	79.77	79.95	79.77	79.91	778200.0
2011-04-12	BNO	ETF	40.78	40.815	39.745	40.02	402000.0
2011-04-12	BRF	ETF	58.02	58.3	57.07	57.22	231321.0
2011-04-12	BSCE	ETF	20.84	20.96	20.84	20.96	9921.0
2011-04-12	BSV	ETF	80.1	80.24	80.08	80.23	384900.0
2011-04-12	BTF	ETF	81.5	81.5495	80.74999999999999	81.5	3697.6000000000004
2011-04-12	BWX	ETF	30.165	30.225	30.0952	30.225	421046.0
2011-04-12	BWZ	ETF	38.65	38.99	38.65	38.98	74164.0

> showing 50 of 838 rows — these rows as CSV

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