PREVIEW / etf_daily / 2018-05-25

all etf daily files

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

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-25	SPY	ETF	272.15	272.86	271.58	272.15	56374800.0
2018-05-25	QQQ	ETF	169.54	170.33	169.21	169.72	27460536.0
2018-05-25	IWM	ETF	161.75	162.16	161.47	161.74	11150200.0
2018-05-25	DIA	ETF	247.41	248.1	246.71	247.37	4207000.0
2018-05-25	GLD	ETF	123.66	123.7	123.21	123.21	7920700.0
2018-05-25	TLT	ETF	119.56	119.84	119.47	119.62	8482800.0
2018-05-25	AADR	ETF	58.71	58.71	58.28	58.28	16600.0
2018-05-25	AAXJ	ETF	76.44	76.93	76.43	76.89	770200.0
2018-05-25	ACSI	ETF	31.4884	31.508	31.485	31.508	1527.0
2018-05-25	ACTX	ETF	63.1306	66.0806	60.1805	61.3606	427.0
2018-05-25	ACWF	ETF	31.33	31.48	31.26	31.3199	18762.0
2018-05-25	ACWI	ETF	72.9	73.05	72.79	72.91	1009100.0
2018-05-25	ACWV	ETF	83.85	84.16	83.85	83.98	76900.0
2018-05-25	ACWX	ETF	49.62	49.72	49.53	49.64	408949.0
2018-05-25	ADRE	ETF	43.03	43.3659	43.03	43.3	4095.0
2018-05-25	AFK	ETF	24.9	25.12	24.531	24.72	11893.0
2018-05-25	AFTY	ETF	16.79	16.79	16.7	16.755	5800.0
2018-05-25	AGG	ETF	106.1	106.18	106.03	106.12	2508100.0
2018-05-25	AGGY	ETF	48.55	48.63	48.55	48.629	25900.0
2018-05-25	AGNG	ETF	20.24	20.341	20.23	20.34	1500.0
2018-05-25	AGQ	ETF	31.85	31.85	31.32	31.32	110300.0
2018-05-25	AGZ	ETF	111.16	111.3084	111.13	111.19	24566.0
2018-05-25	AGZD	ETF	23.975	23.975	23.95	23.95	3400.0
2018-05-25	AIA	ETF	67.33	67.5	67.24	67.47	20962.0
2018-05-25	AIEQ	ETF	27.55	27.65	27.54	27.64	59900.0
2018-05-25	AIQ	ETF	15.03	15.1	15.01	15.03	23483.0
2018-05-25	AIRR	ETF	26.33	26.439	26.301	26.43	8200.0
2018-05-25	AIVI	ETF	43.13	43.32	43.13	43.22	47400.0
2018-05-25	ALTY	ETF	14.91	14.91	14.821	14.87	6100.0
2018-05-25	AMJ	ETF	26.12	26.3	25.73	26.21	2188560.0
2018-05-25	AMLP	ETF	50.5	50.9	49.7	50.6	3341980.0
2018-05-25	AMUB	ETF	19.27	19.27	17.0	17.0	504.0
2018-05-25	AMZA	ETF	74.0	74.45	72.4	74.1	149970.0
2018-05-25	ANGL	ETF	29.03	29.08	28.93	28.98	200000.0
2018-05-25	AOA	ETF	53.95	54.07	53.93	53.95	21100.0
2018-05-25	AOK	ETF	34.11	34.15	34.071	34.12	35775.0
2018-05-25	AOM	ETF	37.72	37.73	37.65	37.73	61823.0
2018-05-25	AOR	ETF	44.69	44.769	44.64	44.69	36314.0
2018-05-25	ARGT	ETF	31.16	31.24	31.0	31.17	14800.0
2018-05-25	ARKG	ETF	29.1	29.1	28.708	28.89	49800.0
2018-05-25	ARKK	ETF	43.25	43.408	43.09	43.19	184000.0
2018-05-25	ARKQ	ETF	33.921	34.052	33.914	34.02	16400.0
2018-05-25	ARKW	ETF	53.2	53.5	53.02	53.34	87200.0
2018-05-25	ASEA	ETF	16.85	17.15	16.85	17.15	27300.0
2018-05-25	ASET	ETF	27.947	27.947	27.8803	27.895	2911.0
2018-05-25	ASHR	ETF	29.87	29.9	29.79	29.84	498300.0
2018-05-25	ASHS	ETF	33.7	33.77	33.68	33.75	4800.0
2018-05-25	ATMP	ETF	19.33	19.87	19.33	19.8	29600.0
2018-05-25	BAB	ETF	29.54	29.54	29.48	29.5102	59079.0
2018-05-25	BAL	ETF	53.5599	54.26	53.53	54.26	4464.0

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

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