PREVIEW / etf_daily / 2007-01-30

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-30.parquet
  size:    20 KB
  rows:    411

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-01-30	SPY	ETF	142.35	142.86	142.06	142.79	70407600.0
2007-01-30	QQQ	ETF	43.68	43.79	43.52	43.63	69984738.0
2007-01-30	IWM	ETF	78.89	79.35	78.51	79.18	33830600.0
2007-01-30	DIA	ETF	124.9	125.27	124.64	125.16	7639900.0
2007-01-30	GLD	ETF	63.92	64.23	63.83	64.22	3094200.0
2007-01-30	TLT	ETF	86.89	86.91	86.76	86.82	1295100.0
2007-01-30	AAA	ETF	61.21	61.23	61.09	61.12	2500.0
2007-01-30	ADRE	ETF	38.44	38.91	37.64	38.87	266649.0
2007-01-30	AGG	ETF	99.55	99.56	99.37	99.55	293100.0
2007-01-30	AIQ	ETF	35.1	35.1	34.3	34.75	31900.0
2007-01-30	AIS	ETF	1.2	1.24	1.17	1.21	118800.0
2007-01-30	ARB	ETF	46.48	46.64	46.35	46.46	238400.0
2007-01-30	BAB	ETF	109.08	109.31	107.71	107.98	168600.0
2007-01-30	BBC	ETF	4.98	5.25	4.98	5.05	171900.0
2007-01-30	BBH	ETF	63.1	63.5667	63.1	63.4733	612300.0
2007-01-30	BITS	ETF	40.96	42.4	40.6824	41.48	23418.0
2007-01-30	BNE	ETF	15.35	15.45	15.26	15.3	53600.0
2007-01-30	BRF	ETF	14.38	14.45	14.38	14.45	9600.0
2007-01-30	BTF	ETF	108.45	108.9	108.35000000000001	108.35000000000001	2340.0
2007-01-30	CBON	ETF	33.62	33.69	33.15	33.4	113048.0
2007-01-30	CDL	ETF	10.36	10.48	10.3	10.47	188200.0
2007-01-30	CEF	ETF	9.37	9.51	9.36	9.44	273800.0
2007-01-30	CEW	ETF	25.82	25.91	25.8	25.91	1400.0
2007-01-30	CGO	ETF	16.96	17.2	16.93	17.17	11500.0
2007-01-30	CHB	ETF	8.05	8.16	8.02	8.1	388400.0
2007-01-30	CHI	ETF	20.26	20.3	20.25	20.27	53400.0
2007-01-30	CHIC	ETF	29.58	30.4	29.5101	30.1	998169.0
2007-01-30	CHY	ETF	17.36	17.37	17.31	17.34	97700.0
2007-01-30	CIL	ETF	25.44	25.44	25.44	25.44	200.0
2007-01-30	CN	ETF	49.53	50.68	49.53	50.56	112700.0
2007-01-30	CNXT	ETF	1.87	1.87	1.84	1.87	6694948.0
2007-01-30	CPI	ETF	23.7	23.7	23.7	23.7	100.0
2007-01-30	CPST	ETF	0.959	0.96	0.9255	0.94	1806759.0
2007-01-30	CSA	ETF	21.25	22.2301	21.19	22.2	20700.0
2007-01-30	CSB	ETF	33.34	33.36	33.1	33.2	13800.0
2007-01-30	CSD	ETF	25.68	25.81	25.63	25.81	33900.0
2007-01-30	CSM	ETF	1.3425	1.3425	1.3425	1.3425	58400.0
2007-01-30	CSQ	ETF	15.47	15.55	15.43	15.49	366500.0
2007-01-30	CTEC	ETF	91.75	92.5	91.25	92.05	17845.2
2007-01-30	CVY	ETF	26.64	26.72	26.63	26.72	40900.0
2007-01-30	CWI	ETF	24.52	24.6	24.4933	24.5467	11100.0
2007-01-30	DBA	ETF	25.51	25.92	25.4	25.92	159800.0
2007-01-30	DBB	ETF	23.15	23.27	23.1	23.25	20900.0
2007-01-30	DBC	ETF	23.1	23.75	23.05	23.74	347000.0
2007-01-30	DBE	ETF	23.64	24.72	23.64	24.67	227400.0
2007-01-30	DBO	ETF	23.06	24.0	22.98	23.87	10000.0
2007-01-30	DBP	ETF	25.64	25.81	25.64	25.81	24500.0
2007-01-30	DBS	ETF	26.3	26.34	26.2453	26.34	2700.0
2007-01-30	DBV	ETF	26.3	26.3	26.21	26.25	174700.0
2007-01-30	DDM	ETF	6.9058	6.9458	6.89	6.9458	739200.0

> showing 50 of 411 rows — these rows as CSV

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