PREVIEW / etf_daily / 2007-03-01

all etf daily files

  file:    by_date/etf_daily/2007/2007-03-01.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-01	SPY	ETF	139.34	141.25	138.05	140.51	212828600.0
2007-03-01	QQQ	ETF	42.55	43.54	42.24	43.13	231967519.0
2007-03-01	IWM	ETF	77.47	79.1	76.75	78.42	97674800.0
2007-03-01	DIA	ETF	121.41	122.9	120.05	122.44	24877800.0
2007-03-01	GLD	ETF	66.23	66.75	65.58	65.82	7108000.0
2007-03-01	TLT	ETF	90.28	90.43	89.65	89.75	2423900.0
2007-03-01	AAA	ETF	60.36	60.36	60.0	60.27	4700.0
2007-03-01	ADRE	ETF	35.49	37.61	34.37	37.41	500360.0
2007-03-01	AGG	ETF	100.7	100.72	100.29	100.44	662900.0
2007-03-01	AIQ	ETF	35.15	36.3	34.1	36.05	40380.0
2007-03-01	AIS	ETF	1.19	1.19	1.14	1.18	52000.0
2007-03-01	ARB	ETF	44.41	44.95	43.72	44.81	245700.0
2007-03-01	BAB	ETF	103.98	104.59	103.48	104.22	78800.0
2007-03-01	BBC	ETF	4.11	4.2	4.02	4.12	110800.0
2007-03-01	BBH	ETF	59.6467	60.2033	59.1667	59.6667	2393100.0
2007-03-01	BITS	ETF	27.76	27.88	26.56	26.72	137252.0
2007-03-01	BNE	ETF	15.38	15.64	15.37	15.54	320739.0
2007-03-01	BRF	ETF	14.61	14.6101	14.54	14.56	6700.0
2007-03-01	BTF	ETF	109.3	110.19999999999999	108.0	109.8	4180.0
2007-03-01	CBON	ETF	30.68	31.92	30.26	31.42	48646.0
2007-03-01	CDL	ETF	10.17	10.22	9.82	10.22	492150.0
2007-03-01	CEF	ETF	9.75	9.75	9.4	9.42	351300.0
2007-03-01	CGO	ETF	16.17	16.37	16.101	16.37	25500.0
2007-03-01	CHB	ETF	7.78	8.16	7.57	8.02	2433415.0
2007-03-01	CHI	ETF	20.06	20.19	20.0	20.11	101515.0
2007-03-01	CHIC	ETF	28.85	29.48	28.27	29.01	364534.0
2007-03-01	CHY	ETF	16.87	17.0	16.83	16.92	140022.0
2007-03-01	CIL	ETF	25.48	25.48	25.48	25.48	300.0
2007-03-01	CN	ETF	45.22	45.84	43.75	45.3	151800.0
2007-03-01	CNXT	ETF	1.95	1.99	1.92	1.98	11340685.0
2007-03-01	CPI	ETF	22.95	22.95	22.95	22.95	100.0
2007-03-01	CPST	ETF	0.88	0.91	0.86	0.89	3364255.0
2007-03-01	CSA	ETF	22.13	22.49	21.79	21.92	8700.0
2007-03-01	CSB	ETF	31.45	31.73	31.23	31.6	20900.0
2007-03-01	CSD	ETF	25.64	25.99	25.45	25.87	17600.0
2007-03-01	CSM	ETF	1.31	1.31	1.31	1.31	8000.0
2007-03-01	CSQ	ETF	14.95	14.95	14.62	14.77	456425.0
2007-03-01	CTEC	ETF	81.69999999999999	82.69999999999999	80.74999999999999	81.4	10906.2
2007-03-01	CVY	ETF	26.4	26.71	26.02	26.63	43300.0
2007-03-01	CWI	ETF	24.1333	24.5	24.0533	24.4533	164550.0
2007-03-01	DBA	ETF	26.74	26.77	26.23	26.64	167400.0
2007-03-01	DBB	ETF	24.46	24.61	24.29	24.43	12200.0
2007-03-01	DBC	ETF	25.11	25.17	24.89	25.03	169100.0
2007-03-01	DBE	ETF	26.33	26.53	26.23	26.47	31700.0
2007-03-01	DBO	ETF	25.75	26.04	25.3	25.96	44600.0
2007-03-01	DBP	ETF	26.74	26.75	26.24	26.39	16200.0
2007-03-01	DBS	ETF	27.78	27.79	26.57	26.76	17800.0
2007-03-01	DBV	ETF	26.17	26.28	26.0901	26.24	161500.0
2007-03-01	DDM	ETF	6.5	6.6675	6.4333	6.6175	2676000.0
2007-03-01	DEF	ETF	25.4	25.71	25.2	25.58	24500.0

> showing 50 of 437 rows — these rows as CSV

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