PREVIEW / etf_daily / 2010-08-18

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-18.parquet
  size:    33 KB
  rows:    770

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-08-18	SPY	ETF	109.54	110.38	108.91	109.79	182922100.0
2010-08-18	QQQ	ETF	45.29	45.82	45.11	45.55	61836475.0
2010-08-18	IWM	ETF	62.55	63.43	61.94	62.81	61766600.0
2010-08-18	DIA	ETF	104.26	105.11	103.68	104.57	6344900.0
2010-08-18	GLD	ETF	119.23	120.51	119.0	120.22	12102500.0
2010-08-18	TLT	ETF	105.0	105.65	104.49	104.53	7721600.0
2010-08-18	AADR	ETF	25.8	25.9	25.8	25.9	600.0
2010-08-18	AAXJ	ETF	55.73	55.96	55.43	55.67	121600.0
2010-08-18	ACWI	ETF	40.91	41.17	40.75	41.01	74400.0
2010-08-18	ACWX	ETF	38.89	39.06	38.69	38.91	56341.0
2010-08-18	ADRE	ETF	42.63	42.72	42.301	42.53	80095.0
2010-08-18	AFK	ETF	30.6	30.67	30.4	30.44	4157.0
2010-08-18	AGG	ETF	108.34	108.34	108.05	108.1	558300.0
2010-08-18	AGQ	ETF	117.76	121.6	117.54	120.66	170350.0
2010-08-18	AGZ	ETF	111.15	111.15	110.9201	110.95	8411.0
2010-08-18	AIA	ETF	39.67	39.76	39.4	39.675	23344.0
2010-08-18	AIQ	ETF	23.3	24.0	23.05	23.35	49272.0
2010-08-18	AIS	ETF	1.6	1.67	1.56	1.67	362920.0
2010-08-18	AIVI	ETF	40.48	40.71	40.3	40.45	18600.0
2010-08-18	AMJ	ETF	32.97	33.02	32.53	32.74	795290.0
2010-08-18	AOA	ETF	29.88	30.03	29.77	30.03	9600.0
2010-08-18	AOK	ETF	27.89	27.9321	27.88	27.91	14078.0
2010-08-18	AOM	ETF	28.39	28.5	28.39	28.45	33770.0
2010-08-18	AOR	ETF	28.95	29.08	28.95	28.974	6339.0
2010-08-18	ARB	ETF	25.55	25.76	25.41	25.54	796674.0
2010-08-18	BAB	ETF	26.62	26.66	26.5345	26.56	241036.0
2010-08-18	BAL	ETF	40.9099	40.91	40.45	40.87	7154.0
2010-08-18	BALT	ETF	11.2	11.64	10.93	11.51	560355.0
2010-08-18	BBH	ETF	31.1167	31.2233	30.79	31.0233	95400.0
2010-08-18	BIB	ETF	5.8238	5.9025	5.7387	5.815	35056.0
2010-08-18	BICK	ETF	29.14	29.2325	29.0	29.21	17718.0
2010-08-18	BIL	ETF	91.7	91.72	91.7	91.7	102150.0
2010-08-18	BIS	ETF	10995.2	11164.8	10865.6	11001.6	61.5
2010-08-18	BITS	ETF	26.48	26.56	25.6	25.8	2638.0
2010-08-18	BIV	ETF	86.22	86.23	85.9	85.93	171800.0
2010-08-18	BJK	ETF	25.88	26.17	25.88	25.94	5000.0
2010-08-18	BKF	ETF	44.92	44.926	44.47	44.84	77375.0
2010-08-18	BLV	ETF	86.02	86.27	85.61	85.69	50600.0
2010-08-18	BMVP	ETF	12.4	12.5127	12.3415	12.46	6697.0
2010-08-18	BND	ETF	82.49	82.53	82.35	82.38	500300.0
2010-08-18	BNE	ETF	11.15	11.18	11.13	11.18	250223.0
2010-08-18	BNO	ETF	25.56	25.855	25.425	25.84	129000.0
2010-08-18	BRF	ETF	50.98	51.57	50.68	51.48	376704.0
2010-08-18	BSCE	ETF	20.85	20.85	20.84	20.84	1600.0
2010-08-18	BSV	ETF	81.59	81.61	81.54	81.57	337000.0
2010-08-18	BTF	ETF	69.05	69.58149999999999	68.5925	69.55	3974.6000000000004
2010-08-18	BWX	ETF	28.85	28.975	28.5	28.88	134322.0
2010-08-18	BWZ	ETF	35.52	35.52	35.24	35.37	15716.0
2010-08-18	BZQ	ETF	3310.4	3347.2	3278.4	3296.0	635.0
2010-08-18	CEF	ETF	14.98	15.13	14.92	15.1	662800.0

> showing 50 of 770 rows — these rows as CSV

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