PREVIEW / etf_daily / 2012-12-24

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-24.parquet
  size:    38 KB
  rows:    941

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-12-24	SPY	ETF	142.48	142.56	142.19	142.35	53874600.0
2012-12-24	QQQ	ETF	65.06	65.14	64.92	65.07	11418232.0
2012-12-24	IWM	ETF	83.89	83.97	83.51	83.78	10103000.0
2012-12-24	DIA	ETF	131.29	131.42	130.97	130.97	1997400.0
2012-12-24	GLD	ETF	160.88	160.96	160.47	160.62	3699400.0
2012-12-24	TLT	ETF	122.0	122.08	121.87	122.03	1071100.0
2012-12-24	AADR	ETF	31.21	31.21	30.75	30.75	1700.0
2012-12-24	AAXJ	ETF	59.1	59.1	58.78	58.99	282700.0
2012-12-24	ACTV	ETF	4.79	4.805	4.64	4.68	320213.0
2012-12-24	ACWI	ETF	47.94	47.95	47.71	47.79	165700.0
2012-12-24	ACWV	ETF	56.03	56.03	55.57	55.77	14300.0
2012-12-24	ACWX	ETF	41.53	41.88	41.12	41.49	103763.0
2012-12-24	ADRE	ETF	39.47	39.57	39.37	39.48	11626.0
2012-12-24	AFK	ETF	30.99	31.02	30.5792	30.61	51720.0
2012-12-24	AGEM	ETF	23.0	23.59	22.78	22.95	6376.0
2012-12-24	AGG	ETF	111.09	111.16	111.08	111.13	329200.0
2012-12-24	AGQ	ETF	173.44	174.2	170.72	171.48	209100.0
2012-12-24	AGZ	ETF	113.49	113.49	113.37	113.45	16136.0
2012-12-24	AIA	ETF	46.91	47.1285	46.848	46.9069	13947.0
2012-12-24	AIQ	ETF	6.3	6.45	6.05	6.05	7561.0
2012-12-24	AIVI	ETF	41.58	41.6	41.54	41.58	6000.0
2012-12-24	ALTL	ETF	26.04	26.04	26.04	26.04	200.0
2012-12-24	AMJ	ETF	38.7	38.866	38.44	38.57	638369.0
2012-12-24	AMLP	ETF	80.2	80.3	79.8	80.0	211620.0
2012-12-24	AOA	ETF	37.41	37.41	37.31	37.33	5200.0
2012-12-24	AOK	ETF	30.6208	30.65	30.6208	30.65	6905.0
2012-12-24	AOM	ETF	31.88	32.0	31.8742	31.92	59011.0
2012-12-24	AOR	ETF	34.1	34.13	34.04	34.11	17964.0
2012-12-24	ARB	ETF	46.36	46.49	46.25	46.4	139927.0
2012-12-24	ARGT	ETF	17.12	17.34	17.1	17.34	1950.0
2012-12-24	ASEA	ETF	17.16	17.19	17.07	17.17	8200.0
2012-12-24	AWAY	ETF	21.81	22.675	21.39	21.64	271361.0
2012-12-24	BAB	ETF	30.22	30.31	30.19	30.25	41353.0
2012-12-24	BAL	ETF	49.7	49.91	49.7	49.86	6200.0
2012-12-24	BALT	ETF	3.15	3.2	3.05	3.14	214950.0
2012-12-24	BBH	ETF	54.12	54.12	53.72	53.85	12200.0
2012-12-24	BCM	ETF	43.56	43.63	43.5507	43.5507	1787.0
2012-12-24	BIB	ETF	14.5125	14.65	14.5	14.625	45252.0
2012-12-24	BICK	ETF	24.81	25.02	24.65	24.7	7068.0
2012-12-24	BIL	ETF	91.64	91.64	91.62	91.62	107450.0
2012-12-24	BIS	ETF	2652.8	2652.8	2640.8	2640.8	52.5
2012-12-24	BIV	ETF	88.09	88.13	88.0	88.08	259200.0
2012-12-24	BJK	ETF	35.34	35.36	35.24	35.36	300.0
2012-12-24	BKF	ETF	39.94	40.2	39.8125	39.88	19693.0
2012-12-24	BKLN	ETF	24.94	24.94	24.9	24.93	604600.0
2012-12-24	BLV	ETF	93.26	93.37	93.14	93.33	34700.0
2012-12-24	BMVP	ETF	16.2	16.22	16.2	16.21	2320.0
2012-12-24	BND	ETF	83.91	83.97	83.89	83.95	830100.0
2012-12-24	BNO	ETF	39.875	40.105	39.875	40.105	5600.0
2012-12-24	BOIL	ETF	809600.0	816600.0	800400.0	805000.0	6.4

> showing 50 of 941 rows — these rows as CSV

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