PREVIEW / etf_daily / 2013-06-21

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-21.parquet
  size:    41 KB
  rows:    1,014

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
2013-06-21	SPY	ETF	159.64	159.76	157.47	159.07	271956800.0
2013-06-21	QQQ	ETF	70.78	70.97	69.84	70.43	51565551.0
2013-06-21	IWM	ETF	95.64	96.18	94.63	95.97	66115300.0
2013-06-21	DIA	ETF	148.03	148.28	146.53	147.73	10968600.0
2013-06-21	GLD	ETF	125.16	125.57	124.46	125.05	16600000.0
2013-06-21	TLT	ETF	110.15	110.41	108.37	108.4	19781000.0
2013-06-21	AADR	ETF	33.11	33.13	32.2	32.2	5500.0
2013-06-21	AAXJ	ETF	53.38	53.57	52.55	53.37	480200.0
2013-06-21	ACTV	ETF	6.64	6.95	6.59	6.92	513178.0
2013-06-21	ACWI	ETF	50.31	50.36	49.54	50.07	2499300.0
2013-06-21	ACWV	ETF	59.15	59.51	58.86	59.33	198900.0
2013-06-21	ACWX	ETF	41.13	41.13	40.43	40.84	234568.0
2013-06-21	ADRE	ETF	33.44	33.49	32.8415	33.27	22611.0
2013-06-21	AFK	ETF	27.58	27.6299	27.1101	27.32	57286.0
2013-06-21	AGEM	ETF	19.72	19.72	19.72	19.72	100.0
2013-06-21	AGG	ETF	107.11	107.31	106.53	106.61	1979500.0
2013-06-21	AGQ	ETF	71.04	72.16	70.12	71.72	438525.0
2013-06-21	AGZ	ETF	111.485	111.485	110.8	110.84	266553.0
2013-06-21	AIA	ETF	41.64	41.64	40.8715	41.45	102056.0
2013-06-21	AIQ	ETF	15.8	16.1	15.8	16.09	90750.0
2013-06-21	AIVI	ETF	41.18	41.18	40.45	40.84	67400.0
2013-06-21	AMJ	ETF	44.6	45.14	43.52	44.34	1314867.0
2013-06-21	AMLP	ETF	87.15	87.2	85.15	86.35	906960.0
2013-06-21	ANGL	ETF	26.73	26.73	26.31	26.36	28900.0
2013-06-21	AOA	ETF	39.64	39.64	39.11	39.41	21100.0
2013-06-21	AOK	ETF	30.76	30.76	30.47	30.55	22892.0
2013-06-21	AOM	ETF	32.2799	32.28	32.0337	32.19	217570.0
2013-06-21	AOR	ETF	35.32	35.32	34.9801	35.13	19621.0
2013-06-21	ARB	ETF	46.76	46.91	46.71	46.89	293976.0
2013-06-21	ARGT	ETF	16.25	16.25	15.8	15.96	5600.0
2013-06-21	ASEA	ETF	16.17	16.25	15.87	16.14	190800.0
2013-06-21	ATMP	ETF	25.1	25.1	24.48	24.89	12000.0
2013-06-21	AVIV	ETF	24.82	25.24	24.8	25.0	817959.0
2013-06-21	AWAY	ETF	30.24	30.42	29.6501	30.24	1211826.0
2013-06-21	BAB	ETF	28.37	28.3999	27.675	27.683	606236.0
2013-06-21	BAL	ETF	54.52	54.56	54.12	54.15	49129.0
2013-06-21	BALT	ETF	3.46	3.57	3.41	3.54	42680.0
2013-06-21	BBH	ETF	66.49	67.11	65.13	66.16	88200.0
2013-06-21	BCM	ETF	39.18	39.18	39.15	39.15	3833.0
2013-06-21	BFOR	ETF	6.1625	6.1625	6.0525	6.115	749600.0
2013-06-21	BIB	ETF	21.1275	21.851	20.55	21.2725	182292.0
2013-06-21	BICK	ETF	20.57	20.6399	20.32	20.56	3725.0
2013-06-21	BIL	ETF	91.62	91.62	91.6	91.62	444100.0
2013-06-21	BIS	ETF	1640.4	1688.64	1600.0	1628.4	293.0
2013-06-21	BIV	ETF	83.72	83.8	83.13	83.16	449700.0
2013-06-21	BIZD	ETF	19.38	19.41	19.16	19.32	8700.0
2013-06-21	BJK	ETF	40.21	40.21	39.22	39.78	72200.0
2013-06-21	BKF	ETF	33.91	34.1499	33.43	33.89	517611.0
2013-06-21	BKLN	ETF	24.71	24.72	24.62	24.63	3840300.0
2013-06-21	BLV	ETF	84.81	85.06	83.72	83.72	216200.0

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

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