PREVIEW / etf_daily / 2016-01-06

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-06.parquet
  size:    50 KB
  rows:    1,244

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
2016-01-06	SPY	ETF	198.34	200.06	197.6	198.82	152112600.0
2016-01-06	QQQ	ETF	107.43	108.89	107.41	108.26	41891091.0
2016-01-06	IWM	ETF	108.7	109.6	108.0	108.57	35569200.0
2016-01-06	DIA	ETF	168.92	169.97	168.01	168.94	8713600.0
2016-01-06	GLD	ETF	104.37	104.8	103.93	104.67	9316600.0
2016-01-06	TLT	ETF	122.3	122.62	122.05	122.59	8916900.0
2016-01-06	AADR	ETF	37.48	37.48	36.93	37.14	1300.0
2016-01-06	AAXJ	ETF	51.02	51.27	50.81	50.94	1022500.0
2016-01-06	ACTX	ETF	7.0801	8.2601	7.0801	7.6701	1518.0
2016-01-06	ACWI	ETF	53.95	54.3	53.76	54.05	4615000.0
2016-01-06	ACWV	ETF	67.81	68.36	67.81	68.2	54800.0
2016-01-06	ACWX	ETF	38.05	38.23	37.91	38.0899	894470.0
2016-01-06	ADRE	ETF	27.86	28.0	27.52	27.8	7353.0
2016-01-06	AFK	ETF	17.45	17.54	17.26	17.3766	19097.0
2016-01-06	AFTY	ETF	13.352	13.365	13.3	13.34	5300.0
2016-01-06	AGG	ETF	108.34	108.46	108.22	108.43	2915800.0
2016-01-06	AGGY	ETF	49.225	49.225	49.225	49.225	100.0
2016-01-06	AGQ	ETF	27.76	28.33	27.45	27.79	120700.0
2016-01-06	AGZ	ETF	113.2054	113.35	112.76	113.26	86188.0
2016-01-06	AGZD	ETF	24.035	24.035	23.945	24.025	2600.0
2016-01-06	AIA	ETF	40.19	40.35	40.04	40.205	27354.0
2016-01-06	AIQ	ETF	8.97	8.97	8.33	8.8	18315.0
2016-01-06	AIRR	ETF	15.94	16.127	15.94	15.99	150200.0
2016-01-06	AIVI	ETF	36.62	36.86	36.52	36.76	15700.0
2016-01-06	ALTY	ETF	13.82	13.87	13.76	13.76	1000.0
2016-01-06	AMJ	ETF	28.62	28.8	27.4989	27.78	5791760.0
2016-01-06	AMLP	ETF	59.0	59.6	56.05	56.95	3811440.0
2016-01-06	AMZA	ETF	105.3	106.0	98.5	100.1	7680.0
2016-01-06	ANGL	ETF	24.36	24.39	24.26	24.38	23200.0
2016-01-06	AOA	ETF	43.9	43.99	43.67	43.8	69500.0
2016-01-06	AOK	ETF	31.26	31.452	31.26	31.44	84523.0
2016-01-06	AOM	ETF	33.66	33.79	33.66	33.73	1320247.0
2016-01-06	AOR	ETF	38.11	38.2822	38.08	38.21	85179.0
2016-01-06	ARGT	ETF	17.54	17.55	17.37	17.52	9400.0
2016-01-06	ARKG	ETF	20.05	20.05	19.605	19.605	300.0
2016-01-06	ARKK	ETF	19.83	19.83	19.83	19.83	200.0
2016-01-06	ARKQ	ETF	18.86	18.86	18.49	18.51	400.0
2016-01-06	ARKW	ETF	22.39	22.405	22.32	22.32	1800.0
2016-01-06	ASEA	ETF	11.78	11.78	11.65	11.66	2000.0
2016-01-06	ASET	ETF	23.87	23.87	23.85	23.85	309.0
2016-01-06	ASHR	ETF	25.79	25.99	25.68	25.75	1144600.0
2016-01-06	ASHS	ETF	37.8	38.12	37.5	37.57	98800.0
2016-01-06	ASHX	ETF	24.0	24.0499	24.0	24.0	1800.0
2016-01-06	ATMP	ETF	18.64	18.71	17.98	18.13	305900.0
2016-01-06	BAB	ETF	29.3	29.46	29.3	29.44	113943.0
2016-01-06	BAL	ETF	41.295	41.295	41.0285	41.17	2185.0
2016-01-06	BBC	ETF	27.09	27.09	25.46	25.9	26544.0
2016-01-06	BBH	ETF	121.78	123.53	120.99	122.23	72700.0
2016-01-06	BBP	ETF	29.12	29.29	28.59	28.923	11800.0
2016-01-06	BCM	ETF	23.23	23.23	23.1	23.1	2146.0

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

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