PREVIEW / etf_daily / 2010-12-03

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-03.parquet
  size:    34 KB
  rows:    808

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
2010-12-03	SPY	ETF	122.14	123.03	122.11	122.89	151288900.0
2010-12-03	QQQ	ETF	53.5	53.94	53.5	53.87	38014163.0
2010-12-03	IWM	ETF	74.83	75.9	74.76	75.67	36549400.0
2010-12-03	DIA	ETF	113.34	114.02	113.31	113.94	4550500.0
2010-12-03	GLD	ETF	136.62	138.11	136.48	138.07	16517200.0
2010-12-03	TLT	ETF	96.28	96.33	94.85	94.89	10194800.0
2010-12-03	AADR	ETF	29.16	29.25	29.16	29.21	4500.0
2010-12-03	AAXJ	ETF	63.19	63.78	63.0	63.7	1043300.0
2010-12-03	ACWI	ETF	45.68	46.01	45.59	45.99	240800.0
2010-12-03	ACWX	ETF	43.24	43.59	43.185	43.56	67548.0
2010-12-03	ADRE	ETF	46.44	47.12	46.44	47.07	62431.0
2010-12-03	AFK	ETF	33.69	33.96	33.63	33.96	22473.0
2010-12-03	AGG	ETF	106.44	106.5	106.12	106.26	660000.0
2010-12-03	AGQ	ETF	283.72	292.0	282.3	289.14	646000.0
2010-12-03	AGZ	ETF	110.53	110.57	110.335	110.39	16460.0
2010-12-03	AIA	ETF	45.63	46.1	45.63	46.1	12208.0
2010-12-03	AIQ	ETF	18.0	18.95	17.55	18.9	22962.0
2010-12-03	AIS	ETF	1.43	1.46	1.42	1.46	194002.0
2010-12-03	AIVI	ETF	42.98	43.42	42.98	43.33	273500.0
2010-12-03	AMJ	ETF	35.68	35.76	35.64	35.74	721883.0
2010-12-03	AMLP	ETF	79.35	79.35	79.2	79.3	97640.0
2010-12-03	AOA	ETF	33.45	33.8	33.45	33.8	12100.0
2010-12-03	AOK	ETF	28.57	28.65	28.57	28.63	14204.0
2010-12-03	AOM	ETF	29.73	29.81	29.72	29.81	23972.0
2010-12-03	AOR	ETF	31.14	31.22	31.09	31.22	14209.0
2010-12-03	ARB	ETF	29.83	30.64	29.68	30.51	149892.0
2010-12-03	BAB	ETF	25.22	25.38	25.14	25.16	198862.0
2010-12-03	BAL	ETF	67.01	67.95	66.96	67.625	67509.0
2010-12-03	BALT	ETF	11.59	11.76	11.57	11.64	118980.0
2010-12-03	BBH	ETF	33.13	33.13	32.9333	33.0467	20100.0
2010-12-03	BICK	ETF	32.57	32.79	32.51	32.79	38967.0
2010-12-03	BIL	ETF	91.7	91.72	91.7	91.72	320300.0
2010-12-03	BIS	ETF	8988.8	8990.4	8967.04	8967.04	3.75
2010-12-03	BITS	ETF	28.08	28.6	28.0	28.6	4922.0
2010-12-03	BIV	ETF	84.71	84.77	84.19	84.32	250800.0
2010-12-03	BJK	ETF	31.75	31.99	31.7	31.95	5000.0
2010-12-03	BKF	ETF	49.32	49.839	49.26	49.82	124047.0
2010-12-03	BLV	ETF	80.81	80.81	79.78	79.86	68000.0
2010-12-03	BMVP	ETF	14.487	14.617	14.487	14.594	28757.0
2010-12-03	BND	ETF	81.37	81.45	81.18	81.25	569200.0
2010-12-03	BNO	ETF	30.21	30.48	30.21	30.48	800.0
2010-12-03	BRF	ETF	60.54	61.2	60.18	61.2	221290.0
2010-12-03	BSCE	ETF	20.7766	20.81	20.768	20.803	55027.0
2010-12-03	BSV	ETF	81.16	81.26	81.09	81.22	701800.0
2010-12-03	BTF	ETF	78.75	78.884	78.25	78.44999999999999	2250.0
2010-12-03	BWX	ETF	28.97	29.13	28.9525	29.0975	312464.0
2010-12-03	BWZ	ETF	36.87	37.0912	36.71	37.018	13370.0
2010-12-03	BZQ	ETF	2630.4	2641.6	2544.0	2561.6	542.5
2010-12-03	CEF	ETF	19.79	20.08	19.77	20.02	1410300.0
2010-12-03	CEW	ETF	22.97	23.07	22.97	23.07	221845.0

> showing 50 of 808 rows — these rows as CSV

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