PREVIEW / etf_daily / 2012-05-24

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-24.parquet
  size:    38 KB
  rows:    936

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
2012-05-24	SPY	ETF	132.63	132.84	131.42	132.53	167357600.0
2012-05-24	QQQ	ETF	62.66	62.71	61.69	62.15	83129559.0
2012-05-24	IWM	ETF	76.43	76.74	75.55	76.64	54576500.0
2012-05-24	DIA	ETF	124.92	125.16	123.96	125.12	7043000.0
2012-05-24	GLD	ETF	152.71	152.91	150.62	151.41	9697100.0
2012-05-24	TLT	ETF	123.23	123.79	122.75	122.94	10256200.0
2012-05-24	AADR	ETF	28.08	28.08	28.08	28.08	200.0
2012-05-24	AAXJ	ETF	50.85	50.89	49.96	50.28	1247900.0
2012-05-24	ACTV	ETF	13.1	13.8	13.08	13.8	621254.0
2012-05-24	ACWI	ETF	42.87	42.88	42.36	42.67	819200.0
2012-05-24	ACWV	ETF	52.41	52.45	52.23	52.29	2200.0
2012-05-24	ACWX	ETF	36.07	36.14	35.6509	35.87	104650.0
2012-05-24	ADRE	ETF	36.54	36.69	36.04	36.29	58122.0
2012-05-24	AFK	ETF	28.05	28.09	27.77	27.89	39769.0
2012-05-24	AGEM	ETF	20.02	20.07	19.79	19.8021	3367.0
2012-05-24	AGG	ETF	110.88	110.88	110.71	110.75	938900.0
2012-05-24	AGQ	ETF	166.28	166.84	161.08	164.04	326075.0
2012-05-24	AGZ	ETF	113.09	113.24	113.09	113.17	13945.0
2012-05-24	AIA	ETF	40.58	40.58	39.7644	39.93	16160.0
2012-05-24	AIQ	ETF	5.25	5.45	5.25	5.35	4588.0
2012-05-24	AIS	ETF	2.93	2.9799	2.86	2.87	949274.0
2012-05-24	AIVI	ETF	37.32	37.38	36.87	37.14	39700.0
2012-05-24	AMJ	ETF	37.46	37.56	36.8609	37.13	1939527.0
2012-05-24	AMLP	ETF	79.85	79.85	79.1	79.5	230920.0
2012-05-24	ANGL	ETF	24.83	25.05	24.83	25.0	50900.0
2012-05-24	AOA	ETF	34.3	34.34	34.02	34.1	18900.0
2012-05-24	AOK	ETF	29.56	29.63	29.46	29.59	10883.0
2012-05-24	AOM	ETF	30.39	30.39	30.231	30.3298	10780.0
2012-05-24	AOR	ETF	31.97	31.97	31.826	31.94	7792.0
2012-05-24	ARB	ETF	35.45	35.87	35.21	35.85	131537.0
2012-05-24	ARGT	ETF	16.0	16.0	16.0	16.0	150.0
2012-05-24	ASEA	ETF	15.06	15.08	14.85	14.9	12300.0
2012-05-24	AWAY	ETF	24.86	25.0	24.49	24.96	480256.0
2012-05-24	BAB	ETF	29.78	29.78	29.63	29.69	101583.0
2012-05-24	BAL	ETF	45.01	45.96	44.51	45.94	24111.0
2012-05-24	BALT	ETF	3.93	3.96	3.84	3.87	101196.0
2012-05-24	BBH	ETF	45.47	45.94	45.47	45.88	18600.0
2012-05-24	BCM	ETF	41.52	41.52	41.4202	41.4699	2435.0
2012-05-24	BIB	ETF	12.0337	12.0936	11.9187	11.995	13200.0
2012-05-24	BICK	ETF	21.89	21.89	21.5	21.62	6195.0
2012-05-24	BIL	ETF	91.62	91.66	91.62	91.66	1778900.0
2012-05-24	BIS	ETF	3585.6	3585.6	3497.6	3499.52	23.75
2012-05-24	BIV	ETF	88.06	88.09	87.95	87.98	165500.0
2012-05-24	BJK	ETF	31.81	31.83	31.48	31.57	3300.0
2012-05-24	BKF	ETF	34.88	34.98	34.2	34.49	125394.0
2012-05-24	BKLN	ETF	24.3	24.3	24.2	24.28	144400.0
2012-05-24	BLNG	ETF	46.39	46.49	46.39	46.42	2141.0
2012-05-24	BLV	ETF	93.59	93.59	93.23	93.42	15200.0
2012-05-24	BMVP	ETF	14.56	14.5933	14.52	14.5488	35148.0
2012-05-24	BND	ETF	84.01	84.04	83.93	83.93	860300.0

> showing 50 of 936 rows — these rows as CSV

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