PREVIEW / etf_daily / 2019-11-18

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-18.parquet
  size:    72 KB
  rows:    1,889

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
2019-11-18	SPY	ETF	311.53	312.28	311.03	312.02	49228000.0
2019-11-18	QQQ	ETF	202.61	203.39	201.77	203.07	18408797.0
2019-11-18	IWM	ETF	158.72	158.74	157.94	158.52	10759500.0
2019-11-18	DIA	ETF	279.76	280.36	279.61	280.27	1790500.0
2019-11-18	GLD	ETF	138.44	138.85	138.3	138.62	5717900.0
2019-11-18	TLT	ETF	138.21	138.61	137.93	138.01	5943900.0
2019-11-18	AAAU	ETF	14.66	14.71	14.65	14.69	124600.0
2019-11-18	AADR	ETF	50.42	50.42	50.07	50.36	5700.0
2019-11-18	AAXJ	ETF	70.31	70.45	70.07	70.21	700900.0
2019-11-18	ACES	ETF	32.09	32.09	32.0	32.028	14000.0
2019-11-18	ACIO	ETF	25.295	25.32	25.295	25.296	53600.0
2019-11-18	ACSI	ETF	34.909	35.0001	34.8808	34.9552	1935.0
2019-11-18	ACTX	ETF	7.8176	8.1126	7.8176	7.9651	840.0
2019-11-18	ACWF	ETF	30.54	30.54	30.46	30.4767	12199.0
2019-11-18	ACWI	ETF	77.35	77.5	77.22	77.46	1281100.0
2019-11-18	ACWV	ETF	95.43	95.72	95.35	95.57	406900.0
2019-11-18	ACWX	ETF	48.13	48.24	48.03	48.19	1886134.0
2019-11-18	ADME	ETF	30.325	30.419	30.325	30.385	63800.0
2019-11-18	ADRE	ETF	41.33	41.33	41.01	41.01	2221.0
2019-11-18	AFIF	ETF	9.88	9.88	9.75	9.77	40348.0
2019-11-18	AFK	ETF	20.63	21.49	20.63	20.75	17900.0
2019-11-18	AFTY	ETF	17.53	17.58	17.5	17.578	25200.0
2019-11-18	AGG	ETF	112.56	112.65	112.52	112.62	5757900.0
2019-11-18	AGGY	ETF	52.13	52.171	52.116	52.14	192000.0
2019-11-18	AGNG	ETF	23.24	23.378	23.24	23.315	1100.0
2019-11-18	AGQ	ETF	28.94	29.16	28.84	29.13	62200.0
2019-11-18	AGZ	ETF	115.88	116.0	115.88	115.94	18456.0
2019-11-18	AGZD	ETF	23.97	24.025	23.97	24.015	6400.0
2019-11-18	AIA	ETF	62.48	62.6889	62.48	62.54	27329.0
2019-11-18	AIEQ	ETF	27.4	27.48	27.345	27.4	18900.0
2019-11-18	AIQ	ETF	17.09	17.15	16.998	17.08	11023.0
2019-11-18	AIRR	ETF	28.501	28.501	28.41	28.471	9700.0
2019-11-18	AIVI	ETF	42.02	42.15	42.02	42.12	3600.0
2019-11-18	ALTY	ETF	14.75	14.75	14.69	14.69	12200.0
2019-11-18	AMJ	ETF	21.03	21.05	20.49	20.49	2515362.0
2019-11-18	AMLP	ETF	40.15	40.15	39.15	39.2	5134480.0
2019-11-18	AMUB	ETF	12.9698	12.9698	12.9698	12.9698	200.0
2019-11-18	AMZA	ETF	42.9	42.9	41.5	41.9	116330.0
2019-11-18	ANGL	ETF	29.25	29.28	29.23	29.26	294900.0
2019-11-18	AOA	ETF	56.79	56.89	56.72	56.85	35700.0
2019-11-18	AOK	ETF	36.0	36.0556	35.9311	35.98	88878.0
2019-11-18	AOM	ETF	39.74	39.816	39.74	39.76	158084.0
2019-11-18	AOR	ETF	47.04	47.16	47.0309	47.14	87157.0
2019-11-18	ARGT	ETF	22.22	22.22	21.77	21.79	48800.0
2019-11-18	ARKF	ETF	23.25	23.308	23.146	23.265	6800.0
2019-11-18	ARKG	ETF	31.74	31.74	31.15	31.574	48400.0
2019-11-18	ARKK	ETF	47.41	47.5	47.01	47.4	242000.0
2019-11-18	ARKQ	ETF	34.55	34.73	34.466	34.55	10200.0
2019-11-18	ARKW	ETF	54.43	54.696	54.115	54.47	52300.0
2019-11-18	ASEA	ETF	16.0	16.11	15.99	16.06	2600.0

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

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