PREVIEW / stock_daily / 2014-04-02

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-02.parquet
  size:    219 KB
  rows:    6,523
  symbols: 3,546

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-04-02	AAPL	Stock	19.3707	19.41	19.295	19.3768	180420800.0
2014-04-02	MSFT	Stock	41.44	41.66	41.17	41.35	28666700.0
2014-04-02	NVDA	Stock	0.4662	0.4673	0.4612	0.4633	239948000.0
2014-04-02	AMZN	Stock	17.2995	17.415	17.019	17.098	89510000.0
2014-04-02	META	Stock	63.21	63.91	62.21	62.72	66277000.0
2014-04-02	TSLA	Stock	14.6667	15.3927	14.5367	15.3527	161734500.0
2014-04-02	TLT	Stock	107.39	107.55	107.17	107.27	6887212.0
2014-04-02	ES	Stock	45.06	45.14	44.76	44.87	1384600.0
2014-04-02	CL	Stock	64.33	64.6	63.87	64.3	2969600.0
2014-04-02	A	Stock	40.3577	40.5579	40.2003	40.5365	2683461.0
2014-04-02	AABA-DELISTED	Stock	36.68	36.86	36.56	36.645	14066039.0
2014-04-02	AACG	Stock	4.05	4.12	4.02	4.02	1000.0
2014-04-02	AAIC-DELISTED	Stock	26.5	26.61	26.41	26.61	310476.0
2014-04-02	AAL	Stock	38.24	38.9	37.48	37.71	12511000.0
2014-04-02	AAMC-DELISTED	Stock	320.6059	337.7471	320.6059	327.1662	118272.0
2014-04-02	AAME	Stock	3.6	3.75	3.6	3.68	9900.0
2014-04-02	AAOI	Stock	24.4	24.58	23.6	24.29	319400.0
2014-04-02	AAON	Stock	12.7422	12.7644	12.5644	12.6756	190125.0
2014-04-02	AAP	Stock	127.45	127.48	126.21	126.86	722300.0
2014-04-02	AAT	Stock	34.19	34.51	33.88	34.49	99000.0
2014-04-02	AAU-DELISTED	Stock	1.43	1.45	1.401	1.45	80188.0
2014-04-02	AAUAF-DELISTED	Stock	1.43	1.45	1.401	1.45	80756.0
2014-04-02	AAV-DELISTED	Stock	5.01	5.1	4.9711	5.02	557785.0
2014-04-02	AAWW-DELISTED	Stock	35.7	35.99	35.11	35.85	189629.0
2014-04-02	AAXJ	Stock	59.79	60.01	59.755	59.94	539700.0
2014-04-02	AAXN-DELISTED	Stock	19.01	19.09	18.4501	18.66	932276.0
2014-04-02	AB	Stock	25.36	25.66	25.27	25.51	314200.0
2014-04-02	ABAC-DELISTED	Stock	1.8302	1.92	1.8302	1.91	7470.0
2014-04-02	ABAX-DELISTED	Stock	39.67	40.06	39.04	39.73	70990.0
2014-04-02	ABB-DELISTED	Stock	26.11	26.1499	25.99	26.08	1037149.0
2014-04-02	ABBNY-DELISTED	Stock	26.11	26.1499	25.99	26.08	1093782.0
2014-04-02	ABBV	Stock	52.1	53.41	51.99	53.34	6007200.0
2014-04-02	ABC-DELISTED	Stock	65.75	66.37	65.55	65.59	1691225.0
2014-04-02	ABCB	Stock	23.7	23.92	23.51	23.88	74700.0
2014-04-02	ABCD-DELISTED	Stock	2.2	2.39	2.18	2.28	46375.0
2014-04-02	ABCO-DELISTED	Stock	65.12	65.64	64.49	65.41	85462.0
2014-04-02	ABE-DELISTED	Stock	13.4	13.4565	13.38	13.45	15277.0
2014-04-02	ABEO	Stock	637.5	662.5	600.0	650.0	7.0
2014-04-02	ABEV	Stock	7.51	7.63	7.5	7.58	8190000.0
2014-04-02	ABFS-DELISTED	Stock	38.66	38.84	38.04	38.57	367588.0
2014-04-02	ABG	Stock	56.76	57.56	56.53	57.5	368400.0
2014-04-02	ABGB-DELISTED	Stock	24.43	25.16	24.3901	25.16	10086.0
2014-04-02	ABIL-DELISTED	Stock	9.68	9.99	9.67	9.71	34242.0
2014-04-02	ABM	Stock	28.87	28.87	28.56	28.78	147700.0
2014-04-02	ABMD-DELISTED	Stock	26.31	26.55	25.78	26.0	233526.0
2014-04-02	ABR	Stock	7.03	7.04	6.89	6.97	159800.0
2014-04-02	ABR.A-DELISTED	Stock	24.67	24.7399	24.62	24.7399	3300.0
2014-04-02	ABR.B-DELISTED	Stock	23.0	23.0	22.97	22.994	5423.0
2014-04-02	ABR.C-DELISTED	Stock	24.8	24.95	24.71	24.9442	27628.0
2014-04-02	ABT	Stock	38.12	38.64	38.07	38.58	6340700.0

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

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