PREVIEW / stock_daily / 2014-10-06

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-06.parquet
  size:    221 KB
  rows:    6,611
  symbols: 3,562

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-10-06	AAPL	Stock	24.9875	25.1625	24.855	24.905	148204800.0
2014-10-06	MSFT	Stock	46.12	46.3	45.92	46.09	20604000.0
2014-10-06	NVDA	Stock	0.4575	0.4612	0.45	0.453	199032000.0
2014-10-06	AMZN	Stock	16.175	16.2065	15.98	16.11	45806000.0
2014-10-06	GOOGL	Stock	29.4975	29.62	29.27	29.389	25722600.0
2014-10-06	META	Stock	77.19	77.89	76.85	77.56	25729000.0
2014-10-06	TSLA	Stock	17.2753	17.4993	17.1867	17.3747	115699500.0
2014-10-06	TLT	Stock	117.62	118.19	117.36	117.77	4486451.0
2014-10-06	ES	Stock	45.67	45.82	45.38	45.55	1238200.0
2014-10-06	CL	Stock	65.16	65.49	64.94	65.27	3154700.0
2014-10-06	A	Stock	40.8155	40.887	40.3648	40.4649	1618045.0
2014-10-06	AA.B-DELISTED	Stock	49.24	50.07	49.24	50.0	114503.0
2014-10-06	AABA-DELISTED	Stock	41.2	41.73	41.04	41.52	22467153.0
2014-10-06	AAC-DELISTED	Stock	18.48	19.58	18.48	19.39	182502.0
2014-10-06	AACG	Stock	4.46	4.46	4.26	4.39	6000.0
2014-10-06	AAIC-DELISTED	Stock	25.44	25.65	25.42	25.46	280708.0
2014-10-06	AAL	Stock	36.31	36.5	34.86	34.93	12789300.0
2014-10-06	AAMC-DELISTED	Stock	197.2412	205.8824	197.2412	204.2676	13355.0
2014-10-06	AAOI	Stock	15.86	16.0	14.63	14.67	263500.0
2014-10-06	AAON	Stock	11.88	11.9067	11.5867	11.6133	197550.0
2014-10-06	AAP	Stock	136.34	136.34	134.26	134.42	614600.0
2014-10-06	AAT	Stock	33.9	34.24	33.76	34.05	94200.0
2014-10-06	AAU-DELISTED	Stock	1.22	1.29	1.18	1.27	198523.0
2014-10-06	AAUAF-DELISTED	Stock	1.26	1.33	1.22	1.27	195109.0
2014-10-06	AAV-DELISTED	Stock	4.87	4.98	4.77	4.85	176828.0
2014-10-06	AAVL-DELISTED	Stock	33.74	34.99	32.91	34.0	100157.0
2014-10-06	AAWW-DELISTED	Stock	32.49	33.19	32.302	32.49	154635.0
2014-10-06	AAXJ	Stock	61.65	61.73	61.36	61.38	496626.0
2014-10-06	AAXN-DELISTED	Stock	15.8	15.85	14.7807	14.9888	1630389.0
2014-10-06	AB	Stock	26.12	26.12	25.58	25.66	148000.0
2014-10-06	ABAC-DELISTED	Stock	2.04	2.08	1.97	2.0799	40359.0
2014-10-06	ABAX-DELISTED	Stock	50.92	51.4	49.64	49.65	214610.0
2014-10-06	ABB-DELISTED	Stock	21.89	22.0	21.755	21.96	3625160.0
2014-10-06	ABBNY-DELISTED	Stock	21.89	22.0	21.755	21.95	3812866.0
2014-10-06	ABBV	Stock	58.59	58.99	57.66	57.81	7359900.0
2014-10-06	ABC-DELISTED	Stock	78.07	78.58	77.02	77.51	1151256.0
2014-10-06	ABCB	Stock	22.43	22.49	22.28	22.37	59100.0
2014-10-06	ABCD-DELISTED	Stock	1.56	1.65	1.5505	1.63	8133.0
2014-10-06	ABCO-DELISTED	Stock	45.32	46.08	45.13	46.03	227993.0
2014-10-06	ABDC-DELISTED	Stock	13.26	13.26	12.82	12.89	36090.0
2014-10-06	ABE-DELISTED	Stock	13.9	14.12	13.9	14.1	24312.0
2014-10-06	ABEO	Stock	325.0	337.5	325.0	325.0	5.0
2014-10-06	ABEV	Stock	6.93	6.97	6.77	6.82	34744700.0
2014-10-06	ABG	Stock	68.94	70.1	67.63	68.05	289200.0
2014-10-06	ABGB-DELISTED	Stock	24.15	24.15	23.4801	23.74	67972.0
2014-10-06	ABIL-DELISTED	Stock	9.79	9.79	9.725	9.73	2549.0
2014-10-06	ABM	Stock	25.94	26.12	25.79	25.82	155300.0
2014-10-06	ABMD-DELISTED	Stock	24.69	24.99	24.16	24.18	140835.0
2014-10-06	ABR	Stock	6.64	6.65	6.56	6.61	39900.0
2014-10-06	ABR.A-DELISTED	Stock	24.5	24.59	24.5	24.58	2043.0

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

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