PREVIEW / etf_daily / 2010-05-14

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-14.parquet
  size:    33 KB
  rows:    760

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-05-14	SPY	ETF	115.12	115.33	112.87	113.89	345601400.0
2010-05-14	QQQ	ETF	47.49	47.52	46.38	46.93	147386023.0
2010-05-14	IWM	ETF	70.47	70.5	68.62	69.56	86134200.0
2010-05-14	DIA	ETF	107.45	107.67	105.62	106.51	17962100.0
2010-05-14	GLD	ETF	121.88	122.02	119.12	120.37	34643200.0
2010-05-14	TLT	ETF	94.12	95.5	94.09	94.88	9796500.0
2010-05-14	AAXJ	ETF	54.6	54.8	53.65	54.18	1700100.0
2010-05-14	ACWI	ETF	41.37	41.91	40.62	40.95	176800.0
2010-05-14	ACWX	ETF	38.51	38.52	37.5	37.89	212552.0
2010-05-14	ADRE	ETF	41.75	41.75	40.5	41.02	154861.0
2010-05-14	AFK	ETF	30.48	30.48	30.09	30.19	9024.0
2010-05-14	AGG	ETF	105.17	105.36	104.98	105.21	585600.0
2010-05-14	AGQ	ETF	142.56	142.6	132.76	137.88	353750.0
2010-05-14	AGZ	ETF	108.91	109.027	108.63	108.63	35028.0
2010-05-14	AIA	ETF	38.56	38.9199	38.21	38.58	21704.0
2010-05-14	AIQ	ETF	27.1	27.35	26.25	27.2	17566.0
2010-05-14	AIS	ETF	1.66	1.67	1.6	1.66	459290.0
2010-05-14	AIVI	ETF	39.5	39.5	38.37	38.66	20500.0
2010-05-14	AMJ	ETF	30.25	30.68	29.8	30.23	402687.0
2010-05-14	AOA	ETF	30.43	30.59	30.15	30.42	83700.0
2010-05-14	AOK	ETF	27.94	27.94	27.71	27.71	44451.0
2010-05-14	AOM	ETF	28.45	28.45	28.25	28.37	28617.0
2010-05-14	AOR	ETF	29.35	29.35	29.0	29.19	27690.0
2010-05-14	ARB	ETF	32.54	32.65	31.6	32.12	133362.0
2010-05-14	BAB	ETF	26.0	26.1399	25.88	26.025	193417.0
2010-05-14	BAL	ETF	38.29	38.29	38.11	38.17	1230.0
2010-05-14	BALT	ETF	13.3	13.3	12.66	12.84	190578.0
2010-05-14	BBH	ETF	31.41	31.5067	30.5733	30.6833	251700.0
2010-05-14	BIB	ETF	6.4975	6.4975	6.2387	6.355	12400.0
2010-05-14	BICK	ETF	28.0	28.34	28.0	28.075	3787.0
2010-05-14	BIL	ETF	91.72	91.72	91.7	91.72	189050.0
2010-05-14	BIS	ETF	10798.4	11126.4	10798.4	10964.8	33.1
2010-05-14	BITS	ETF	30.64	30.88	30.48	30.88	1223.0
2010-05-14	BIV	ETF	81.57	81.67	81.32	81.54	141600.0
2010-05-14	BJK	ETF	25.45	25.45	24.84	25.02	10600.0
2010-05-14	BKF	ETF	43.08	43.08	41.9305	42.43	265428.0
2010-05-14	BLV	ETF	79.24	79.56	78.96	78.97	46700.0
2010-05-14	BMVP	ETF	12.99	13.03	12.85	12.95	37864.0
2010-05-14	BND	ETF	80.04	80.26	79.97	80.12	698500.0
2010-05-14	BNE	ETF	11.07	11.12	11.05	11.09	1177023.0
2010-05-14	BRF	ETF	43.5	43.51	42.01	42.7	799389.0
2010-05-14	BSV	ETF	80.35	80.41	80.32	80.4	280100.0
2010-05-14	BTF	ETF	69.5	69.5	67.9005	68.702	3531.2000000000003
2010-05-14	BWX	ETF	26.62	26.745	26.475	26.525	613300.0
2010-05-14	BWZ	ETF	33.87	34.02	33.71	33.7352	19703.0
2010-05-14	BZQ	ETF	4096.0	4320.0	4088.0	4214.4	1618.0
2010-05-14	CEF	ETF	15.18	15.23	14.81	15.2	4365200.0
2010-05-14	CEW	ETF	21.86	21.9	21.6945	21.75	164857.0
2010-05-14	CGO	ETF	13.76	13.81	13.55	13.55	47894.0
2010-05-14	CGW	ETF	17.67	17.69	17.2	17.27	65794.0

> showing 50 of 760 rows — these rows as CSV

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