PREVIEW / etf_daily / 2015-03-05

all etf daily files

  file:    by_date/etf_daily/2015/2015-03-05.parquet
  size:    47 KB
  rows:    1,163

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
2015-03-05	SPY	ETF	210.62	210.8	209.85	210.46	76873000.0
2015-03-05	QQQ	ETF	108.73	108.965	108.19	108.64	15381039.0
2015-03-05	IWM	ETF	122.53	122.92	121.91	122.72	19725600.0
2015-03-05	DIA	ETF	181.25	181.45	180.71	181.17	2410700.0
2015-03-05	GLD	ETF	115.43	116.12	114.84	115.0	5872200.0
2015-03-05	TLT	ETF	126.53	126.88	125.9	126.29	6045000.0
2015-03-05	AADR	ETF	39.02	39.02	38.74	38.74	1600.0
2015-03-05	AAXJ	ETF	63.27	63.29	63.0	63.11	627500.0
2015-03-05	ACWI	ETF	60.6	60.75	60.47	60.61	2542200.0
2015-03-05	ACWV	ETF	71.82	72.02	71.66	71.8	117900.0
2015-03-05	ACWX	ETF	44.89	45.0	44.78	44.85	118928.0
2015-03-05	ADRE	ETF	35.57	35.79	35.4501	35.67	8726.0
2015-03-05	AFK	ETF	25.9	25.9	25.5901	25.68	11305.0
2015-03-05	AGG	ETF	110.43	110.54	110.3	110.42	1053000.0
2015-03-05	AGQ	ETF	39.98	40.53	39.5	39.76	134000.0
2015-03-05	AGZ	ETF	113.72	113.77	113.22	113.4	10036.0
2015-03-05	AGZD	ETF	24.59	24.655	24.59	24.65	5200.0
2015-03-05	AIA	ETF	48.92	48.9299	48.769	48.86	9597.0
2015-03-05	AIQ	ETF	22.69	22.8	21.33	21.34	10782.0
2015-03-05	AIRR	ETF	18.171	18.3	18.171	18.3	325000.0
2015-03-05	AIVI	ETF	45.04	45.07	44.92	44.98	11000.0
2015-03-05	ALTL	ETF	37.7266	37.7266	37.7266	37.7266	250.0
2015-03-05	AMJ	ETF	44.32	44.8	44.16	44.42	397740.0
2015-03-05	AMLP	ETF	84.55	85.25	84.5	84.8	611800.0
2015-03-05	AMZA	ETF	223.49	223.49	222.5	222.5	100.0
2015-03-05	ANGL	ETF	27.16	27.37	27.16	27.37	8000.0
2015-03-05	AOA	ETF	47.84	47.84	47.52	47.67	48200.0
2015-03-05	AOK	ETF	32.83	32.88	32.76	32.8	56014.0
2015-03-05	AOM	ETF	35.62	35.68	35.51	35.6	57711.0
2015-03-05	AOR	ETF	40.8	40.97	40.8	40.88	84236.0
2015-03-05	ARGT	ETF	20.21	20.55	20.11	20.5	16300.0
2015-03-05	ARKG	ETF	23.41	23.41	23.258	23.36	3600.0
2015-03-05	ARKK	ETF	21.352	21.352	21.352	21.352	200.0
2015-03-05	ARKQ	ETF	20.21	20.41	20.21	20.377	2200.0
2015-03-05	ARKW	ETF	22.16	22.16	22.014	22.014	400.0
2015-03-05	ASEA	ETF	15.6	15.64	15.52	15.56	26700.0
2015-03-05	ASHR	ETF	35.49	35.6	35.37	35.45	743100.0
2015-03-05	ASHS	ETF	40.75	40.81	40.64	40.78	10000.0
2015-03-05	ATMP	ETF	29.73	29.89	29.63	29.73	47900.0
2015-03-05	AVIV	ETF	36.03	36.49	35.95	35.95	208330.0
2015-03-05	AWAY	ETF	31.0	31.17	30.66	30.78	1031356.0
2015-03-05	BAB	ETF	29.85	30.0776	29.81	29.89	127942.0
2015-03-05	BAL	ETF	43.18	43.4	42.73	42.78	2776.0
2015-03-05	BALT	ETF	1.62	1.65	1.55	1.56	459545.0
2015-03-05	BAR	ETF	2.77	2.86	2.75	2.75	41490.0
2015-03-05	BBC	ETF	33.12	33.4	32.77	33.26	60239.0
2015-03-05	BBH	ETF	130.0	132.8	129.95	132.43	136200.0
2015-03-05	BBP	ETF	31.49	31.49	30.94	31.18	29000.0
2015-03-05	BCHP	ETF	19.3001	19.351	19.28	19.351	789.0
2015-03-05	BCM	ETF	31.63	31.64	31.63	31.64	2871.0

> showing 50 of 1,163 rows — these rows as CSV

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