PREVIEW / etf_daily / 2008-03-27

all etf daily files

  file:    by_date/etf_daily/2008/2008-03-27.parquet
  size:    26 KB
  rows:    575

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-03-27	SPY	ETF	134.2	134.44	132.36	132.78	225153200.0
2008-03-27	QQQ	ETF	44.44	44.51	43.71	43.71	143868548.0
2008-03-27	IWM	ETF	70.08	70.08	68.97	69.0	63938500.0
2008-03-27	DIA	ETF	124.56	124.7	122.83	123.15	17362000.0
2008-03-27	GLD	ETF	93.51	94.09	92.95	93.46	7560500.0
2008-03-27	TLT	ETF	94.64	95.36	94.54	94.63	2405700.0
2008-03-27	ADRE	ETF	49.27	49.43	48.598	48.68	274717.0
2008-03-27	AGG	ETF	102.5	102.77	102.3	102.59	371300.0
2008-03-27	AIA	ETF	43.57	43.57	42.79	42.98	5700.0
2008-03-27	AIQ	ETF	44.15	44.85	42.5	44.4	30733.0
2008-03-27	AIS	ETF	0.98	0.98	0.9	0.92	74800.0
2008-03-27	AIVI	ETF	65.0	65.0	63.78	63.84	15100.0
2008-03-27	ARB	ETF	42.7	43.06	42.43	42.68	402000.0
2008-03-27	BBH	ETF	58.2733	58.2733	57.3933	57.4167	300600.0
2008-03-27	BIL	ETF	91.86	91.88	91.8	91.88	8300.0
2008-03-27	BITS	ETF	22.56	22.68	21.88	22.32	3856.0
2008-03-27	BIV	ETF	79.06	79.26	78.92	79.01	55400.0
2008-03-27	BJK	ETF	41.01	41.08	40.79	40.79	400.0
2008-03-27	BKF	ETF	49.99	49.99	48.94	48.94	22200.0
2008-03-27	BLV	ETF	77.28	77.28	76.21	76.4	4000.0
2008-03-27	BMVP	ETF	15.47	15.66	15.43	15.43	44800.0
2008-03-27	BND	ETF	77.55	77.93	77.55	77.81	86600.0
2008-03-27	BNE	ETF	15.52	15.62	15.11	15.11	146400.0
2008-03-27	BRF	ETF	14.66	14.68	14.58	14.66	28800.0
2008-03-27	BSV	ETF	78.77	78.82	78.68	78.74	48100.0
2008-03-27	BTF	ETF	100.64999999999999	102.24999999999999	100.25	100.44999999999999	4860.0
2008-03-27	BWX	ETF	29.035	29.035	28.92	28.965	191400.0
2008-03-27	CBON	ETF	13.93	14.32	13.65	14.01	174978.0
2008-03-27	CDL	ETF	1.61	1.66	1.55	1.56	684515.0
2008-03-27	CEF	ETF	13.35	13.35	13.02	13.23	696800.0
2008-03-27	CGO	ETF	16.39	16.4	16.25	16.4	14700.0
2008-03-27	CGW	ETF	23.5	23.95	23.39	23.66	55600.0
2008-03-27	CHB	ETF	10.04	10.48	9.69	9.76	988180.0
2008-03-27	CHI	ETF	14.31	14.34	14.13	14.15	59800.0
2008-03-27	CHIC	ETF	17.26	17.57	17.09	17.36	1535876.0
2008-03-27	CHW	ETF	11.34	11.35	11.25	11.25	76333.0
2008-03-27	CHY	ETF	13.18	13.1899	12.93	12.94	113005.0
2008-03-27	CMF	ETF	51.26	51.27	51.1255	51.25	9000.0
2008-03-27	CN	ETF	57.0	57.98	56.38	56.64	579727.0
2008-03-27	CNXT	ETF	0.58	0.59	0.56	0.58	2690503.0
2008-03-27	COW	ETF	41.86	41.86	40.88	40.99	20300.0
2008-03-27	CPI	ETF	18.37	18.37	18.0	18.0	2900.0
2008-03-27	CPST	ETF	2.11	2.25	2.03	2.18	3837750.0
2008-03-27	CSA	ETF	15.7	15.75	15.5	15.7	52100.0
2008-03-27	CSD	ETF	23.21	23.25	22.87	22.87	15700.0
2008-03-27	CSQ	ETF	12.16	12.26	12.0601	12.18	401002.0
2008-03-27	CUT	ETF	21.0	21.04	20.67	20.85	39000.0
2008-03-27	CVY	ETF	22.42	22.42	22.06	22.06	7200.0
2008-03-27	CWI	ETF	25.42	25.42	25.06	25.06	62250.0
2008-03-27	CZA	ETF	22.88	22.92	22.88	22.92	1300.0

> showing 50 of 575 rows — these rows as CSV

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