PREVIEW / etf_daily / 2010-09-17

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-17.parquet
  size:    33 KB
  rows:    782

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-09-17	SPY	ETF	113.04	113.15	112.18	112.49	195836900.0
2010-09-17	QQQ	ETF	48.14	48.14	47.75	47.995	76372570.0
2010-09-17	IWM	ETF	65.4	65.52	64.28	65.21	61775400.0
2010-09-17	DIA	ETF	106.35	106.49	105.65	106.07	7777800.0
2010-09-17	GLD	ETF	125.03	125.03	124.27	124.54	13819200.0
2010-09-17	TLT	ETF	101.83	102.16	101.32	101.67	9203600.0
2010-09-17	AADR	ETF	27.22	27.25	27.22	27.25	600.0
2010-09-17	AAXJ	ETF	58.42	58.58	58.2	58.25	138200.0
2010-09-17	ACWI	ETF	42.58	42.58	42.17	42.23	73500.0
2010-09-17	ACWX	ETF	40.53	40.5799	40.144	40.28	14664.0
2010-09-17	ADRE	ETF	43.34	43.34	42.9401	43.03	37969.0
2010-09-17	AFK	ETF	31.14	31.28	31.1202	31.21	9543.0
2010-09-17	AGG	ETF	107.74	108.0	107.74	107.89	719400.0
2010-09-17	AGQ	ETF	152.78	153.5	149.7	151.54	237050.0
2010-09-17	AGZ	ETF	110.93	110.94	110.82	110.89	7334.0
2010-09-17	AIA	ETF	41.24	41.24	41.06	41.23	44199.0
2010-09-17	AIQ	ETF	21.9	22.0	21.55	21.55	26373.0
2010-09-17	AIS	ETF	1.53	1.53	1.48	1.49	395264.0
2010-09-17	AIVI	ETF	42.39	42.39	41.95	42.06	14400.0
2010-09-17	AMJ	ETF	32.96	32.97	32.75	32.92	503802.0
2010-09-17	AMLP	ETF	76.15	76.15	75.75	76.0	127400.0
2010-09-17	AOA	ETF	30.81	30.92	30.81	30.9	5200.0
2010-09-17	AOK	ETF	28.17	28.17	28.11	28.1275	8625.0
2010-09-17	AOM	ETF	28.81	28.86	28.81	28.8599	11846.0
2010-09-17	AOR	ETF	29.69	29.69	29.5301	29.59	6951.0
2010-09-17	ARB	ETF	27.04	27.92	26.48	27.69	169208.0
2010-09-17	BAB	ETF	26.3	26.3375	26.2	26.29	133392.0
2010-09-17	BAL	ETF	47.47	48.38	47.275	48.345	70614.0
2010-09-17	BALT	ETF	11.36	11.36	11.01	11.09	118927.0
2010-09-17	BBH	ETF	31.9833	32.0733	31.8533	31.87	132900.0
2010-09-17	BIB	ETF	6.2125	6.2325	6.155	6.2325	4000.0
2010-09-17	BICK	ETF	30.76	30.76	30.37	30.57	13759.0
2010-09-17	BIL	ETF	91.7	91.72	91.7	91.7	168750.0
2010-09-17	BITS	ETF	26.08	29.56	25.68	29.0	47505.0
2010-09-17	BIV	ETF	85.48	85.53	85.29	85.43	119900.0
2010-09-17	BJK	ETF	27.52	27.52	27.19	27.32	11500.0
2010-09-17	BKF	ETF	46.29	46.3	45.94	46.14	169052.0
2010-09-17	BLV	ETF	83.64	83.89	83.4	83.58	56100.0
2010-09-17	BMVP	ETF	12.83	12.83	12.75	12.78	19767.0
2010-09-17	BND	ETF	81.99	82.13	81.97	82.0	553400.0
2010-09-17	BNE	ETF	11.1	11.1	11.05	11.07	328017.0
2010-09-17	BRF	ETF	55.57	55.6181	54.98	55.07	324742.0
2010-09-17	BSCE	ETF	20.83	20.83	20.8183	20.82	8660.0
2010-09-17	BSV	ETF	81.53	81.53	81.43	81.43	396100.0
2010-09-17	BTF	ETF	74.35	74.39949999999999	73.455	73.949	5874.8
2010-09-17	BWX	ETF	29.055	29.055	28.81	28.815	143172.0
2010-09-17	BWZ	ETF	35.78	35.82	35.7	35.8	10666.0
2010-09-17	BZQ	ETF	3088.0	3155.2	3073.6	3139.2	166.0
2010-09-17	CEF	ETF	16.22	16.28	16.1	16.14	828800.0
2010-09-17	CEW	ETF	22.46	22.46	22.39	22.39	124226.0

> showing 50 of 782 rows — these rows as CSV

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