PREVIEW / stock_daily / 2014-12-15

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-15.parquet
  size:    223 KB
  rows:    6,664
  symbols: 3,562

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-12-15	AAPL	Stock	27.675	27.9	26.5875	27.0575	268872400.0
2014-12-15	MSFT	Stock	47.2	47.67	46.55	46.67	29247800.0
2014-12-15	NVDA	Stock	0.4965	0.5055	0.4878	0.4892	254696000.0
2014-12-15	AMZN	Stock	15.4435	15.543	15.1075	15.3035	76832000.0
2014-12-15	GOOGL	Stock	26.188	26.2685	25.7699	25.792	52439540.0
2014-12-15	META	Stock	78.46	78.58	76.56	76.99	29396500.0
2014-12-15	TSLA	Stock	13.9527	13.9867	13.5113	13.6027	78274500.0
2014-12-15	TLT	Stock	125.64	126.7	125.43	126.04	9387414.0
2014-12-15	ES	Stock	51.3	51.43	50.37	50.73	1277300.0
2014-12-15	CL	Stock	68.65	69.16	67.78	67.95	4459400.0
2014-12-15	A	Stock	40.07	40.17	38.65	38.68	4507400.0
2014-12-15	AA.B-DELISTED	Stock	47.8328	48.78	47.7	48.04	483478.0
2014-12-15	AABA-DELISTED	Stock	50.42	50.92	49.5	49.82	17570707.0
2014-12-15	AAC-DELISTED	Stock	30.0	30.39	28.6701	29.71	125268.0
2014-12-15	AACG	Stock	3.47	3.48	2.5	2.63	23100.0
2014-12-15	AAIC-DELISTED	Stock	27.0	27.22	26.7501	26.81	268423.0
2014-12-15	AAL	Stock	50.21	51.32	49.32	50.84	15368500.0
2014-12-15	AAMC-DELISTED	Stock	132.6471	132.6471	126.5882	130.0	30134.0
2014-12-15	AAME	Stock	3.85	3.88	3.77	3.88	2700.0
2014-12-15	AAMI	Stock	15.84	16.155	15.58	15.98	299800.0
2014-12-15	AAOI	Stock	9.69	9.89	9.26	9.48	288900.0
2014-12-15	AAON	Stock	14.04	14.2733	13.7733	13.9267	279750.0
2014-12-15	AAP	Stock	161.7	163.36	160.29	161.01	1343500.0
2014-12-15	AAT	Stock	39.19	39.37	38.33	38.41	117000.0
2014-12-15	AAU-DELISTED	Stock	1.0022	1.0507	0.95	0.95	229056.0
2014-12-15	AAUAF-DELISTED	Stock	0.96	1.0065	0.91	0.95	240678.0
2014-12-15	AAV-DELISTED	Stock	4.58	4.837	4.58	4.62	236636.0
2014-12-15	AAVL-DELISTED	Stock	50.94	52.4	48.091	51.39	198421.0
2014-12-15	AAWW-DELISTED	Stock	46.7	47.06	45.78	45.9	176352.0
2014-12-15	AAXJ	Stock	60.08	60.29	59.32	59.55	598084.0
2014-12-15	AAXN-DELISTED	Stock	23.39	23.4367	22.76	22.87	2274566.0
2014-12-15	AB	Stock	24.29	24.58	23.75	24.16	299600.0
2014-12-15	ABAC-DELISTED	Stock	1.8554	1.88	1.8554	1.88	800.0
2014-12-15	ABAX-DELISTED	Stock	57.57	58.0	55.04	56.23	142623.0
2014-12-15	ABB-DELISTED	Stock	20.85	20.89	20.43	20.47	1839931.0
2014-12-15	ABBNY-DELISTED	Stock	20.85	20.89	20.43	20.5	2229427.0
2014-12-15	ABBV	Stock	65.75	66.47	64.81	65.62	7226000.0
2014-12-15	ABC-DELISTED	Stock	91.55	91.72	89.98	90.71	2130371.0
2014-12-15	ABCB	Stock	25.27	25.92	25.26	25.64	124000.0
2014-12-15	ABCD-DELISTED	Stock	1.5701	1.65	1.517	1.57	23534.0
2014-12-15	ABCO-DELISTED	Stock	46.06	49.67	45.26	48.35	631520.0
2014-12-15	ABCW-DELISTED	Stock	30.3999	30.4	30.1	30.4	583.0
2014-12-15	ABDC-DELISTED	Stock	11.55	11.75	11.55	11.61	86520.0
2014-12-15	ABE-DELISTED	Stock	13.37	13.37	13.11	13.1101	5635.0
2014-12-15	ABEO	Stock	135.25	163.75	135.25	163.75	40.0
2014-12-15	ABEV	Stock	5.89	5.89	5.58	5.75	15838500.0
2014-12-15	ABG	Stock	75.3	76.11	74.48	74.99	320800.0
2014-12-15	ABGB-DELISTED	Stock	12.7	12.7	11.93	12.04	30092.0
2014-12-15	ABIL-DELISTED	Stock	9.77	9.87	9.75	9.87	902.0
2014-12-15	ABM	Stock	27.43	27.8	27.19	27.69	260700.0

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

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