PREVIEW / stock_daily / 2017-08-15

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-15.parquet
  size:    215 KB
  rows:    6,472
  symbols: 2,958

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-08-15	AAPL	Stock	40.165	40.55	40.035	40.4	117862000.0
2017-08-15	MSFT	Stock	73.59	73.59	73.04	73.22	19181400.0
2017-08-15	NVDA	Stock	4.2152	4.2418	4.1398	4.1745	764532000.0
2017-08-15	AMZN	Stock	49.445	49.587	49.1	49.137	50986000.0
2017-08-15	GOOGL	Stock	47.0515	47.1535	46.832	46.904	22129680.0
2017-08-15	META	Stock	171.49	171.5	170.01	171.0	8729200.0
2017-08-15	TSLA	Stock	24.3467	24.366	23.958	24.1553	46276500.0
2017-08-15	TLT	Stock	124.73	125.535	124.71	125.25	7473231.0
2017-08-15	ES	Stock	61.94	62.6	61.9	62.57	961900.0
2017-08-15	CL	Stock	71.45	72.01	71.45	71.8	2307900.0
2017-08-15	A	Stock	59.7	59.88	59.11	59.38	2933300.0
2017-08-15	AA	Stock	37.3	37.98	37.14	37.5	1826500.0
2017-08-15	AAAP-DELISTED	Stock	49.25	49.76	49.2	49.25	27268.0
2017-08-15	AABA-DELISTED	Stock	59.28	60.135	58.79	59.98	6802451.0
2017-08-15	AAC-DELISTED	Stock	8.98	8.99	8.72	8.76	53480.0
2017-08-15	AACG	Stock	4.63	4.75	4.63	4.74	1700.0
2017-08-15	AAIC-DELISTED	Stock	13.05	13.095	13.0	13.04	196040.0
2017-08-15	AAL	Stock	48.76	49.0	48.35	48.52	3149600.0
2017-08-15	AAM.A-DELISTED	Stock	26.0925	26.14	25.95	25.95	51605.0
2017-08-15	AAMC-DELISTED	Stock	21.7647	22.6471	20.5879	21.6912	26051.0
2017-08-15	AAME	Stock	3.35	3.45	3.35	3.36	1700.0
2017-08-15	AAMI	Stock	13.82	13.93	13.75	13.77	384800.0
2017-08-15	AAOI	Stock	71.07	71.45	67.45	68.18	3691000.0
2017-08-15	AAON	Stock	22.5333	22.6333	21.78	21.8	144150.0
2017-08-15	AAP	Stock	91.99	93.0	82.21	87.08	19749500.0
2017-08-15	AAT	Stock	40.62	40.74	40.2	40.51	202300.0
2017-08-15	AAU-DELISTED	Stock	1.15	1.15	1.06	1.08	254164.0
2017-08-15	AAUAF-DELISTED	Stock	1.15	1.15	1.06	1.08	268635.0
2017-08-15	AAV-DELISTED	Stock	6.35	6.35	6.25	6.25	45902.0
2017-08-15	AAWW-DELISTED	Stock	62.05	63.0	61.65	62.85	177927.0
2017-08-15	AAXJ	Stock	70.04	70.05	69.75	69.98	250869.0
2017-08-15	AAXN-DELISTED	Stock	22.1	22.37	21.52	21.63	688605.0
2017-08-15	AB	Stock	24.0	24.08	23.8	23.85	202100.0
2017-08-15	ABAC-DELISTED	Stock	2.09	2.13	1.9	2.09	15285.0
2017-08-15	ABAX-DELISTED	Stock	47.16	47.16	46.31	46.64	75776.0
2017-08-15	ABB-DELISTED	Stock	22.87	22.91	22.8	22.85	1058380.0
2017-08-15	ABBNY-DELISTED	Stock	22.87	22.91	22.8	22.85	1100610.0
2017-08-15	ABBV	Stock	71.08	71.14	70.28	70.34	3724100.0
2017-08-15	ABC-DELISTED	Stock	80.27	80.425	79.78	80.01	1688077.0
2017-08-15	ABCB	Stock	45.4	45.6	44.75	44.85	168600.0
2017-08-15	ABCD-DELISTED	Stock	5.09	5.12	4.99	5.03	53781.0
2017-08-15	ABCO-DELISTED	Stock	51.5	52.05	51.4	51.75	267126.0
2017-08-15	ABDC-DELISTED	Stock	11.29	11.29	10.7	10.91	65332.0
2017-08-15	ABE-DELISTED	Stock	13.41	14.25	13.41	13.76	5726.0
2017-08-15	ABEO	Stock	180.0	211.25	175.25	202.5	33324.0
2017-08-15	ABEOW-DELISTED	Stock	4.49	4.5	4.35	4.35	2400.0
2017-08-15	ABEV	Stock	6.13	6.2	6.12	6.19	14092200.0
2017-08-15	ABG	Stock	51.8	52.6	50.7	51.2	172400.0
2017-08-15	ABIL-DELISTED	Stock	0.6407	0.66	0.6255	0.6551	8050.0
2017-08-15	ABM	Stock	44.11	44.16	43.68	43.75	82000.0

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

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