PREVIEW / etf_daily / 2010-09-20

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-20.parquet
  size:    34 KB
  rows:    788

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-20	SPY	ETF	112.88	114.46	112.52	114.21	214555200.0
2010-09-20	QQQ	ETF	48.18	48.93	48.1101	48.8299	84536536.0
2010-09-20	IWM	ETF	65.42	67.2	64.97	67.02	70669500.0
2010-09-20	DIA	ETF	106.4	107.72	106.2	107.52	5257500.0
2010-09-20	GLD	ETF	125.09	125.45	124.78	124.87	8475800.0
2010-09-20	TLT	ETF	102.15	102.45	101.69	102.26	5277800.0
2010-09-20	AADR	ETF	27.74	27.81	27.74	27.81	500.0
2010-09-20	AAXJ	ETF	58.83	59.3	58.7	59.18	188500.0
2010-09-20	ACWI	ETF	42.55	43.05	42.35	42.97	522800.0
2010-09-20	ACWX	ETF	40.4506	41.01	40.45	40.95	27865.0
2010-09-20	ADRE	ETF	43.21	43.72	43.137	43.66	68170.0
2010-09-20	AFK	ETF	31.43	31.72	31.38	31.705	16412.0
2010-09-20	AGG	ETF	107.85	108.0	107.77	107.93	717000.0
2010-09-20	AGQ	ETF	153.3	154.82	151.2	151.54	246600.0
2010-09-20	AGZ	ETF	110.78	110.992	110.78	110.9	8418.0
2010-09-20	AIA	ETF	41.41	41.72	41.35	41.71	20746.0
2010-09-20	AIQ	ETF	21.5	23.0	21.4	22.9	31941.0
2010-09-20	AIS	ETF	1.48	1.49	1.41	1.45	739782.0
2010-09-20	AIVI	ETF	42.04	42.48	41.97	42.48	8700.0
2010-09-20	AMJ	ETF	32.97	33.19	32.92	33.15	930528.0
2010-09-20	AMLP	ETF	76.3	76.45	76.0	76.3	97260.0
2010-09-20	AOA	ETF	30.98	31.4	30.98	31.35	6400.0
2010-09-20	AOK	ETF	28.2276	28.27	28.21	28.232	1065.0
2010-09-20	AOM	ETF	28.91	29.06	28.9	29.06	9443.0
2010-09-20	AOR	ETF	29.63	29.9176	29.63	29.9176	1559.0
2010-09-20	ARB	ETF	27.75	28.67	27.75	28.57	111782.0
2010-09-20	BAB	ETF	26.4	26.42	26.3	26.39	138036.0
2010-09-20	BAL	ETF	49.49	49.72	48.3601	48.485	57617.0
2010-09-20	BALT	ETF	11.11	11.4	11.02	11.32	118805.0
2010-09-20	BBH	ETF	31.85	32.3933	31.8467	32.3333	49200.0
2010-09-20	BIB	ETF	6.2637	6.44	6.2637	6.4287	42400.0
2010-09-20	BICK	ETF	30.71	30.8125	30.5865	30.7734	19968.0
2010-09-20	BIL	ETF	91.7	91.72	91.7	91.7	371900.0
2010-09-20	BIS	ETF	9972.8	9972.8	9840.0	9840.0	1.875
2010-09-20	BITS	ETF	28.8	28.8	27.0	27.12	5709.0
2010-09-20	BIV	ETF	85.55	85.63	85.32	85.63	138900.0
2010-09-20	BJK	ETF	27.36	27.81	27.35	27.81	6500.0
2010-09-20	BKF	ETF	46.45	46.78	46.15	46.675	101730.0
2010-09-20	BLV	ETF	83.92	84.02	83.71	83.9	58900.0
2010-09-20	BMVP	ETF	12.81	13.0	12.78	12.98	12277.0
2010-09-20	BND	ETF	81.98	82.09	81.95	82.06	510300.0
2010-09-20	BNE	ETF	11.08	11.1	11.07	11.08	337166.0
2010-09-20	BNO	ETF	26.665	26.665	26.665	26.665	400.0
2010-09-20	BRF	ETF	55.32	55.629	55.2	55.4	344090.0
2010-09-20	BSCE	ETF	20.83	20.83	20.803	20.8299	7915.0
2010-09-20	BSV	ETF	81.5	81.53	81.45	81.49	443600.0
2010-09-20	BTF	ETF	74.25	75.25	74.25	75.25	5144.200000000001
2010-09-20	BWX	ETF	28.8	28.97	28.765	28.77	261300.0
2010-09-20	BWZ	ETF	35.75	35.95	35.7	35.87	46200.0
2010-09-20	BZQ	ETF	3113.6	3137.6	3068.8	3078.4	395.0

> showing 50 of 788 rows — these rows as CSV

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