PREVIEW / stock_daily / 2017-12-07

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-07.parquet
  size:    217 KB
  rows:    6,496
  symbols: 2,903

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-07	AAPL	Stock	42.2575	42.61	42.2275	42.33	102693200.0
2017-12-07	MSFT	Stock	82.54	82.8	82.0	82.49	23184500.0
2017-12-07	NVDA	Stock	4.799	4.84	4.753	4.7998	542600000.0
2017-12-07	AMZN	Stock	57.8295	58.1595	57.55	57.9895	50232000.0
2017-12-07	GOOGL	Stock	51.8035	52.446	51.768	52.2285	30865700.0
2017-12-07	META	Stock	175.8	180.39	175.8	180.14	20404500.0
2017-12-07	TSLA	Stock	20.8	21.242	20.7367	20.7493	71709000.0
2017-12-07	TLT	Stock	127.93	128.1	126.3	126.68	13056807.0
2017-12-07	ES	Stock	65.1	65.1	64.47	64.91	2395000.0
2017-12-07	CL	Stock	73.94	74.22	73.14	73.2	3696200.0
2017-12-07	A	Stock	65.91	66.88	65.77	66.71	2294500.0
2017-12-07	AA	Stock	41.13	41.19	40.27	40.6	3426900.0
2017-12-07	AAAP-DELISTED	Stock	81.49	81.65	81.46	81.57	1052235.0
2017-12-07	AABA-DELISTED	Stock	69.75	70.64	69.48	70.25	5974568.0
2017-12-07	AAC-DELISTED	Stock	8.53	8.97	8.4014	8.88	109531.0
2017-12-07	AACG	Stock	5.14	5.17	5.14	5.15	9100.0
2017-12-07	AAIC-DELISTED	Stock	11.9	12.125	11.9	12.03	353387.0
2017-12-07	AAL	Stock	49.53	50.92	49.3	50.88	3047000.0
2017-12-07	AAM.A-DELISTED	Stock	26.13	26.38	26.08	26.38	187813.0
2017-12-07	AAMC-DELISTED	Stock	19.6176	21.8529	19.6176	21.5809	39205.0
2017-12-07	AAME	Stock	3.6	3.6	3.5	3.5	3800.0
2017-12-07	AAMI	Stock	15.93	16.11	15.87	15.96	340600.0
2017-12-07	AAOI	Stock	40.43	40.7	38.2	38.84	2192800.0
2017-12-07	AAON	Stock	24.1	24.5333	24.1	24.1667	204450.0
2017-12-07	AAP	Stock	97.75	98.37	96.57	97.61	1171700.0
2017-12-07	AAT	Stock	38.47	38.6	38.24	38.46	163600.0
2017-12-07	AAU-DELISTED	Stock	0.8	0.81	0.79	0.81	826889.0
2017-12-07	AAUAF-DELISTED	Stock	0.8	0.81	0.79	0.801	917440.0
2017-12-07	AAV-DELISTED	Stock	4.2	4.25	3.9	4.0	591320.0
2017-12-07	AAWW-DELISTED	Stock	56.4	57.375	55.9	57.35	159415.0
2017-12-07	AAXJ	Stock	73.8	74.4708	73.8	74.41	2755362.0
2017-12-07	AAXN-DELISTED	Stock	24.04	24.69	23.91	24.34	474038.0
2017-12-07	AB	Stock	25.55	26.15	25.45	25.9	232900.0
2017-12-07	ABAC-DELISTED	Stock	2.95	3.01	2.8591	2.8591	3355.0
2017-12-07	ABAX-DELISTED	Stock	48.2	48.2	46.83	47.12	123676.0
2017-12-07	ABB-DELISTED	Stock	25.69	25.86	25.62	25.81	1849028.0
2017-12-07	ABBNY-DELISTED	Stock	25.69	25.86	25.62	25.81	3091628.0
2017-12-07	ABBV	Stock	94.03	94.57	92.9	94.24	4524500.0
2017-12-07	ABC-DELISTED	Stock	86.27	86.84	85.43	85.91	1559415.0
2017-12-07	ABCB	Stock	48.3	48.6	47.5	47.6	188600.0
2017-12-07	ABCD-DELISTED	Stock	5.75	5.75	5.56	5.63	28627.0
2017-12-07	ABDC-DELISTED	Stock	8.32	8.355	8.26	8.27	56438.0
2017-12-07	ABE-DELISTED	Stock	14.06	14.15	14.06	14.145	19361.0
2017-12-07	ABEO	Stock	370.0	410.0	367.5	395.0	28464.0
2017-12-07	ABEOW-DELISTED	Stock	10.625	11.3	10.4	11.09	701.0
2017-12-07	ABEV	Stock	6.12	6.29	6.11	6.21	17989500.0
2017-12-07	ABG	Stock	66.8	66.85	65.43	66.5	228100.0
2017-12-07	ABIL-DELISTED	Stock	0.4828	0.4828	0.44	0.4461	120484.0
2017-12-07	ABLX-DELISTED	Stock	22.73	23.55	22.73	23.55	127151.0
2017-12-07	ABM	Stock	43.55	43.77	43.07	43.33	373400.0

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

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