PREVIEW / etf_daily / 2010-12-27

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-27.parquet
  size:    35 KB
  rows:    815

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
2010-12-27	SPY	ETF	125.13	125.77	125.04	125.65	58126000.0
2010-12-27	QQQ	ETF	54.62	54.86	54.21	54.77	29263417.0
2010-12-27	IWM	ETF	78.47	79.1	78.31	78.96	15770300.0
2010-12-27	DIA	ETF	115.36	115.64	115.15	115.54	4138600.0
2010-12-27	GLD	ETF	134.96	135.06	134.49	135.02	3436400.0
2010-12-27	TLT	ETF	92.76	93.88	92.3	93.76	5285900.0
2010-12-27	AADR	ETF	29.51	29.59	29.43	29.59	1000.0
2010-12-27	AAXJ	ETF	62.52	62.84	62.4	62.74	134900.0
2010-12-27	ACWI	ETF	46.25	46.41	46.13	46.36	921600.0
2010-12-27	ACWX	ETF	43.35	43.5	43.265	43.49	66371.0
2010-12-27	ADRE	ETF	46.51	46.96	46.51	46.89	18336.0
2010-12-27	AFK	ETF	34.6	34.6	34.3	34.56	20788.0
2010-12-27	AGG	ETF	105.36	105.68	105.16	105.62	686600.0
2010-12-27	AGQ	ETF	284.62	286.28	282.44	285.5	146050.0
2010-12-27	AGZ	ETF	109.36	109.558	109.24	109.558	6483.0
2010-12-27	AIA	ETF	46.0	46.07	45.74	46.0	28893.0
2010-12-27	AIQ	ETF	20.6	21.45	20.35	21.05	29444.0
2010-12-27	AIS	ETF	1.64	1.73	1.64	1.73	453265.0
2010-12-27	AIVI	ETF	43.48	43.66	43.33	43.52	17400.0
2010-12-27	AMJ	ETF	35.79	35.79	35.6299	35.75	245125.0
2010-12-27	AMLP	ETF	79.45	79.45	79.05	79.3	82280.0
2010-12-27	AOA	ETF	34.11	34.23	34.04	34.22	5000.0
2010-12-27	AOM	ETF	29.75	29.82	29.72	29.8	7660.0
2010-12-27	AOR	ETF	31.32	31.43	31.303	31.43	12270.0
2010-12-27	ARB	ETF	41.53	42.334	41.52	41.86	208726.0
2010-12-27	BAB	ETF	24.92	25.0	24.8	24.96	161810.0
2010-12-27	BAL	ETF	72.26	74.76	72.0	74.54	36614.0
2010-12-27	BALT	ETF	10.6	10.72	10.57	10.58	118329.0
2010-12-27	BBH	ETF	33.45	33.6533	33.29	33.5767	35700.0
2010-12-27	BIB	ETF	7.7263	7.7263	7.7263	7.7263	2400.0
2010-12-27	BICK	ETF	32.0	32.0	31.65	31.9336	22472.0
2010-12-27	BIL	ETF	91.7	91.72	91.7	91.7	151100.0
2010-12-27	BIS	ETF	8025.216	8025.216	8025.216	8025.216	0.625
2010-12-27	BITS	ETF	28.76	28.8	28.12	28.64	2492.0
2010-12-27	BIV	ETF	81.99	82.21	81.72	82.15	159600.0
2010-12-27	BJK	ETF	30.82	31.02	30.77	30.96	18700.0
2010-12-27	BKF	ETF	48.26	48.43	47.89	48.09	138672.0
2010-12-27	BLV	ETF	78.16	78.6	77.72	78.6	83600.0
2010-12-27	BMVP	ETF	14.68	14.72	14.62	14.707	13158.0
2010-12-27	BND	ETF	79.79	80.04	79.7	80.04	514800.0
2010-12-27	BNO	ETF	31.145	31.145	31.075	31.075	1200.0
2010-12-27	BRF	ETF	54.36	54.7	54.1	54.69	317273.0
2010-12-27	BSCE	ETF	20.59	20.61	20.5766	20.61	2885.0
2010-12-27	BSV	ETF	80.23	80.34	80.1	80.33	330000.0
2010-12-27	BTF	ETF	77.85	77.85	76.35	77.75	6133.400000000001
2010-12-27	BWX	ETF	28.71	28.79	28.71	28.79	90274.0
2010-12-27	BWZ	ETF	36.46	36.46	36.229	36.38	10765.0
2010-12-27	BZQ	ETF	2665.6	2675.2	2646.4	2652.8	446.0
2010-12-27	CEF	ETF	19.77	19.85	19.73	19.84	486500.0
2010-12-27	CEW	ETF	22.23	23.089	22.23	22.29	133236.0

> showing 50 of 815 rows — these rows as CSV

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