PREVIEW / etf_daily / 2007-01-03

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-03.parquet
  size:    19 KB
  rows:    390

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-03	SPY	ETF	142.25	142.86	140.57	141.37	94807600.0
2007-01-03	QQQ	ETF	43.46	44.06	42.52	43.24	168787533.0
2007-01-03	IWM	ETF	78.68	79.12	77.22	78.16	54095400.0
2007-01-03	DIA	ETF	125.16	125.68	123.88	124.47	11525000.0
2007-01-03	GLD	ETF	63.58	64.02	62.0	62.28	8061900.0
2007-01-03	TLT	ETF	89.22	89.46	88.66	89.06	1870400.0
2007-01-03	AAA	ETF	62.65	62.85	62.2201	62.23	3300.0
2007-01-03	ADRE	ETF	40.02	40.04	38.84	39.07	429929.0
2007-01-03	AGG	ETF	100.0	100.07	99.79	99.91	471200.0
2007-01-03	AIQ	ETF	32.65	33.15	32.25	33.0	39440.0
2007-01-03	AIS	ETF	1.22	1.24	1.19	1.2	196500.0
2007-01-03	ARB	ETF	43.58	44.5	43.49	44.15	247000.0
2007-01-03	BAB	ETF	106.13	106.389	104.95	105.8	98300.0
2007-01-03	BBC	ETF	5.1	5.45	5.1	5.2999	372800.0
2007-01-03	BBH	ETF	61.8	62.08	60.5833	61.2233	1002900.0
2007-01-03	BITS	ETF	35.28	35.7984	34.8	34.92	10841.0
2007-01-03	BNE	ETF	16.01	16.05	15.79	15.89	277700.0
2007-01-03	BRF	ETF	14.4	14.48	14.32	14.34	19800.0
2007-01-03	BTF	ETF	111.4	112.65	108.2	108.64999999999999	6360.0
2007-01-03	CBON	ETF	30.25	30.25	29.75	29.82	59608.0
2007-01-03	CDL	ETF	10.0	10.17	9.95	10.07	329100.0
2007-01-03	CEF	ETF	9.64	9.64	9.11	9.23	549500.0
2007-01-03	CGO	ETF	17.08	17.08	16.47	16.67	42800.0
2007-01-03	CHB	ETF	9.44	9.55	8.93	9.08	1516500.0
2007-01-03	CHI	ETF	20.27	20.27	20.03	20.09	106400.0
2007-01-03	CHIC	ETF	30.82	33.19	30.61	32.06	1407950.0
2007-01-03	CHY	ETF	17.25	17.48	16.96	17.03	203200.0
2007-01-03	CIL	ETF	25.12	25.4	25.12	25.39	4100.0
2007-01-03	CN	ETF	55.0	59.33	54.5	56.82	548800.0
2007-01-03	CNXT	ETF	2.06	2.09	2.03	2.07	10946049.0
2007-01-03	CPI	ETF	23.91	24.04	23.91	24.04	800.0
2007-01-03	CPST	ETF	1.24	1.25	1.15	1.15	2300600.0
2007-01-03	CSA	ETF	21.4	21.4	20.79	21.02	36100.0
2007-01-03	CSB	ETF	33.57	33.57	33.18	33.31	29900.0
2007-01-03	CSD	ETF	25.14	25.16	24.83	24.83	4900.0
2007-01-03	CSQ	ETF	15.53	15.59	15.5	15.56	505100.0
2007-01-03	CTEC	ETF	92.2	92.5	89.19999999999999	91.54999999999998	51311.600000000006
2007-01-03	CVY	ETF	26.56	26.59	26.33	26.43	40000.0
2007-01-03	DBC	ETF	24.27	24.34	23.66	23.7999	746800.0
2007-01-03	DBV	ETF	26.0	26.16	26.0	26.08	285800.0
2007-01-03	DDM	ETF	6.9867	7.0308	6.8367	6.9017	1249200.0
2007-01-03	DEF	ETF	25.2	25.2699	25.05	25.13	52200.0
2007-01-03	DES	ETF	19.3067	19.36	19.0367	19.2133	107400.0
2007-01-03	DEW	ETF	62.15	63.1	61.88	62.1	28500.0
2007-01-03	DFE	ETF	66.2	66.3	65.46	65.66	30000.0
2007-01-03	DFJ	ETF	50.96	51.25	50.55	50.87	37300.0
2007-01-03	DGT	ETF	76.59	76.75	75.84	76.13	9400.0
2007-01-03	DHS	ETF	57.97	58.39	57.57	57.84	51500.0
2007-01-03	DIM	ETF	64.4	64.45	63.75	64.03	25800.0
2007-01-03	DIV	ETF	13.7	13.71	13.61	13.64	38600.0

> showing 50 of 390 rows — these rows as CSV

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