PREVIEW / etf_daily / 2007-02-12

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-12.parquet
  size:    20 KB
  rows:    422

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
2007-02-12	SPY	ETF	143.94	144.04	143.19	143.45	65657000.0
2007-02-12	QQQ	ETF	43.88	43.89	43.59	43.7	126965882.0
2007-02-12	IWM	ETF	80.28	80.3	79.6	80.09	39561300.0
2007-02-12	DIA	ETF	125.88	126.04	125.39	125.59	9208000.0
2007-02-12	GLD	ETF	66.0	66.11	65.41	65.67	4113500.0
2007-02-12	TLT	ETF	87.49	87.65	87.33	87.43	467600.0
2007-02-12	AAA	ETF	60.44	60.44	60.2084	60.2084	1700.0
2007-02-12	ADRE	ETF	39.5	39.5	38.96	39.22	165793.0
2007-02-12	AGG	ETF	99.68	99.73	99.46	99.63	304700.0
2007-02-12	AIQ	ETF	36.45	36.45	35.0	35.15	27520.0
2007-02-12	AIS	ETF	1.23	1.2468	1.19	1.22	81900.0
2007-02-12	ARB	ETF	46.0	46.49	46.0	46.3	136560.0
2007-02-12	BAB	ETF	109.97	111.0	109.87	110.87	83500.0
2007-02-12	BBC	ETF	4.23	4.3	4.09	4.1	205360.0
2007-02-12	BBH	ETF	63.0833	63.3133	62.38	62.56	1374600.0
2007-02-12	BITS	ETF	39.52	39.52	37.92	38.48	12908.0
2007-02-12	BNE	ETF	15.27	15.51	15.27	15.42	109400.0
2007-02-12	BRF	ETF	14.5	14.5	14.43	14.44	6800.0
2007-02-12	BTF	ETF	112.94999999999999	112.94999999999999	112.3	112.35	3300.0
2007-02-12	CBON	ETF	32.87	33.26	32.76	32.99	28593.0
2007-02-12	CDL	ETF	10.68	10.75	10.21	10.34	542827.0
2007-02-12	CEF	ETF	9.65	9.7	9.41	9.61	474100.0
2007-02-12	CGO	ETF	17.16	17.16	16.94	17.0	19500.0
2007-02-12	CHB	ETF	7.85	7.92	7.7	7.91	1068526.0
2007-02-12	CHI	ETF	20.28	20.28	20.1	20.17	89969.0
2007-02-12	CHIC	ETF	30.17	30.29	29.26	29.91	618050.0
2007-02-12	CHY	ETF	17.18	17.1998	17.02	17.02	160600.0
2007-02-12	CIL	ETF	25.6	25.6	25.6	25.6	100.0
2007-02-12	CN	ETF	49.99	50.0	49.2	49.63	46700.0
2007-02-12	CNXT	ETF	2.01	2.02	1.96	1.97	5434280.0
2007-02-12	CPST	ETF	0.95	0.955	0.89	0.893	8879820.0
2007-02-12	CSA	ETF	21.9	22.27	21.69	21.8	14900.0
2007-02-12	CSB	ETF	33.17	33.31	32.8	32.9	27500.0
2007-02-12	CSD	ETF	25.96	25.99	25.92	25.95	8500.0
2007-02-12	CSQ	ETF	15.38	15.38	15.03	15.22	434469.0
2007-02-12	CTEC	ETF	87.69999999999999	87.79999999999998	86.05	87.05	11556.0
2007-02-12	CVY	ETF	26.88	26.95	26.78	26.84	28500.0
2007-02-12	CWI	ETF	24.74	24.7933	24.7267	24.76	14850.0
2007-02-12	DBA	ETF	26.19	26.22	25.86	25.94	161900.0
2007-02-12	DBB	ETF	22.7	22.77	22.21	22.52	14000.0
2007-02-12	DBC	ETF	24.2	24.2699	23.85	23.96	209200.0
2007-02-12	DBE	ETF	25.17	25.19	24.62	24.75	87000.0
2007-02-12	DBO	ETF	24.9	24.92	24.14	24.4	11500.0
2007-02-12	DBP	ETF	26.48	26.53	26.27	26.42	31500.0
2007-02-12	DBS	ETF	27.08	27.1499	26.82	27.0001	3800.0
2007-02-12	DBV	ETF	26.32	26.38	26.26	26.36	128500.0
2007-02-12	DDM	ETF	7.0017	7.0167	6.9425	6.9617	900000.0
2007-02-12	DEF	ETF	26.15	26.15	25.93	25.9597	9400.0
2007-02-12	DES	ETF	19.61	19.61	19.4533	19.55	91200.0
2007-02-12	DEW	ETF	62.67	62.67	62.45	62.57	3000.0

> showing 50 of 422 rows — these rows as CSV

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