PREVIEW / etf_daily / 2011-03-18

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-18.parquet
  size:    35 KB
  rows:    829

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-03-18	SPY	ETF	128.84	128.88	127.51	127.76	230435400.0
2011-03-18	QQQ	ETF	55.2	55.22	54.41	54.45	94887135.0
2011-03-18	IWM	ETF	79.33	79.59	79.07	79.46	70017700.0
2011-03-18	DIA	ETF	118.83	119.01	118.0	118.27	10498900.0
2011-03-18	GLD	ETF	138.14	138.83	137.76	138.37	18602000.0
2011-03-18	TLT	ETF	92.75	93.48	92.69	93.46	7260900.0
2011-03-18	AADR	ETF	29.19	29.19	29.19	29.19	200.0
2011-03-18	AAXJ	ETF	59.69	59.69	59.07	59.16	162000.0
2011-03-18	ACWI	ETF	46.6	46.81	46.4	46.59	552400.0
2011-03-18	ACWX	ETF	43.67	43.7	43.3874	43.56	219289.0
2011-03-18	ADRE	ETF	45.82	45.9	45.44	45.48	47438.0
2011-03-18	AFK	ETF	31.71	31.94	31.32	31.34	15910.0
2011-03-18	AGG	ETF	105.81	105.96	105.73	105.92	382900.0
2011-03-18	AGQ	ETF	388.92	396.22	387.64	392.54	354550.0
2011-03-18	AGZ	ETF	110.22	110.22	109.74	109.84	27864.0
2011-03-18	AIA	ETF	44.74	44.84	44.53	44.59	43931.0
2011-03-18	AIQ	ETF	19.9	20.15	19.55	19.9	40697.0
2011-03-18	AIS	ETF	1.56	1.63	1.56	1.62	422020.0
2011-03-18	AIVI	ETF	45.07	45.26	44.82	44.9	13900.0
2011-03-18	AMJ	ETF	36.97	37.07	36.65	36.68	555313.0
2011-03-18	AMLP	ETF	80.55	80.9	80.05	80.1	127140.0
2011-03-18	AOA	ETF	34.88	34.94	34.7	34.7	8900.0
2011-03-18	AOK	ETF	29.07	29.09	29.0312	29.06	10151.0
2011-03-18	AOM	ETF	30.29	30.29	30.1764	30.24	19410.0
2011-03-18	AOR	ETF	31.97	31.99	31.8972	31.93	4986.0
2011-03-18	ARB	ETF	35.95	35.97	35.5	35.84	280775.0
2011-03-18	ARGT	ETF	29.42	29.42	28.84	28.84	1700.0
2011-03-18	ASEA	ETF	15.04	15.04	14.98	14.98	1700.0
2011-03-18	BAB	ETF	25.34	25.44	25.28	25.44	93617.0
2011-03-18	BAL	ETF	102.33	104.48	101.5	104.01	408535.0
2011-03-18	BALT	ETF	8.98	8.98	8.63	8.86	191589.0
2011-03-18	BBH	ETF	34.5633	34.7	34.3367	34.4067	43500.0
2011-03-18	BICK	ETF	31.06	31.19	30.981	30.981	18254.0
2011-03-18	BIL	ETF	91.72	91.74	91.72	91.74	222750.0
2011-03-18	BIS	ETF	7864.0	7864.0	7848.0	7848.0	16.9
2011-03-18	BITS	ETF	25.0	25.0	24.16	24.92	4822.0
2011-03-18	BIV	ETF	83.06	83.32	83.06	83.25	50900.0
2011-03-18	BJK	ETF	30.43	30.49	30.24	30.27	7300.0
2011-03-18	BKF	ETF	47.04	47.25	46.89	46.941	318387.0
2011-03-18	BKLN	ETF	24.71	24.84	24.67	24.83	94500.0
2011-03-18	BLV	ETF	78.9	79.16	78.61	79.1	19600.0
2011-03-18	BMVP	ETF	14.997	15.007	14.878	14.88	5852.0
2011-03-18	BND	ETF	80.58	80.72	80.54	80.71	533600.0
2011-03-18	BNO	ETF	37.79	38.155	37.575	37.95	516800.0
2011-03-18	BRF	ETF	52.17	52.226	51.85	51.94	128214.0
2011-03-18	BSCE	ETF	20.9699	21.03	20.9175	20.9572	19630.0
2011-03-18	BSV	ETF	80.73	80.73	80.62	80.71	476300.0
2011-03-18	BTF	ETF	82.89949999999999	83.85	82.89949999999999	83.85	3699.4
2011-03-18	BWX	ETF	30.22	30.3	30.14	30.25	273226.0
2011-03-18	BWZ	ETF	38.48	38.91	38.4001	38.54	12468.0

> showing 50 of 829 rows — these rows as CSV

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