PREVIEW / etf_daily / 2010-11-22

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-22.parquet
  size:    34 KB
  rows:    806

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-11-22	SPY	ETF	119.69	120.24	118.77	120.19	181361000.0
2010-11-22	QQQ	ETF	52.25	52.91	52.17	52.91	69918816.0
2010-11-22	IWM	ETF	72.17	72.99	71.74	72.8	42163100.0
2010-11-22	DIA	ETF	111.55	111.86	110.54	111.82	6814800.0
2010-11-22	GLD	ETF	132.13	133.6	131.69	133.48	13093400.0
2010-11-22	TLT	ETF	97.37	97.62	96.24	97.0	10413500.0
2010-11-22	AADR	ETF	28.83	28.98	28.69	28.98	1500.0
2010-11-22	AAXJ	ETF	62.72	62.88	62.06	62.78	558000.0
2010-11-22	ACWI	ETF	45.03	45.39	44.76	45.33	138100.0
2010-11-22	ACWX	ETF	43.16	43.28	42.65	43.2	106395.0
2010-11-22	ADRE	ETF	46.22	46.42	45.72	46.24	75803.0
2010-11-22	AFK	ETF	34.06	34.0699	33.7	33.98	14739.0
2010-11-22	AGG	ETF	107.44	107.61	107.44	107.56	512200.0
2010-11-22	AGQ	ETF	252.08	263.06	249.58	262.64	647000.0
2010-11-22	AGZ	ETF	110.6901	110.929	110.6901	110.914	9609.0
2010-11-22	AIA	ETF	45.07	45.2	44.68	45.13	39043.0
2010-11-22	AIQ	ETF	20.05	20.3	19.7	20.1	27328.0
2010-11-22	AIS	ETF	1.42	1.49	1.41	1.43	329292.0
2010-11-22	AIVI	ETF	44.5	44.58	43.86	44.48	13500.0
2010-11-22	AMJ	ETF	36.27	36.42	36.11	36.41	1467907.0
2010-11-22	AMLP	ETF	79.75	79.75	79.25	79.55	118120.0
2010-11-22	AOA	ETF	33.08	33.11	32.86	33.11	3900.0
2010-11-22	AOK	ETF	28.67	28.68	28.5959	28.6492	19474.0
2010-11-22	AOM	ETF	29.6	29.66	29.53	29.66	6269.0
2010-11-22	AOR	ETF	30.8	30.86	30.68	30.852	4846.0
2010-11-22	ARB	ETF	26.97	28.45	26.79	28.36	442395.0
2010-11-22	BAB	ETF	25.59	25.67	25.4624	25.56	238260.0
2010-11-22	BAL	ETF	59.5	60.74	58.06	60.62	158689.0
2010-11-22	BALT	ETF	12.04	12.23	12.02	12.23	103682.0
2010-11-22	BBH	ETF	33.1867	33.3833	32.9	33.14	52500.0
2010-11-22	BICK	ETF	32.74	32.74	32.24	32.6175	43303.0
2010-11-22	BIL	ETF	91.7	91.72	91.7	91.7	226650.0
2010-11-22	BITS	ETF	28.0	28.8	27.6	28.28	2725.0
2010-11-22	BIV	ETF	85.54	85.77	85.4	85.74	294500.0
2010-11-22	BJK	ETF	31.37	31.69	31.29	31.58	21400.0
2010-11-22	BKF	ETF	48.68	49.039	48.23	48.807	129709.0
2010-11-22	BLV	ETF	81.57	81.86	81.14	81.53	28000.0
2010-11-22	BMVP	ETF	14.16	14.28	14.15	14.27	11121.0
2010-11-22	BND	ETF	81.89	82.0	81.89	82.0	650500.0
2010-11-22	BNE	ETF	11.49	11.5	11.48	11.49	1894924.0
2010-11-22	BNO	ETF	27.94	27.94	27.94	27.94	400.0
2010-11-22	BRF	ETF	60.19	60.36	58.96	59.86	273560.0
2010-11-22	BSCE	ETF	20.86	20.88	20.8552	20.88	9398.0
2010-11-22	BSV	ETF	81.38	81.54	81.33	81.53	732800.0
2010-11-22	BTF	ETF	77.85	78.75	77.8	78.35	4563.0
2010-11-22	BWX	ETF	29.645	29.72	29.5408	29.68	288014.0
2010-11-22	BWZ	ETF	37.12	37.24	37.07	37.185	18335.0
2010-11-22	BZQ	ETF	2684.8	2761.6	2657.6	2715.2	689.5
2010-11-22	CEF	ETF	18.66	19.01	18.54	18.97	973000.0
2010-11-22	CEW	ETF	23.1	23.11	23.0	23.023	56626.0

> showing 50 of 806 rows — these rows as CSV

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