PREVIEW / etf_daily / 2012-02-01

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-01.parquet
  size:    37 KB
  rows:    903

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-02-01	SPY	ETF	132.29	133.14	132.13	132.47	166234500.0
2012-02-01	QQQ	ETF	60.85	61.24	60.66	61.02	46146664.0
2012-02-01	IWM	ETF	79.76	80.9	79.47	80.72	67292200.0
2012-02-01	DIA	ETF	127.07	127.59	126.77	126.91	9891000.0
2012-02-01	GLD	ETF	169.75	170.18	169.08	169.56	7734200.0
2012-02-01	TLT	ETF	119.75	119.9	118.81	119.18	7925200.0
2012-02-01	AADR	ETF	29.72	29.73	29.68	29.68	16100.0
2012-02-01	AAXJ	ETF	55.81	56.35	55.76	56.02	313500.0
2012-02-01	ACTV	ETF	14.75	15.0	14.69	14.73	219400.0
2012-02-01	ACWI	ETF	44.97	45.3	44.95	45.05	1871500.0
2012-02-01	ACWV	ETF	52.83	52.83	52.67	52.67	1100.0
2012-02-01	ACWX	ETF	39.65	39.93	39.561	39.72	522992.0
2012-02-01	ADRE	ETF	42.9	43.5	42.9	43.25	40882.0
2012-02-01	AFK	ETF	28.55	28.83	28.55	28.75	21153.0
2012-02-01	AGEM	ETF	23.49	23.65	23.49	23.61	969.0
2012-02-01	AGG	ETF	110.61	110.72	110.45	110.58	1965000.0
2012-02-01	AGQ	ETF	246.0	247.64	241.0	243.52	471775.0
2012-02-01	AGZ	ETF	113.45	113.46	113.041	113.43	10414.0
2012-02-01	AIA	ETF	43.36	43.8	43.35	43.59	72676.0
2012-02-01	AIQ	ETF	5.8	6.0	5.65	6.0	15641.0
2012-02-01	AIS	ETF	2.66	2.71	2.59	2.63	3444522.0
2012-02-01	AIVI	ETF	41.06	41.34	41.0	41.06	81200.0
2012-02-01	AMJ	ETF	39.88	40.22	39.8	40.22	1327535.0
2012-02-01	AMLP	ETF	84.5	84.75	84.25	84.7	425520.0
2012-02-01	AOA	ETF	34.93	35.2	34.91	35.1	7900.0
2012-02-01	AOK	ETF	29.91	29.96	29.87	29.87	51698.0
2012-02-01	AOM	ETF	30.7	30.78	30.68	30.68	41585.0
2012-02-01	AOR	ETF	32.3732	32.516	32.3732	32.44	36150.0
2012-02-01	ARB	ETF	35.87	35.87	34.04	34.28	610806.0
2012-02-01	ARGT	ETF	23.6	23.64	23.44	23.64	650.0
2012-02-01	ASEA	ETF	15.74	15.9	15.74	15.79	56200.0
2012-02-01	AWAY	ETF	26.96	27.14	25.8	26.7	748734.0
2012-02-01	BAB	ETF	29.28	29.319	29.21	29.3056	229992.0
2012-02-01	BAL	ETF	58.12	58.189	57.679	57.79	8222.0
2012-02-01	BALT	ETF	4.26	4.28	4.11	4.2	133229.0
2012-02-01	BBH	ETF	42.16	42.9533	42.16	42.89	22200.0
2012-02-01	BCM	ETF	45.92	45.92	45.165	45.24	11424.0
2012-02-01	BIB	ETF	10.8413	11.1724	10.8413	11.1308	80936.0
2012-02-01	BICK	ETF	27.06	27.25	26.92	27.1533	58303.0
2012-02-01	BIL	ETF	91.64	91.66	91.64	91.64	362600.0
2012-02-01	BIS	ETF	4188.8	4188.8	4016.0	4043.2	85.5
2012-02-01	BITS	ETF	22.4	22.68	22.2	22.48	2575.0
2012-02-01	BIV	ETF	88.04	88.07	87.9	88.01	493300.0
2012-02-01	BJK	ETF	33.31	33.59	33.31	33.47	37200.0
2012-02-01	BKF	ETF	41.7	42.37	41.69	42.19	238906.0
2012-02-01	BKLN	ETF	24.39	24.45	24.39	24.42	149100.0
2012-02-01	BLV	ETF	92.17	92.26	91.71	91.71	149500.0
2012-02-01	BMVP	ETF	14.46	14.68	14.46	14.6	6248.0
2012-02-01	BND	ETF	83.85	83.91	83.74	83.78	2908500.0
2012-02-01	BNO	ETF	39.025	39.185	38.725	38.895	88200.0

> showing 50 of 903 rows — these rows as CSV

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