PREVIEW / etf_daily / 2010-09-14

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-14.parquet
  size:    33 KB
  rows:    780

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
2010-09-14	SPY	ETF	112.5	113.29	112.08	112.65	209823600.0
2010-09-14	QQQ	ETF	47.17	47.7	47.08	47.45	91405795.0
2010-09-14	IWM	ETF	65.13	65.62	64.76	64.99	55811200.0
2010-09-14	DIA	ETF	105.48	106.07	105.17	105.44	5077800.0
2010-09-14	GLD	ETF	122.92	124.59	121.55	124.02	26588900.0
2010-09-14	TLT	ETF	103.03	103.82	102.97	103.81	5978100.0
2010-09-14	AADR	ETF	27.14	27.18	27.14	27.14	1300.0
2010-09-14	AAXJ	ETF	57.99	58.5	57.92	58.34	1314700.0
2010-09-14	ACWI	ETF	42.09	42.59	42.01	42.4	140100.0
2010-09-14	ACWX	ETF	40.28	40.76	40.16	40.57	36464.0
2010-09-14	ADRE	ETF	43.64	43.976	43.46	43.61	146120.0
2010-09-14	AFK	ETF	31.02	31.5	30.883	31.35	3421.0
2010-09-14	AGG	ETF	107.82	108.14	107.77	108.13	792300.0
2010-09-14	AGQ	ETF	144.56	148.64	144.5	148.3	188900.0
2010-09-14	AGZ	ETF	110.72	111.0399	110.72	111.03	11672.0
2010-09-14	AIA	ETF	41.1	41.33	40.93	41.26	29469.0
2010-09-14	AIQ	ETF	22.25	22.25	21.8	22.1	12711.0
2010-09-14	AIS	ETF	1.53	1.55	1.5	1.51	222819.0
2010-09-14	AIVI	ETF	41.78	42.52	41.78	42.33	14100.0
2010-09-14	AMJ	ETF	33.0	33.01	32.8606	32.99	388162.0
2010-09-14	AMLP	ETF	76.4	76.45	76.0	76.15	98740.0
2010-09-14	AOA	ETF	31.0	31.04	30.97	30.97	1500.0
2010-09-14	AOK	ETF	28.17	28.23	28.1412	28.2	15222.0
2010-09-14	AOM	ETF	28.79	28.928	28.79	28.85	4622.0
2010-09-14	AOR	ETF	29.52	29.71	29.5	29.6184	17375.0
2010-09-14	ARB	ETF	26.68	27.5	26.5401	27.11	163561.0
2010-09-14	BAB	ETF	26.53	26.65	26.52	26.58	211324.0
2010-09-14	BAL	ETF	45.86	46.25	45.86	45.94	4015.0
2010-09-14	BALT	ETF	11.23	11.23	11.06	11.12	66597.0
2010-09-14	BBH	ETF	31.51	31.88	31.51	31.7633	41100.0
2010-09-14	BIB	ETF	6.1525	6.1725	6.1525	6.1725	10400.0
2010-09-14	BICK	ETF	30.44	30.58	30.16	30.45	7543.0
2010-09-14	BIL	ETF	91.7	91.72	91.7	91.72	46600.0
2010-09-14	BIS	ETF	10276.8	10276.8	10276.8	10276.8	3.125
2010-09-14	BITS	ETF	25.88	25.88	25.56	25.72	1256.0
2010-09-14	BIV	ETF	85.36	85.7	85.32	85.69	92400.0
2010-09-14	BJK	ETF	27.43	27.68	27.21	27.41	50500.0
2010-09-14	BKF	ETF	46.28	46.569	45.94	46.3	90591.0
2010-09-14	BLV	ETF	84.34	84.9	84.34	84.9	15200.0
2010-09-14	BMVP	ETF	12.7967	12.8667	12.7533	12.8133	9604.0
2010-09-14	BND	ETF	82.0	82.2	82.0	82.13	678800.0
2010-09-14	BNE	ETF	11.08	11.09	11.0	11.07	307882.0
2010-09-14	BNO	ETF	26.605	26.605	26.57	26.57	6000.0
2010-09-14	BRF	ETF	55.0	55.512	54.91	55.29	398892.0
2010-09-14	BSCE	ETF	20.81	20.82	20.81	20.82	4154.0
2010-09-14	BSV	ETF	81.37	81.49	81.35	81.46	524500.0
2010-09-14	BTF	ETF	74.35	74.44149999999999	73.55	73.94999999999999	3201.6000000000004
2010-09-14	BWX	ETF	28.78	29.225	28.78	29.195	232462.0
2010-09-14	BWZ	ETF	35.75	36.0399	35.56	35.96	13697.0
2010-09-14	BZQ	ETF	3044.8	3088.0	3019.2	3075.2	603.0

> showing 50 of 780 rows — these rows as CSV

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