PREVIEW / etf_daily / 2011-01-03

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-03.parquet
  size:    35 KB
  rows:    819

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
2011-01-03	SPY	ETF	126.71	127.6	125.7	127.05	138725200.0
2011-01-03	QQQ	ETF	54.959	55.69	54.95	55.31	90994287.0
2011-01-03	IWM	ETF	78.94	80.02	78.73	79.6	48878000.0
2011-01-03	DIA	ETF	116.41	116.86	116.36	116.41	9108900.0
2011-01-03	GLD	ETF	138.67	139.0	137.88	138.0	11510200.0
2011-01-03	TLT	ETF	93.2	94.31	92.95	93.41	13799400.0
2011-01-03	AADR	ETF	29.98	30.06	29.88	30.06	1600.0
2011-01-03	AAXJ	ETF	64.6	64.82	64.5	64.58	181700.0
2011-01-03	ACWI	ETF	47.16	47.37	47.14	47.16	522000.0
2011-01-03	ACWX	ETF	44.39	44.53	44.3	44.41	135868.0
2011-01-03	ADRE	ETF	48.66	48.8081	48.47	48.55	80253.0
2011-01-03	AFK	ETF	35.11	35.76	35.05	35.2499	60613.0
2011-01-03	AGG	ETF	105.4	105.68	105.3	105.63	739700.0
2011-01-03	AGQ	ETF	319.92	322.9	308.96	313.18	605050.0
2011-01-03	AGZ	ETF	109.68	109.68	109.41	109.54	8178.0
2011-01-03	AIA	ETF	47.65	47.73	47.44	47.58	67481.0
2011-01-03	AIQ	ETF	21.35	22.35	21.35	21.85	82654.0
2011-01-03	AIS	ETF	1.72	1.73	1.7	1.73	372071.0
2011-01-03	AIVI	ETF	44.22	44.59	44.22	44.31	31000.0
2011-01-03	AMJ	ETF	36.44	36.7761	36.43	36.48	908319.0
2011-01-03	AMLP	ETF	80.4	80.85	80.4	80.6	185620.0
2011-01-03	AOA	ETF	34.61	34.83	34.61	34.69	16100.0
2011-01-03	AOK	ETF	28.8076	28.9	28.74	28.83	11042.0
2011-01-03	AOM	ETF	30.0	30.11	29.97	30.055	19898.0
2011-01-03	AOR	ETF	31.62	31.8	31.62	31.73	37790.0
2011-01-03	ARB	ETF	41.93	42.88	41.93	42.72	201618.0
2011-01-03	BAB	ETF	24.95	25.07	24.85	25.0499	263814.0
2011-01-03	BAL	ETF	73.89	74.38	71.1	71.47	92598.0
2011-01-03	BALT	ETF	10.31	10.49	10.25	10.44	184889.0
2011-01-03	BBH	ETF	33.3933	33.8533	33.3933	33.5133	25500.0
2011-01-03	BIB	ETF	7.4962	7.7061	7.4962	7.6625	15600.0
2011-01-03	BICK	ETF	33.13	33.49	33.12	33.285	92461.0
2011-01-03	BIL	ETF	91.7	91.72	91.7	91.72	126850.0
2011-01-03	BITS	ETF	28.96	30.0	28.64	29.0	2024.0
2011-01-03	BIV	ETF	82.17	82.53	82.02	82.42	287700.0
2011-01-03	BJK	ETF	31.91	32.26	31.91	31.98	28500.0
2011-01-03	BKF	ETF	49.52	50.0381	49.52	49.915	124387.0
2011-01-03	BLV	ETF	78.5	79.4	78.49	79.17	53100.0
2011-01-03	BMVP	ETF	14.797	14.875	14.797	14.813	11096.0
2011-01-03	BND	ETF	80.03	80.23	79.96	80.17	936500.0
2011-01-03	BNO	ETF	33.44	33.44	31.605	31.645	10600.0
2011-01-03	BOSS	ETF	49.025	50.0	49.025	50.0	100.0
2011-01-03	BRF	ETF	58.15	58.86	57.86	58.67	476794.0
2011-01-03	BSCE	ETF	20.65	20.67	20.6	20.67	9631.0
2011-01-03	BSV	ETF	80.34	80.42	80.27	80.42	566100.0
2011-01-03	BTF	ETF	77.94999999999999	78.49999999999999	77.94999999999999	78.39999999999999	2225.0
2011-01-03	BWX	ETF	29.22	29.255	29.06	29.22	214022.0
2011-01-03	BWZ	ETF	37.29	37.29	37.0	37.1	49263.0
2011-01-03	BZQ	ETF	2377.6	2377.6	2332.8	2353.6	617.5
2011-01-03	CEF	ETF	20.83	20.9	20.58	20.64	807400.0

> showing 50 of 819 rows — these rows as CSV

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