PREVIEW / etf_daily / 2010-08-17

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-17.parquet
  size:    33 KB
  rows:    771

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-08-17	SPY	ETF	109.19	110.39	108.88	109.59	172270300.0
2010-08-17	QQQ	ETF	45.11	45.78	45.03	45.372	56927057.0
2010-08-17	IWM	ETF	62.22	63.15	61.86	62.62	54593200.0
2010-08-17	DIA	ETF	103.99	105.12	103.67	104.33	5461600.0
2010-08-17	GLD	ETF	119.75	119.97	119.6	119.75	9145400.0
2010-08-17	TLT	ETF	104.85	104.86	104.0	104.25	6756800.0
2010-08-17	AADR	ETF	25.57	25.75	25.57	25.75	6500.0
2010-08-17	AAXJ	ETF	55.63	56.02	55.53	55.61	659300.0
2010-08-17	ACWI	ETF	40.83	41.21	40.72	40.94	123700.0
2010-08-17	ACWX	ETF	38.93	39.02	38.64	38.86	51723.0
2010-08-17	ADRE	ETF	42.63	42.82	42.48	42.66	78928.0
2010-08-17	AFK	ETF	30.33	30.92	30.31	30.76	16818.0
2010-08-17	AGG	ETF	108.24	108.26	108.11	108.22	513500.0
2010-08-17	AGQ	ETF	121.8	123.32	121.26	122.04	85450.0
2010-08-17	AGZ	ETF	111.15	111.15	111.004	111.02	15677.0
2010-08-17	AIA	ETF	40.06	40.06	39.7019	39.77	12442.0
2010-08-17	AIQ	ETF	23.5	23.9	22.7	23.2	19600.0
2010-08-17	AIS	ETF	1.56	1.61	1.56	1.61	433305.0
2010-08-17	AIVI	ETF	40.35	40.6	40.27	40.37	19900.0
2010-08-17	AMJ	ETF	33.0	33.394	32.79	32.84	845860.0
2010-08-17	AOA	ETF	29.81	30.01	29.78	29.9	15600.0
2010-08-17	AOK	ETF	27.87	27.929	27.8495	27.8977	7507.0
2010-08-17	AOM	ETF	28.42	28.5	28.3799	28.4618	22489.0
2010-08-17	AOR	ETF	28.898	29.05	28.898	28.9899	5652.0
2010-08-17	ARB	ETF	25.65	25.79	25.31	25.59	288777.0
2010-08-17	BAB	ETF	26.59	26.59	26.38	26.454	384204.0
2010-08-17	BAL	ETF	41.0	41.1	40.689	40.824	5265.0
2010-08-17	BALT	ETF	10.99	11.49	10.84	11.1	276261.0
2010-08-17	BBH	ETF	30.88	31.29	30.88	31.1167	95400.0
2010-08-17	BIB	ETF	5.7538	5.8775	5.7538	5.8625	6400.0
2010-08-17	BICK	ETF	29.17	29.2	28.98	29.004	36388.0
2010-08-17	BIL	ETF	91.72	91.72	91.7	91.72	193950.0
2010-08-17	BIS	ETF	10960.096	10960.096	10960.096	10960.096	0.625
2010-08-17	BITS	ETF	27.0	27.2	25.84	26.56	2379.0
2010-08-17	BIV	ETF	86.05	86.12	85.83	85.96	140900.0
2010-08-17	BJK	ETF	25.71	26.07	25.7	25.94	5800.0
2010-08-17	BKF	ETF	44.8	45.02	44.6	44.82	101638.0
2010-08-17	BLV	ETF	85.88	85.88	85.23	85.56	78700.0
2010-08-17	BMVP	ETF	12.32	12.4833	12.32	12.4215	10207.0
2010-08-17	BND	ETF	82.48	82.49	82.35	82.43	823700.0
2010-08-17	BNE	ETF	11.17	11.2	11.14	11.14	346797.0
2010-08-17	BNO	ETF	26.055	26.14	25.945	25.945	21800.0
2010-08-17	BRF	ETF	50.34	50.95	50.3	50.93	345714.0
2010-08-17	BSCE	ETF	20.86	20.86	20.85	20.85	7336.0
2010-08-17	BSV	ETF	81.55	81.58	81.52	81.57	259500.0
2010-08-17	BTF	ETF	68.6	69.69999999999999	68.6	69.25	2509.8
2010-08-17	BWX	ETF	28.62	28.785	28.5	28.605	169622.0
2010-08-17	BWZ	ETF	35.32	35.41	35.3	35.33	10166.0
2010-08-17	BZQ	ETF	3297.6	3332.8	3275.2	3291.2	861.0
2010-08-17	CEF	ETF	15.06	15.12	15.01	15.09	578800.0

> showing 50 of 771 rows — these rows as CSV

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