PREVIEW / etf_daily / 2014-10-01

all etf daily files

  file:    by_date/etf_daily/2014/2014-10-01.parquet
  size:    46 KB
  rows:    1,130

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
2014-10-01	SPY	ETF	196.7	196.77	193.91	194.35	177798000.0
2014-10-01	QQQ	ETF	98.54	98.61	96.9	97.21	58164861.0
2014-10-01	IWM	ETF	109.29	109.39	107.43	107.8	88621100.0
2014-10-01	DIA	ETF	169.91	169.98	167.42	167.68	11030600.0
2014-10-01	GLD	ETF	116.61	117.26	116.59	116.77	7018800.0
2014-10-01	TLT	ETF	116.89	118.26	116.83	118.23	17194900.0
2014-10-01	AADR	ETF	36.97	36.97	36.83	36.83	3100.0
2014-10-01	AAXJ	ETF	61.09	61.16	60.33	60.33	575100.0
2014-10-01	ACWI	ETF	58.72	58.76	58.0	58.13	1328100.0
2014-10-01	ACWV	ETF	66.53	66.54	66.0	66.16	148100.0
2014-10-01	ACWX	ETF	45.23	45.271	44.82	44.88	380019.0
2014-10-01	ADRE	ETF	38.88	38.92	38.2	38.24	46836.0
2014-10-01	AFK	ETF	31.26	31.3	31.012	31.02	48552.0
2014-10-01	AGG	ETF	109.2	109.54	109.2	109.53	6605200.0
2014-10-01	AGQ	ETF	46.6	48.2	46.43	46.86	375000.0
2014-10-01	AGZ	ETF	112.34	112.6997	112.236	112.46	27059.0
2014-10-01	AGZD	ETF	24.84	24.84	24.765	24.83	10800.0
2014-10-01	AIA	ETF	46.41	46.41	45.845	45.876	45720.0
2014-10-01	AIQ	ETF	22.71	22.71	21.5	21.83	19787.0
2014-10-01	AIRR	ETF	18.09	18.25	18.01	18.05	270100.0
2014-10-01	AIVI	ETF	46.53	46.53	46.14	46.24	46900.0
2014-10-01	AMJ	ETF	53.15	53.47	52.22	52.25	1691067.0
2014-10-01	AMLP	ETF	95.9	96.35	94.8	94.9	787040.0
2014-10-01	ANGL	ETF	27.85	27.85	27.53	27.53	600.0
2014-10-01	AOA	ETF	45.79	45.79	45.02	45.11	65300.0
2014-10-01	AOK	ETF	32.41	32.44	32.342	32.38	39776.0
2014-10-01	AOM	ETF	34.98	34.98	34.7	34.75	59121.0
2014-10-01	AOR	ETF	39.69	39.69	39.12	39.15	57610.0
2014-10-01	ARGT	ETF	21.0	21.08	20.65	20.68	39800.0
2014-10-01	ARKQ	ETF	19.57	19.57	19.456	19.456	8600.0
2014-10-01	ARKW	ETF	19.65	19.66	19.551	19.551	8100.0
2014-10-01	ASEA	ETF	16.7	16.72	16.62	16.62	4300.0
2014-10-01	ASHR	ETF	25.77	25.77	25.46	25.54	590400.0
2014-10-01	ASHS	ETF	33.1	33.48	33.1	33.36	9200.0
2014-10-01	ATMP	ETF	32.36	32.51	31.92	31.96	39300.0
2014-10-01	AVIV	ETF	26.36	26.71	26.2	26.29	393644.0
2014-10-01	AWAY	ETF	35.48	35.49	34.68	34.88	1493092.0
2014-10-01	BAB	ETF	29.7	29.83	29.59	29.82	135880.0
2014-10-01	BAL	ETF	41.19	41.64	41.13	41.19	16083.0
2014-10-01	BALT	ETF	4.15	4.2	3.76	3.87	1347058.0
2014-10-01	BAR	ETF	3.075	3.075	3.074	3.074	16260.0
2014-10-01	BBH	ETF	105.84	105.84	103.55	104.31	144300.0
2014-10-01	BCHP	ETF	18.8399	18.8399	18.82	18.82	565.0
2014-10-01	BFOR	ETF	7.5475	7.5475	7.41	7.4225	400800.0
2014-10-01	BIB	ETF	51.83	51.85	49.71	50.43	660400.0
2014-10-01	BICK	ETF	24.6	24.72	24.36	24.37	1609.0
2014-10-01	BIL	ETF	91.52	91.52	91.5	91.52	663450.0
2014-10-01	BIS	ETF	484.8	502.4	482.0	495.6	18950.0
2014-10-01	BIV	ETF	84.25	84.62	84.25	84.6	784900.0
2014-10-01	BIZD	ETF	19.13	19.15	18.99	19.09	46000.0

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

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