PREVIEW / etf_daily / 2010-06-21

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-21.parquet
  size:    33 KB
  rows:    762

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-06-21	SPY	ETF	113.12	113.2	110.79	111.41	213140700.0
2010-06-21	QQQ	ETF	47.6	47.68	46.33	46.6	95488065.0
2010-06-21	IWM	ETF	67.87	68.0	65.72	66.11	58648400.0
2010-06-21	DIA	ETF	105.73	105.96	103.96	104.45	10258800.0
2010-06-21	GLD	ETF	123.09	123.11	120.36	120.39	20041700.0
2010-06-21	TLT	ETF	96.46	97.55	96.41	97.41	5740900.0
2010-06-21	AAXJ	ETF	55.73	56.24	55.37	55.57	2218600.0
2010-06-21	ACWI	ETF	41.3	41.52	40.71	40.91	123600.0
2010-06-21	ACWX	ETF	38.78	38.86	38.04	38.18	104661.0
2010-06-21	ADRE	ETF	42.43	42.81	41.982	42.18	74657.0
2010-06-21	AFK	ETF	29.8	29.86	29.325	29.36	11661.0
2010-06-21	AGG	ETF	105.97	106.28	105.82	106.28	696100.0
2010-06-21	AGQ	ETF	135.58	135.94	126.56	127.18	435300.0
2010-06-21	AGZ	ETF	109.5085	109.63	109.475	109.612	8398.0
2010-06-21	AIA	ETF	39.45	39.45	38.74	38.88	54334.0
2010-06-21	AIQ	ETF	25.6	25.9	24.25	24.35	11832.0
2010-06-21	AIS	ETF	1.97	2.0	1.81	1.81	1425774.0
2010-06-21	AIVI	ETF	40.07	40.11	39.26	39.35	27800.0
2010-06-21	AMJ	ETF	30.88	31.17	30.4	30.57	494068.0
2010-06-21	AOA	ETF	30.61	30.61	30.11	30.11	7000.0
2010-06-21	AOK	ETF	27.87	27.9991	27.78	27.79	29862.0
2010-06-21	AOM	ETF	28.5	28.54	28.286	28.286	22842.0
2010-06-21	AOR	ETF	29.33	29.33	29.002	29.06	12734.0
2010-06-21	ARB	ETF	28.56	28.93	28.0	28.17	128335.0
2010-06-21	BAB	ETF	25.76	25.832	25.67	25.8	242582.0
2010-06-21	BAL	ETF	38.5185	38.66	38.5185	38.652	810.0
2010-06-21	BALT	ETF	12.68	12.76	12.3	12.34	95283.0
2010-06-21	BBH	ETF	31.1533	31.4667	30.79	30.8967	288000.0
2010-06-21	BICK	ETF	29.2	29.35	29.03	29.06	1979.0
2010-06-21	BIL	ETF	91.7	91.72	91.7	91.7	787600.0
2010-06-21	BITS	ETF	27.84	28.72	27.8	28.56	1173.0
2010-06-21	BIV	ETF	81.87	82.3	81.8	82.22	178400.0
2010-06-21	BJK	ETF	25.48	25.6	25.02	25.06	108900.0
2010-06-21	BKF	ETF	44.57	44.65	43.87	44.07	357092.0
2010-06-21	BLV	ETF	79.79	80.32	79.35	80.29	26600.0
2010-06-21	BMVP	ETF	12.8233	12.8631	12.6	12.6	6102.0
2010-06-21	BND	ETF	80.46	80.68	80.46	80.64	624500.0
2010-06-21	BNE	ETF	11.21	11.22	11.19	11.22	509470.0
2010-06-21	BNO	ETF	26.98	26.98	26.48	26.64	38400.0
2010-06-21	BOSS	ETF	29.34	29.745	29.0	29.0	1500.0
2010-06-21	BRF	ETF	46.51	46.74	45.6503	45.87	371968.0
2010-06-21	BSCE	ETF	20.24	20.24	20.22	20.22	8250.0
2010-06-21	BSV	ETF	80.47	80.57	80.44	80.57	481200.0
2010-06-21	BTF	ETF	68.15	68.94999999999999	67.85	67.85	10116.800000000001
2010-06-21	BWX	ETF	26.85	26.85	26.66	26.745	218354.0
2010-06-21	BWZ	ETF	33.8699	33.87	33.74	33.75	5085.0
2010-06-21	BZQ	ETF	3670.4	3814.4	3638.4	3761.6	795.0
2010-06-21	CEF	ETF	15.4	15.48	14.99	15.03	1255100.0
2010-06-21	CEW	ETF	21.8	21.82	21.71	21.75	355271.0
2010-06-21	CGO	ETF	13.32	13.386	13.26	13.29	28121.0

> showing 50 of 762 rows — these rows as CSV

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