PREVIEW / etf_daily / 2010-12-28

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-28.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-28	SPY	ETF	125.9	125.95	125.5	125.83	55309100.0
2010-12-28	QQQ	ETF	54.88	54.92	54.55	54.67	24168603.0
2010-12-28	IWM	ETF	79.11	79.16	78.52	78.74	25827900.0
2010-12-28	DIA	ETF	115.77	115.88	115.34	115.79	4738400.0
2010-12-28	GLD	ETF	136.85	137.34	136.62	137.22	10111800.0
2010-12-28	TLT	ETF	92.93	93.07	91.31	91.61	13972100.0
2010-12-28	AADR	ETF	29.66	29.66	29.58	29.59	2300.0
2010-12-28	AAXJ	ETF	62.83	62.87	62.61	62.73	202600.0
2010-12-28	ACWI	ETF	46.31	46.44	46.31	46.44	249800.0
2010-12-28	ACWX	ETF	43.74	43.74	43.4	43.44	288291.0
2010-12-28	ADRE	ETF	46.85	46.94	46.751	46.91	45962.0
2010-12-28	AFK	ETF	34.47	34.5	34.13	34.38	13990.0
2010-12-28	AGG	ETF	105.16	105.28	104.66	104.66	709000.0
2010-12-28	AGQ	ETF	295.52	306.54	294.14	304.6	411750.0
2010-12-28	AGZ	ETF	109.49	109.49	109.061	109.176	19557.0
2010-12-28	AIA	ETF	45.89	45.95	45.8852	45.94	19805.0
2010-12-28	AIQ	ETF	21.15	21.45	20.85	21.25	17985.0
2010-12-28	AIS	ETF	1.73	1.75	1.7	1.71	402631.0
2010-12-28	AIVI	ETF	43.73	43.74	43.41	43.49	25500.0
2010-12-28	AMJ	ETF	35.71	35.96	35.71	35.96	1229600.0
2010-12-28	AMLP	ETF	79.4	79.7	79.35	79.7	192100.0
2010-12-28	AOA	ETF	34.32	34.32	34.16	34.22	17800.0
2010-12-28	AOK	ETF	28.71	28.77	28.681	28.7087	4793.0
2010-12-28	AOM	ETF	29.8	29.81	29.74	29.77	17207.0
2010-12-28	AOR	ETF	31.42	31.42	31.32	31.35	12113.0
2010-12-28	ARB	ETF	41.93	42.38	41.87	41.97	193427.0
2010-12-28	BAB	ETF	24.99	24.99	24.73	24.75	231404.0
2010-12-28	BAL	ETF	75.41	75.69	73.1736	73.36	38580.0
2010-12-28	BALT	ETF	10.58	10.59	10.25	10.31	142999.0
2010-12-28	BBH	ETF	33.58	33.58	33.41	33.41	65100.0
2010-12-28	BIB	ETF	7.7975	7.7975	7.5312	7.6787	20400.0
2010-12-28	BICK	ETF	31.86	31.91	31.76	31.91	11778.0
2010-12-28	BIL	ETF	91.7	91.72	91.7	91.72	115200.0
2010-12-28	BITS	ETF	29.0	29.0	28.2	28.8	3144.0
2010-12-28	BIV	ETF	82.22	82.34	81.54	81.54	163900.0
2010-12-28	BJK	ETF	31.01	31.08	30.88	30.92	11300.0
2010-12-28	BKF	ETF	47.9	48.2	47.77	47.84	199648.0
2010-12-28	BLV	ETF	78.65	78.65	77.25	77.43	27800.0
2010-12-28	BMVP	ETF	14.76	14.76	14.643	14.67	10154.0
2010-12-28	BND	ETF	79.94	79.97	79.52	79.52	688600.0
2010-12-28	BNO	ETF	31.35	31.44	31.23	31.405	7600.0
2010-12-28	BRF	ETF	54.55	54.8799	54.35	54.6	224566.0
2010-12-28	BSCE	ETF	20.76	20.76	20.61	20.6722	19432.0
2010-12-28	BSV	ETF	80.22	80.3	80.1	80.16	423100.0
2010-12-28	BTF	ETF	77.75	78.15	77.6	77.85	1100.4
2010-12-28	BWX	ETF	28.885	29.5495	28.785	28.815	416232.0
2010-12-28	BWZ	ETF	36.58	37.255	36.378	36.4	12658.0
2010-12-28	BZQ	ETF	2648.0	2676.8	2636.8	2648.0	69.0
2010-12-28	CEF	ETF	20.14	20.4	20.03	20.36	870900.0
2010-12-28	CEW	ETF	22.32	22.36	22.26	22.3	174160.0

> showing 50 of 815 rows — these rows as CSV

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