PREVIEW / etf_daily / 2010-12-20

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-20.parquet
  size:    35 KB
  rows:    815

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-20	SPY	ETF	124.64	124.9	123.98	124.6	119085500.0
2010-12-20	QQQ	ETF	54.59	54.76	54.16	54.56	48159595.0
2010-12-20	IWM	ETF	78.31	78.81	77.93	78.33	42692700.0
2010-12-20	DIA	ETF	115.14	115.15	114.38	114.75	6742100.0
2010-12-20	GLD	ETF	135.13	135.44	134.33	135.11	13142300.0
2010-12-20	TLT	ETF	93.75	94.23	92.64	93.14	13703500.0
2010-12-20	AADR	ETF	29.31	29.31	29.31	29.31	600.0
2010-12-20	AAXJ	ETF	62.84	62.84	62.41	62.56	678200.0
2010-12-20	ACWI	ETF	46.26	46.57	46.13	46.35	428600.0
2010-12-20	ACWX	ETF	43.68	43.68	43.305	43.51	545986.0
2010-12-20	ADRE	ETF	46.53	46.54	46.1501	46.26	117842.0
2010-12-20	AFK	ETF	34.6	34.71	34.17	34.39	38851.0
2010-12-20	AGG	ETF	105.41	105.67	105.26	105.44	930100.0
2010-12-20	AGQ	ETF	284.88	291.12	276.6	288.72	405900.0
2010-12-20	AGZ	ETF	109.67	109.67	109.418	109.44	9278.0
2010-12-20	AIA	ETF	45.8	45.8	45.408	45.58	30207.0
2010-12-20	AIQ	ETF	19.3	19.5	18.7	18.7	36718.0
2010-12-20	AIS	ETF	1.63	1.73	1.6	1.69	1403606.0
2010-12-20	AIVI	ETF	43.58	43.63	43.33	43.61	63900.0
2010-12-20	AMJ	ETF	34.85	35.129	34.54	35.1	1549380.0
2010-12-20	AMLP	ETF	78.65	78.75	78.15	78.45	107280.0
2010-12-20	AOA	ETF	34.21	34.21	34.03	34.15	15700.0
2010-12-20	AOK	ETF	28.72	28.72	28.65	28.69	105908.0
2010-12-20	AOM	ETF	29.9	30.01	29.8155	30.01	36927.0
2010-12-20	AOR	ETF	31.38	31.46	31.33	31.46	24665.0
2010-12-20	ARB	ETF	41.2	41.62	40.81	40.9	288781.0
2010-12-20	BAB	ETF	25.02	25.02	24.8	24.82	300438.0
2010-12-20	BAL	ETF	78.95	82.6399	78.47	82.2	84376.0
2010-12-20	BALT	ETF	10.91	11.02	10.72	10.85	127017.0
2010-12-20	BBH	ETF	33.99	34.0633	33.9033	33.9667	49800.0
2010-12-20	BIB	ETF	7.6875	7.6875	7.6	7.6662	8000.0
2010-12-20	BICK	ETF	31.81	31.83	31.6361	31.73	21912.0
2010-12-20	BIL	ETF	91.7	91.72	91.7	91.72	120600.0
2010-12-20	BITS	ETF	28.92	29.68	28.12	28.6	17625.0
2010-12-20	BIV	ETF	83.02	83.28	82.81	82.9	185600.0
2010-12-20	BJK	ETF	31.47	31.76	31.43	31.61	23700.0
2010-12-20	BKF	ETF	48.41	48.45	47.849	48.13	153888.0
2010-12-20	BLV	ETF	79.48	79.66	78.74	79.06	96500.0
2010-12-20	BMVP	ETF	14.6633	14.672	14.5833	14.6133	7756.0
2010-12-20	BND	ETF	80.52	80.7	80.38	80.49	639600.0
2010-12-20	BNO	ETF	30.42	30.42	30.375	30.375	4000.0
2010-12-20	BRF	ETF	57.91	58.0	57.31	57.36	448201.0
2010-12-20	BSCE	ETF	20.7	20.7	20.65	20.68	2110.0
2010-12-20	BSV	ETF	80.78	80.87	80.74	80.82	377700.0
2010-12-20	BTF	ETF	77.45	77.45	77.0005	77.3	1842.0
2010-12-20	BWX	ETF	28.64	28.71	28.59	28.66	230392.0
2010-12-20	BWZ	ETF	36.26	36.26	36.007	36.059	15532.0
2010-12-20	BZQ	ETF	2716.8	2792.0	2716.8	2761.6	811.0
2010-12-20	CEF	ETF	19.97	20.03	19.73	20.01	910900.0
2010-12-20	CEW	ETF	22.94	22.94	22.84	22.92	292212.0

> showing 50 of 815 rows — these rows as CSV

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