PREVIEW / etf_daily / 2007-03-19

all etf daily files

  file:    by_date/etf_daily/2007/2007-03-19.parquet
  size:    21 KB
  rows:    437

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-03-19	SPY	ETF	139.26	140.33	139.15	140.2	96161200.0
2007-03-19	QQQ	ETF	43.06	43.39	42.95	43.27	95964699.0
2007-03-19	IWM	ETF	77.83	78.48	77.81	78.23	56720800.0
2007-03-19	DIA	ETF	121.56	122.28	121.5	122.28	6829200.0
2007-03-19	GLD	ETF	64.88	64.94	64.63	64.74	2990500.0
2007-03-19	TLT	ETF	89.58	89.7	89.52	89.66	693900.0
2007-03-19	AAA	ETF	62.4	62.64	62.25	62.64	14700.0
2007-03-19	ADRE	ETF	38.19	38.47	37.9	38.34	128052.0
2007-03-19	AGG	ETF	100.49	100.53	100.36	100.51	181300.0
2007-03-19	AIQ	ETF	36.25	39.85	36.25	39.8	144160.0
2007-03-19	AIS	ETF	1.13	1.2	1.13	1.17	71700.0
2007-03-19	ARB	ETF	46.2	46.84	46.13	46.27	119600.0
2007-03-19	BAB	ETF	97.62	98.0	97.464	97.94	34500.0
2007-03-19	BBC	ETF	3.35	3.53	3.33	3.36	129700.0
2007-03-19	BBH	ETF	58.3333	59.0467	58.3333	58.84	799800.0
2007-03-19	BITS	ETF	32.68	34.64	32.08	33.04	35296.0
2007-03-19	BNE	ETF	15.55	15.77	15.46	15.69	164400.0
2007-03-19	BRF	ETF	14.51	14.57	14.51	14.51	3100.0
2007-03-19	BTF	ETF	107.69999999999999	107.79999999999998	107.5	107.7575	2880.0
2007-03-19	CBON	ETF	30.9	31.07	30.77	30.9	35246.0
2007-03-19	CDL	ETF	9.74	9.74	9.61	9.7	347300.0
2007-03-19	CEF	ETF	9.35	9.4	9.31	9.34	125400.0
2007-03-19	CGO	ETF	16.82	16.88	16.74	16.87	10300.0
2007-03-19	CHB	ETF	9.55	9.79	9.38	9.4	2492600.0
2007-03-19	CHI	ETF	19.97	20.05	19.94	20.01	78900.0
2007-03-19	CHIC	ETF	27.45	27.89	27.36	27.42	350987.0
2007-03-19	CHY	ETF	16.38	16.48	16.38	16.46	153300.0
2007-03-19	CIL	ETF	25.67	25.67	25.67	25.67	200.0
2007-03-19	CN	ETF	44.93	45.15	44.53	45.13	87500.0
2007-03-19	CNXT	ETF	1.67	1.72	1.66	1.7	9461321.0
2007-03-19	CPI	ETF	22.75	22.75	22.2	22.2	1700.0
2007-03-19	CPST	ETF	0.83	0.86	0.83	0.85	1454177.0
2007-03-19	CSA	ETF	21.6	21.6	20.4	21.0	57800.0
2007-03-19	CSB	ETF	32.34	32.4	32.07	32.14	10800.0
2007-03-19	CSD	ETF	26.25	26.39	26.2	26.39	6700.0
2007-03-19	CSM	ETF	1.3225	1.3225	1.3225	1.3225	24000.0
2007-03-19	CSQ	ETF	14.79	15.1	14.79	15.07	310200.0
2007-03-19	CTEC	ETF	81.64999999999999	83.35000000000001	79.74999999999999	81.4	21645.800000000003
2007-03-19	CVY	ETF	26.26	26.48	26.26	26.46	14800.0
2007-03-19	CWI	ETF	24.6467	24.74	24.6	24.7267	27000.0
2007-03-19	DBA	ETF	25.88	26.12	25.7	25.99	96500.0
2007-03-19	DBB	ETF	24.32	24.78	24.32	24.5	30200.0
2007-03-19	DBC	ETF	24.26	24.4	24.21	24.37	148000.0
2007-03-19	DBE	ETF	25.33	25.6	25.33	25.49	700.0
2007-03-19	DBO	ETF	24.67	24.94	24.49	24.87	3700.0
2007-03-19	DBP	ETF	25.82	25.87	25.8	25.8	1700.0
2007-03-19	DBS	ETF	25.84	26.01	25.77	25.9	3600.0
2007-03-19	DBV	ETF	26.35	26.53	26.35	26.47	172100.0
2007-03-19	DDM	ETF	6.5525	6.6017	6.5325	6.5958	1148400.0
2007-03-19	DEF	ETF	25.46	25.6	25.44	25.59	14700.0

> showing 50 of 437 rows — these rows as CSV

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