PREVIEW / etf_daily / 2012-10-23

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-23.parquet
  size:    39 KB
  rows:    953

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-10-23	SPY	ETF	141.86	142.06	140.83	141.42	192056300.0
2012-10-23	QQQ	ETF	65.49	65.95	65.19	65.39	52598740.0
2012-10-23	IWM	ETF	81.15	81.53	80.43	81.42	40737600.0
2012-10-23	DIA	ETF	131.6	131.63	130.53	130.74	8962100.0
2012-10-23	GLD	ETF	166.04	166.06	165.12	165.43	11892500.0
2012-10-23	TLT	ETF	122.1	122.73	122.02	122.69	5760600.0
2012-10-23	AAXJ	ETF	56.05	56.14	55.6	55.87	359400.0
2012-10-23	ACTV	ETF	9.59	9.63	9.31	9.49	522291.0
2012-10-23	ACWI	ETF	46.62	46.62	46.19	46.47	654300.0
2012-10-23	ACWV	ETF	56.15	56.17	55.77	56.05	35400.0
2012-10-23	ACWX	ETF	39.55	39.55	39.2017	39.45	75192.0
2012-10-23	ADRE	ETF	38.88	38.94	38.75	38.81	28931.0
2012-10-23	AFK	ETF	31.48	31.48	31.18	31.3778	22179.0
2012-10-23	AGEM	ETF	22.4912	22.4912	22.4912	22.4912	551.0
2012-10-23	AGG	ETF	111.87	112.07	111.87	112.05	628100.0
2012-10-23	AGQ	ETF	198.96	198.96	194.0	195.32	322000.0
2012-10-23	AGZ	ETF	113.551	113.65	113.54	113.6	22362.0
2012-10-23	AIA	ETF	44.35	44.35	44.01	44.2	10276.0
2012-10-23	AIQ	ETF	7.05	7.05	6.8	6.8	4710.0
2012-10-23	AIVI	ETF	40.22	40.22	39.86	40.16	23000.0
2012-10-23	AMJ	ETF	40.53	40.79	40.39	40.7	1081801.0
2012-10-23	AMLP	ETF	83.2	83.4	82.85	83.4	367440.0
2012-10-23	ANGL	ETF	27.0	27.0	26.98	26.98	500.0
2012-10-23	AOA	ETF	36.36	36.39	36.15	36.31	10400.0
2012-10-23	AOK	ETF	30.4	30.41	30.33	30.36	15031.0
2012-10-23	AOM	ETF	31.39	31.4499	31.33	31.42	12729.0
2012-10-23	AOR	ETF	33.4	33.49	33.31	33.43	16663.0
2012-10-23	ARB	ETF	36.61	37.44	36.42	37.27	76297.0
2012-10-23	ARGT	ETF	17.24	17.26	17.24	17.24	200.0
2012-10-23	ASEA	ETF	16.7	16.74	16.55	16.67	11700.0
2012-10-23	AWAY	ETF	24.9	25.68	24.72	25.37	216328.0
2012-10-23	BAB	ETF	29.94	30.049	29.91	30.04	191622.0
2012-10-23	BAL	ETF	50.02	50.02	48.42	48.98	12649.0
2012-10-23	BALT	ETF	3.4	3.47	3.31	3.45	141299.0
2012-10-23	BBH	ETF	52.37	52.51	51.49	52.12	40000.0
2012-10-23	BCM	ETF	44.37	44.49	44.37	44.49	1350.0
2012-10-23	BIB	ETF	14.625	14.625	13.9225	14.365	242012.0
2012-10-23	BICK	ETF	23.66	23.66	23.4484	23.54	5391.0
2012-10-23	BIL	ETF	91.64	91.64	91.62	91.64	965650.0
2012-10-23	BIS	ETF	2801.2	2819.6	2742.0	2765.6	66.0
2012-10-23	BIV	ETF	89.89	90.01	89.81	90.01	238900.0
2012-10-23	BJK	ETF	34.16	34.16	33.85	34.13	3800.0
2012-10-23	BKF	ETF	38.53	38.53	38.15	38.26	130971.0
2012-10-23	BKLN	ETF	24.91	24.91	24.89	24.89	616900.0
2012-10-23	BLNG	ETF	51.12	51.12	51.12	51.12	100.0
2012-10-23	BLV	ETF	96.06	96.27	95.92	96.27	35600.0
2012-10-23	BMVP	ETF	15.7199	15.7867	15.6067	15.7567	4485.0
2012-10-23	BND	ETF	84.69	84.76	84.63	84.75	949800.0
2012-10-23	BNO	ETF	39.415	39.415	39.03	39.29	49200.0
2012-10-23	BOIL	ETF	1117000.0	1155200.0	1117000.0	1140400.0	9.4

> showing 50 of 953 rows — these rows as CSV

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