PREVIEW / etf_daily / 2007-07-12

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-12.parquet
  size:    23 KB
  rows:    494

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-07-12	SPY	ETF	152.37	154.75	152.34	154.39	133882500.0
2007-07-12	QQQ	ETF	49.05	49.67	48.92	49.56	107667041.0
2007-07-12	IWM	ETF	84.16	85.1	84.03	84.82	71638400.0
2007-07-12	DIA	ETF	136.33	138.67	136.32	138.34	13518100.0
2007-07-12	GLD	ETF	65.89	66.29	65.45	66.02	5870600.0
2007-07-12	TLT	ETF	84.55	84.58	83.87	84.03	1941200.0
2007-07-12	ADRE	ETF	48.26	49.2	48.18	49.1601	184126.0
2007-07-12	AGG	ETF	98.02	98.02	97.67	97.78	234100.0
2007-07-12	AIQ	ETF	49.65	52.0	49.6	52.0	36260.0
2007-07-12	AIS	ETF	1.73	1.75	1.7	1.73	261600.0
2007-07-12	ARB	ETF	53.73	53.85	53.2	53.52	374300.0
2007-07-12	BBH	ETF	56.1833	56.47	55.6933	56.4667	936000.0
2007-07-12	BIL	ETF	91.72	91.72	91.68	91.72	14700.0
2007-07-12	BITS	ETF	27.2	27.56	27.08	27.2	20672.0
2007-07-12	BIV	ETF	73.5	73.5	73.27	73.27	7500.0
2007-07-12	BLV	ETF	72.6	72.6	72.13	72.27	10000.0
2007-07-12	BMVP	ETF	18.16	18.3533	18.1567	18.34	33900.0
2007-07-12	BND	ETF	74.03	74.03	73.71	73.81	28100.0
2007-07-12	BNE	ETF	19.74	20.09	19.65	20.04	186000.0
2007-07-12	BRF	ETF	14.51	14.51	14.46	14.49	7200.0
2007-07-12	BSV	ETF	74.84	74.84	74.7	74.74	395600.0
2007-07-12	BTF	ETF	108.3	109.8	108.3	109.74999999999999	1000.0
2007-07-12	CBON	ETF	27.1	27.85	27.1	27.73	109076.0
2007-07-12	CDL	ETF	6.25	6.25	6.12	6.25	3686930.0
2007-07-12	CEF	ETF	9.29	9.39	9.27	9.36	284100.0
2007-07-12	CGO	ETF	18.14	18.29	18.07	18.2416	24800.0
2007-07-12	CGW	ETF	26.0	26.27	25.94	26.26	138500.0
2007-07-12	CHB	ETF	9.45	9.68	9.09	9.63	2033001.0
2007-07-12	CHI	ETF	19.01	19.08	18.84	18.98	143300.0
2007-07-12	CHIC	ETF	24.59	24.98	24.53	24.68	1236164.0
2007-07-12	CHY	ETF	15.9	16.0	15.8201	15.99	170500.0
2007-07-12	CN	ETF	55.0	56.23	55.0	56.12	104100.0
2007-07-12	CNXT	ETF	1.47	1.53	1.46	1.53	5778697.0
2007-07-12	CPST	ETF	1.38	1.48	1.31	1.41	13034057.0
2007-07-12	CSA	ETF	18.27	18.75	18.18	18.75	165000.0
2007-07-12	CSB	ETF	32.46	32.71	32.35	32.68	24700.0
2007-07-12	CSD	ETF	31.34	31.42	31.26	31.42	23600.0
2007-07-12	CSM	ETF	1.435	1.435	1.4175	1.435	4400.0
2007-07-12	CSQ	ETF	15.2	15.3	15.2	15.29	252600.0
2007-07-12	CTEC	ETF	109.1	112.39999999999999	109.04999999999998	110.5	16166.6
2007-07-12	CVY	ETF	27.78	27.99	27.78	27.99	18200.0
2007-07-12	CWI	ETF	28.16	28.5267	28.16	28.48	15300.0
2007-07-12	CZA	ETF	27.65	27.75	27.64	27.75	900.0
2007-07-12	DBA	ETF	27.28	27.54	27.03	27.45	278500.0
2007-07-12	DBB	ETF	27.8	27.97	27.51	27.62	45700.0
2007-07-12	DBC	ETF	26.63	26.71	26.38	26.61	282400.0
2007-07-12	DBE	ETF	29.74	29.83	29.31	29.45	39300.0
2007-07-12	DBO	ETF	27.88	27.97	27.46	27.64	15100.0
2007-07-12	DBP	ETF	26.1	26.24	26.1	26.15	15800.0
2007-07-12	DBS	ETF	25.6	25.8	25.58	25.7335	18400.0

> showing 50 of 494 rows — these rows as CSV

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