PREVIEW / etf_daily / 2013-09-18

all etf daily files

  file:    by_date/etf_daily/2013/2013-09-18.parquet
  size:    42 KB
  rows:    1,026

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-09-18	SPY	ETF	171.01	173.52	170.58	173.05	203460600.0
2013-09-18	QQQ	ETF	78.49	79.47	78.33	79.31	31714662.0
2013-09-18	IWM	ETF	106.05	107.61	105.26	107.09	46237100.0
2013-09-18	DIA	ETF	155.16	157.06	154.65	156.69	9637300.0
2013-09-18	GLD	ETF	125.32	132.16	125.15	132.01	24780000.0
2013-09-18	TLT	ETF	103.63	105.55	102.98	104.99	19749200.0
2013-09-18	AADR	ETF	35.17	36.02	35.17	35.76	33500.0
2013-09-18	AAXJ	ETF	59.03	61.4	58.84	61.19	3838700.0
2013-09-18	ACTV	ETF	10.76	10.89	10.5	10.82	377177.0
2013-09-18	ACWI	ETF	54.2	55.26	53.96	55.17	1204100.0
2013-09-18	ACWV	ETF	61.81	63.14	61.8	62.93	61200.0
2013-09-18	ACWX	ETF	44.81	46.0899	44.68	46.04	215210.0
2013-09-18	ADRE	ETF	37.44	38.68	37.39	38.64	41420.0
2013-09-18	AFK	ETF	29.58	30.0	29.13	30.0	91782.0
2013-09-18	AGEM	ETF	22.5	23.5	22.5	23.32	18747.0
2013-09-18	AGG	ETF	105.93	106.99	105.8	106.9	1113400.0
2013-09-18	AGQ	ETF	79.4	92.52	77.44	91.76	1715400.0
2013-09-18	AGZ	ETF	110.47	110.7499	109.895	110.65	16346.0
2013-09-18	AIA	ETF	47.04	48.47	47.0044	48.47	80635.0
2013-09-18	AIQ	ETF	24.91	25.41	24.701	25.34	38465.0
2013-09-18	AIVI	ETF	45.24	46.32	45.02	46.26	35700.0
2013-09-18	ALTL	ETF	30.51	30.92	30.35	30.78	91550.0
2013-09-18	AMJ	ETF	43.12	43.99	42.91	43.95	3486479.0
2013-09-18	AMLP	ETF	85.25	86.9	85.15	86.85	1049340.0
2013-09-18	ANGL	ETF	26.41	26.52	26.39	26.52	2300.0
2013-09-18	AOA	ETF	42.12	42.81	42.03	42.74	23300.0
2013-09-18	AOK	ETF	31.29	31.5778	31.2339	31.5778	8163.0
2013-09-18	AOM	ETF	33.27	33.6999	32.98	33.62	38553.0
2013-09-18	AOR	ETF	36.84	37.39	36.7901	37.36	29431.0
2013-09-18	ARB	ETF	47.5	47.52	47.42	47.48	126255.0
2013-09-18	ARGT	ETF	19.45	20.2	19.28	20.2	3100.0
2013-09-18	ASEA	ETF	16.68	17.46	16.62	17.45	24700.0
2013-09-18	ATMP	ETF	25.27	25.79	25.23	25.79	11000.0
2013-09-18	AVIV	ETF	22.53	23.37	22.39	23.32	268616.0
2013-09-18	AWAY	ETF	31.8	32.47	31.3	32.35	666715.0
2013-09-18	BAB	ETF	26.93	27.2515	26.83	27.22	134828.0
2013-09-18	BAL	ETF	54.24	54.93	54.226	54.93	3783.0
2013-09-18	BALT	ETF	5.26	5.32	5.07	5.08	731226.0
2013-09-18	BBH	ETF	83.15	84.22	82.79	84.05	67200.0
2013-09-18	BCM	ETF	41.0501	41.051	41.04	41.051	2919.0
2013-09-18	BFOR	ETF	6.7975	6.8625	6.76	6.8525	273600.0
2013-09-18	BIB	ETF	32.735	33.505	32.375	33.3325	175448.0
2013-09-18	BICK	ETF	24.0	24.5396	24.0	24.5396	1557.0
2013-09-18	BIL	ETF	91.58	91.6	91.58	91.6	295750.0
2013-09-18	BIS	ETF	1030.0	1032.4	1003.68	1008.8	300.0
2013-09-18	BIV	ETF	82.15	83.19	81.91	82.99	209200.0
2013-09-18	BIZD	ETF	20.58	20.8	20.37	20.8	18100.0
2013-09-18	BJK	ETF	46.68	47.96	46.57	47.81	4200.0
2013-09-18	BKF	ETF	37.62	39.04	37.52	38.96	171808.0
2013-09-18	BKLN	ETF	24.79	24.83	24.75	24.8	5720400.0

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

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