PREVIEW / etf_daily / 2010-07-30

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-30.parquet
  size:    33 KB
  rows:    758

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-30	SPY	ETF	109.17	110.86	108.98	110.27	220070600.0
2010-07-30	QQQ	ETF	45.36	46.09	45.07	45.81	98958084.0
2010-07-30	IWM	ETF	64.1	65.61	63.82	65.02	67453000.0
2010-07-30	DIA	ETF	103.8	105.13	103.54	104.7	11706000.0
2010-07-30	GLD	ETF	114.36	115.73	114.08	115.49	10093200.0
2010-07-30	TLT	ETF	100.2	100.61	99.85	100.48	7683200.0
2010-07-30	AADR	ETF	24.99	25.1	24.99	25.1	600.0
2010-07-30	AAXJ	ETF	55.75	56.36	55.55	56.17	229800.0
2010-07-30	ACWI	ETF	40.73	41.25	40.56	41.11	353300.0
2010-07-30	ACWX	ETF	38.61	39.07	38.5	39.057	137325.0
2010-07-30	ADRE	ETF	42.12	42.58	41.87	42.58	106746.0
2010-07-30	AFK	ETF	30.31	30.75	30.3	30.75	10289.0
2010-07-30	AGG	ETF	107.94	107.96	107.72	107.85	937100.0
2010-07-30	AGQ	ETF	114.16	117.48	113.0	115.48	176550.0
2010-07-30	AGZ	ETF	110.78	110.8	110.6	110.67	12137.0
2010-07-30	AIA	ETF	39.35	39.81	39.29	39.75	25480.0
2010-07-30	AIQ	ETF	17.65	22.35	17.65	21.0	336962.0
2010-07-30	AIS	ETF	1.49	1.56	1.49	1.52	472929.0
2010-07-30	AIVI	ETF	40.38	40.68	40.24	40.57	11900.0
2010-07-30	AMJ	ETF	32.39	33.08	31.78	33.08	953331.0
2010-07-30	AOA	ETF	29.76	30.16	29.76	30.16	4100.0
2010-07-30	AOK	ETF	27.81	27.91	27.79	27.91	23204.0
2010-07-30	AOM	ETF	28.39	28.48	28.368	28.48	4965.0
2010-07-30	AOR	ETF	28.84	29.13	28.84	29.13	8084.0
2010-07-30	ARB	ETF	28.68	29.37	28.3811	28.9	170476.0
2010-07-30	BAB	ETF	26.0	26.05	25.96	26.04	179600.0
2010-07-30	BAL	ETF	37.62	38.374	37.62	38.28	3711.0
2010-07-30	BALT	ETF	11.31	11.57	11.21	11.43	41649.0
2010-07-30	BBH	ETF	30.43	31.2633	30.3333	31.0533	112500.0
2010-07-30	BIB	ETF	5.6712	5.6712	5.6338	5.6487	12400.0
2010-07-30	BICK	ETF	29.11	29.19	28.79	29.12	9235.0
2010-07-30	BIL	ETF	91.7	91.7	91.68	91.7	67950.0
2010-07-30	BIS	ETF	11910.4	11945.6	11435.2	11449.6	8.2
2010-07-30	BITS	ETF	25.6	28.2	25.6	28.18	875.0
2010-07-30	BIV	ETF	84.84	84.85	84.5	84.83	205800.0
2010-07-30	BJK	ETF	24.97	25.57	24.97	25.43	43100.0
2010-07-30	BKF	ETF	44.36	45.07	44.1	44.78	87530.0
2010-07-30	BLV	ETF	82.78	83.22	82.7	83.22	64200.0
2010-07-30	BMVP	ETF	12.29	12.5	12.29	12.44	10977.0
2010-07-30	BND	ETF	81.93	81.96	81.8	81.85	1510600.0
2010-07-30	BNE	ETF	11.29	11.32	11.29	11.31	415543.0
2010-07-30	BNO	ETF	25.925	26.46	25.925	26.46	5200.0
2010-07-30	BRF	ETF	48.6	49.56	48.46	49.41	258137.0
2010-07-30	BSCE	ETF	20.8	20.8	20.741	20.75	11619.0
2010-07-30	BSV	ETF	81.45	81.45	81.37	81.43	510500.0
2010-07-30	BTF	ETF	69.95	70.6	69.69999999999999	70.25	2650.0
2010-07-30	BWX	ETF	28.425	28.545	28.385	28.515	173428.0
2010-07-30	BWZ	ETF	35.3	35.41	35.27	35.39	14592.0
2010-07-30	BZQ	ETF	3489.6	3502.4	3329.6	3364.8	1386.0
2010-07-30	CEF	ETF	14.28	14.5	14.27	14.49	805900.0

> showing 50 of 758 rows — these rows as CSV

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