PREVIEW / etf_daily / 2010-07-01

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-01.parquet
  size:    33 KB
  rows:    763

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-07-01	SPY	ETF	103.15	103.49	101.13	102.76	382924800.0
2010-07-01	QQQ	ETF	42.82	42.96	41.77	42.59	158694905.0
2010-07-01	IWM	ETF	61.2	61.4	59.12	60.68	114225800.0
2010-07-01	DIA	ETF	97.75	98.0	96.26	97.34	18562200.0
2010-07-01	GLD	ETF	120.91	121.03	116.98	117.04	33248900.0
2010-07-01	TLT	ETF	101.57	102.66	101.38	101.6	12893400.0
2010-07-01	AAXJ	ETF	52.03	52.29	51.3	52.16	235700.0
2010-07-01	ACWI	ETF	37.64	37.93	37.11	37.83	2515700.0
2010-07-01	ACWX	ETF	35.4	35.56	34.95	35.5	114249.0
2010-07-01	ADRE	ETF	39.15	39.28	38.28	39.19	125073.0
2010-07-01	AFK	ETF	27.66	27.71	26.82	27.67	14613.0
2010-07-01	AGG	ETF	107.01	107.12	106.79	106.88	744800.0
2010-07-01	AGQ	ETF	123.02	123.22	113.38	114.46	470550.0
2010-07-01	AGZ	ETF	110.22	110.3	110.0	110.03	12321.0
2010-07-01	AIA	ETF	36.66	36.77	36.13	36.685	31262.0
2010-07-01	AIQ	ETF	20.25	20.459	19.75	19.95	18788.0
2010-07-01	AIS	ETF	1.76	1.84	1.64	1.68	1226533.0
2010-07-01	AIVI	ETF	36.3	36.56	35.95	36.56	21000.0
2010-07-01	AMJ	ETF	30.78	30.85	29.95	30.47	319252.0
2010-07-01	AOA	ETF	28.09	28.61	27.54	27.99	11300.0
2010-07-01	AOK	ETF	27.37	27.39	27.26	27.334	8658.0
2010-07-01	AOM	ETF	27.52	28.49	26.67	27.48	12125.0
2010-07-01	AOR	ETF	28.57	28.57	27.4795	27.73	11067.0
2010-07-01	ARB	ETF	25.59	25.95	24.92	25.75	290384.0
2010-07-01	BAB	ETF	26.19	26.236	26.07	26.12	205421.0
2010-07-01	BAL	ETF	36.96	37.2001	36.9401	37.08	3358.0
2010-07-01	BALT	ETF	11.34	11.39	10.64	10.74	266644.0
2010-07-01	BBH	ETF	29.1833	29.1833	28.27	28.7333	601200.0
2010-07-01	BIB	ETF	5.0	5.0	4.815	4.8523	10624.0
2010-07-01	BICK	ETF	26.51	27.0	26.38	26.995	3878.0
2010-07-01	BIL	ETF	91.72	91.72	91.7	91.72	572500.0
2010-07-01	BIS	ETF	12848.0	13698.88	12848.0	13305.6	23.35
2010-07-01	BITS	ETF	26.6	26.6	26.2	26.32	1756.0
2010-07-01	BIV	ETF	83.54	83.72	83.4	83.42	297800.0
2010-07-01	BJK	ETF	22.89	23.01	22.41	22.87	17600.0
2010-07-01	BKF	ETF	40.89	41.1194	40.211	41.03	340376.0
2010-07-01	BLV	ETF	82.55	82.55	81.61	81.67	1278100.0
2010-07-01	BMVP	ETF	11.66	11.66	11.39	11.59	21205.0
2010-07-01	BND	ETF	81.26	81.33	81.11	81.19	1631400.0
2010-07-01	BNE	ETF	11.22	11.23	11.21	11.22	489671.0
2010-07-01	BNO	ETF	24.97	24.97	24.31	24.54	6600.0
2010-07-01	BOSS	ETF	26.76	26.76	26.76	26.76	100.0
2010-07-01	BRF	ETF	43.87	44.11	43.01	43.88	583747.0
2010-07-01	BSCE	ETF	20.48	20.48	20.4448	20.4448	8030.0
2010-07-01	BSV	ETF	80.85	80.9	80.78	80.78	598600.0
2010-07-01	BTF	ETF	67.19999999999999	67.19999999999999	65.75	66.2995	16391.4
2010-07-01	BWX	ETF	27.16	27.24	27.015	27.14	578992.0
2010-07-01	BWZ	ETF	33.69	33.98	33.69	33.97	15823.0
2010-07-01	BZQ	ETF	4403.2	4577.6	4286.4	4288.0	967.0
2010-07-01	CEF	ETF	15.01	15.01	14.51	14.56	1530900.0

> showing 50 of 763 rows — these rows as CSV

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