PREVIEW / etf_daily / 2010-07-09

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-09.parquet
  size:    32 KB
  rows:    756

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-09	SPY	ETF	107.13	107.97	106.93	107.96	144999900.0
2010-07-09	QQQ	ETF	44.18	44.63	44.08	44.62	47861055.0
2010-07-09	IWM	ETF	61.98	62.94	61.77	62.94	38202700.0
2010-07-09	DIA	ETF	101.46	102.13	101.28	102.11	7377600.0
2010-07-09	GLD	ETF	118.14	118.73	118.0	118.36	9596800.0
2010-07-09	TLT	ETF	99.4	99.64	99.18	99.22	4286000.0
2010-07-09	AAXJ	ETF	54.41	55.03	54.27	54.98	132400.0
2010-07-09	ACWI	ETF	39.43	39.9	39.43	39.89	129200.0
2010-07-09	ACWX	ETF	37.24	37.62	37.16	37.59	41922.0
2010-07-09	ADRE	ETF	41.06	41.64	40.97	41.58	71931.0
2010-07-09	AFK	ETF	28.61	28.7	28.25	28.596	7050.0
2010-07-09	AGG	ETF	106.67	106.91	106.67	106.74	490600.0
2010-07-09	AGQ	ETF	117.38	119.46	117.1	118.26	101450.0
2010-07-09	AGZ	ETF	109.85	109.864	109.784	109.84	6879.0
2010-07-09	AIA	ETF	38.27	38.74	38.27	38.74	11614.0
2010-07-09	AIQ	ETF	19.4	19.4	18.525	19.15	33352.0
2010-07-09	AIS	ETF	1.73	1.7599	1.7	1.74	359225.0
2010-07-09	AIVI	ETF	38.51	38.81	38.48	38.81	4300.0
2010-07-09	AMJ	ETF	31.73	31.917	31.67	31.9	406852.0
2010-07-09	AOA	ETF	29.17	29.3	29.12	29.3	2900.0
2010-07-09	AOK	ETF	27.5	27.54	27.473	27.522	1903.0
2010-07-09	AOM	ETF	27.95	28.0075	27.95	28.0075	3802.0
2010-07-09	AOR	ETF	28.43	28.5	28.43	28.497	7818.0
2010-07-09	ARB	ETF	25.89	26.58	25.78	26.45	100962.0
2010-07-09	BAB	ETF	25.8	25.82	25.7	25.76	243559.0
2010-07-09	BAL	ETF	36.4325	36.69	36.4325	36.69	300.0
2010-07-09	BALT	ETF	10.49	10.49	10.08	10.41	626380.0
2010-07-09	BBH	ETF	29.52	29.83	29.4367	29.8033	432000.0
2010-07-09	BIB	ETF	5.2787	5.2787	5.2787	5.2787	800.0
2010-07-09	BICK	ETF	27.59	28.22	27.59	28.18	1413.0
2010-07-09	BIL	ETF	91.7	91.72	91.7	91.7	223000.0
2010-07-09	BIS	ETF	12614.4	12614.4	12287.04	12313.6	10.7
2010-07-09	BITS	ETF	26.96	27.8	26.96	27.8	936.0
2010-07-09	BIV	ETF	83.35	83.35	83.11	83.21	152000.0
2010-07-09	BJK	ETF	23.67	23.83	23.6	23.83	6600.0
2010-07-09	BKF	ETF	42.57	43.32	42.57	43.32	124531.0
2010-07-09	BLV	ETF	80.92	81.26	80.92	81.0	33600.0
2010-07-09	BMVP	ETF	12.02	12.1333	12.02	12.1322	10565.0
2010-07-09	BND	ETF	81.11	81.12	81.0	81.09	582400.0
2010-07-09	BNE	ETF	11.29	11.3	11.27	11.28	327569.0
2010-07-09	BNO	ETF	25.64	25.715	25.305	25.43	98200.0
2010-07-09	BRF	ETF	46.16	46.8	45.88	46.78	295854.0
2010-07-09	BSCE	ETF	20.42	20.42	20.38	20.416	2774.0
2010-07-09	BSV	ETF	80.88	80.89	80.8	80.88	879700.0
2010-07-09	BTF	ETF	67.94999999999999	68.2	67.89999999999999	68.0	4510.400000000001
2010-07-09	BWX	ETF	27.455	27.455	27.265	27.395	265154.0
2010-07-09	BWZ	ETF	34.32	34.349	34.26	34.277	3347.0
2010-07-09	BZQ	ETF	3808.0	3817.6	3675.2	3688.0	943.0
2010-07-09	CEF	ETF	14.76	14.93	14.68	14.93	521100.0
2010-07-09	CEW	ETF	21.62	21.63	21.5601	21.61	92986.0

> showing 50 of 756 rows — these rows as CSV

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