PREVIEW / etf_daily / 2018-05-01

all etf daily files

  file:    by_date/etf_daily/2018/2018-05-01.parquet
  size:    60 KB
  rows:    1,551

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
2018-05-01	SPY	ETF	263.87	265.1	262.11	264.98	74203400.0
2018-05-01	QQQ	ETF	160.52	162.8	160.14	162.78	36513529.0
2018-05-01	IWM	ETF	153.01	154.29	151.71	154.07	24977500.0
2018-05-01	DIA	ETF	240.69	240.89	237.91	240.76	4396600.0
2018-05-01	GLD	ETF	123.9	123.98	123.39	123.71	7551600.0
2018-05-01	TLT	ETF	118.77	118.84	118.23	118.41	7979200.0
2018-05-01	AADR	ETF	58.19	58.39	57.83	58.39	35800.0
2018-05-01	AAXJ	ETF	75.93	76.15	75.19	76.09	615700.0
2018-05-01	ACSI	ETF	30.86	30.92	30.86	30.92	1174.0
2018-05-01	ACTX	ETF	59.5905	63.7206	59.5905	63.1306	505.0
2018-05-01	ACWF	ETF	30.5446	30.64	30.37	30.5285	6618.0
2018-05-01	ACWI	ETF	71.89	71.94	71.36	71.91	2009500.0
2018-05-01	ACWV	ETF	83.13	83.31	82.73	83.28	95000.0
2018-05-01	ACWX	ETF	49.93	49.93	49.46	49.8	420478.0
2018-05-01	ADRE	ETF	43.57	43.86	43.39	43.86	6442.0
2018-05-01	AFK	ETF	25.0	25.09	25.0	25.04	2811.0
2018-05-01	AGG	ETF	105.73	105.79	105.6	105.67	3027000.0
2018-05-01	AGGY	ETF	48.63	48.63	48.541	48.55	40700.0
2018-05-01	AGNG	ETF	19.551	19.63	19.551	19.63	400.0
2018-05-01	AGQ	ETF	30.5	30.56	29.8	30.26	418600.0
2018-05-01	AGZ	ETF	110.82	110.92	110.77	110.918	17195.0
2018-05-01	AGZD	ETF	24.09	24.09	24.0	24.015	42000.0
2018-05-01	AIA	ETF	67.15	67.15	66.25	67.11	126002.0
2018-05-01	AIEQ	ETF	26.44	26.629	26.26	26.62	46200.0
2018-05-01	AIRR	ETF	25.25	25.25	24.66	25.08	18600.0
2018-05-01	AIVI	ETF	44.23	44.25	43.97	44.12	8700.0
2018-05-01	ALTY	ETF	14.68	14.68	14.621	14.625	1400.0
2018-05-01	AMJ	ETF	25.87	26.13	25.85	26.04	1900109.0
2018-05-01	AMLP	ETF	50.4	50.9	50.3	50.85	2470300.0
2018-05-01	AMZA	ETF	73.0	73.55	72.6	73.4	73750.0
2018-05-01	ANGL	ETF	29.0	29.0	28.91	28.99	723600.0
2018-05-01	AOA	ETF	53.32	53.44	53.08	53.44	54000.0
2018-05-01	AOK	ETF	34.06	34.06	33.88	33.97	65074.0
2018-05-01	AOM	ETF	37.42	37.5056	37.28	37.44	85704.0
2018-05-01	AOR	ETF	44.29	44.34	44.11	44.33	63219.0
2018-05-01	ARGT	ETF	34.74	35.02	34.42	34.52	22300.0
2018-05-01	ARKG	ETF	25.38	25.63	25.285	25.61	27600.0
2018-05-01	ARKK	ETF	39.03	39.63	38.95	39.57	120800.0
2018-05-01	ARKQ	ETF	32.35	32.89	32.33	32.86	32100.0
2018-05-01	ARKW	ETF	49.41	50.116	49.22	50.04	104000.0
2018-05-01	ASEA	ETF	17.6	17.64	17.6	17.64	900.0
2018-05-01	ASET	ETF	27.85	27.91	27.75	27.875	6909.0
2018-05-01	ASHR	ETF	29.67	29.72	29.48	29.69	479400.0
2018-05-01	ASHS	ETF	33.55	33.65	33.48	33.63	2900.0
2018-05-01	ASHX	ETF	20.5	20.5	20.5	20.5	100.0
2018-05-01	ATMP	ETF	19.64	19.79	19.64	19.74	99700.0
2018-05-01	BAB	ETF	29.65	29.65	29.5601	29.6	89235.0
2018-05-01	BAR	ETF	13.025	13.05	13.015	13.05	5400.0
2018-05-01	BBC	ETF	30.9	31.4	30.9	31.4	11092.0
2018-05-01	BBH	ETF	115.02	115.74	114.29	115.69	18500.0

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

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