PREVIEW / etf_daily / 2012-01-12

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-12.parquet
  size:    37 KB
  rows:    902

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-01-12	SPY	ETF	129.57	129.7	128.54	129.51	118983700.0
2012-01-12	QQQ	ETF	58.29	58.47	57.86	58.39	26188209.0
2012-01-12	IWM	ETF	76.79	76.92	75.94	76.8	36131400.0
2012-01-12	DIA	ETF	124.5	124.67	123.66	124.53	5591300.0
2012-01-12	GLD	ETF	161.02	161.62	159.83	160.38	8602500.0
2012-01-12	TLT	ETF	119.95	120.19	119.24	119.69	7205400.0
2012-01-12	AADR	ETF	28.15	28.25	28.15	28.25	700.0
2012-01-12	AAXJ	ETF	51.87	52.07	51.52	52.0	407700.0
2012-01-12	ACTV	ETF	14.16	15.05	14.09	15.0	710348.0
2012-01-12	ACWI	ETF	43.21	43.31	42.88	43.17	390200.0
2012-01-12	ACWV	ETF	51.62	51.68	51.58	51.65	2800.0
2012-01-12	ACWX	ETF	37.5	37.5	37.17	37.38	157683.0
2012-01-12	ADRE	ETF	40.32	40.5	40.1701	40.36	28007.0
2012-01-12	AFK	ETF	26.42	26.63	26.4	26.63	23650.0
2012-01-12	AGEM	ETF	21.78	21.893	21.67	21.893	4253.0
2012-01-12	AGG	ETF	110.33	110.38	110.17	110.3	844200.0
2012-01-12	AGQ	ETF	200.92	204.08	194.04	196.48	654250.0
2012-01-12	AGZ	ETF	112.95	113.21	112.9327	113.11	7175.0
2012-01-12	AIA	ETF	40.64	40.71	40.272	40.53	11649.0
2012-01-12	AIQ	ETF	5.65	5.85	5.65	5.85	4911.0
2012-01-12	AIS	ETF	2.22	2.2399	2.17	2.2	445248.0
2012-01-12	AIVI	ETF	39.61	39.67	39.34	39.65	59100.0
2012-01-12	AMJ	ETF	38.68	38.83	38.461	38.64	2166349.0
2012-01-12	AMLP	ETF	82.65	82.8	82.25	82.75	524280.0
2012-01-12	AOA	ETF	33.89	33.91	33.66	33.85	6100.0
2012-01-12	AOK	ETF	29.51	29.54	29.44	29.49	94923.0
2012-01-12	AOM	ETF	30.1155	30.189	30.0999	30.15	27161.0
2012-01-12	AOR	ETF	31.64	31.68	31.5404	31.68	12980.0
2012-01-12	ARB	ETF	36.32	36.47	35.71	36.28	78192.0
2012-01-12	ARGT	ETF	22.6	22.68	22.6	22.66	1400.0
2012-01-12	ASEA	ETF	14.9	14.9	14.66	14.84	6000.0
2012-01-12	AWAY	ETF	25.0	25.13	24.07	25.0	246263.0
2012-01-12	BAB	ETF	28.82	28.91	28.75	28.85	209038.0
2012-01-12	BAL	ETF	59.17	59.61	58.31	59.44	18581.0
2012-01-12	BALT	ETF	4.39	4.6	4.35	4.46	125654.0
2012-01-12	BBH	ETF	39.6133	40.0967	39.4567	40.05	43200.0
2012-01-12	BCM	ETF	44.36	44.36	43.93	43.93	2277.0
2012-01-12	BIB	ETF	9.93	10.0013	9.6875	9.9934	113480.0
2012-01-12	BICK	ETF	24.42	24.519	24.32	24.46	13421.0
2012-01-12	BIL	ETF	91.64	91.66	91.64	91.64	344250.0
2012-01-12	BIS	ETF	4648.0	4657.6	4566.4	4566.4	9.05
2012-01-12	BITS	ETF	21.974	22.8	21.96	22.8	1686.0
2012-01-12	BIV	ETF	87.27	87.28	86.95	87.05	154800.0
2012-01-12	BJK	ETF	30.73	31.02	30.53	31.02	25100.0
2012-01-12	BKF	ETF	38.55	38.65	38.34	38.61	188701.0
2012-01-12	BKLN	ETF	24.21	24.21	24.13	24.14	113300.0
2012-01-12	BLV	ETF	91.71	91.81	91.33	91.52	45100.0
2012-01-12	BMVP	ETF	14.03	14.09	14.0	14.08	3990.0
2012-01-12	BND	ETF	83.65	83.65	83.37	83.45	2047900.0
2012-01-12	BNO	ETF	39.555	39.945	38.365	38.455	467400.0

> showing 50 of 902 rows — these rows as CSV

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