PREVIEW / etf_daily / 2010-06-24

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-24.parquet
  size:    32 KB
  rows:    749

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-06-24	SPY	ETF	108.69	108.83	107.14	107.42	268523600.0
2010-06-24	QQQ	ETF	45.84	45.99	45.2	45.35	114714307.0
2010-06-24	IWM	ETF	64.03	64.53	63.39	63.54	72504900.0
2010-06-24	DIA	ETF	102.51	102.64	101.3	101.56	13397700.0
2010-06-24	GLD	ETF	120.76	122.16	120.67	121.3	13137700.0
2010-06-24	TLT	ETF	99.35	99.59	98.35	98.65	6184600.0
2010-06-24	AAXJ	ETF	54.69	54.69	53.77	53.88	171300.0
2010-06-24	ACWI	ETF	39.82	39.82	39.2	39.28	221500.0
2010-06-24	ACWX	ETF	37.14	37.14	36.62	36.6744	71571.0
2010-06-24	ADRE	ETF	41.53	41.53	40.72	40.91	93053.0
2010-06-24	AFK	ETF	28.86	29.048	28.61	28.61	16546.0
2010-06-24	AGG	ETF	106.8	106.88	106.49	106.57	812300.0
2010-06-24	AGQ	ETF	122.64	128.38	122.32	125.98	166800.0
2010-06-24	AGZ	ETF	109.95	110.04	109.62	109.676	10066.0
2010-06-24	AIA	ETF	38.57	38.58	38.18	38.2	51562.0
2010-06-24	AIQ	ETF	23.3	23.65	22.75	22.85	19697.0
2010-06-24	AIS	ETF	1.75	1.88	1.74	1.8	792948.0
2010-06-24	AIVI	ETF	38.8	38.99	38.55	38.55	14300.0
2010-06-24	AMJ	ETF	30.06	30.45	30.0	30.26	350351.0
2010-06-24	AOA	ETF	29.45	29.47	29.17	29.17	15900.0
2010-06-24	AOK	ETF	27.79	27.8	27.51	27.51	27440.0
2010-06-24	AOM	ETF	28.07	28.07	27.9995	27.9995	9445.0
2010-06-24	AOR	ETF	29.02	29.02	28.483	28.483	10088.0
2010-06-24	ARB	ETF	27.46	27.795	26.72	26.84	143534.0
2010-06-24	BAB	ETF	25.98	26.05	25.89	25.95	211418.0
2010-06-24	BAL	ETF	38.25	38.62	38.25	38.4301	2257.0
2010-06-24	BALT	ETF	11.68	11.77	11.5	11.59	149322.0
2010-06-24	BBH	ETF	30.6167	30.8533	30.5633	30.5633	68100.0
2010-06-24	BIB	ETF	5.6387	5.6387	5.6387	5.6387	4000.0
2010-06-24	BICK	ETF	28.79	28.79	28.0301	28.18	2535.0
2010-06-24	BIL	ETF	91.7	91.72	91.7	91.72	291000.0
2010-06-24	BIS	ETF	11795.2	11836.8	11795.2	11836.8	3.125
2010-06-24	BITS	ETF	27.2	27.88	26.44	27.28	1502.0
2010-06-24	BIV	ETF	82.77	83.0	82.68	82.82	126700.0
2010-06-24	BJK	ETF	24.67	24.71	24.29	24.29	23000.0
2010-06-24	BKF	ETF	43.41	43.41	42.712	42.82	157022.0
2010-06-24	BLV	ETF	80.83	81.44	80.71	80.88	27600.0
2010-06-24	BMVP	ETF	12.26	12.26	12.12	12.12	2106.0
2010-06-24	BND	ETF	81.11	81.12	80.84	80.92	451400.0
2010-06-24	BNE	ETF	11.21	11.22	11.21	11.21	352009.0
2010-06-24	BNO	ETF	25.785	25.97	25.785	25.895	59800.0
2010-06-24	BRF	ETF	45.48	45.55	44.66	44.83	188796.0
2010-06-24	BSCE	ETF	20.3	20.3	20.28	20.29	3606.0
2010-06-24	BSV	ETF	80.82	80.83	80.72	80.78	354300.0
2010-06-24	BTF	ETF	67.55	68.05	67.19999999999999	67.24999999999999	7391.400000000001
2010-06-24	BWX	ETF	26.905	26.955	26.735	26.745	193150.0
2010-06-24	BWZ	ETF	33.65	33.85	33.65	33.7	13968.0
2010-06-24	BZQ	ETF	3889.6	4054.4	3889.6	3996.8	849.0
2010-06-24	CEF	ETF	14.91	15.11	14.9	15.03	1735400.0
2010-06-24	CEW	ETF	21.4	21.53	21.36	21.53	71744.0

> showing 50 of 749 rows — these rows as CSV

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