PREVIEW / etf_daily / 2018-01-12

all etf daily files

  file:    by_date/etf_daily/2018/2018-01-12.parquet
  size:    61 KB
  rows:    1,554

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
2018-01-12	SPY	ETF	276.42	278.11	276.08	277.92	90816100.0
2018-01-12	QQQ	ETF	163.03	164.66	162.94	164.49	37762708.0
2018-01-12	IWM	ETF	157.68	158.86	157.47	158.16	24089800.0
2018-01-12	DIA	ETF	256.63	257.97	256.48	257.91	3678400.0
2018-01-12	GLD	ETF	126.01	127.13	125.81	126.96	9258600.0
2018-01-12	TLT	ETF	124.1	124.79	123.91	124.52	9987100.0
2018-01-12	AADR	ETF	62.47	62.65	62.36	62.57	114800.0
2018-01-12	AAXJ	ETF	79.48	80.15	79.38	80.15	1162100.0
2018-01-12	ACSI	ETF	31.92	31.94	31.8773	31.94	2512.0
2018-01-12	ACTX	ETF	92.0408	106.201	91.4508	93.8108	973.0
2018-01-12	ACWF	ETF	31.81	32.11	31.8	32.07	19979.0
2018-01-12	ACWI	ETF	74.78	75.25	74.76	75.2	1382000.0
2018-01-12	ACWV	ETF	85.35	85.71	85.16	85.61	129900.0
2018-01-12	ACWX	ETF	51.84	52.21	51.81	52.2	725707.0
2018-01-12	ADRE	ETF	45.25	45.69	45.25	45.511	10204.0
2018-01-12	AFK	ETF	25.61	25.73	25.61	25.7048	3802.0
2018-01-12	AFTY	ETF	18.89	19.09	18.89	19.09	6600.0
2018-01-12	AGG	ETF	108.64	108.83	108.63	108.74	3605900.0
2018-01-12	AGGY	ETF	50.42	50.52	50.36	50.46	89000.0
2018-01-12	AGNG	ETF	20.32	20.32	20.15	20.23	9300.0
2018-01-12	AGQ	ETF	34.23	35.15	34.2	35.04	187600.0
2018-01-12	AGZ	ETF	112.44	112.53	112.378	112.4986	26533.0
2018-01-12	AGZD	ETF	24.17	24.19	24.17	24.175	5800.0
2018-01-12	AIA	ETF	68.88	69.4375	68.64	69.34	136497.0
2018-01-12	AIEQ	ETF	27.26	27.43	27.26	27.41	274600.0
2018-01-12	AIRR	ETF	28.02	28.37	28.02	28.172	40400.0
2018-01-12	AIVI	ETF	45.1	45.43	45.1	45.39	13600.0
2018-01-12	ALTY	ETF	15.45	15.45	15.45	15.45	400.0
2018-01-12	AMJ	ETF	29.88	30.07	29.555	30.01	3413893.0
2018-01-12	AMLP	ETF	58.35	58.9	57.95	58.8	5864040.0
2018-01-12	AMZA	ETF	87.2	88.05	87.0	88.0	177440.0
2018-01-12	ANGL	ETF	30.24	30.26	30.2	30.26	437200.0
2018-01-12	AOA	ETF	55.35	55.65	55.32	55.6	104000.0
2018-01-12	AOK	ETF	34.88	35.0	34.8701	34.9999	52986.0
2018-01-12	AOM	ETF	38.55	38.66	38.48	38.66	279876.0
2018-01-12	AOR	ETF	45.81	46.0	45.7592	46.0	118340.0
2018-01-12	ARCM	ETF	100.19	100.19	100.19	100.19	3000.0
2018-01-12	ARGT	ETF	37.0	37.33	36.9	37.29	109600.0
2018-01-12	ARKG	ETF	25.93	26.22	25.7	25.7	95100.0
2018-01-12	ARKK	ETF	39.84	39.989	39.6	39.71	347500.0
2018-01-12	ARKQ	ETF	35.68	36.049	35.64	35.964	98300.0
2018-01-12	ARKW	ETF	48.98	49.239	48.8	49.1	220600.0
2018-01-12	ASEA	ETF	17.6	17.96	17.6	17.8	4900.0
2018-01-12	ASET	ETF	28.8025	28.84	28.8006	28.84	7220.0
2018-01-12	ASHR	ETF	32.73	32.91	32.69	32.91	1215500.0
2018-01-12	ASHS	ETF	36.06	36.25	36.06	36.25	10600.0
2018-01-12	ASHX	ETF	23.272	23.272	23.21	23.2103	495.0
2018-01-12	ATMP	ETF	22.37	22.62	22.31	22.62	66600.0
2018-01-12	BAB	ETF	30.32	30.4	30.25	30.35	160007.0
2018-01-12	BAL	ETF	55.63	55.63	53.55	54.37	15464.0

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

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