PREVIEW / etf_daily / 2010-07-14

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-14.parquet
  size:    33 KB
  rows:    756

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-14	SPY	ETF	109.31	110.08	108.86	109.65	184426800.0
2010-07-14	QQQ	ETF	45.42	45.81	45.24	45.56	87694697.0
2010-07-14	IWM	ETF	64.02	64.39	63.47	63.97	52526100.0
2010-07-14	DIA	ETF	103.53	104.09	103.12	103.75	8757900.0
2010-07-14	GLD	ETF	118.26	119.13	117.59	118.3	9574800.0
2010-07-14	TLT	ETF	98.72	99.49	98.39	99.32	5417300.0
2010-07-14	AAXJ	ETF	54.87	55.21	54.77	55.04	647900.0
2010-07-14	ACWI	ETF	40.32	40.53	40.11	40.46	145600.0
2010-07-14	ACWX	ETF	37.87	38.16	37.7899	38.08	58271.0
2010-07-14	ADRE	ETF	41.15	41.308	40.85	41.17	2251903.0
2010-07-14	AFK	ETF	28.94	29.21	28.79	29.14	51932.0
2010-07-14	AGG	ETF	106.74	106.98	106.73	106.95	786900.0
2010-07-14	AGQ	ETF	119.44	122.9	118.3	121.14	131300.0
2010-07-14	AGZ	ETF	110.01	110.1	109.95	110.0875	28325.0
2010-07-14	AIA	ETF	38.8	39.026	38.7	38.9681	10842.0
2010-07-14	AIQ	ETF	19.85	20.65	19.65	20.65	59676.0
2010-07-14	AIS	ETF	1.66	1.68	1.61	1.62	300514.0
2010-07-14	AIVI	ETF	39.12	39.75	39.09	39.28	68200.0
2010-07-14	AMJ	ETF	32.32	32.42	32.1	32.36	1020140.0
2010-07-14	AOA	ETF	29.64	29.81	29.53	29.6	8000.0
2010-07-14	AOK	ETF	27.67	27.69	27.6401	27.68	4907.0
2010-07-14	AOM	ETF	28.1116	28.21	28.1004	28.177	9563.0
2010-07-14	AOR	ETF	28.7294	28.84	28.7099	28.81	6717.0
2010-07-14	ARB	ETF	27.4	27.91	27.36	27.79	136861.0
2010-07-14	BAB	ETF	25.77	26.0	25.77	25.98	186796.0
2010-07-14	BAL	ETF	36.08	36.355	36.05	36.355	2950.0
2010-07-14	BALT	ETF	10.68	10.98	10.47	10.8	88301.0
2010-07-14	BBH	ETF	30.1133	30.1233	29.8867	29.9933	54000.0
2010-07-14	BIB	ETF	5.5097	5.5606	5.49	5.49	18400.0
2010-07-14	BICK	ETF	28.2	28.2	28.0701	28.2	666.0
2010-07-14	BIL	ETF	91.7	91.72	91.7	91.72	159200.0
2010-07-14	BITS	ETF	27.6	27.8	26.92	27.8	150.0
2010-07-14	BIV	ETF	83.24	83.52	83.15	83.47	189600.0
2010-07-14	BJK	ETF	24.16	24.35	24.11	24.19	16400.0
2010-07-14	BKF	ETF	43.0	43.39	42.9119	43.33	113909.0
2010-07-14	BLV	ETF	81.01	81.37	80.64	81.35	81100.0
2010-07-14	BMVP	ETF	12.3133	12.3816	12.2528	12.3133	10596.0
2010-07-14	BND	ETF	81.09	81.23	81.01	81.19	795800.0
2010-07-14	BNE	ETF	11.28	11.3	11.27	11.28	374299.0
2010-07-14	BNO	ETF	25.93	26.145	25.875	25.91	24000.0
2010-07-14	BRF	ETF	45.99	46.65	45.86	46.44	226562.0
2010-07-14	BSCE	ETF	20.45	20.46	20.4336	20.46	3444.0
2010-07-14	BSV	ETF	80.85	81.0	80.85	80.97	392700.0
2010-07-14	BTF	ETF	69.19999999999999	69.45	69.0	69.0	4206.6
2010-07-14	BWX	ETF	27.56	27.62	27.5	27.54	187354.0
2010-07-14	BWZ	ETF	34.32	34.57	34.32	34.5	23035.0
2010-07-14	BZQ	ETF	3848.0	3891.2	3761.6	3820.8	544.0
2010-07-14	CEF	ETF	14.89	15.0	14.76	14.83	582200.0
2010-07-14	CEW	ETF	21.56	21.7	21.56	21.66	329639.0
2010-07-14	CGO	ETF	13.16	13.2	12.99	13.2	20338.0

> showing 50 of 756 rows — these rows as CSV

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