PREVIEW / etf_daily / 2019-06-19

all etf daily files

  file:    by_date/etf_daily/2019/2019-06-19.parquet
  size:    70 KB
  rows:    1,813

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-06-19	SPY	ETF	292.55	293.65	291.47	293.06	78674400.0
2019-06-19	QQQ	ETF	186.73	187.53	185.57	187.11	31672855.0
2019-06-19	IWM	ETF	154.19	154.7	153.4	154.56	15625000.0
2019-06-19	DIA	ETF	265.4	266.21	264.63	265.56	3920800.0
2019-06-19	GLD	ETF	126.77	127.99	126.7	127.89	11660600.0
2019-06-19	TLT	ETF	131.86	132.72	131.58	132.54	11962500.0
2019-06-19	AAAU	ETF	13.42	13.54	13.42	13.53	64500.0
2019-06-19	AADR	ETF	48.72	49.04	48.58	49.04	9000.0
2019-06-19	AAXJ	ETF	68.26	68.87	68.12	68.57	644900.0
2019-06-19	ACES	ETF	29.31	29.31	29.115	29.299	6600.0
2019-06-19	ACSI	ETF	33.7	33.8099	33.66	33.8099	2167.0
2019-06-19	ACTX	ETF	10.9151	17.994	10.9151	17.7002	596.0
2019-06-19	ACWF	ETF	28.83	28.95	28.76	28.91	5680.0
2019-06-19	ACWI	ETF	72.97	73.26	72.76	73.11	5488500.0
2019-06-19	ACWV	ETF	91.7	92.34	91.53	92.15	534600.0
2019-06-19	ACWX	ETF	46.13	46.39	46.06	46.32	747125.0
2019-06-19	ADRE	ETF	39.63	39.63	39.375	39.5462	3510.0
2019-06-19	AFIF	ETF	9.84	9.88	9.84	9.88	861.0
2019-06-19	AFK	ETF	21.7173	21.79	21.6776	21.79	2691.0
2019-06-19	AFTY	ETF	16.97	16.97	16.86	16.952	3900.0
2019-06-19	AGG	ETF	110.71	111.22	110.65	111.22	2895900.0
2019-06-19	AGGY	ETF	50.92	51.18	50.88	51.17	54100.0
2019-06-19	AGNG	ETF	21.35	21.5	21.35	21.404	4600.0
2019-06-19	AGQ	ETF	23.68	24.17	23.59	24.17	295700.0
2019-06-19	AGZ	ETF	114.85	115.18	114.8	115.18	21693.0
2019-06-19	AGZD	ETF	23.8	23.815	23.785	23.805	27800.0
2019-06-19	AIA	ETF	59.63	60.1658	59.5	60.01	59600.0
2019-06-19	AIEQ	ETF	26.1	26.25	26.07	26.18	25100.0
2019-06-19	AIQ	ETF	16.24	16.24	16.02	16.18	25822.0
2019-06-19	AIRR	ETF	25.41	25.46	25.34	25.46	3900.0
2019-06-19	AIVI	ETF	41.11	41.31	41.11	41.31	5700.0
2019-06-19	ALTY	ETF	14.9	14.9	14.87	14.9	4600.0
2019-06-19	AMJ	ETF	24.66	24.68	24.46	24.58	877136.0
2019-06-19	AMLP	ETF	48.55	48.65	48.2	48.5	2768780.0
2019-06-19	AMOM	ETF	26.137	26.137	26.137	26.137	200.0
2019-06-19	AMUB	ETF	15.5112	15.5112	15.5112	15.5112	0.0
2019-06-19	AMZA	ETF	54.4	55.0	54.35	54.6	75020.0
2019-06-19	ANGL	ETF	28.96	29.17	28.92	29.12	243400.0
2019-06-19	AOA	ETF	54.53	54.8	54.5	54.78	229200.0
2019-06-19	AOK	ETF	35.13	35.2596	35.0801	35.2	41627.0
2019-06-19	AOM	ETF	38.75	38.91	38.7	38.91	387913.0
2019-06-19	AOR	ETF	45.52	45.77	45.52	45.75	364731.0
2019-06-19	ARGT	ETF	31.8	31.88	31.56	31.83	20100.0
2019-06-19	ARKF	ETF	22.38	22.52	22.305	22.508	14900.0
2019-06-19	ARKG	ETF	32.24	32.4	32.01	32.38	136300.0
2019-06-19	ARKK	ETF	45.28	45.36	44.821	45.27	191200.0
2019-06-19	ARKQ	ETF	31.83	31.965	31.76	31.91	8600.0
2019-06-19	ARKW	ETF	51.13	51.49	50.83	51.49	32800.0
2019-06-19	ASEA	ETF	16.6	16.6	16.33	16.49	23400.0
2019-06-19	ASET	ETF	29.61	29.72	29.61	29.72	505.0

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

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