PREVIEW / etf_daily / 2012-04-11

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-11.parquet
  size:    38 KB
  rows:    933

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-04-11	SPY	ETF	137.29	137.54	136.75	137.0	154133000.0
2012-04-11	QQQ	ETF	66.705	66.89	66.28	66.45	62949946.0
2012-04-11	IWM	ETF	79.01	79.57	78.85	79.46	54346800.0
2012-04-11	DIA	ETF	128.17	128.29	127.74	127.85	5603300.0
2012-04-11	GLD	ETF	161.2	161.54	160.74	161.07	10005400.0
2012-04-11	TLT	ETF	115.71	116.06	115.35	115.46	8713000.0
2012-04-11	AAXJ	ETF	55.4	55.58	55.22	55.35	323900.0
2012-04-11	ACTV	ETF	16.41	16.56	16.34	16.55	156172.0
2012-04-11	ACWI	ETF	45.77	45.78	45.51	45.57	913800.0
2012-04-11	ACWV	ETF	53.43	53.43	53.43	53.43	500.0
2012-04-11	ACWX	ETF	39.43	39.46	39.16	39.22	127427.0
2012-04-11	ADRE	ETF	41.04	41.06	40.79	40.83	21890.0
2012-04-11	AFK	ETF	28.3	28.504	28.3	28.32	9040.0
2012-04-11	AGEM	ETF	22.54	22.67	22.54	22.587	6177.0
2012-04-11	AGG	ETF	110.05	110.13	109.89	110.13	1203100.0
2012-04-11	AGQ	ETF	208.48	210.72	204.92	207.32	321000.0
2012-04-11	AGZ	ETF	112.8	112.8599	112.48	112.49	61702.0
2012-04-11	AIA	ETF	43.91	43.96	43.742	43.742	17241.0
2012-04-11	AIQ	ETF	7.35	7.45	7.05	7.45	18111.0
2012-04-11	AIS	ETF	2.99	3.11	2.99	3.05	727773.0
2012-04-11	AIVI	ETF	39.99	40.06	39.78	39.8	39500.0
2012-04-11	AMJ	ETF	38.36	38.44	38.18	38.31	760156.0
2012-04-11	AMLP	ETF	81.5	82.4	81.5	81.8	314000.0
2012-04-11	ANGL	ETF	25.15	25.15	25.13	25.15	1200.0
2012-04-11	AOA	ETF	35.52	35.56	35.43	35.46	10800.0
2012-04-11	AOK	ETF	29.8864	29.89	29.85	29.85	11490.0
2012-04-11	AOM	ETF	30.86	30.87	30.805	30.82	13706.0
2012-04-11	AOR	ETF	32.76	32.76	32.67	32.67	20253.0
2012-04-11	ARB	ETF	36.38	37.57	36.26	37.35	285291.0
2012-04-11	ARGT	ETF	19.78	20.06	19.78	19.88	250.0
2012-04-11	ASEA	ETF	15.82	15.94	15.82	15.9	2300.0
2012-04-11	AWAY	ETF	23.84	23.92	23.55	23.6	144527.0
2012-04-11	BAB	ETF	29.47	29.53	29.25	29.44	149797.0
2012-04-11	BAL	ETF	55.15	55.75	54.96	55.0	31972.0
2012-04-11	BALT	ETF	4.1	4.18	4.02	4.06	129021.0
2012-04-11	BBH	ETF	43.34	43.36	42.96	43.02	36100.0
2012-04-11	BCM	ETF	44.69	44.779	44.57	44.57	20161.0
2012-04-11	BIB	ETF	11.1013	11.3175	10.915	11.1813	26080.0
2012-04-11	BICK	ETF	25.64	25.64	25.33	25.3521	10962.0
2012-04-11	BIL	ETF	91.64	91.66	91.64	91.66	1014250.0
2012-04-11	BIS	ETF	3920.0	3920.0	3844.48	3900.8	38.55
2012-04-11	BIV	ETF	87.41	87.47	87.31	87.4	510900.0
2012-04-11	BJK	ETF	35.47	35.72	35.46	35.59	5900.0
2012-04-11	BKF	ETF	40.22	40.22	39.83	39.95	83492.0
2012-04-11	BKLN	ETF	24.51	24.55	24.41	24.52	95800.0
2012-04-11	BLV	ETF	90.0	90.43	89.96	90.17	22700.0
2012-04-11	BMVP	ETF	15.18	15.18	15.18	15.18	108.0
2012-04-11	BND	ETF	83.5	83.51	83.4	83.49	1017900.0
2012-04-11	BNO	ETF	42.08	42.38	41.995	42.18	44400.0
2012-04-11	BOIL	ETF	693000.0	697000.0	654000.0	657000.0	13.2

> showing 50 of 933 rows — these rows as CSV

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