PREVIEW / etf_daily / 2019-07-18

all etf daily files

  file:    by_date/etf_daily/2019/2019-07-18.parquet
  size:    70 KB
  rows:    1,820

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-07-18	SPY	ETF	297.19	299.25	296.7	298.83	51392600.0
2019-07-18	QQQ	ETF	191.3	192.79	190.69	192.42	29066336.0
2019-07-18	IWM	ETF	154.08	155.01	153.73	154.71	15705500.0
2019-07-18	DIA	ETF	271.66	272.75	270.75	272.27	2119000.0
2019-07-18	GLD	ETF	133.83	136.63	133.61	136.48	18448200.0
2019-07-18	TLT	ETF	131.47	132.32	131.24	132.0	5724900.0
2019-07-18	AAAU	ETF	14.17	14.46	14.15	14.43	118800.0
2019-07-18	AADR	ETF	51.29	52.0	51.28	52.0	7900.0
2019-07-18	AAXJ	ETF	69.48	69.87	69.36	69.87	386100.0
2019-07-18	ACES	ETF	30.45	30.52	30.35	30.518	2000.0
2019-07-18	ACIO	ETF	25.06	25.07	24.975	25.07	18400.0
2019-07-18	ACSI	ETF	34.25	34.3527	34.16	34.3527	1081.0
2019-07-18	ACTX	ETF	27.1402	29.5003	27.1402	27.7302	207.0
2019-07-18	ACWF	ETF	29.44	29.6538	29.44	29.6538	2059.0
2019-07-18	ACWI	ETF	74.16	74.65	74.05	74.65	1258100.0
2019-07-18	ACWV	ETF	93.07	93.69	92.96	93.68	244700.0
2019-07-18	ACWX	ETF	46.62	46.96	46.5905	46.94	8134266.0
2019-07-18	ADRE	ETF	40.66	40.7489	40.5368	40.711	1540.0
2019-07-18	AFIF	ETF	9.88	9.89	9.85	9.89	14667.0
2019-07-18	AFK	ETF	21.988	22.0572	21.9061	21.9975	1874.0
2019-07-18	AFTY	ETF	17.25	17.35	17.25	17.323	500.0
2019-07-18	AGG	ETF	111.1	111.33	111.06	111.3	5982200.0
2019-07-18	AGGY	ETF	51.26	51.42	51.235	51.37	98800.0
2019-07-18	AGNG	ETF	21.1	21.338	21.1	21.208	1200.0
2019-07-18	AGQ	ETF	27.18	28.03	26.97	27.99	623100.0
2019-07-18	AGZ	ETF	114.86	115.1099	114.82	115.07	44757.0
2019-07-18	AGZD	ETF	23.91	23.94	23.91	23.91	13200.0
2019-07-18	AIA	ETF	61.01	61.35	60.95	61.31	21820.0
2019-07-18	AIEQ	ETF	26.58	26.89	26.58	26.88	45400.0
2019-07-18	AIQ	ETF	16.72	16.7201	16.5935	16.69	9768.0
2019-07-18	AIRR	ETF	25.89	25.991	25.865	25.91	14700.0
2019-07-18	AIVI	ETF	40.67	40.97	40.59	40.97	5900.0
2019-07-18	ALTY	ETF	15.0	15.08	15.0	15.056	15800.0
2019-07-18	AMJ	ETF	25.56	25.56	25.26	25.41	1591136.0
2019-07-18	AMLP	ETF	50.2	50.35	49.65	49.85	3649220.0
2019-07-18	AMOM	ETF	26.38	26.481	26.37	26.481	1300.0
2019-07-18	AMUB	ETF	15.9777	15.9777	15.9777	15.9777	0.0
2019-07-18	AMZA	ETF	57.2	57.2	56.2	56.9	68600.0
2019-07-18	ANGL	ETF	29.24	29.27	29.14	29.14	316700.0
2019-07-18	AOA	ETF	54.81	55.07	54.68	55.07	39600.0
2019-07-18	AOK	ETF	35.25	35.38	35.2011	35.37	80193.0
2019-07-18	AOM	ETF	38.81	38.94	38.76	38.94	102844.0
2019-07-18	AOR	ETF	45.7	45.9	45.6301	45.9	79014.0
2019-07-18	ARGT	ETF	32.99	32.99	32.48	32.96	79000.0
2019-07-18	ARKF	ETF	23.03	23.17	23.01	23.151	10900.0
2019-07-18	ARKG	ETF	33.5	34.13	33.499	34.11	75300.0
2019-07-18	ARKK	ETF	48.4	48.83	48.35	48.83	132400.0
2019-07-18	ARKQ	ETF	33.84	34.2	33.682	33.927	6900.0
2019-07-18	ARKW	ETF	53.7	54.14	53.576	53.99	35500.0
2019-07-18	ASEA	ETF	16.7	16.75	16.7	16.75	700.0

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

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