PREVIEW / etf_daily / 2010-04-13

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-13.parquet
  size:    32 KB
  rows:    746

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-04-13	SPY	ETF	119.62	120.04	119.0	119.83	125043600.0
2010-04-13	QQQ	ETF	49.02	49.35	48.86	49.32	59375924.0
2010-04-13	IWM	ETF	70.39	70.74	69.94	70.7	42151000.0
2010-04-13	DIA	ETF	110.0	110.44	109.53	110.25	6104100.0
2010-04-13	GLD	ETF	113.12	113.16	112.06	112.69	11261100.0
2010-04-13	TLT	ETF	89.89	89.95	89.52	89.74	3090900.0
2010-04-13	AAXJ	ETF	58.02	58.36	57.86	58.23	100700.0
2010-04-13	ACWI	ETF	44.8	44.8	44.44	44.65	615100.0
2010-04-13	ACWX	ETF	42.82	42.88	42.41	42.73	285258.0
2010-04-13	ADRE	ETF	45.27	45.27	44.76	45.19	96050.0
2010-04-13	AFK	ETF	32.97	32.97	32.11	32.56	94938.0
2010-04-13	AGG	ETF	104.12	104.22	104.05	104.19	680900.0
2010-04-13	AGQ	ETF	126.28	126.5	121.66	125.2	125450.0
2010-04-13	AGZ	ETF	108.18	108.18	107.9601	108.0553	10831.0
2010-04-13	AIA	ETF	41.41	41.6181	41.33	41.6181	22231.0
2010-04-13	AIQ	ETF	26.65	26.85	26.25	26.4	19341.0
2010-04-13	AIS	ETF	1.61	1.63	1.5	1.57	972553.0
2010-04-13	AIVI	ETF	43.9	44.0	43.66	43.93	7400.0
2010-04-13	AMJ	ETF	31.38	31.38	30.905	31.35	413232.0
2010-04-13	AOA	ETF	32.27	33.06	32.08	32.33	16700.0
2010-04-13	AOK	ETF	28.07	28.08	27.982	28.0699	18602.0
2010-04-13	AOM	ETF	29.07	29.1	28.95	29.0778	11483.0
2010-04-13	AOR	ETF	30.26	30.3	30.12	30.28	15556.0
2010-04-13	ARB	ETF	27.0	27.0	26.47	26.94	311066.0
2010-04-13	BAB	ETF	25.09	25.2	25.06	25.15	216703.0
2010-04-13	BAL	ETF	37.94	38.83	37.94	38.67	11794.0
2010-04-13	BALT	ETF	13.73	13.76	13.14	13.25	449030.0
2010-04-13	BBH	ETF	34.4633	34.6967	34.4633	34.6967	55500.0
2010-04-13	BIB	ETF	7.4425	7.5012	7.4425	7.4975	22400.0
2010-04-13	BICK	ETF	30.2299	30.2299	29.78	30.034	15664.0
2010-04-13	BIL	ETF	91.7	91.7	91.68	91.68	96350.0
2010-04-13	BIS	ETF	9600.0	9705.6	9587.2	9587.2	10.6
2010-04-13	BITS	ETF	31.94	31.94	31.8408	31.92	615.0
2010-04-13	BIV	ETF	80.22	80.3	80.08	80.25	75000.0
2010-04-13	BJK	ETF	27.3	27.3	27.03	27.26	13800.0
2010-04-13	BKF	ETF	47.9	47.95	47.3425	47.91	361395.0
2010-04-13	BLV	ETF	77.08	77.22	76.9	77.17	28800.0
2010-04-13	BMVP	ETF	13.45	13.52	13.42	13.51	8985.0
2010-04-13	BND	ETF	79.18	79.2	79.07	79.18	464600.0
2010-04-13	BNE	ETF	11.13	11.16	11.12	11.16	423880.0
2010-04-13	BRF	ETF	46.16	46.7	45.791	46.54	442520.0
2010-04-13	BSV	ETF	79.85	79.88	79.77	79.85	426400.0
2010-04-13	BTF	ETF	74.74999999999999	75.25	74.6	74.85	3108.4
2010-04-13	BWX	ETF	28.01	28.09	27.9225	28.045	429004.0
2010-04-13	BWZ	ETF	35.96	35.96	35.75	35.91	73580.0
2010-04-13	BZQ	ETF	3459.2	3544.0	3416.0	3443.2	558.0
2010-04-13	CEF	ETF	14.67	14.67	14.39	14.52	651300.0
2010-04-13	CEW	ETF	22.45	22.45	22.4	22.44	175489.0
2010-04-13	CGO	ETF	15.05	15.06	14.91	14.982	55491.0
2010-04-13	CGW	ETF	18.94	18.94	18.74	18.83	41745.0

> showing 50 of 746 rows — these rows as CSV

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