PREVIEW / etf_daily / 2007-01-25

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-25.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-25	SPY	ETF	143.86	143.92	142.01	142.26	73583800.0
2007-01-25	QQQ	ETF	44.37	44.47	43.58	43.73	158464297.0
2007-01-25	IWM	ETF	78.71	78.95	77.53	77.78	57289400.0
2007-01-25	DIA	ETF	126.03	126.12	124.79	124.97	8768800.0
2007-01-25	GLD	ETF	64.8	64.88	63.98	64.06	5985700.0
2007-01-25	TLT	ETF	87.45	87.47	86.88	86.98	1397000.0
2007-01-25	AAA	ETF	61.5	61.68	61.25	61.25	4200.0
2007-01-25	ADRE	ETF	39.94	39.99	38.53	38.6	296668.0
2007-01-25	AGG	ETF	99.71	99.71	99.44	99.54	296700.0
2007-01-25	AIQ	ETF	34.35	35.4	34.0	34.2	25620.0
2007-01-25	AIS	ETF	1.15	1.17	1.12	1.17	114700.0
2007-01-25	ARB	ETF	45.92	45.92	45.05	45.29	90400.0
2007-01-25	BAB	ETF	103.96	104.11	102.8	102.96	125400.0
2007-01-25	BBC	ETF	5.07	5.07	4.91	5.0	182500.0
2007-01-25	BBH	ETF	65.3667	65.3667	64.4333	64.53	1179900.0
2007-01-25	BITS	ETF	38.24	41.0	38.0	38.8	54604.0
2007-01-25	BNE	ETF	15.21	15.31	15.01	15.08	96500.0
2007-01-25	BRF	ETF	14.42	14.43	14.39	14.39	10400.0
2007-01-25	BTF	ETF	109.0	109.0	108.0	108.05	2240.0
2007-01-25	CBON	ETF	33.4	33.75	32.77	33.38	95880.0
2007-01-25	CDL	ETF	10.31	10.39	10.25	10.36	450100.0
2007-01-25	CEF	ETF	9.48	9.49	9.4	9.44	646400.0
2007-01-25	CEW	ETF	25.85	25.94	25.85	25.94	1300.0
2007-01-25	CGO	ETF	16.91	17.02	16.82	16.92	12600.0
2007-01-25	CHB	ETF	8.4	8.51	7.99	8.13	1066300.0
2007-01-25	CHI	ETF	20.31	20.38	20.23	20.28	88400.0
2007-01-25	CHIC	ETF	30.71	30.85	28.35	29.02	3746302.0
2007-01-25	CHY	ETF	17.28	17.39	17.25	17.32	174800.0
2007-01-25	CIL	ETF	25.33	25.33	25.32	25.33	2800.0
2007-01-25	CN	ETF	50.16	50.4	49.0	49.4	179400.0
2007-01-25	CNXT	ETF	1.98	2.01	1.95	2.01	12810515.0
2007-01-25	CPST	ETF	0.95	0.95	0.8801	0.9	3178324.0
2007-01-25	CSA	ETF	21.9	21.9	21.77	21.89	3300.0
2007-01-25	CSB	ETF	33.84	33.92	33.46	33.4601	10900.0
2007-01-25	CSD	ETF	25.6	25.6	25.21	25.24	17700.0
2007-01-25	CSM	ETF	1.35	1.35	1.35	1.35	400.0
2007-01-25	CSQ	ETF	15.4	15.42	15.23	15.3	468200.0
2007-01-25	CTEC	ETF	92.94999999999999	93.75	92.44999999999999	93.49999999999999	10232.400000000001
2007-01-25	CVY	ETF	26.73	26.73	26.5	26.54	37600.0
2007-01-25	CWI	ETF	24.7333	24.7467	24.32	24.4133	65550.0
2007-01-25	DBA	ETF	26.01	26.15	25.77	25.93	226100.0
2007-01-25	DBB	ETF	24.35	24.41	24.24	24.33	28700.0
2007-01-25	DBC	ETF	23.59	23.7	23.28	23.29	366200.0
2007-01-25	DBE	ETF	24.15	24.15	23.63	23.63	17500.0
2007-01-25	DBO	ETF	23.68	23.68	22.87	23.01	67500.0
2007-01-25	DBP	ETF	26.01	26.03	25.74	25.76	7900.0
2007-01-25	DBS	ETF	26.52	26.55	26.2499	26.2499	9600.0
2007-01-25	DBV	ETF	26.45	26.45	26.27	26.35	199400.0
2007-01-25	DDM	ETF	7.0333	7.0433	6.9033	6.9283	1093200.0
2007-01-25	DEF	ETF	25.75	25.77	25.62	25.63	40700.0

> showing 50 of 411 rows — these rows as CSV

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