PREVIEW / stock_daily / 2017-11-13

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-13.parquet
  size:    216 KB
  rows:    6,486
  symbols: 2,923

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-11-13	AAPL	Stock	43.375	43.625	43.35	43.4925	67928400.0
2017-11-13	MSFT	Stock	83.66	83.94	83.46	83.93	14196900.0
2017-11-13	NVDA	Stock	5.4035	5.4292	5.3002	5.3158	582376000.0
2017-11-13	AMZN	Stock	56.15	56.995	56.117	56.4585	58368000.0
2017-11-13	GOOGL	Stock	52.04	52.437	51.963	52.06	18814420.0
2017-11-13	META	Stock	177.5	179.04	177.3	178.77	9523400.0
2017-11-13	TSLA	Stock	20.0087	21.12	19.9407	21.0267	113773500.0
2017-11-13	TLT	Stock	124.8	124.81	124.31	124.36	5880784.0
2017-11-13	ES	Stock	64.1	64.83	64.01	64.76	1423800.0
2017-11-13	CL	Stock	73.26	73.83	73.0	73.7	2511500.0
2017-11-13	A	Stock	66.45	67.39	66.25	67.13	1536400.0
2017-11-13	AA	Stock	42.7	43.87	42.55	43.13	3162700.0
2017-11-13	AAAP-DELISTED	Stock	81.0	81.09	80.95	81.05	341705.0
2017-11-13	AABA-DELISTED	Stock	70.66	71.39	70.01	70.27	4944378.0
2017-11-13	AAC-DELISTED	Stock	11.2	11.379	10.24	10.32	187631.0
2017-11-13	AACG	Stock	4.46	4.5	4.46	4.46	4600.0
2017-11-13	AAIC-DELISTED	Stock	11.09	11.31	11.09	11.25	399897.0
2017-11-13	AAL	Stock	45.63	45.86	45.33	45.74	1772400.0
2017-11-13	AAM.A-DELISTED	Stock	26.34	26.62	26.34	26.6	14693.0
2017-11-13	AAMI	Stock	15.98	16.14	15.86	16.07	784200.0
2017-11-13	AAOI	Stock	45.24	46.6	43.64	44.58	2423400.0
2017-11-13	AAON	Stock	22.4	22.8333	22.3	22.5333	137100.0
2017-11-13	AAP	Stock	80.72	82.82	80.46	82.28	3894500.0
2017-11-13	AAT	Stock	39.44	39.64	39.26	39.53	183100.0
2017-11-13	AAU-DELISTED	Stock	0.915	0.9373	0.9119	0.9184	174498.0
2017-11-13	AAUAF-DELISTED	Stock	0.915	0.9373	0.9119	0.9184	202568.0
2017-11-13	AAV-DELISTED	Stock	5.85	5.875	5.6	5.65	98788.0
2017-11-13	AAWW-DELISTED	Stock	53.3	53.85	51.905	53.75	220330.0
2017-11-13	AAXJ	Stock	75.83	76.22	75.8	76.11	381701.0
2017-11-13	AAXN-DELISTED	Stock	21.02	21.47	21.02	21.12	577308.0
2017-11-13	AB	Stock	25.0	25.0	24.7	24.75	112600.0
2017-11-13	ABAC-DELISTED	Stock	3.38	3.5	2.99	3.38	6608.0
2017-11-13	ABAX-DELISTED	Stock	46.28	46.72	45.5	45.85	84423.0
2017-11-13	ABB-DELISTED	Stock	25.29	25.535	25.26	25.48	1389530.0
2017-11-13	ABBNY-DELISTED	Stock	25.29	25.535	25.26	25.48	1452061.0
2017-11-13	ABBV	Stock	95.37	95.42	94.04	95.12	4035700.0
2017-11-13	ABC-DELISTED	Stock	74.69	77.0	74.31	75.39	2672795.0
2017-11-13	ABCB	Stock	45.45	46.9	45.25	46.75	93400.0
2017-11-13	ABCD-DELISTED	Stock	6.87	7.2996	6.705	6.89	130016.0
2017-11-13	ABCO-DELISTED	Stock	53.5	53.55	53.35	53.45	3521145.0
2017-11-13	ABDC-DELISTED	Stock	7.21	7.44	7.2	7.3	189210.0
2017-11-13	ABE-DELISTED	Stock	14.2512	14.26	14.21	14.22	4880.0
2017-11-13	ABEO	Stock	382.5	382.5	363.75	367.5	17560.0
2017-11-13	ABEOW-DELISTED	Stock	10.3499	10.3499	9.74	9.75	3600.0
2017-11-13	ABEV	Stock	6.06	6.15	6.03	6.12	14779000.0
2017-11-13	ABG	Stock	62.1	62.2	61.13	61.55	335100.0
2017-11-13	ABIL-DELISTED	Stock	0.65	0.77	0.615	0.652	1488497.0
2017-11-13	ABLX-DELISTED	Stock	20.52	20.85	20.4108	20.75	140344.0
2017-11-13	ABM	Stock	40.12	40.44	39.78	40.17	242100.0
2017-11-13	ABMD-DELISTED	Stock	193.36	196.0	193.36	195.11	390481.0

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

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