PREVIEW / stock_daily / 2014-02-03

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-03.parquet
  size:    218 KB
  rows:    6,487
  symbols: 3,550

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-02-03	AAPL	Stock	17.9504	18.1332	17.8321	17.9118	401464000.0
2014-02-03	MSFT	Stock	37.74	37.99	36.43	36.48	64063100.0
2014-02-03	NVDA	Stock	0.3953	0.3958	0.3858	0.3873	431728000.0
2014-02-03	AMZN	Stock	17.949	18.0425	17.005	17.3075	205616000.0
2014-02-03	META	Stock	63.03	63.77	60.7	61.48	74866600.0
2014-02-03	TSLA	Stock	12.1927	12.3253	11.6773	11.8073	101473500.0
2014-02-03	TLT	Stock	107.7899	109.34	107.61	109.32	20781789.0
2014-02-03	ES	Stock	43.86	44.52	43.36	43.45	2139200.0
2014-02-03	CL	Stock	61.22	61.3	59.75	60.17	6868200.0
2014-02-03	A	Stock	41.5951	41.8312	40.1144	40.1645	4095161.0
2014-02-03	AABA-DELISTED	Stock	35.89	36.01	34.66	34.91	20911684.0
2014-02-03	AACG	Stock	4.01	4.01	3.95	3.95	2400.0
2014-02-03	AAIC-DELISTED	Stock	26.25	26.3499	24.81	25.01	465964.0
2014-02-03	AAL	Stock	33.95	34.48	33.05	33.96	21739500.0
2014-02-03	AAMC-DELISTED	Stock	287.9412	287.9412	272.0588	275.9265	51020.0
2014-02-03	AAME	Stock	3.97	3.97	3.92	3.93	12300.0
2014-02-03	AAOI	Stock	13.7	14.36	13.45	13.61	116600.0
2014-02-03	AAON	Stock	13.08	13.3022	12.2222	12.4533	531450.0
2014-02-03	AAP	Stock	115.44	115.65	109.58	110.22	1327800.0
2014-02-03	AAT	Stock	33.3	33.37	31.17	32.1	195900.0
2014-02-03	AAU-DELISTED	Stock	1.4	1.46	1.39	1.4	83903.0
2014-02-03	AAUAF-DELISTED	Stock	1.4	1.42	1.36	1.4	86738.0
2014-02-03	AAV-DELISTED	Stock	4.06	4.0726	3.9101	3.96	109984.0
2014-02-03	AAWW-DELISTED	Stock	35.13	35.7099	33.84	34.24	294145.0
2014-02-03	AAXJ	Stock	55.67	55.77	54.63	54.75	743197.0
2014-02-03	AAXN-DELISTED	Stock	16.75	17.52	16.6275	16.9	2893314.0
2014-02-03	AB	Stock	22.4	22.4	21.0	21.07	630300.0
2014-02-03	ABAC-DELISTED	Stock	1.964	1.964	1.92	1.93	13064.0
2014-02-03	ABAX-DELISTED	Stock	37.96	38.11	36.3	36.955	345012.0
2014-02-03	ABB-DELISTED	Stock	24.77	24.82	24.26	24.3	1902278.0
2014-02-03	ABBNY-DELISTED	Stock	24.77	24.82	24.26	24.31	1975841.0
2014-02-03	ABBV	Stock	49.4	49.49	47.06	47.35	10314600.0
2014-02-03	ABC-DELISTED	Stock	67.13	67.13	65.1	65.18	3202218.0
2014-02-03	ABCB	Stock	20.42	20.71	20.09	20.19	209800.0
2014-02-03	ABCD-DELISTED	Stock	1.76	2.05	1.76	1.88	6693.0
2014-02-03	ABCO-DELISTED	Stock	63.27	63.8	61.02	61.66	269727.0
2014-02-03	ABE-DELISTED	Stock	12.19	12.2	12.13	12.19	47495.0
2014-02-03	ABEO	Stock	425.0	425.0	387.5	412.5	39.0
2014-02-03	ABEV	Stock	6.55	6.55	6.23	6.23	9106500.0
2014-02-03	ABFS-DELISTED	Stock	34.22	34.22	32.11	32.49	566896.0
2014-02-03	ABG	Stock	47.09	47.61	45.31	45.42	584200.0
2014-02-03	ABGB-DELISTED	Stock	16.66	16.66	16.66	16.66	1000.0
2014-02-03	ABM	Stock	26.66	26.96	25.71	26.01	253800.0
2014-02-03	ABMD-DELISTED	Stock	27.1	27.15	25.96	26.41	723066.0
2014-02-03	ABR	Stock	6.86	6.88	6.75	6.81	135100.0
2014-02-03	ABR.A-DELISTED	Stock	24.9	25.13	24.9	25.13	1788.0
2014-02-03	ABR.B-DELISTED	Stock	23.22	23.53	23.16	23.49	6675.0
2014-02-03	ABT	Stock	36.58	36.95	35.8	35.85	12231900.0
2014-02-03	ABTL-DELISTED	Stock	14.9	15.06	13.18	13.75	270759.0
2014-02-03	ABUS	Stock	13.83	14.96	13.83	14.4	437400.0

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

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