PREVIEW / etf_daily / 2013-08-13

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-13.parquet
  size:    41 KB
  rows:    1,002

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
2013-08-13	SPY	ETF	169.41	169.9	168.41	169.61	80806000.0
2013-08-13	QQQ	ETF	76.77	77.27	76.22	77.1	23916974.0
2013-08-13	IWM	ETF	104.68	104.68	103.78	104.45	22812900.0
2013-08-13	DIA	ETF	154.42	154.97	153.34	154.44	4752500.0
2013-08-13	GLD	ETF	128.49	128.65	127.38	127.74	7336100.0
2013-08-13	TLT	ETF	105.33	105.36	104.8	104.99	11485600.0
2013-08-13	AADR	ETF	34.33	34.37	34.33	34.35	11900.0
2013-08-13	AAXJ	ETF	56.98	57.1	56.68	56.93	287900.0
2013-08-13	ACTV	ETF	9.93	10.18	9.81	10.1	402484.0
2013-08-13	ACWI	ETF	53.15	53.23	52.78	53.21	1433300.0
2013-08-13	ACWV	ETF	62.22	62.25	61.88	62.07	53700.0
2013-08-13	ACWX	ETF	43.48	43.76	43.37	43.72	489564.0
2013-08-13	ADRE	ETF	36.01	36.15	35.9	36.14	15281.0
2013-08-13	AFK	ETF	29.9	29.99	29.64	29.65	23304.0
2013-08-13	AGG	ETF	106.68	106.75	106.52	106.65	525100.0
2013-08-13	AGQ	ETF	80.76	80.92	79.2	80.6	550175.0
2013-08-13	AGZ	ETF	111.27	111.27	110.91	110.95	14813.0
2013-08-13	AIA	ETF	44.69	44.932	44.62	44.78	11724.0
2013-08-13	AIQ	ETF	25.41	25.44	24.6335	24.8	113925.0
2013-08-13	AIVI	ETF	43.41	43.65	43.25	43.63	26100.0
2013-08-13	AMJ	ETF	46.77	46.9499	45.65	45.85	719870.0
2013-08-13	AMLP	ETF	87.6	87.6	86.45	86.95	421320.0
2013-08-13	ANGL	ETF	26.4	26.5	26.34	26.34	2100.0
2013-08-13	AOA	ETF	41.7	42.28	41.5	41.71	61400.0
2013-08-13	AOK	ETF	31.19	31.23	31.14	31.21	26017.0
2013-08-13	AOM	ETF	33.13	33.1611	33.032	33.12	25812.0
2013-08-13	AOR	ETF	36.62	36.64	36.48	36.63	30966.0
2013-08-13	ARB	ETF	46.32	46.335	46.03	46.03	270407.0
2013-08-13	ARGT	ETF	18.7	19.01	18.7	19.0	7000.0
2013-08-13	ASEA	ETF	17.05	17.12	17.04	17.1	13600.0
2013-08-13	ATMP	ETF	26.18	26.28	26.14	26.14	68000.0
2013-08-13	AVIV	ETF	24.85	24.85	24.14	24.2	48070.0
2013-08-13	AWAY	ETF	30.72	30.98	30.35	30.85	661816.0
2013-08-13	BAB	ETF	27.74	27.74	27.47	27.535	183995.0
2013-08-13	BAL	ETF	58.3	59.37	58.2	58.73	14977.0
2013-08-13	BALT	ETF	3.83	3.95	3.81	3.83	76715.0
2013-08-13	BBH	ETF	77.61	77.82	76.7	77.5	77500.0
2013-08-13	BCM	ETF	40.364	40.364	40.2401	40.302	1010.0
2013-08-13	BFOR	ETF	6.68	6.6825	6.625	6.6775	109600.0
2013-08-13	BIB	ETF	28.075	28.34	27.5825	28.065	86940.0
2013-08-13	BICK	ETF	22.3	22.35	22.28	22.35	1077.0
2013-08-13	BIL	ETF	91.6	91.6	91.58	91.6	60500.0
2013-08-13	BIS	ETF	1234.72	1234.72	1209.6	1209.6	53.0
2013-08-13	BIV	ETF	83.12	83.12	82.83	82.92	182100.0
2013-08-13	BIZD	ETF	20.1	20.17	20.0	20.14	5000.0
2013-08-13	BJK	ETF	43.06	43.35	42.98	43.3	42600.0
2013-08-13	BKF	ETF	35.7	35.9	35.6375	35.77	190174.0
2013-08-13	BKLN	ETF	24.88	24.89	24.86	24.88	2824400.0
2013-08-13	BLV	ETF	82.89	82.89	82.4	82.66	34900.0
2013-08-13	BMVP	ETF	19.98	20.11	19.98	20.1	11582.0

> showing 50 of 1,002 rows — these rows as CSV

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