PREVIEW / stock_daily / 2017-12-13

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-13.parquet
  size:    217 KB
  rows:    6,501
  symbols: 2,907

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
2017-12-13	AAPL	Stock	43.125	43.385	43.0	43.0675	95273600.0
2017-12-13	MSFT	Stock	85.74	86.0	85.17	85.35	22062700.0
2017-12-13	NVDA	Stock	4.8125	4.8138	4.647	4.6545	554280000.0
2017-12-13	AMZN	Stock	58.5	58.5435	58.0135	58.2065	52336000.0
2017-12-13	GOOGL	Stock	52.604	52.774	52.329	52.5695	27680760.0
2017-12-13	META	Stock	177.3	179.16	177.25	178.3	14615700.0
2017-12-13	TSLA	Stock	22.7287	22.948	22.4333	22.602	93322500.0
2017-12-13	TLT	Stock	126.81	127.39	126.59	127.33	8532859.0
2017-12-13	ES	Stock	64.8	65.52	64.43	65.08	1931800.0
2017-12-13	CL	Stock	72.69	73.8	72.64	73.35	3817700.0
2017-12-13	A	Stock	67.23	67.66	66.64	66.68	1684600.0
2017-12-13	AA	Stock	42.45	42.57	41.715	41.86	4146200.0
2017-12-13	AAAP-DELISTED	Stock	81.57	81.74	81.5	81.63	533010.0
2017-12-13	AABA-DELISTED	Stock	69.8	71.76	69.69	71.26	15324697.0
2017-12-13	AAC-DELISTED	Stock	9.09	9.09	8.53	8.61	160050.0
2017-12-13	AACG	Stock	5.35	5.35	5.32	5.32	1200.0
2017-12-13	AAIC-DELISTED	Stock	12.18	12.41	12.14	12.38	663274.0
2017-12-13	AAL	Stock	50.58	50.75	49.85	50.09	3035200.0
2017-12-13	AAM.A-DELISTED	Stock	26.21	26.21	26.0	26.11	19535.0
2017-12-13	AAMC-DELISTED	Stock	21.8971	24.4118	21.8971	22.8529	10343.0
2017-12-13	AAME	Stock	3.15	3.2	3.0	3.15	13000.0
2017-12-13	AAMI	Stock	16.16	16.295	16.09	16.21	438300.0
2017-12-13	AAOI	Stock	40.67	41.43	40.19	40.35	887200.0
2017-12-13	AAON	Stock	23.2333	23.7333	23.2333	23.4333	214500.0
2017-12-13	AAP	Stock	103.63	103.72	101.86	102.5	1093100.0
2017-12-13	AAT	Stock	39.26	39.75	39.18	39.22	211400.0
2017-12-13	AAU-DELISTED	Stock	0.9188	0.9299	0.9	0.9205	254050.0
2017-12-13	AAUAF-DELISTED	Stock	0.9188	0.9299	0.9	0.9205	274180.0
2017-12-13	AAV-DELISTED	Stock	4.05	4.05	3.945	3.975	234115.0
2017-12-13	AAWW-DELISTED	Stock	57.3	58.05	57.1	57.975	142326.0
2017-12-13	AAXJ	Stock	75.73	76.33	75.73	76.18	1869271.0
2017-12-13	AAXN-DELISTED	Stock	25.21	26.01	25.16	25.59	818451.0
2017-12-13	AB	Stock	24.9	25.5	24.9	25.05	367400.0
2017-12-13	ABAC-DELISTED	Stock	3.13	3.25	2.91	3.08	9999.0
2017-12-13	ABAX-DELISTED	Stock	47.23	48.105	47.07	47.42	160510.0
2017-12-13	ABB-DELISTED	Stock	26.01	26.12	25.965	26.11	1921717.0
2017-12-13	ABBNY-DELISTED	Stock	26.01	26.12	25.965	26.1	2215385.0
2017-12-13	ABBV	Stock	96.6	98.87	96.6	97.35	6148700.0
2017-12-13	ABC-DELISTED	Stock	87.54	89.24	87.36	88.5	1191193.0
2017-12-13	ABCB	Stock	47.05	47.95	47.0	47.2	217600.0
2017-12-13	ABCD-DELISTED	Stock	5.49	5.62	5.49	5.56	69570.0
2017-12-13	ABDC-DELISTED	Stock	8.4	8.44	8.25	8.32	138548.0
2017-12-13	ABE-DELISTED	Stock	14.185	14.2999	14.185	14.2979	4794.0
2017-12-13	ABEO	Stock	388.75	405.0	386.25	400.0	19940.0
2017-12-13	ABEV	Stock	6.47	6.5	6.26	6.31	18480000.0
2017-12-13	ABG	Stock	65.0	67.0	64.75	65.85	170100.0
2017-12-13	ABIL-DELISTED	Stock	0.4	0.426	0.4	0.426	36381.0
2017-12-13	ABLX-DELISTED	Stock	24.1	24.17	23.9	23.96	58332.0
2017-12-13	ABM	Stock	43.83	44.38	43.75	43.75	595800.0
2017-12-13	ABMD-DELISTED	Stock	193.02	193.86	191.7401	193.14	127422.0

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

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