PREVIEW / etf_daily / 2015-05-01

all etf daily files

  file:    by_date/etf_daily/2015/2015-05-01.parquet
  size:    48 KB
  rows:    1,181

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
2015-05-01	SPY	ETF	209.4	210.77	209.28	210.72	103399700.0
2015-05-01	QQQ	ETF	108.05	109.12	108.03	109.05	32874307.0
2015-05-01	IWM	ETF	121.52	122.16	120.91	121.97	47996200.0
2015-05-01	DIA	ETF	179.21	180.01	178.98	179.9	3895700.0
2015-05-01	GLD	ETF	112.42	113.31	112.28	113.08	7597000.0
2015-05-01	TLT	ETF	124.73	125.04	123.69	124.0	12378500.0
2015-05-01	AADR	ETF	40.58	40.58	40.55	40.55	500.0
2015-05-01	AAXJ	ETF	68.33	68.64	68.13	68.51	659300.0
2015-05-01	ACTX	ETF	4.72	4.72	2.95	3.54	9009.0
2015-05-01	ACWI	ETF	61.95	62.31	61.89	62.3	1766300.0
2015-05-01	ACWV	ETF	73.11	73.39	73.01	73.38	77100.0
2015-05-01	ACWX	ETF	47.01	47.25	46.87	47.23	1031129.0
2015-05-01	ADRE	ETF	37.578	37.8	37.5547	37.757	5435.0
2015-05-01	AFK	ETF	26.65	27.15	26.65	27.11	121748.0
2015-05-01	AFTY	ETF	23.02	23.26	23.01	23.18	76500.0
2015-05-01	AGG	ETF	110.52	110.53	110.25	110.34	1357200.0
2015-05-01	AGQ	ETF	38.35	39.19	38.02	39.15	147800.0
2015-05-01	AGZ	ETF	113.5	113.64	113.39	113.44	18631.0
2015-05-01	AGZD	ETF	24.525	24.525	24.45	24.455	8400.0
2015-05-01	AIA	ETF	53.78	54.2399	53.78	54.07	48452.0
2015-05-01	AIQ	ETF	21.58	21.86	21.25	21.86	10390.0
2015-05-01	AIRR	ETF	18.36	18.36	18.09	18.21	9000.0
2015-05-01	AIVI	ETF	46.14	46.26	45.93	46.26	14500.0
2015-05-01	AMJ	ETF	45.59	45.81	45.16	45.691	1198769.0
2015-05-01	AMLP	ETF	86.15	86.45	85.9	86.2	715620.0
2015-05-01	AMZA	ETF	224.1	225.9	224.0	225.9	730.0
2015-05-01	ANGL	ETF	27.81	27.81	27.63	27.67	11000.0
2015-05-01	AOA	ETF	48.47	48.55	48.27	48.54	36300.0
2015-05-01	AOK	ETF	33.08	33.12	33.03	33.04	44456.0
2015-05-01	AOM	ETF	35.92	35.92	35.79	35.87	28375.0
2015-05-01	AOR	ETF	41.39	41.44	41.2679	41.44	36465.0
2015-05-01	ARGT	ETF	22.08	22.25	22.08	22.25	2600.0
2015-05-01	ARKG	ETF	22.696	22.809	22.688	22.809	1400.0
2015-05-01	ARKK	ETF	20.84	20.84	20.79	20.79	400.0
2015-05-01	ARKQ	ETF	19.62	19.62	19.62	19.62	100.0
2015-05-01	ARKW	ETF	22.44	22.44	22.213	22.39	6000.0
2015-05-01	ASEA	ETF	16.04	16.05	16.04	16.05	900.0
2015-05-01	ASHR	ETF	48.58	49.11	48.54	49.09	812700.0
2015-05-01	ASHS	ETF	55.32	55.33	55.05	55.3	13400.0
2015-05-01	ATMP	ETF	30.8	30.85	30.69	30.82	15800.0
2015-05-01	AWAY	ETF	28.07	28.47	27.38	27.48	1848338.0
2015-05-01	BAB	ETF	30.07	30.07	29.78	29.82	190491.0
2015-05-01	BAL	ETF	46.12	46.12	44.68	45.14	20978.0
2015-05-01	BALT	ETF	1.42	1.45	1.38	1.43	413631.0
2015-05-01	BAR	ETF	2.559	2.591	2.55	2.554	52920.0
2015-05-01	BBC	ETF	30.04	31.2199	30.04	31.072	17238.0
2015-05-01	BBH	ETF	126.23	128.88	126.2	128.57	104200.0
2015-05-01	BBP	ETF	29.9	30.814	29.9	30.66	26600.0
2015-05-01	BCHP	ETF	20.4135	20.46	20.4135	20.46	398.0
2015-05-01	BCM	ETF	32.34	32.35	32.34	32.35	1381.0

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

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