PREVIEW / stock_daily / 2014-01-02

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-02.parquet
  size:    217 KB
  rows:    6,447
  symbols: 3,520

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-02	AAPL	Stock	19.8457	19.8939	19.715	19.7546	234684800.0
2014-01-02	MSFT	Stock	37.35	37.4	37.1	37.16	30632200.0
2014-01-02	NVDA	Stock	0.398	0.3995	0.393	0.3965	260092000.0
2014-01-02	AMZN	Stock	19.94	19.968	19.701	19.8985	42756000.0
2014-01-02	META	Stock	54.83	55.22	54.19	54.71	43195500.0
2014-01-02	TSLA	Stock	9.9867	10.1653	9.77	10.0067	92826000.0
2014-01-02	TLT	Stock	101.72	102.39	101.69	102.17	8580808.0
2014-01-02	ES	Stock	42.35	42.42	41.7	41.72	2915300.0
2014-01-02	CL	Stock	64.89	65.03	64.0	64.3	3004300.0
2014-01-02	A	Stock	40.8441	40.8441	40.1645	40.2074	2678848.0
2014-01-02	AABA-DELISTED	Stock	40.37	40.49	39.31	39.6	17003133.0
2014-01-02	AACG	Stock	4.0	4.0	3.94	3.94	13000.0
2014-01-02	AAIC-DELISTED	Stock	26.39	26.52	26.11	26.24	159742.0
2014-01-02	AAL	Stock	25.07	25.82	25.06	25.36	8997900.0
2014-01-02	AAMC-DELISTED	Stock	270.1059	273.0147	264.7059	271.5147	38491.0
2014-01-02	AAME	Stock	4.09	4.13	3.98	3.98	20200.0
2014-01-02	AAOI	Stock	14.88	14.92	14.61	14.63	22500.0
2014-01-02	AAON	Stock	14.1733	14.2889	14.0178	14.0844	228375.0
2014-01-02	AAP	Stock	110.36	111.88	109.29	109.74	542700.0
2014-01-02	AAT	Stock	31.43	31.51	30.64	31.26	217800.0
2014-01-02	AAU-DELISTED	Stock	1.19	1.22	1.18	1.22	138622.0
2014-01-02	AAUAF-DELISTED	Stock	1.19	1.22	1.18	1.22	140127.0
2014-01-02	AAV-DELISTED	Stock	4.35	4.405	4.32	4.33	83989.0
2014-01-02	AAWW-DELISTED	Stock	41.08	41.08	40.42	40.52	143686.0
2014-01-02	AAXJ	Stock	59.16	59.25	58.25	58.36	1357316.0
2014-01-02	AAXN-DELISTED	Stock	15.84	15.84	14.89	15.38	1198156.0
2014-01-02	AB	Stock	21.3	21.43	20.98	21.32	291600.0
2014-01-02	ABAC-DELISTED	Stock	2.258	2.28	2.03	2.13	86032.0
2014-01-02	ABAX-DELISTED	Stock	39.77	40.24	39.48	40.08	118052.0
2014-01-02	ABB-DELISTED	Stock	26.17	26.17	25.78	25.905	2665393.0
2014-01-02	ABBNY-DELISTED	Stock	26.17	26.17	25.78	25.93	2720427.0
2014-01-02	ABBV	Stock	52.12	52.33	51.52	51.98	4569100.0
2014-01-02	ABC-DELISTED	Stock	70.11	70.23	69.48	69.89	1043891.0
2014-01-02	ABCB	Stock	20.9	21.0	20.6	20.89	110600.0
2014-01-02	ABCD-DELISTED	Stock	1.7	1.7601	1.7	1.74	11326.0
2014-01-02	ABCO-DELISTED	Stock	63.21	63.21	60.7	61.05	159087.0
2014-01-02	ABE-DELISTED	Stock	13.65	13.7699	13.6	13.7699	14678.0
2014-01-02	ABEO	Stock	300.0	312.5	300.0	312.5	2.0
2014-01-02	ABEV	Stock	7.28	7.3	7.2	7.28	5196100.0
2014-01-02	ABFS-DELISTED	Stock	33.58	34.08	33.16	33.84	295470.0
2014-01-02	ABG	Stock	53.7	54.0	52.92	53.98	235800.0
2014-01-02	ABGB-DELISTED	Stock	14.54	14.69	14.41	14.4198	4630.0
2014-01-02	ABM	Stock	28.45	28.66	28.14	28.24	223700.0
2014-01-02	ABMD-DELISTED	Stock	26.66	27.25	26.27	26.85	204729.0
2014-01-02	ABR	Stock	6.68	6.75	6.61	6.73	63400.0
2014-01-02	ABR.A-DELISTED	Stock	24.2799	24.3	24.18	24.18	723.0
2014-01-02	ABR.B-DELISTED	Stock	22.609	22.609	22.6	22.6	1100.0
2014-01-02	ABT	Stock	38.09	38.4	38.0	38.23	4967500.0
2014-01-02	ABTL-DELISTED	Stock	15.12	15.12	13.75	14.4	208243.0
2014-01-02	ABUS	Stock	7.95	8.0	7.65	7.77	35500.0

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

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