PREVIEW / etf_daily / 2010-08-27

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-27.parquet
  size:    33 KB
  rows:    770

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-08-27	SPY	ETF	105.89	106.97	104.31	106.86	272649000.0
2010-08-27	QQQ	ETF	43.86	44.16	42.97	44.07	109595931.0
2010-08-27	IWM	ETF	60.77	61.8	59.56	61.65	72003600.0
2010-08-27	DIA	ETF	100.53	101.63	99.4	101.58	10431400.0
2010-08-27	GLD	ETF	121.2	121.45	120.42	121.01	11155400.0
2010-08-27	TLT	ETF	107.77	108.33	105.2	105.35	13514000.0
2010-08-27	AADR	ETF	25.1	25.26	24.95	25.26	10300.0
2010-08-27	AAXJ	ETF	54.76	55.28	54.16	55.25	731500.0
2010-08-27	ACWI	ETF	39.45	39.93	39.0	39.9	90200.0
2010-08-27	ACWX	ETF	37.61	38.07	37.22	38.07	39405.0
2010-08-27	ADRE	ETF	40.54	41.266	40.28	41.25	103333.0
2010-08-27	AFK	ETF	29.82	29.84	29.5888	29.79	8074.0
2010-08-27	AGG	ETF	108.6	108.83	108.12	108.13	475500.0
2010-08-27	AGQ	ETF	129.8	132.56	127.28	129.22	258200.0
2010-08-27	AGZ	ETF	111.28	111.36	110.95	110.95	28818.0
2010-08-27	AIA	ETF	38.97	39.07	38.66	39.07	5886.0
2010-08-27	AIQ	ETF	21.95	22.75	21.25	22.65	20460.0
2010-08-27	AIS	ETF	1.51	1.51	1.47	1.47	254006.0
2010-08-27	AIVI	ETF	39.24	39.71	38.86	39.64	21100.0
2010-08-27	AMJ	ETF	32.0	32.26	31.82	32.22	776305.0
2010-08-27	AMLP	ETF	75.6	75.6	75.0	75.5	272740.0
2010-08-27	AOA	ETF	29.04	29.31	28.85	29.31	25200.0
2010-08-27	AOK	ETF	27.74	27.74	27.71	27.71	13027.0
2010-08-27	AOM	ETF	27.9655	28.146	27.9655	28.13	11751.0
2010-08-27	AOR	ETF	28.45	28.572	28.27	28.52	13216.0
2010-08-27	ARB	ETF	24.63	25.76	24.44	25.71	224745.0
2010-08-27	BAB	ETF	26.85	26.9	26.51	26.59	402997.0
2010-08-27	BAL	ETF	42.3	42.57	41.65	41.65	20352.0
2010-08-27	BALT	ETF	10.99	11.5	10.99	11.5	112407.0
2010-08-27	BBH	ETF	29.7433	30.21	29.4	30.1767	30600.0
2010-08-27	BIB	ETF	5.4013	5.4512	5.4013	5.44	21600.0
2010-08-27	BICK	ETF	28.23	28.42	28.18	28.42	10640.0
2010-08-27	BIL	ETF	91.7	91.72	91.7	91.7	134500.0
2010-08-27	BITS	ETF	24.76	25.0	24.52	25.0	650.0
2010-08-27	BIV	ETF	86.26	86.45	85.57	85.61	214900.0
2010-08-27	BJK	ETF	25.43	25.81	25.27	25.77	12500.0
2010-08-27	BKF	ETF	43.03	43.58	42.5	43.51	98988.0
2010-08-27	BLV	ETF	87.26	88.0	85.51	85.71	68100.0
2010-08-27	BMVP	ETF	12.03	12.1781	11.8567	12.1733	17256.0
2010-08-27	BND	ETF	82.68	82.83	82.36	82.38	736600.0
2010-08-27	BNE	ETF	11.13	11.18	11.11	11.18	231741.0
2010-08-27	BNO	ETF	25.315	25.785	25.28	25.785	181800.0
2010-08-27	BRF	ETF	50.85	51.67	50.411	51.6	208101.0
2010-08-27	BSCE	ETF	20.86	20.86	20.824	20.834	7400.0
2010-08-27	BSV	ETF	81.62	81.63	81.44	81.48	552000.0
2010-08-27	BTF	ETF	68.39999999999999	69.25	67.84949999999999	69.25	1855.4
2010-08-27	BWX	ETF	28.805	28.9498	28.715	28.89	143800.0
2010-08-27	BWZ	ETF	35.0601	35.18	34.999	35.05	9981.0
2010-08-27	BZQ	ETF	3676.8	3739.2	3480.0	3480.0	1077.0
2010-08-27	CEF	ETF	15.36	15.49	15.27	15.37	1062300.0

> showing 50 of 770 rows — these rows as CSV

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