PREVIEW / etf_daily / 2017-12-01

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-01.parquet
  size:    59 KB
  rows:    1,521

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
2017-12-01	SPY	ETF	264.76	265.31	260.76	264.46	164390900.0
2017-12-01	QQQ	ETF	154.19	155.24	152.26	154.49	59015828.0
2017-12-01	IWM	ETF	153.02	153.71	148.75	153.02	62734800.0
2017-12-01	DIA	ETF	243.14	243.44	239.41	242.45	9772700.0
2017-12-01	GLD	ETF	120.94	122.43	120.74	121.59	13080100.0
2017-12-01	TLT	ETF	125.87	127.69	125.1	126.55	24583100.0
2017-12-01	AADR	ETF	55.68	55.81	55.26	55.56	27100.0
2017-12-01	AAXJ	ETF	75.31	75.52	74.77	75.13	1541800.0
2017-12-01	ACSI	ETF	30.64	30.92	30.5352	30.82	2457.0
2017-12-01	ACTX	ETF	70.2106	74.6357	64.9006	72.5707	812.0
2017-12-01	ACWF	ETF	34.07	34.07	30.3	30.4374	5164.0
2017-12-01	ACWI	ETF	71.61	71.66	70.8	71.54	6765100.0
2017-12-01	ACWV	ETF	84.39	84.56	83.63	84.42	99800.0
2017-12-01	ACWX	ETF	49.33	49.49	49.11	49.39	599593.0
2017-12-01	ADRE	ETF	42.14	42.29	41.86	42.1409	127653.0
2017-12-01	AFK	ETF	24.42	24.42	24.2648	24.2648	2150.0
2017-12-01	AFTY	ETF	18.12	18.126	18.051	18.12	3900.0
2017-12-01	AGG	ETF	109.02	109.48	108.85	109.16	3410200.0
2017-12-01	AGGY	ETF	50.6	50.78	50.497	50.63	70100.0
2017-12-01	AGNG	ETF	19.77	19.795	19.61	19.795	1900.0
2017-12-01	AGQ	ETF	31.57	32.5	31.27	32.05	287700.0
2017-12-01	AGZ	ETF	113.16	113.48	113.1219	113.3	19538.0
2017-12-01	AGZD	ETF	24.14	24.14	24.125	24.125	5800.0
2017-12-01	AIA	ETF	65.3	65.3	64.66	65.12	802554.0
2017-12-01	AIEQ	ETF	25.6	25.604	24.9	25.5	214000.0
2017-12-01	AIRR	ETF	27.0	27.032	26.228	26.94	12400.0
2017-12-01	AIVI	ETF	43.34	43.37	43.25	43.33	9100.0
2017-12-01	ALTY	ETF	15.31	15.31	15.25	15.25	6500.0
2017-12-01	AMJ	ETF	26.4	26.79	26.305	26.62	4619636.0
2017-12-01	AMLP	ETF	52.15	53.05	51.9	52.6	4310200.0
2017-12-01	AMUB	ETF	16.735	16.735	16.735	16.735	152.0
2017-12-01	AMZA	ETF	82.0	83.8	81.9	83.1	180750.0
2017-12-01	ANGL	ETF	30.0	30.0	29.85	29.97	733900.0
2017-12-01	AOA	ETF	55.17	55.24	54.8	55.16	70000.0
2017-12-01	AOK	ETF	34.83	34.87	34.79	34.8	756712.0
2017-12-01	AOM	ETF	38.33	38.5	38.25	38.48	142236.0
2017-12-01	AOR	ETF	45.79	45.8669	45.54	45.74	85565.0
2017-12-01	ARCM	ETF	100.24	100.24	100.24	100.24	600.0
2017-12-01	ARGT	ETF	32.31	32.64	32.31	32.39	43600.0
2017-12-01	ARKG	ETF	25.82	26.1	25.07	25.98	37200.0
2017-12-01	ARKK	ETF	37.25	37.65	36.5	37.4	267200.0
2017-12-01	ARKQ	ETF	34.09	34.09	33.21	33.84	49200.0
2017-12-01	ARKW	ETF	45.33	45.69	44.661	45.32	162100.0
2017-12-01	ASEA	ETF	17.06	17.06	16.57	16.57	3400.0
2017-12-01	ASET	ETF	28.65	28.6999	28.594	28.68	3690.0
2017-12-01	ASHR	ETF	30.43	30.43	30.15	30.24	1019100.0
2017-12-01	ASHS	ETF	34.54	34.54	34.37	34.51	4200.0
2017-12-01	ASHX	ETF	22.34	22.34	22.34	22.34	1000.0
2017-12-01	ATMP	ETF	19.75	20.23	19.75	20.09	106900.0
2017-12-01	BAB	ETF	30.51	30.78	30.4	30.56	121389.0

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

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