PREVIEW / etf_daily / 2018-05-07

all etf daily files

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

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-07	SPY	ETF	266.89	268.02	266.11	266.92	55304900.0
2018-05-07	QQQ	ETF	165.64	166.78	165.51	166.24	32500152.0
2018-05-07	IWM	ETF	156.19	157.86	156.1	157.05	16303500.0
2018-05-07	DIA	ETF	243.5	244.67	242.49	243.42	2983800.0
2018-05-07	GLD	ETF	124.5	124.7	124.3	124.57	3397500.0
2018-05-07	TLT	ETF	118.97	119.02	118.74	118.8	3647800.0
2018-05-07	AADR	ETF	57.46	58.15	57.46	57.76	14400.0
2018-05-07	AAXJ	ETF	75.17	75.72	75.04	75.47	317900.0
2018-05-07	ACSI	ETF	31.164	31.164	31.08	31.08	145055.0
2018-05-07	ACTX	ETF	59.8855	60.7705	56.6405	60.7705	304.0
2018-05-07	ACWF	ETF	30.8	30.8399	30.64	30.66	4342.0
2018-05-07	ACWI	ETF	72.27	72.55	72.16	72.34	1525700.0
2018-05-07	ACWV	ETF	83.24	83.43	83.12	83.29	74800.0
2018-05-07	ACWX	ETF	49.89	50.05	49.81	49.93	401176.0
2018-05-07	ADRE	ETF	43.7	44.25	43.7	44.01	6189.0
2018-05-07	AFK	ETF	24.97	25.349	24.97	25.2811	5442.0
2018-05-07	AFTY	ETF	16.88	16.94	16.88	16.914	2500.0
2018-05-07	AGG	ETF	105.88	105.88	105.77	105.81	1533400.0
2018-05-07	AGGY	ETF	48.59	48.59	48.53	48.551	44300.0
2018-05-07	AGNG	ETF	19.8	19.8	19.73	19.75	1600.0
2018-05-07	AGQ	ETF	31.38	31.52	31.22	31.31	134600.0
2018-05-07	AGZ	ETF	110.88	111.038	110.87	110.89	15745.0
2018-05-07	AGZD	ETF	24.04	24.045	24.0	24.04	9000.0
2018-05-07	AIA	ETF	65.92	66.21	65.755	66.04	56839.0
2018-05-07	AIEQ	ETF	26.66	26.97	26.66	26.86	79400.0
2018-05-07	AIRR	ETF	25.44	25.706	25.417	25.58	14700.0
2018-05-07	AIVI	ETF	44.5	44.62	44.44	44.5	8700.0
2018-05-07	ALTY	ETF	14.71	14.719	14.659	14.719	2600.0
2018-05-07	AMJ	ETF	25.94	26.32	25.75	25.99	1227021.0
2018-05-07	AMLP	ETF	50.6	51.25	50.35	50.6	2639860.0
2018-05-07	AMZA	ETF	72.7	73.95	72.7	73.2	111410.0
2018-05-07	ANGL	ETF	29.02	29.05	28.99	28.99	258800.0
2018-05-07	AOA	ETF	53.45	53.71	53.45	53.55	67800.0
2018-05-07	AOK	ETF	33.95	34.01	33.95	33.96	58367.0
2018-05-07	AOM	ETF	37.4	37.5472	37.4	37.46	132581.0
2018-05-07	AOR	ETF	44.42	44.53	44.38	44.41	169250.0
2018-05-07	ARGT	ETF	32.69	33.16	32.55	32.66	211000.0
2018-05-07	ARKG	ETF	25.9	26.63	25.9	26.42	70300.0
2018-05-07	ARKK	ETF	40.19	41.119	40.19	40.95	246200.0
2018-05-07	ARKQ	ETF	33.31	33.746	33.18	33.601	26800.0
2018-05-07	ARKW	ETF	51.53	52.4	51.53	52.28	199700.0
2018-05-07	ASEA	ETF	17.5	17.5	17.2	17.31	10900.0
2018-05-07	ASET	ETF	28.04	28.055	28.01	28.055	1041.0
2018-05-07	ASHR	ETF	30.01	30.06	29.97	30.04	880100.0
2018-05-07	ASHS	ETF	34.35	34.4	34.33	34.33	3800.0
2018-05-07	ASHX	ETF	20.87	20.87	20.8	20.8	311.0
2018-05-07	ATMP	ETF	19.61	20.04	19.61	19.8	155000.0
2018-05-07	BAB	ETF	29.67	29.67	29.57	29.59	55403.0
2018-05-07	BAL	ETF	53.19	53.2248	52.32	52.3544	2288.0
2018-05-07	BAR	ETF	13.118	13.12	13.1157	13.12	11770.0

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

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