PREVIEW / stock_daily / 2014-11-18

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-18.parquet
  size:    224 KB
  rows:    6,701
  symbols: 3,587

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
2014-11-18	AAPL	Stock	28.485	28.9225	28.4725	28.8675	176896000.0
2014-11-18	MSFT	Stock	49.13	49.33	48.7	48.74	23995500.0
2014-11-18	NVDA	Stock	0.4928	0.5055	0.4915	0.5043	207772000.0
2014-11-18	AMZN	Stock	16.1995	16.478	16.1625	16.2465	70990000.0
2014-11-18	GOOGL	Stock	27.3965	27.6395	27.19	27.2255	36443320.0
2014-11-18	META	Stock	74.45	74.8	73.9	74.34	20690500.0
2014-11-18	TSLA	Stock	17.0573	17.3327	17.034	17.18	67095000.0
2014-11-18	TLT	Stock	119.32	119.58	119.16	119.52	4471230.0
2014-11-18	ES	Stock	49.61	49.96	49.35	49.78	1048600.0
2014-11-18	CL	Stock	68.0	68.11	67.63	67.97	1880800.0
2014-11-18	A	Stock	40.25	41.16	40.05	40.8	5891400.0
2014-11-18	AA.B-DELISTED	Stock	52.45	53.36	52.45	53.161	38027.0
2014-11-18	AABA-DELISTED	Stock	52.29	52.62	51.34	51.74	24223816.0
2014-11-18	AAC-DELISTED	Stock	27.99	30.0	27.99	29.38	81669.0
2014-11-18	AACG	Stock	3.92	3.92	3.81	3.9	6100.0
2014-11-18	AAIC-DELISTED	Stock	27.25	27.44	27.25	27.35	159311.0
2014-11-18	AAL	Stock	43.76	45.46	43.76	45.05	14218900.0
2014-11-18	AAMC-DELISTED	Stock	144.4265	148.2353	144.4176	144.4176	20998.0
2014-11-18	AAME	Stock	3.85	3.87	3.85	3.87	1200.0
2014-11-18	AAMI	Stock	15.74	15.932	15.53	15.66	213500.0
2014-11-18	AAOI	Stock	11.9	12.7	11.9	12.61	550700.0
2014-11-18	AAON	Stock	13.7067	13.9467	13.58	13.8267	300450.0
2014-11-18	AAP	Stock	145.44	146.52	145.44	146.24	736500.0
2014-11-18	AAT	Stock	38.93	39.12	38.72	38.88	160100.0
2014-11-18	AAU-DELISTED	Stock	1.19	1.22	1.14	1.15	225445.0
2014-11-18	AAUAF-DELISTED	Stock	1.15	1.18	1.1	1.15	234980.0
2014-11-18	AAV-DELISTED	Stock	5.05	5.06	4.79	4.81	209906.0
2014-11-18	AAVL-DELISTED	Stock	33.02	33.85	32.98	33.8	33510.0
2014-11-18	AAWW-DELISTED	Stock	41.37	42.24	41.37	41.9	174144.0
2014-11-18	AAXJ	Stock	61.9	62.16	61.89	62.1	265417.0
2014-11-18	AAXN-DELISTED	Stock	19.6	20.53	19.6	20.13	2435650.0
2014-11-18	AB	Stock	26.25	26.55	26.02	26.05	697300.0
2014-11-18	ABAC-DELISTED	Stock	2.3	2.3	2.26	2.2899	34270.0
2014-11-18	ABAX-DELISTED	Stock	54.63	55.24	54.376	54.6	95761.0
2014-11-18	ABB-DELISTED	Stock	22.58	22.67	22.525	22.63	1124898.0
2014-11-18	ABBNY-DELISTED	Stock	22.58	22.67	22.525	22.63	1550853.0
2014-11-18	ABBV	Stock	64.78	66.24	64.78	66.05	6432200.0
2014-11-18	ABC-DELISTED	Stock	89.0	89.97	88.67	89.79	1454774.0
2014-11-18	ABCB	Stock	25.7	25.9	25.59	25.64	58100.0
2014-11-18	ABCD-DELISTED	Stock	1.72	1.86	1.71	1.85	1000.0
2014-11-18	ABCO-DELISTED	Stock	45.49	46.05	43.46	43.47	333492.0
2014-11-18	ABCW-DELISTED	Stock	31.0	31.0	30.97	30.97	300.0
2014-11-18	ABDC-DELISTED	Stock	12.69	12.9199	12.61	12.61	36398.0
2014-11-18	ABE-DELISTED	Stock	13.7	13.7917	13.7	13.7864	1023.0
2014-11-18	ABEO	Stock	162.75	172.5	162.75	172.5	156.0
2014-11-18	ABEV	Stock	6.2	6.27	6.15	6.22	9727900.0
2014-11-18	ABG	Stock	73.29	74.77	73.12	73.7	254400.0
2014-11-18	ABGB-DELISTED	Stock	13.3	15.5	13.14	14.3874	1452526.0
2014-11-18	ABM	Stock	27.04	27.33	27.04	27.06	118400.0
2014-11-18	ABMD-DELISTED	Stock	33.94	34.98	33.4	34.88	524732.0

> showing 50 of 6,701 rows — these rows as CSV

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