PREVIEW / etf_daily / 2010-11-19

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-19.parquet
  size:    34 KB
  rows:    801

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-11-19	SPY	ETF	119.9	120.34	119.25	120.29	156852900.0
2010-11-19	QQQ	ETF	52.34	52.59	52.14	52.47	54512708.0
2010-11-19	IWM	ETF	72.0	72.61	71.53	72.45	32830300.0
2010-11-19	DIA	ETF	111.66	112.06	111.18	112.01	4474300.0
2010-11-19	GLD	ETF	131.48	132.35	131.01	132.2	14146400.0
2010-11-19	TLT	ETF	96.09	96.59	95.79	96.59	8359500.0
2010-11-19	AAXJ	ETF	62.57	62.67	61.88	62.63	2430700.0
2010-11-19	ACWI	ETF	45.3	45.54	45.01	45.54	167900.0
2010-11-19	ACWX	ETF	43.18	43.51	42.97	43.51	53581.0
2010-11-19	ADRE	ETF	46.2	46.32	45.8	46.29	48277.0
2010-11-19	AFK	ETF	33.78	34.08	33.5601	34.08	17363.0
2010-11-19	AGG	ETF	107.22	107.37	107.19	107.3	658200.0
2010-11-19	AGQ	ETF	240.68	255.0	236.1	254.0	699950.0
2010-11-19	AGZ	ETF	110.49	110.736	110.49	110.695	10153.0
2010-11-19	AIA	ETF	45.16	45.16	44.658	45.09	22061.0
2010-11-19	AIQ	ETF	20.55	20.6	20.15	20.2	12587.0
2010-11-19	AIS	ETF	1.42	1.48	1.41	1.45	252045.0
2010-11-19	AIVI	ETF	44.63	45.02	44.42	45.02	20000.0
2010-11-19	AMJ	ETF	36.09	36.3	35.99	36.3	706682.0
2010-11-19	AMLP	ETF	79.4	79.5	79.0	79.45	106260.0
2010-11-19	AOA	ETF	32.95	33.11	32.85	33.11	4100.0
2010-11-19	AOK	ETF	28.57	28.65	28.53	28.65	11367.0
2010-11-19	AOM	ETF	29.58	29.67	29.524	29.67	7277.0
2010-11-19	AOR	ETF	30.7	30.87	30.69	30.85	9103.0
2010-11-19	ARB	ETF	26.24	26.45	26.07	26.22	121254.0
2010-11-19	BAB	ETF	25.37	25.55	25.37	25.53	517126.0
2010-11-19	BAL	ETF	62.37	62.559	61.43	61.69	58401.0
2010-11-19	BALT	ETF	11.75	12.19	11.6	12.14	150331.0
2010-11-19	BBH	ETF	33.33	33.3733	33.1667	33.2833	33600.0
2010-11-19	BIB	ETF	6.7337	6.7525	6.6525	6.7525	27880.0
2010-11-19	BICK	ETF	32.71	32.73	32.359	32.704	28474.0
2010-11-19	BIL	ETF	91.7	91.72	91.7	91.7	154650.0
2010-11-19	BIS	ETF	9104.0	9139.2	9104.0	9136.0	21.25
2010-11-19	BITS	ETF	28.0	28.24	27.8	28.24	450.0
2010-11-19	BIV	ETF	85.22	85.36	85.11	85.3	136600.0
2010-11-19	BJK	ETF	31.14	31.47	31.14	31.44	13400.0
2010-11-19	BKF	ETF	48.93	49.1281	48.48	49.01	284983.0
2010-11-19	BLV	ETF	80.87	81.19	80.8	81.06	22400.0
2010-11-19	BMVP	ETF	14.113	14.213	14.063	14.2	20968.0
2010-11-19	BND	ETF	81.73	81.84	81.67	81.76	1286400.0
2010-11-19	BNE	ETF	11.39	11.39	11.35	11.37	85513.0
2010-11-19	BRF	ETF	59.86	60.57	59.64	60.54	242277.0
2010-11-19	BSCE	ETF	20.87	20.87	20.8641	20.87	19392.0
2010-11-19	BSV	ETF	81.34	81.42	81.32	81.35	550000.0
2010-11-19	BTF	ETF	77.8	78.39999999999999	77.6	78.1	1013.2
2010-11-19	BWX	ETF	29.605	29.72	29.555	29.57	650328.0
2010-11-19	BWZ	ETF	36.86	37.15	36.85	37.15	31789.0
2010-11-19	BZQ	ETF	2670.4	2704.0	2628.8	2633.6	192.5
2010-11-19	CEF	ETF	18.38	18.73	18.21	18.68	850000.0
2010-11-19	CEW	ETF	23.05	23.09	23.03	23.08	212416.0

> showing 50 of 801 rows — these rows as CSV

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