PREVIEW / etf_daily / 2018-10-01

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-01.parquet
  size:    63 KB
  rows:    1,636

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-10-01	SPY	ETF	292.11	292.93	290.98	291.73	62078900.0
2018-10-01	QQQ	ETF	186.82	187.53	185.7	186.17	27371297.0
2018-10-01	IWM	ETF	169.29	169.32	165.77	166.33	27893100.0
2018-10-01	DIA	ETF	266.1	267.15	265.74	266.73	5828100.0
2018-10-01	GLD	ETF	112.4	112.62	112.15	112.57	3892600.0
2018-10-01	TLT	ETF	116.66	116.83	116.12	116.15	22442400.0
2018-10-01	AAAU	ETF	11.88	11.9	11.88	11.89	3300.0
2018-10-01	AADR	ETF	53.9	54.14	53.62	53.7	8800.0
2018-10-01	AAXJ	ETF	70.93	70.93	70.33	70.46	1649500.0
2018-10-01	ACES	ETF	25.912	25.912	25.78	25.78	5900.0
2018-10-01	ACSI	ETF	34.1854	34.1854	34.0	34.0	2825.0
2018-10-01	ACTX	ETF	54.2805	102.6609	53.9855	101.4809	30066.0
2018-10-01	ACWF	ETF	30.9082	30.91	30.765	30.7687	9822.0
2018-10-01	ACWI	ETF	74.63	74.75	74.33	74.47	1648500.0
2018-10-01	ACWV	ETF	88.12	88.14	87.74	87.84	57500.0
2018-10-01	ACWX	ETF	47.92	47.99	47.76	47.84	437294.0
2018-10-01	ADRE	ETF	40.79	40.79	39.81	40.5401	8193.0
2018-10-01	AFIF	ETF	10.02	10.04	10.02	10.03	6656.0
2018-10-01	AFK	ETF	21.43	21.73	21.33	21.42	4661.0
2018-10-01	AFTY	ETF	15.352	15.53	15.332	15.332	15200.0
2018-10-01	AGG	ETF	105.35	105.35	105.2	105.24	3518400.0
2018-10-01	AGGY	ETF	48.34	48.36	48.26	48.26	66100.0
2018-10-01	AGNG	ETF	22.79	22.79	22.595	22.595	4800.0
2018-10-01	AGQ	ETF	23.39	23.72	23.26	23.65	123500.0
2018-10-01	AGZ	ETF	110.49	110.6	110.4313	110.47	19578.0
2018-10-01	AGZD	ETF	24.03	24.03	23.95	23.99	9800.0
2018-10-01	AIA	ETF	62.76	62.94	62.65	62.73	23586.0
2018-10-01	AIEQ	ETF	29.66	29.7	29.4	29.46	72400.0
2018-10-01	AIQ	ETF	15.92	15.95	15.8376	15.8658	5041.0
2018-10-01	AIRR	ETF	28.1	28.1	27.478	27.478	8700.0
2018-10-01	AIVI	ETF	42.18	42.18	41.96	41.96	12900.0
2018-10-01	ALTY	ETF	15.0	15.18	15.0	15.17	8300.0
2018-10-01	AMJ	ETF	27.52	28.14	27.52	28.05	1278148.0
2018-10-01	AMLP	ETF	53.6	54.45	53.55	54.3	2260460.0
2018-10-01	AMZA	ETF	74.8	76.2	74.7	76.1	113960.0
2018-10-01	ANGL	ETF	28.97	29.03	28.97	29.01	455100.0
2018-10-01	AOA	ETF	54.87	54.99	54.7	54.74	55600.0
2018-10-01	AOK	ETF	34.22	34.25	34.11	34.1712	56441.0
2018-10-01	AOM	ETF	37.93	37.95	37.864	37.92	99744.0
2018-10-01	AOR	ETF	45.24	45.44	45.121	45.2	57504.0
2018-10-01	ARGT	ETF	26.76	26.98	26.64	26.7	26400.0
2018-10-01	ARKG	ETF	33.72	33.72	32.54	32.61	158200.0
2018-10-01	ARKK	ETF	48.35	48.48	47.25	47.41	252600.0
2018-10-01	ARKQ	ETF	36.81	36.91	36.42	36.56	13900.0
2018-10-01	ARKW	ETF	58.47	58.74	57.94	58.05	164600.0
2018-10-01	ARVR	ETF	21.92	21.92	21.54	21.545	919.0
2018-10-01	ASEA	ETF	16.22	16.22	16.2	16.2	700.0
2018-10-01	ASET	ETF	27.8801	27.8801	27.8756	27.8756	405.0
2018-10-01	ASHR	ETF	25.39	25.45	25.34	25.4	1301900.0
2018-10-01	ASHS	ETF	25.44	25.56	25.44	25.56	3300.0

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

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