PREVIEW / etf_daily / 2014-10-10

all etf daily files

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

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-10	SPY	ETF	192.69	193.65	190.49	190.54	221909000.0
2014-10-10	QQQ	ETF	96.29	96.83	94.42	94.44	77579425.0
2014-10-10	IWM	ETF	105.77	106.89	104.59	104.74	66579500.0
2014-10-10	DIA	ETF	166.39	167.36	165.21	165.21	12717500.0
2014-10-10	GLD	ETF	117.7	117.74	117.19	117.59	4651400.0
2014-10-10	TLT	ETF	119.52	120.08	119.31	120.05	8774400.0
2014-10-10	AADR	ETF	35.32	35.32	35.17	35.19	900.0
2014-10-10	AAXJ	ETF	60.31	60.54	59.79	59.98	1259900.0
2014-10-10	ACWI	ETF	57.14	57.32	56.4	56.4	1409200.0
2014-10-10	ACWV	ETF	66.1	66.54	65.88	65.88	39500.0
2014-10-10	ACWX	ETF	43.64	43.69	43.1	43.13	2243756.0
2014-10-10	ADRE	ETF	39.4	39.4	38.5	38.5	15088.0
2014-10-10	AFK	ETF	30.28	30.28	29.69	29.87	25153.0
2014-10-10	AGG	ETF	109.96	110.03	109.87	109.99	1734400.0
2014-10-10	AGQ	ETF	47.5	47.87	47.05	47.63	93900.0
2014-10-10	AGZ	ETF	113.01	113.19	112.91	113.06	5243.0
2014-10-10	AGZD	ETF	24.77	24.855	24.725	24.845	9400.0
2014-10-10	AIA	ETF	45.94	46.02	45.4901	45.59	25535.0
2014-10-10	AIQ	ETF	21.91	22.885	21.6	21.74	35735.0
2014-10-10	AIRR	ETF	17.33	17.48	17.19	17.2	40300.0
2014-10-10	AIVI	ETF	44.46	44.46	43.92	43.93	198900.0
2014-10-10	ALTL	ETF	34.25	34.4	34.25	34.37	1499.0
2014-10-10	AMJ	ETF	49.35	49.66	46.4	48.71	5453871.0
2014-10-10	AMLP	ETF	91.35	91.75	87.9	90.65	1894660.0
2014-10-10	AMZA	ETF	237.9	237.9	229.6	233.1	2570.0
2014-10-10	ANGL	ETF	27.58	27.58	27.51	27.55	2000.0
2014-10-10	AOA	ETF	44.43	44.43	43.92	43.92	28600.0
2014-10-10	AOK	ETF	32.15	32.17	32.06	32.06	77238.0
2014-10-10	AOM	ETF	34.39	34.48	34.23	34.25	38236.0
2014-10-10	AOR	ETF	38.79	38.816	38.46	38.46	26187.0
2014-10-10	ARGT	ETF	19.5	19.5	19.03	19.11	78000.0
2014-10-10	ARKQ	ETF	19.12	19.12	18.67	18.67	4300.0
2014-10-10	ARKW	ETF	19.59	19.59	18.949	18.949	3300.0
2014-10-10	ASEA	ETF	16.39	16.42	16.29	16.29	5000.0
2014-10-10	ASHR	ETF	25.84	25.84	25.62	25.64	414400.0
2014-10-10	ASHS	ETF	33.8	33.9	33.76	33.77	3600.0
2014-10-10	ATMP	ETF	30.45	30.45	29.08	29.92	77100.0
2014-10-10	AVIV	ETF	27.69	28.2	27.64	27.67	247184.0
2014-10-10	AWAY	ETF	34.17	34.77	33.78	34.19	1124123.0
2014-10-10	BAB	ETF	30.03	30.0599	29.949	30.04	75458.0
2014-10-10	BAL	ETF	43.19	43.8	42.7996	42.82	15232.0
2014-10-10	BALT	ETF	3.25	3.28	3.1	3.18	886280.0
2014-10-10	BAR	ETF	3.128	3.135	3.1	3.123	38780.0
2014-10-10	BBH	ETF	102.84	104.6	101.29	101.3	104900.0
2014-10-10	BCHP	ETF	17.822	17.822	17.6701	17.691	571.0
2014-10-10	BCM	ETF	36.16	36.18	36.16	36.18	1828.0
2014-10-10	BFOR	ETF	7.2975	7.3125	7.185	7.185	243600.0
2014-10-10	BIB	ETF	49.0	50.945	47.645	47.645	961912.0
2014-10-10	BICK	ETF	24.45	24.76	24.45	24.45	3003.0
2014-10-10	BIL	ETF	91.48	91.5	91.48	91.5	581100.0

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

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