PREVIEW / stock_daily / 2017-02-01

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-01.parquet
  size:    215 KB
  rows:    6,486
  symbols: 3,086

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-02-01	AAPL	Stock	31.7575	32.6225	31.7525	32.1875	447940000.0
2017-02-01	MSFT	Stock	64.36	64.62	63.47	63.58	39671500.0
2017-02-01	NVDA	Stock	2.7645	2.853	2.7465	2.8488	590004000.0
2017-02-01	AMZN	Stock	41.4605	41.689	41.247	41.6175	77004000.0
2017-02-01	GOOGL	Stock	41.2	41.2	40.6125	40.762	45020940.0
2017-02-01	META	Stock	132.25	133.49	130.68	133.23	50139800.0
2017-02-01	TSLA	Stock	16.87	16.88	16.6033	16.616	59382000.0
2017-02-01	TLT	Stock	119.1	119.53	118.58	119.1	10975521.0
2017-02-01	ES	Stock	54.91	55.24	54.5	54.7	1298400.0
2017-02-01	CL	Stock	64.5	65.0	64.43	64.72	4915800.0
2017-02-01	A	Stock	48.93	49.81	48.68	49.26	2244600.0
2017-02-01	AA	Stock	36.58	37.19	36.2	36.26	2905400.0
2017-02-01	AAAP-DELISTED	Stock	32.62	33.33	32.55	32.96	72913.0
2017-02-01	AABA-DELISTED	Stock	44.25	44.26	43.71	43.79	4836750.0
2017-02-01	AAC-DELISTED	Stock	7.95	8.1	7.93	8.02	51470.0
2017-02-01	AACG	Stock	2.97	3.33	2.97	3.16	29000.0
2017-02-01	AAIC-DELISTED	Stock	15.15	15.23	14.98	15.04	301617.0
2017-02-01	AAL	Stock	44.75	45.0	43.91	44.05	7955500.0
2017-02-01	AAMC-DELISTED	Stock	18.3971	19.2647	18.3971	19.1176	12407.0
2017-02-01	AAME	Stock	3.75	3.81	3.75	3.8	2900.0
2017-02-01	AAMI	Stock	14.19	14.44	14.103	14.22	262600.0
2017-02-01	AAOI	Stock	31.3	31.36	30.51	30.93	256500.0
2017-02-01	AAON	Stock	22.7667	22.8	22.3333	22.6	146400.0
2017-02-01	AAP	Stock	164.02	164.89	159.7	160.59	1594900.0
2017-02-01	AAT	Stock	42.75	43.24	42.15	42.33	124400.0
2017-02-01	AAU-DELISTED	Stock	1.03	1.07	1.02	1.06	185022.0
2017-02-01	AAUAF-DELISTED	Stock	1.03	1.07	1.02	1.07	187180.0
2017-02-01	AAV-DELISTED	Stock	6.45	6.475	6.35	6.4	63207.0
2017-02-01	AAWW-DELISTED	Stock	53.2	53.7	52.7	52.85	185660.0
2017-02-01	AAXJ	Stock	59.26	59.36	58.9931	59.09	1080591.0
2017-02-01	AAXN-DELISTED	Stock	25.13	25.3	24.91	25.12	439154.0
2017-02-01	AB	Stock	23.45	23.65	23.15	23.25	306000.0
2017-02-01	ABAC-DELISTED	Stock	3.48	3.48	3.15	3.38	15272.0
2017-02-01	ABAX-DELISTED	Stock	51.75	52.22	50.81	51.05	238533.0
2017-02-01	ABB-DELISTED	Stock	23.82	23.8799	23.62	23.75	1583090.0
2017-02-01	ABBNY-DELISTED	Stock	23.82	23.8799	23.62	23.75	1645758.0
2017-02-01	ABBV	Stock	61.07	61.1	60.27	60.89	5888700.0
2017-02-01	ABC-DELISTED	Stock	87.71	88.7	86.09	88.61	2920255.0
2017-02-01	ABCB	Stock	45.5	46.2	44.75	45.05	130300.0
2017-02-01	ABCD-DELISTED	Stock	5.09	5.14	4.72	5.02	88024.0
2017-02-01	ABCO-DELISTED	Stock	45.7	46.425	45.7	46.15	510842.0
2017-02-01	ABDC-DELISTED	Stock	12.03	12.03	11.67	11.89	63171.0
2017-02-01	ABE-DELISTED	Stock	11.764	11.835	11.74	11.83	23205.0
2017-02-01	ABEO	Stock	115.0	118.75	112.5	116.25	6908.0
2017-02-01	ABEOW-DELISTED	Stock	2.75	2.85	2.65	2.75	3548.0
2017-02-01	ABEV	Stock	5.47	5.5	5.4	5.48	12196200.0
2017-02-01	ABG	Stock	65.75	67.05	64.95	65.3	229500.0
2017-02-01	ABIL-DELISTED	Stock	3.24	3.24	3.2	3.2	4952.0
2017-02-01	ABM	Stock	40.41	40.87	40.05	40.14	467900.0
2017-02-01	ABMD-DELISTED	Stock	106.28	106.76	104.9	105.55	398597.0

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

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