PREVIEW / etf_daily / 2007-01-23

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-23.parquet
  size:    20 KB
  rows:    406

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-23	SPY	ETF	142.26	143.08	142.06	142.8	54064400.0
2007-01-23	QQQ	ETF	43.64	43.9801	43.5	43.58	133258480.0
2007-01-23	IWM	ETF	77.04	78.28	77.0	77.92	47783000.0
2007-01-23	DIA	ETF	124.71	125.41	124.58	125.33	6596600.0
2007-01-23	GLD	ETF	63.68	64.29	63.67	64.23	6322000.0
2007-01-23	TLT	ETF	88.02	88.05	87.57	87.62	1096800.0
2007-01-23	AAA	ETF	62.13	62.3	61.95	62.17	6300.0
2007-01-23	ADRE	ETF	38.56	39.43	38.51	39.43	331258.0
2007-01-23	AGG	ETF	99.89	99.89	99.64	99.7	334200.0
2007-01-23	AIQ	ETF	34.0	34.25	33.35	33.95	26620.0
2007-01-23	AIS	ETF	1.11	1.2	1.1	1.13	229600.0
2007-01-23	ARB	ETF	45.62	46.34	45.37	45.47	111600.0
2007-01-23	BAB	ETF	105.5	105.8	104.35	104.86	120200.0
2007-01-23	BBC	ETF	4.85	4.98	4.81	4.9	148700.0
2007-01-23	BBH	ETF	65.3667	65.73	64.6433	64.8867	1588800.0
2007-01-23	BITS	ETF	36.4	36.56	35.92	36.16	9522.0
2007-01-23	BNE	ETF	15.25	15.41	15.21	15.23	197300.0
2007-01-23	BRF	ETF	14.39	14.49	14.39	14.4799	16900.0
2007-01-23	BTF	ETF	108.1	108.69999999999999	108.1	108.35000000000001	2620.0
2007-01-23	CBON	ETF	32.6	33.266	32.6	33.09	91159.0
2007-01-23	CDL	ETF	10.24	10.29	10.12	10.29	212500.0
2007-01-23	CEF	ETF	9.3	9.36	9.23	9.36	385800.0
2007-01-23	CGO	ETF	16.82	16.84	16.71	16.84	29300.0
2007-01-23	CHB	ETF	8.07	8.55	8.0	8.32	1690000.0
2007-01-23	CHI	ETF	20.16	20.22	20.15	20.2	93600.0
2007-01-23	CHIC	ETF	31.6	32.49	31.6	32.35	402730.0
2007-01-23	CHY	ETF	17.26	17.39	17.25	17.28	137400.0
2007-01-23	CIL	ETF	25.33	25.33	25.31	25.31	500.0
2007-01-23	CN	ETF	48.85	49.89	48.5805	49.89	120800.0
2007-01-23	CNXT	ETF	1.95	2.0	1.92	1.94	6980453.0
2007-01-23	CPI	ETF	23.05	23.3	23.05	23.3	400.0
2007-01-23	CPST	ETF	0.97	0.99	0.941	0.95	3957612.0
2007-01-23	CSA	ETF	21.85	21.89	21.77	21.85	2200.0
2007-01-23	CSB	ETF	34.19	34.58	34.19	34.4201	11600.0
2007-01-23	CSD	ETF	25.29	25.42	25.28	25.41	8100.0
2007-01-23	CSM	ETF	1.345	1.35	1.345	1.3475	6400.0
2007-01-23	CSQ	ETF	15.55	15.55	15.38	15.45	450300.0
2007-01-23	CTEC	ETF	96.3	96.575	92.35049999999998	92.89999999999999	30059.2
2007-01-23	CVY	ETF	26.42	26.57	26.36	26.54	51700.0
2007-01-23	CWI	ETF	24.5467	24.7067	24.5467	24.66	68700.0
2007-01-23	DBA	ETF	26.25	26.58	26.05	26.57	542900.0
2007-01-23	DBB	ETF	24.2	24.45	24.11	24.2	23800.0
2007-01-23	DBC	ETF	23.2	23.7	23.06	23.7	483800.0
2007-01-23	DBE	ETF	23.52	24.04	23.52	24.02	10000.0
2007-01-23	DBO	ETF	22.7	23.29	22.53	23.15	30500.0
2007-01-23	DBP	ETF	25.67	25.82	25.62	25.82	22200.0
2007-01-23	DBS	ETF	25.88	26.21	25.88	26.21	2000.0
2007-01-23	DBV	ETF	26.55	26.55	26.45	26.5	319300.0
2007-01-23	DDM	ETF	6.8892	6.97	6.8892	6.9667	620400.0
2007-01-23	DEF	ETF	25.4	25.59	25.4	25.57	11300.0

> showing 50 of 406 rows — these rows as CSV

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