PREVIEW / etf_daily / 2019-12-24

all etf daily files

  file:    by_date/etf_daily/2019/2019-12-24.parquet
  size:    72 KB
  rows:    1,903

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-12-24	SPY	ETF	321.47	321.52	320.9	321.23	20270000.0
2019-12-24	QQQ	ETF	211.97	212.09	211.44	211.92	7089020.0
2019-12-24	IWM	ETF	166.45	166.7	166.04	166.68	4334500.0
2019-12-24	DIA	ETF	285.63	285.63	284.87	285.01	611600.0
2019-12-24	GLD	ETF	140.44	141.33	140.43	141.27	5303700.0
2019-12-24	TLT	ETF	135.92	137.06	135.89	136.84	4667400.0
2019-12-24	AAAU	ETF	14.87	14.97	14.87	14.96	66400.0
2019-12-24	AADR	ETF	53.65	54.0	53.65	54.0	8500.0
2019-12-24	AAXJ	ETF	72.88	72.9	72.72	72.81	119300.0
2019-12-24	ACES	ETF	33.83	33.927	33.76	33.927	5800.0
2019-12-24	ACIO	ETF	25.773	25.773	25.773	25.773	100.0
2019-12-24	ACSI	ETF	35.88	35.988	35.88	35.947	802.0
2019-12-24	ACTX	ETF	11.8031	12.252	11.8031	11.806	1133.0
2019-12-24	ACWF	ETF	31.18	31.18	31.1094	31.1167	8181.0
2019-12-24	ACWI	ETF	79.12	79.13	78.95	79.07	1295900.0
2019-12-24	ACWV	ETF	95.46	95.52	95.23	95.49	79300.0
2019-12-24	ACWX	ETF	48.93	48.93	48.79	48.92	1180717.0
2019-12-24	ADME	ETF	30.63	30.63	30.604	30.61	8400.0
2019-12-24	ADRE	ETF	44.46	44.55	44.31	44.395	10670.0
2019-12-24	AESR	ETF	10.125	10.125	10.125	10.125	100.0
2019-12-24	AFIF	ETF	9.85	9.85	9.72	9.755	2824.0
2019-12-24	AFK	ETF	19.96	20.088	19.96	20.0	4374.0
2019-12-24	AFTY	ETF	16.984	17.1	16.966	16.967	12900.0
2019-12-24	AGG	ETF	112.17	112.4	112.13	112.38	1887800.0
2019-12-24	AGGY	ETF	52.05	52.19	52.05	52.16	45800.0
2019-12-24	AGNG	ETF	23.97	24.26	23.836	24.02	2400.0
2019-12-24	AGQ	ETF	30.86	31.47	30.86	31.39	246200.0
2019-12-24	AGZ	ETF	115.43	115.57	115.41	115.5442	21314.0
2019-12-24	AGZD	ETF	24.02	24.055	24.02	24.055	1600.0
2019-12-24	AIA	ETF	65.2145	65.31	65.18	65.21	13324.0
2019-12-24	AIEQ	ETF	28.48	28.574	28.43	28.455	8000.0
2019-12-24	AIQ	ETF	18.09	18.09	17.945	18.0103	7591.0
2019-12-24	AIRR	ETF	29.28	29.28	29.2	29.205	1500.0
2019-12-24	AIVI	ETF	42.59	42.59	42.51	42.53	7000.0
2019-12-24	ALTY	ETF	14.92	15.0	14.92	14.995	3000.0
2019-12-24	AMJ	ETF	22.08	22.08	21.86	21.98	1888112.0
2019-12-24	AMLP	ETF	42.9	43.05	42.7	43.0	2737320.0
2019-12-24	AMOM	ETF	26.02	26.021	26.02	26.021	200.0
2019-12-24	AMUB	ETF	13.79	13.8424	13.79	13.8424	558.0
2019-12-24	AMZA	ETF	46.0	46.0	45.6	46.0	38650.0
2019-12-24	ANGL	ETF	29.9	29.9	29.84	29.87	114000.0
2019-12-24	AOA	ETF	57.84	57.84	57.77	57.84	33600.0
2019-12-24	AOK	ETF	36.19	36.22	36.1176	36.16	42957.0
2019-12-24	AOM	ETF	40.03	40.07	40.0	40.07	62266.0
2019-12-24	AOR	ETF	47.71	47.71	47.62	47.7	63254.0
2019-12-24	ARCM	ETF	99.955	99.955	99.955	99.955	100.0
2019-12-24	ARGT	ETF	26.9	27.63	26.9	27.11	36700.0
2019-12-24	ARKF	ETF	24.25	24.33	24.21	24.313	10600.0
2019-12-24	ARKG	ETF	36.34	36.45	36.103	36.43	40300.0
2019-12-24	ARKK	ETF	51.64	51.82	51.4	51.82	84200.0

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

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