PREVIEW / etf_daily / 2010-07-29

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-29.parquet
  size:    33 KB
  rows:    766

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-29	SPY	ETF	111.52	111.82	109.41	110.29	220149100.0
2010-07-29	QQQ	ETF	46.3	46.41	45.25	45.71	85693920.0
2010-07-29	IWM	ETF	65.71	65.99	63.95	64.98	63214400.0
2010-07-29	DIA	ETF	105.66	105.93	103.92	104.67	11562800.0
2010-07-29	GLD	ETF	113.54	114.35	113.34	114.29	9476300.0
2010-07-29	TLT	ETF	98.1	99.02	97.92	98.94	6305500.0
2010-07-29	AADR	ETF	25.3	25.3	25.02	25.02	1200.0
2010-07-29	AAXJ	ETF	56.49	56.65	55.7	56.01	495500.0
2010-07-29	ACWI	ETF	41.59	41.59	40.74	41.1	143300.0
2010-07-29	ACWX	ETF	39.23	39.4104	38.71	39.0	126052.0
2010-07-29	ADRE	ETF	42.54	42.84	41.9601	42.31	117618.0
2010-07-29	AFK	ETF	30.76	30.84	30.44	30.45	14709.0
2010-07-29	AGG	ETF	107.44	107.67	107.4	107.67	444800.0
2010-07-29	AGQ	ETF	110.62	112.18	110.0	111.1	85400.0
2010-07-29	AGZ	ETF	110.49	110.66	110.444	110.58	139593.0
2010-07-29	AIA	ETF	39.79	39.94	39.472	39.8399	12568.0
2010-07-29	AIQ	ETF	19.4	19.4	17.25	17.9	154197.0
2010-07-29	AIS	ETF	1.54	1.5564	1.44	1.49	790353.0
2010-07-29	AIVI	ETF	40.9	41.06	40.22	40.6	11200.0
2010-07-29	AMJ	ETF	32.94	32.95	32.34	32.52	1493968.0
2010-07-29	AOA	ETF	30.41	30.41	29.95	30.11	1500.0
2010-07-29	AOK	ETF	27.8999	27.8999	27.79	27.86	10195.0
2010-07-29	AOM	ETF	28.45	28.45	28.358	28.42	11841.0
2010-07-29	AOR	ETF	29.26	29.26	28.93	29.05	14456.0
2010-07-29	ARB	ETF	29.82	30.12	28.85	29.17	208406.0
2010-07-29	BAB	ETF	25.8	25.97	25.73	25.94	275810.0
2010-07-29	BAL	ETF	37.53	37.53	37.27	37.2701	1308.0
2010-07-29	BALT	ETF	11.34	11.59	11.13	11.49	66169.0
2010-07-29	BBH	ETF	31.32	31.4067	30.5967	30.83	182700.0
2010-07-29	BIB	ETF	5.5875	5.5875	5.3842	5.475	38200.0
2010-07-29	BICK	ETF	28.92	28.98	28.815	28.98	1022.0
2010-07-29	BIL	ETF	91.68	91.7	91.68	91.68	110750.0
2010-07-29	BIS	ETF	11534.4	11825.6	11534.4	11825.6	3.75
2010-07-29	BIV	ETF	84.35	84.56	84.15	84.4	242300.0
2010-07-29	BJK	ETF	25.28	25.49	24.91	25.25	9000.0
2010-07-29	BKF	ETF	45.09	45.17	44.36	44.67	145506.0
2010-07-29	BLV	ETF	81.98	82.16	81.64	82.16	55500.0
2010-07-29	BMVP	ETF	12.54	12.58	12.33	12.44	14767.0
2010-07-29	BND	ETF	81.64	81.75	81.54	81.73	507100.0
2010-07-29	BNE	ETF	11.34	11.34	11.28	11.31	509968.0
2010-07-29	BNO	ETF	25.95	26.42	25.95	26.245	155400.0
2010-07-29	BRF	ETF	48.8	48.81	48.12	48.64	153399.0
2010-07-29	BSCE	ETF	20.77	20.8	20.73	20.74	33875.0
2010-07-29	BSV	ETF	81.27	81.34	81.23	81.34	404700.0
2010-07-29	BTF	ETF	69.74999999999999	70.75	69.71799999999999	70.7	4583.6
2010-07-29	BWX	ETF	28.05	28.415	27.92	28.405	255376.0
2010-07-29	BWZ	ETF	35.14	35.35	35.14	35.35	14519.0
2010-07-29	BZQ	ETF	3388.8	3486.4	3350.4	3424.0	1071.0
2010-07-29	CEF	ETF	14.17	14.32	14.15	14.22	630000.0
2010-07-29	CEW	ETF	22.04	22.04	21.91	21.99	75677.0

> showing 50 of 766 rows — these rows as CSV

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