PREVIEW / etf_daily / 2008-01-30

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-30.parquet
  size:    26 KB
  rows:    567

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
2008-01-30	SPY	ETF	135.58	138.54	134.6	134.91	334939200.0
2008-01-30	QQQ	ETF	44.24	45.32	44.18	44.37	220824400.0
2008-01-30	IWM	ETF	69.72	71.4	69.1	69.22	126086600.0
2008-01-30	DIA	ETF	124.21	126.68	123.48	123.78	24848200.0
2008-01-30	GLD	ETF	90.71	92.58	90.45	92.06	14378100.0
2008-01-30	TLT	ETF	94.69	94.77	93.59	94.32	3468000.0
2008-01-30	ADRE	ETF	49.25	50.8399	48.84	49.35	427549.0
2008-01-30	AGG	ETF	103.02	103.18	102.77	103.06	557800.0
2008-01-30	AIA	ETF	42.68	43.51	42.36	42.4601	7800.0
2008-01-30	AIQ	ETF	50.95	51.5	49.4	49.45	35180.0
2008-01-30	AIS	ETF	1.01	1.04	0.99	1.04	195800.0
2008-01-30	AIVI	ETF	64.09	65.83	63.92	64.32	30700.0
2008-01-30	ARB	ETF	39.78	40.42	39.45	39.5	539650.0
2008-01-30	BBH	ETF	54.2	54.9533	54.14	54.1533	1125000.0
2008-01-30	BIL	ETF	91.82	91.98	91.8	91.94	60100.0
2008-01-30	BITS	ETF	22.96	24.12	22.96	23.68	11025.0
2008-01-30	BIV	ETF	78.73	81.45	78.5	79.25	238200.0
2008-01-30	BJK	ETF	41.99	43.0	41.99	42.41	7600.0
2008-01-30	BKF	ETF	51.03	56.25	50.47	50.68	84700.0
2008-01-30	BLV	ETF	77.7	77.72	77.15	77.15	4300.0
2008-01-30	BMVP	ETF	15.67	16.2	15.67	15.76	88850.0
2008-01-30	BND	ETF	78.01	78.42	78.0	78.29	121500.0
2008-01-30	BNE	ETF	12.88	13.07	12.38	12.39	235000.0
2008-01-30	BRF	ETF	14.68	14.69	14.66	14.69	6900.0
2008-01-30	BSV	ETF	78.63	78.66	78.31	78.64	133400.0
2008-01-30	BTF	ETF	108.0	109.49999999999999	108.0	109.49949999999998	1620.0
2008-01-30	BWX	ETF	27.36	27.575	27.234	27.535	165430.0
2008-01-30	CBON	ETF	15.46	16.36	15.2	15.78	87003.0
2008-01-30	CDL	ETF	1.65	1.71	1.45	1.45	2325039.0
2008-01-30	CEF	ETF	12.28	12.65	11.95	12.32	1283700.0
2008-01-30	CGO	ETF	17.1	17.6899	17.09	17.44	17500.0
2008-01-30	CGW	ETF	23.44	23.75	22.99	23.44	59350.0
2008-01-30	CHB	ETF	10.08	10.43	9.51	9.69	2082774.0
2008-01-30	CHI	ETF	15.86	15.99	15.7	15.83	99200.0
2008-01-30	CHIC	ETF	16.64	17.67	16.47	17.21	1020707.0
2008-01-30	CHW	ETF	12.34	12.62	12.16	12.47	105291.0
2008-01-30	CHY	ETF	14.19	14.42	14.04	14.21	141704.0
2008-01-30	CMF	ETF	53.055	53.055	52.785	52.785	16200.0
2008-01-30	CN	ETF	61.85	65.57	61.85	62.59	298134.0
2008-01-30	CNXT	ETF	0.65	0.69	0.65	0.66	3425070.0
2008-01-30	COW	ETF	46.38	46.49	46.1001	46.37	20400.0
2008-01-30	CPST	ETF	1.51	1.57	1.48	1.523	2357011.0
2008-01-30	CSA	ETF	16.41	16.89	16.15	16.66	58600.0
2008-01-30	CSD	ETF	24.62	25.1	24.56	24.58	4800.0
2008-01-30	CSQ	ETF	13.53	13.75	13.35	13.61	307643.0
2008-01-30	CUT	ETF	21.5	22.37	21.35	21.55	20200.0
2008-01-30	CVY	ETF	23.4	23.68	23.21	23.28	36900.0
2008-01-30	CWI	ETF	24.8933	25.5533	24.82	25.04	126450.0
2008-01-30	CZA	ETF	23.91	25.07	23.91	25.07	2800.0
2008-01-30	DBA	ETF	36.68	36.78	36.25	36.78	1358400.0

> showing 50 of 567 rows — these rows as CSV

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