PREVIEW / etf_daily / 2010-12-21

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-21.parquet
  size:    35 KB
  rows:    818

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-12-21	SPY	ETF	124.99	125.47	124.87	125.39	94965500.0
2010-12-21	QQQ	ETF	54.7602	54.89	54.62	54.89	35775349.0
2010-12-21	IWM	ETF	78.65	79.28	78.59	79.2	30166800.0
2010-12-21	DIA	ETF	115.11	115.46	114.99	115.31	4783100.0
2010-12-21	GLD	ETF	135.17	135.78	134.79	135.32	10235600.0
2010-12-21	TLT	ETF	93.13	93.79	92.49	93.79	8985100.0
2010-12-21	AADR	ETF	29.53	29.58	29.46	29.55	10700.0
2010-12-21	AAXJ	ETF	62.7	62.92	62.54	62.79	186800.0
2010-12-21	ACWI	ETF	46.28	46.36	46.17	46.3	488400.0
2010-12-21	ACWX	ETF	43.29	43.48	43.29	43.43	70797.0
2010-12-21	ADRE	ETF	46.64	47.1481	46.64	46.94	41883.0
2010-12-21	AFK	ETF	34.66	34.701	34.54	34.67	14666.0
2010-12-21	AGG	ETF	105.49	105.65	105.38	105.64	1520300.0
2010-12-21	AGQ	ETF	284.72	288.82	281.32	287.04	322500.0
2010-12-21	AGZ	ETF	109.52	109.66	109.41	109.545	22839.0
2010-12-21	AIA	ETF	45.83	46.15	45.83	46.1099	56096.0
2010-12-21	AIQ	ETF	18.85	18.85	18.45	18.8	53895.0
2010-12-21	AIS	ETF	1.7	1.7	1.65	1.69	493591.0
2010-12-21	AIVI	ETF	43.97	44.0	43.84	43.91	62800.0
2010-12-21	AMJ	ETF	35.1	35.46	35.1	35.46	1639955.0
2010-12-21	AMLP	ETF	78.65	78.9	78.45	78.9	107840.0
2010-12-21	AOA	ETF	34.32	34.4	34.3	34.39	13900.0
2010-12-21	AOK	ETF	28.76	28.76	28.69	28.7534	2797.0
2010-12-21	AOM	ETF	29.945	30.03	29.92	30.03	43575.0
2010-12-21	AOR	ETF	31.54	31.62	31.5101	31.62	44307.0
2010-12-21	ARB	ETF	40.96	42.12	40.96	42.04	325075.0
2010-12-21	BAB	ETF	24.8	24.92	24.72	24.87	340504.0
2010-12-21	BAL	ETF	84.09	84.54	79.351	79.6899	119756.0
2010-12-21	BALT	ETF	10.88	10.89	10.67	10.78	238412.0
2010-12-21	BBH	ETF	33.9933	33.9933	33.81	33.8933	45600.0
2010-12-21	BIB	ETF	7.6662	7.698	7.6662	7.698	8800.0
2010-12-21	BICK	ETF	32.13	32.24	32.07	32.17	67131.0
2010-12-21	BIL	ETF	91.72	91.72	91.7	91.72	103350.0
2010-12-21	BIS	ETF	7975.984	7975.984	7929.6	7929.6	3.445
2010-12-21	BITS	ETF	28.76	28.8	28.12	28.76	2357.0
2010-12-21	BIV	ETF	82.99	83.14	82.72	83.02	363000.0
2010-12-21	BJK	ETF	31.87	31.99	31.77	31.88	19300.0
2010-12-21	BKF	ETF	48.32	48.62	48.09	48.49	130316.0
2010-12-21	BLV	ETF	79.01	79.38	78.64	79.38	27500.0
2010-12-21	BMVP	ETF	14.64	14.7167	14.64	14.7	9604.0
2010-12-21	BND	ETF	80.55	80.6	80.38	80.58	1499700.0
2010-12-21	BNO	ETF	30.865	31.055	30.865	31.055	17400.0
2010-12-21	BRF	ETF	57.85	58.2899	57.84	57.86	559941.0
2010-12-21	BSCE	ETF	20.7	20.71	20.677	20.706	8830.0
2010-12-21	BSV	ETF	80.77	80.84	80.74	80.77	493900.0
2010-12-21	BTF	ETF	77.75	77.75	77.1	77.5	1302.0
2010-12-21	BWX	ETF	28.665	28.715	28.545	28.595	214860.0
2010-12-21	BWZ	ETF	36.27	36.27	35.88	35.924	42559.0
2010-12-21	BZQ	ETF	2708.8	2718.4	2635.2	2668.8	786.0
2010-12-21	CEF	ETF	19.97	20.01	19.86	19.99	543600.0

> showing 50 of 818 rows — these rows as CSV

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