PREVIEW / stock_daily / 2014-01-31

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-31.parquet
  size:    217 KB
  rows:    6,456
  symbols: 3,537

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-01-31	AAPL	Stock	17.685	17.9118	17.6268	17.8786	464797200.0
2014-01-31	MSFT	Stock	36.95	37.89	36.56	37.84	93162300.0
2014-01-31	NVDA	Stock	0.3875	0.3948	0.3873	0.3925	335348000.0
2014-01-31	AMZN	Stock	18.588	18.7725	17.888	17.9345	323096000.0
2014-01-31	META	Stock	60.47	63.37	60.17	62.57	87794600.0
2014-01-31	TSLA	Stock	11.9233	12.4	11.9007	12.094	97632000.0
2014-01-31	TLT	Stock	108.2	108.41	107.85	108.28	14691208.0
2014-01-31	ES	Stock	43.12	43.98	43.05	43.8	2091500.0
2014-01-31	CL	Stock	60.61	61.59	60.0	61.23	6831800.0
2014-01-31	A	Stock	41.9242	42.3104	41.5236	41.5951	4804227.0
2014-01-31	AABA-DELISTED	Stock	34.7	36.33	34.55	36.01	28746639.0
2014-01-31	AACG	Stock	4.0	4.0	4.0	4.0	2100.0
2014-01-31	AAIC-DELISTED	Stock	26.3	26.31	25.9	26.25	212074.0
2014-01-31	AAL	Stock	33.44	34.08	33.0	33.55	12791000.0
2014-01-31	AAMC-DELISTED	Stock	288.2353	296.4706	287.9412	296.4706	6725.0
2014-01-31	AAME	Stock	4.0	4.0	3.91	3.97	11000.0
2014-01-31	AAOI	Stock	13.88	13.96	13.4	13.63	37600.0
2014-01-31	AAON	Stock	13.4311	13.6711	13.1422	13.1822	505575.0
2014-01-31	AAP	Stock	115.23	116.03	113.7	114.81	807500.0
2014-01-31	AAT	Stock	32.34	33.49	32.34	33.47	205900.0
2014-01-31	AAU-DELISTED	Stock	1.35	1.4	1.32	1.36	54963.0
2014-01-31	AAUAF-DELISTED	Stock	1.35	1.4	1.32	1.36	56280.0
2014-01-31	AAV-DELISTED	Stock	4.07	4.09	4.02	4.07	56706.0
2014-01-31	AAWW-DELISTED	Stock	35.14	35.888	35.0101	35.33	335691.0
2014-01-31	AAXJ	Stock	55.44	56.0981	55.34	55.93	341381.0
2014-01-31	AAXN-DELISTED	Stock	16.08	16.32	15.93	16.06	685228.0
2014-01-31	AB	Stock	22.3	22.55	22.15	22.34	386200.0
2014-01-31	ABAC-DELISTED	Stock	1.94	1.99	1.94	1.97	8700.0
2014-01-31	ABAX-DELISTED	Stock	34.29	39.35	33.62	38.17	1049336.0
2014-01-31	ABB-DELISTED	Stock	24.71	25.05	24.71	24.85	1919459.0
2014-01-31	ABBNY-DELISTED	Stock	24.71	25.05	24.71	24.84	1980730.0
2014-01-31	ABBV	Stock	49.94	50.55	49.07	49.23	12863500.0
2014-01-31	ABC-DELISTED	Stock	66.6	67.49	66.13	67.22	3344000.0
2014-01-31	ABCB	Stock	20.11	20.59	20.11	20.47	218800.0
2014-01-31	ABCD-DELISTED	Stock	1.79	2.0899	1.75	1.89	9672.0
2014-01-31	ABCO-DELISTED	Stock	63.61	64.8	63.21	63.32	206499.0
2014-01-31	ABE-DELISTED	Stock	12.18	12.36	12.15	12.27	54468.0
2014-01-31	ABEO	Stock	425.0	487.5	425.0	450.0	18.0
2014-01-31	ABEV	Stock	6.41	6.69	6.36	6.54	12097100.0
2014-01-31	ABFS-DELISTED	Stock	32.9	34.9	32.0	34.29	496120.0
2014-01-31	ABG	Stock	46.77	47.57	46.41	47.02	303400.0
2014-01-31	ABM	Stock	26.64	27.08	26.58	26.66	167800.0
2014-01-31	ABMD-DELISTED	Stock	26.7	28.02	25.77	27.5	537057.0
2014-01-31	ABR	Stock	6.85	7.0	6.85	6.87	92800.0
2014-01-31	ABR.A-DELISTED	Stock	25.0411	25.05	24.9201	24.9201	700.0
2014-01-31	ABR.B-DELISTED	Stock	22.949	23.25	22.942	23.24	13122.0
2014-01-31	ABT	Stock	36.03	36.89	35.97	36.66	10845500.0
2014-01-31	ABTL-DELISTED	Stock	14.38	15.1	14.0	14.86	304408.0
2014-01-31	ABUS	Stock	13.41	14.85	13.3	13.96	734500.0
2014-01-31	ABX-DELISTED	Stock	19.33	19.57	19.06	19.27	15869322.0

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

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