PREVIEW / etf_daily / 2012-03-30

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-30.parquet
  size:    38 KB
  rows:    916

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-03-30	SPY	ETF	140.92	141.05	140.05	140.81	135486800.0
2012-03-30	QQQ	ETF	67.99	68.02	67.28	67.55	39480224.0
2012-03-30	IWM	ETF	83.59	83.6	82.53	82.81	45904700.0
2012-03-30	DIA	ETF	131.71	131.97	131.18	131.8	4218500.0
2012-03-30	GLD	ETF	161.67	162.33	161.22	162.12	7534000.0
2012-03-30	TLT	ETF	114.21	114.27	112.19	112.2	9467500.0
2012-03-30	AADR	ETF	31.02	31.02	30.95	30.95	1200.0
2012-03-30	AAXJ	ETF	56.59	56.59	56.19	56.44	281200.0
2012-03-30	ACTV	ETF	17.14	17.15	16.83	16.83	223577.0
2012-03-30	ACWI	ETF	47.2	47.25	46.92	47.2	2018200.0
2012-03-30	ACWV	ETF	54.53	54.53	54.53	54.53	100.0
2012-03-30	ACWX	ETF	40.94	40.94	40.59	40.83	194084.0
2012-03-30	ADRE	ETF	42.23	42.36	41.97	42.22	14099.0
2012-03-30	AFK	ETF	29.48	29.5	29.25	29.5	2625.0
2012-03-30	AGEM	ETF	23.25	23.41	23.22	23.22	731.0
2012-03-30	AGG	ETF	110.11	110.11	109.69	109.85	1121300.0
2012-03-30	AGQ	ETF	220.96	222.56	217.2	217.84	339725.0
2012-03-30	AGZ	ETF	112.47	112.82	112.41	112.64	52684.0
2012-03-30	AIA	ETF	44.65	44.756	44.3	44.5	41729.0
2012-03-30	AIQ	ETF	7.3	7.55	7.05	7.5	29968.0
2012-03-30	AIS	ETF	3.25	3.35	3.23	3.23	1096922.0
2012-03-30	AIVI	ETF	41.95	41.95	41.66	41.81	22300.0
2012-03-30	AMJ	ETF	38.81	39.22	38.75	39.14	1998926.0
2012-03-30	AMLP	ETF	82.65	83.35	82.55	83.2	351420.0
2012-03-30	AOA	ETF	36.51	36.52	36.39	36.45	19200.0
2012-03-30	AOK	ETF	30.18	30.2096	30.138	30.18	8840.0
2012-03-30	AOM	ETF	31.25	31.27	31.2145	31.22	43771.0
2012-03-30	AOR	ETF	33.39	33.39	33.24	33.342	19355.0
2012-03-30	ARB	ETF	37.01	37.37	36.8	36.98	278279.0
2012-03-30	ARGT	ETF	21.4	21.4	21.4	21.4	50.0
2012-03-30	ASEA	ETF	16.21	16.22	16.1	16.22	1100.0
2012-03-30	AWAY	ETF	25.27	25.77	24.99	25.33	261920.0
2012-03-30	BAB	ETF	29.22	29.27	29.02	29.06	107242.0
2012-03-30	BAL	ETF	56.21	56.92	56.21	56.63	32220.0
2012-03-30	BALT	ETF	4.1	4.22	4.08	4.15	107176.0
2012-03-30	BBH	ETF	44.28	44.57	44.2	44.5	70800.0
2012-03-30	BCM	ETF	45.13	45.5	45.1	45.34	11313.0
2012-03-30	BIB	ETF	12.0488	12.0686	11.9262	12.0087	39424.0
2012-03-30	BICK	ETF	26.29	26.34	26.19	26.28	11493.0
2012-03-30	BIL	ETF	91.64	91.66	91.64	91.64	102250.0
2012-03-30	BIS	ETF	3668.8	3668.8	3648.0	3664.0	45.45
2012-03-30	BIV	ETF	87.18	87.27	86.85	86.96	167600.0
2012-03-30	BJK	ETF	36.21	36.21	35.64	35.83	8700.0
2012-03-30	BKF	ETF	41.2	41.2	40.7	40.88	107638.0
2012-03-30	BKLN	ETF	24.55	24.6	24.54	24.58	724900.0
2012-03-30	BLNG	ETF	51.0045	51.0045	51.0045	51.0045	300.0
2012-03-30	BLV	ETF	89.84	90.0	88.8	88.91	37500.0
2012-03-30	BMVP	ETF	15.54	15.57	15.54	15.55	3150.0
2012-03-30	BND	ETF	83.47	83.5	83.21	83.28	1454300.0
2012-03-30	BNO	ETF	43.28	43.57	43.105	43.15	49800.0

> showing 50 of 916 rows — these rows as CSV

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