PREVIEW / stock_daily / 2014-01-07

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-07.parquet
  size:    217 KB
  rows:    6,462
  symbols: 3,534

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-07	AAPL	Stock	19.44	19.4986	19.2114	19.2871	317209200.0
2014-01-07	MSFT	Stock	36.33	36.49	36.21	36.41	35802800.0
2014-01-07	NVDA	Stock	0.401	0.405	0.3982	0.4035	333288000.0
2014-01-07	AMZN	Stock	19.752	19.9235	19.7145	19.9015	38320000.0
2014-01-07	META	Stock	57.7	58.55	57.22	57.92	77207400.0
2014-01-07	TSLA	Stock	9.8413	10.0267	9.6833	9.9573	75511500.0
2014-01-07	TLT	Stock	102.82	102.99	102.56	102.86	4428082.0
2014-01-07	ES	Stock	41.64	41.94	41.64	41.92	1143200.0
2014-01-07	CL	Stock	64.49	64.58	64.03	64.2	2872100.0
2014-01-07	A	Stock	40.7368	41.2232	40.7225	41.0944	2045554.0
2014-01-07	AABA-DELISTED	Stock	40.14	41.2025	40.08	40.89	13297375.0
2014-01-07	AACG	Stock	4.0	4.02	3.94	4.01	19900.0
2014-01-07	AAIC-DELISTED	Stock	26.44	26.5	26.3	26.33	117964.0
2014-01-07	AAL	Stock	27.2	27.4	26.67	26.91	11288700.0
2014-01-07	AAMC-DELISTED	Stock	267.0588	276.4529	267.0588	274.2647	40980.0
2014-01-07	AAME	Stock	4.01	4.04	3.91	4.04	12000.0
2014-01-07	AAOI	Stock	14.89	14.89	14.35	14.74	49300.0
2014-01-07	AAON	Stock	13.9422	14.1867	13.8178	14.0533	285750.0
2014-01-07	AAP	Stock	111.98	113.4	111.63	113.18	922800.0
2014-01-07	AAT	Stock	31.65	32.08	31.54	32.0	103700.0
2014-01-07	AAU-DELISTED	Stock	1.31	1.32	1.25	1.25	132809.0
2014-01-07	AAUAF-DELISTED	Stock	1.29	1.3	1.23	1.25	138776.0
2014-01-07	AAV-DELISTED	Stock	4.35	4.57	4.34	4.56	158900.0
2014-01-07	AAWW-DELISTED	Stock	40.37	40.64	40.1	40.44	132262.0
2014-01-07	AAXJ	Stock	57.9	57.99	57.68	57.91	500913.0
2014-01-07	AAXN-DELISTED	Stock	15.62	15.91	15.45	15.89	790031.0
2014-01-07	AB	Stock	22.0	22.28	21.9	22.22	296000.0
2014-01-07	ABAC-DELISTED	Stock	2.19	2.2	2.0505	2.18	57817.0
2014-01-07	ABAX-DELISTED	Stock	41.28	42.47	40.85	42.47	179887.0
2014-01-07	ABB-DELISTED	Stock	25.71	25.91	25.68	25.87	865218.0
2014-01-07	ABBNY-DELISTED	Stock	25.71	25.91	25.68	25.87	909636.0
2014-01-07	ABBV	Stock	50.84	51.21	50.3	50.49	9719900.0
2014-01-07	ABC-DELISTED	Stock	69.82	70.92	69.82	70.46	1250295.0
2014-01-07	ABCB	Stock	21.02	21.44	20.65	21.02	17300.0
2014-01-07	ABCD-DELISTED	Stock	1.95	1.951	1.85	1.88	24494.0
2014-01-07	ABCO-DELISTED	Stock	60.39	61.24	60.24	60.77	154486.0
2014-01-07	ABE-DELISTED	Stock	13.8	13.9	13.7301	13.77	18722.0
2014-01-07	ABEO	Stock	337.5	400.0	337.5	387.5	95.0
2014-01-07	ABEV	Stock	7.28	7.34	7.2	7.25	19490500.0
2014-01-07	ABFS-DELISTED	Stock	33.66	34.52	33.55	33.89	501572.0
2014-01-07	ABG	Stock	52.77	53.61	52.71	52.81	166300.0
2014-01-07	ABGB-DELISTED	Stock	15.45	15.7599	15.45	15.63	2772.0
2014-01-07	ABM	Stock	28.4	28.57	28.25	28.45	137400.0
2014-01-07	ABMD-DELISTED	Stock	27.36	27.69	27.215	27.62	280386.0
2014-01-07	ABR	Stock	6.9	6.97	6.87	6.97	72900.0
2014-01-07	ABR.A-DELISTED	Stock	24.3	24.45	24.3	24.35	1602.0
2014-01-07	ABR.B-DELISTED	Stock	22.5	22.5	22.45	22.45	700.0
2014-01-07	ABT	Stock	39.23	39.35	38.74	38.85	8329300.0
2014-01-07	ABTL-DELISTED	Stock	14.22	14.98	14.03	14.78	241010.0
2014-01-07	ABUS	Stock	7.75	8.0	7.66	7.88	73100.0

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

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