PREVIEW / etf_daily / 2020-02-12

all etf daily files

  file:    by_date/etf_daily/2020/2020-02-12.parquet
  size:    74 KB
  rows:    1,950

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
2020-02-12	SPY	ETF	336.83	337.65	336.43	337.42	43992700.0
2020-02-12	QQQ	ETF	233.34	234.38	232.8	234.27	24471275.0
2020-02-12	IWM	ETF	168.02	168.29	167.28	168.11	12123000.0
2020-02-12	DIA	ETF	294.63	295.87	294.53	295.72	2804400.0
2020-02-12	GLD	ETF	147.42	147.81	147.16	147.54	5040600.0
2020-02-12	TLT	ETF	143.37	143.55	142.99	143.37	5595500.0
2020-02-12	AAAU	ETF	15.63	15.66	15.6	15.63	34900.0
2020-02-12	AADR	ETF	56.27	56.3	55.86	56.3	15100.0
2020-02-12	AAXJ	ETF	73.69	74.05	73.53	73.99	771300.0
2020-02-12	ABEQ	ETF	25.154	25.154	25.148	25.148	2500.0
2020-02-12	ACES	ETF	40.07	40.49	39.93	40.44	126500.0
2020-02-12	ACIO	ETF	25.522	25.522	25.512	25.512	300.0
2020-02-12	ACSI	ETF	37.34	37.4129	37.32	37.4129	1440.0
2020-02-12	ACTX	ETF	6.7851	7.6701	6.7851	7.6701	56.0
2020-02-12	ACWF	ETF	31.74	31.88	31.72	31.845	9560.0
2020-02-12	ACWI	ETF	81.58	81.75	81.48	81.73	2056700.0
2020-02-12	ACWV	ETF	99.24	99.24	98.78	99.08	222500.0
2020-02-12	ACWX	ETF	49.3	49.37	49.22	49.36	895609.0
2020-02-12	ADME	ETF	31.62	31.66	31.62	31.66	1500.0
2020-02-12	ADRE	ETF	44.22	44.5679	44.22	44.5427	5169.0
2020-02-12	AFIF	ETF	9.7384	9.745	9.735	9.745	855.0
2020-02-12	AFK	ETF	19.4	19.8	19.4	19.75	7715.0
2020-02-12	AFLG	ETF	21.19	21.209	21.19	21.209	1000.0
2020-02-12	AFSM	ETF	20.603	20.603	20.603	20.603	100.0
2020-02-12	AFTY	ETF	16.55	16.55	16.48	16.53	2600.0
2020-02-12	AGG	ETF	114.12	114.14	114.03	114.09	6373700.0
2020-02-12	AGGY	ETF	53.18	53.2	53.134	53.19	219300.0
2020-02-12	AGNG	ETF	24.66	24.791	24.493	24.5	3300.0
2020-02-12	AGQ	ETF	30.06	30.27	29.91	29.98	292900.0
2020-02-12	AGZ	ETF	116.81	116.89	116.8	116.87	36468.0
2020-02-12	AGZD	ETF	24.0	24.085	23.97	24.045	5200.0
2020-02-12	AIA	ETF	66.89	67.37	66.84	67.19	41465.0
2020-02-12	AIEQ	ETF	29.95	30.12	29.9	30.12	25400.0
2020-02-12	AIQ	ETF	19.77	19.875	19.7286	19.875	19643.0
2020-02-12	AIRR	ETF	29.31	29.46	29.31	29.395	6000.0
2020-02-12	AIVI	ETF	42.06	42.11	42.04	42.11	4200.0
2020-02-12	ALTY	ETF	14.98	14.99	14.977	14.98	3800.0
2020-02-12	AMJ	ETF	20.53	20.78	20.45	20.76	2603376.0
2020-02-12	AMLP	ETF	40.1	40.5	39.85	40.45	5732180.0
2020-02-12	AMOM	ETF	27.603	27.603	27.603	27.603	100.0
2020-02-12	AMUB	ETF	12.98	13.069	12.98	13.069	284.0
2020-02-12	AMZA	ETF	40.0	40.9	39.89	40.8	139930.0
2020-02-12	ANGL	ETF	30.37	30.53	30.37	30.52	1113300.0
2020-02-12	AOA	ETF	59.31	59.41	59.25	59.41	33200.0
2020-02-12	AOK	ETF	36.89	36.92	36.86	36.88	62312.0
2020-02-12	AOM	ETF	40.85	40.9486	40.85	40.93	340427.0
2020-02-12	AOR	ETF	48.84	48.89	48.8	48.89	58469.0
2020-02-12	ARCM	ETF	100.15	100.15	100.15	100.15	100.0
2020-02-12	ARGT	ETF	25.84	26.03	25.7	26.03	29400.0
2020-02-12	ARKF	ETF	26.86	26.95	26.688	26.929	91000.0

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

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