PREVIEW / etf_daily / 2012-10-01

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-01.parquet
  size:    39 KB
  rows:    947

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-01	SPY	ETF	144.52	145.69	144.01	144.35	135911200.0
2012-10-01	QQQ	ETF	68.9	69.33	68.25	68.47	37715207.0
2012-10-01	IWM	ETF	83.96	84.54	83.31	83.72	43705600.0
2012-10-01	DIA	ETF	134.62	135.69	134.53	134.78	4854000.0
2012-10-01	GLD	ETF	172.83	173.62	171.77	172.29	10676400.0
2012-10-01	TLT	ETF	123.97	124.47	123.38	124.42	4842600.0
2012-10-01	AADR	ETF	30.16	30.32	30.16	30.26	1600.0
2012-10-01	AAXJ	ETF	56.58	57.19	56.53	56.79	457400.0
2012-10-01	ACTV	ETF	12.56	12.63	12.05	12.06	1178284.0
2012-10-01	ACWI	ETF	47.1	47.34	46.85	46.94	555100.0
2012-10-01	ACWV	ETF	56.95	57.1	56.79	56.85	121700.0
2012-10-01	ACWX	ETF	39.92	40.17	39.732	39.8	267150.0
2012-10-01	ADRE	ETF	39.33	39.81	39.33	39.52	19361.0
2012-10-01	AFK	ETF	31.13	31.2499	31.0	31.01	42073.0
2012-10-01	AGG	ETF	112.17	112.25	112.07	112.2	1674400.0
2012-10-01	AGQ	ETF	237.84	242.16	234.12	236.12	556875.0
2012-10-01	AGZ	ETF	114.01	114.01	113.85	113.98	376654.0
2012-10-01	AIA	ETF	44.8	45.16	44.77	44.79	10977.0
2012-10-01	AIQ	ETF	6.9	7.0	6.8	6.85	1495.0
2012-10-01	AIVI	ETF	40.42	40.74	40.21	40.26	43000.0
2012-10-01	ALTL	ETF	25.87	25.87	25.87	25.87	400.0
2012-10-01	AMJ	ETF	40.5	40.9098	40.37	40.76	538317.0
2012-10-01	AMLP	ETF	83.0	83.85	82.9	83.5	334740.0
2012-10-01	ANGL	ETF	26.39	26.39	26.39	26.39	200.0
2012-10-01	AOA	ETF	36.83	36.98	36.68	36.73	9500.0
2012-10-01	AOK	ETF	30.6148	30.6283	30.54	30.56	15385.0
2012-10-01	AOM	ETF	31.65	31.7265	31.57	31.62	21107.0
2012-10-01	AOR	ETF	33.8	33.92	33.7007	33.75	44917.0
2012-10-01	ARB	ETF	37.89	38.36	37.73	37.98	82474.0
2012-10-01	ARGT	ETF	17.82	18.1	17.82	18.1	2500.0
2012-10-01	ASEA	ETF	16.75	16.85	16.67	16.67	2900.0
2012-10-01	AWAY	ETF	23.65	23.89	23.11	23.7322	444811.0
2012-10-01	BAB	ETF	30.05	30.15	30.03	30.13	265934.0
2012-10-01	BAL	ETF	47.4	48.8784	46.27	46.6813	11958.0
2012-10-01	BALT	ETF	3.26	3.26	3.12	3.13	51364.0
2012-10-01	BBH	ETF	54.47	54.98	54.39	54.54	26100.0
2012-10-01	BCM	ETF	46.7	46.7	46.5699	46.5699	700.0
2012-10-01	BIB	ETF	15.9775	16.1875	15.9375	16.0585	18440.0
2012-10-01	BICK	ETF	23.96	24.149	23.94	23.98	8200.0
2012-10-01	BIL	ETF	91.62	91.64	91.62	91.62	165100.0
2012-10-01	BIS	ETF	2534.4	2534.4	2494.24	2507.2	47.6
2012-10-01	BIV	ETF	90.02	90.23	90.0	90.23	326800.0
2012-10-01	BJK	ETF	34.26	34.59	34.07	34.07	2400.0
2012-10-01	BKF	ETF	38.09	38.42	38.05	38.13	116929.0
2012-10-01	BKLN	ETF	24.95	25.0	24.95	24.96	1062900.0
2012-10-01	BLV	ETF	96.35	96.73	96.12	96.64	237600.0
2012-10-01	BMVP	ETF	16.15	16.24	16.1465	16.16	41121.0
2012-10-01	BND	ETF	84.95	85.05	84.93	85.04	994800.0
2012-10-01	BNO	ETF	40.7	40.89	40.325	40.49	96000.0
2012-10-01	BOIL	ETF	1082400.0	1124400.0	1078200.0	1115200.0	23.2

> showing 50 of 947 rows — these rows as CSV

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