PREVIEW / etf_daily / 2019-11-27

all etf daily files

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

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-27	SPY	ETF	314.61	315.48	314.37	315.48	44444600.0
2019-11-27	QQQ	ETF	205.13	206.05	204.89	206.04	17060233.0
2019-11-27	IWM	ETF	162.38	162.93	162.08	162.83	13202500.0
2019-11-27	DIA	ETF	281.61	281.91	281.01	281.91	1786300.0
2019-11-27	GLD	ETF	137.03	137.21	136.83	137.01	4111000.0
2019-11-27	TLT	ETF	140.6	140.91	140.42	140.72	4095700.0
2019-11-27	AAAU	ETF	14.52	14.53	14.5	14.51	20600.0
2019-11-27	AADR	ETF	50.63	50.67	50.52	50.67	13500.0
2019-11-27	AAXJ	ETF	70.75	70.97	70.64	70.88	420000.0
2019-11-27	ACES	ETF	32.28	32.515	32.28	32.515	9400.0
2019-11-27	ACIO	ETF	25.42	25.43	25.408	25.408	14700.0
2019-11-27	ACSI	ETF	35.3729	35.4429	35.36	35.4429	730.0
2019-11-27	ACTX	ETF	6.4901	6.4901	6.4901	6.4901	63.0
2019-11-27	ACWF	ETF	30.81	30.8417	30.75	30.8417	17323.0
2019-11-27	ACWI	ETF	77.87	78.06	77.81	78.02	639400.0
2019-11-27	ACWV	ETF	95.97	96.09	95.75	96.04	164100.0
2019-11-27	ACWX	ETF	48.27	48.36	48.23	48.35	954441.0
2019-11-27	ADME	ETF	30.332	30.4	30.332	30.389	13100.0
2019-11-27	ADRE	ETF	41.74	41.9225	41.684	41.9225	5059.0
2019-11-27	AFIF	ETF	9.75	9.75	9.735	9.735	269.0
2019-11-27	AFK	ETF	20.51	20.69	20.5	20.59	2888.0
2019-11-27	AFTY	ETF	17.4	17.46	17.4	17.46	1800.0
2019-11-27	AGG	ETF	113.03	113.07	112.96	113.0	3437300.0
2019-11-27	AGGY	ETF	52.23	52.32	52.23	52.3	298800.0
2019-11-27	AGNG	ETF	23.68	23.875	23.68	23.85	1700.0
2019-11-27	AGQ	ETF	28.78	28.96	28.69	28.76	69100.0
2019-11-27	AGZ	ETF	116.37	116.37	116.2843	116.33	23264.0
2019-11-27	AGZD	ETF	23.935	24.005	23.935	23.965	7200.0
2019-11-27	AIA	ETF	62.76	62.99	62.7	62.97	37881.0
2019-11-27	AIEQ	ETF	27.87	27.96	27.82	27.96	18000.0
2019-11-27	AIQ	ETF	17.42	17.426	17.35	17.41	1834.0
2019-11-27	AIRR	ETF	28.97	28.97	28.88	28.922	1700.0
2019-11-27	AIVI	ETF	42.01	42.14	42.01	42.12	6600.0
2019-11-27	ALTY	ETF	14.7	14.73	14.672	14.715	4600.0
2019-11-27	AMJ	ETF	20.22	20.3	19.94	20.3	2206984.0
2019-11-27	AMLP	ETF	39.4	39.55	38.8	39.4	4607740.0
2019-11-27	AMOM	ETF	26.855	26.855	26.855	26.855	100.0
2019-11-27	AMUB	ETF	12.73	12.7609	10.32	12.7609	502.0
2019-11-27	AMZA	ETF	41.2	41.3	40.3	41.1	77420.0
2019-11-27	ANGL	ETF	29.31	29.41	29.29	29.39	978400.0
2019-11-27	AOA	ETF	57.18	57.23	57.08	57.2	42300.0
2019-11-27	AOK	ETF	36.14	36.16	36.0527	36.15	140925.0
2019-11-27	AOM	ETF	39.9	39.97	39.89	39.93	157986.0
2019-11-27	AOR	ETF	47.36	47.41	47.33	47.35	115098.0
2019-11-27	ARGT	ETF	23.13	23.88	23.13	23.88	105700.0
2019-11-27	ARKF	ETF	23.99	24.01	23.9	23.996	10700.0
2019-11-27	ARKG	ETF	34.61	34.87	34.43	34.69	184000.0
2019-11-27	ARKK	ETF	50.3	50.466	49.96	50.23	130700.0
2019-11-27	ARKQ	ETF	34.65	34.943	34.65	34.91	7000.0
2019-11-27	ARKW	ETF	56.34	56.51	56.19	56.43	50700.0

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

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