PREVIEW / stock_daily / 2017-02-03

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-03.parquet
  size:    216 KB
  rows:    6,503
  symbols: 3,098

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-03	AAPL	Stock	32.0775	32.2975	32.04	32.27	98029200.0
2017-02-03	MSFT	Stock	63.5	63.7	63.07	63.68	30301800.0
2017-02-03	NVDA	Stock	2.8863	2.8975	2.8475	2.8595	372744000.0
2017-02-03	AMZN	Stock	40.336	40.915	40.2	40.51	217376000.0
2017-02-03	GOOGL	Stock	41.1565	41.3065	40.9675	41.0065	30561900.0
2017-02-03	META	Stock	131.24	132.85	130.76	130.98	24804900.0
2017-02-03	TSLA	Stock	16.794	16.812	16.6453	16.7553	32800500.0
2017-02-03	TLT	Stock	119.44	119.87	118.4743	119.0	10275574.0
2017-02-03	ES	Stock	55.61	56.14	55.33	55.72	1933100.0
2017-02-03	CL	Stock	66.34	66.34	65.75	65.97	4478200.0
2017-02-03	A	Stock	49.09	49.47	49.06	49.38	1191800.0
2017-02-03	AA	Stock	37.87	38.05	36.83	36.86	5243300.0
2017-02-03	AAAP-DELISTED	Stock	33.8	34.56	33.8	34.23	172379.0
2017-02-03	AABA-DELISTED	Stock	43.9	43.99	43.66	43.7	4008776.0
2017-02-03	AAC-DELISTED	Stock	8.17	8.35	8.03	8.17	83843.0
2017-02-03	AACG	Stock	3.74	3.74	3.13	3.43	5200.0
2017-02-03	AAIC-DELISTED	Stock	15.25	15.39	15.175	15.27	298572.0
2017-02-03	AAL	Stock	44.31	44.55	43.76	44.2	6357900.0
2017-02-03	AAMC-DELISTED	Stock	22.7353	22.9117	21.3088	22.4559	29220.0
2017-02-03	AAME	Stock	3.85	3.85	3.85	3.85	1400.0
2017-02-03	AAMI	Stock	15.07	15.31	14.95	15.2	450000.0
2017-02-03	AAOI	Stock	31.41	32.68	31.11	32.6	418300.0
2017-02-03	AAON	Stock	22.3333	22.6667	22.3	22.6667	131550.0
2017-02-03	AAP	Stock	162.98	163.7	161.92	162.75	850400.0
2017-02-03	AAT	Stock	42.84	42.93	42.55	42.9	174700.0
2017-02-03	AAU-DELISTED	Stock	1.19	1.24	1.16	1.2	440332.0
2017-02-03	AAUAF-DELISTED	Stock	1.19	1.24	1.16	1.2	443128.0
2017-02-03	AAV-DELISTED	Stock	6.5	6.525	6.425	6.45	70230.0
2017-02-03	AAWW-DELISTED	Stock	52.3	53.0	52.0	52.4	141576.0
2017-02-03	AAXJ	Stock	59.39	59.6	59.29	59.55	638289.0
2017-02-03	AAXN-DELISTED	Stock	25.74	26.35	25.52	26.28	750197.0
2017-02-03	AB	Stock	23.9	23.97	23.55	23.75	365500.0
2017-02-03	ABAC-DELISTED	Stock	3.49	3.77	3.45	3.75	6439.0
2017-02-03	ABAX-DELISTED	Stock	51.32	51.67	50.32	51.38	65593.0
2017-02-03	ABB-DELISTED	Stock	23.57	23.695	23.56	23.63	2447454.0
2017-02-03	ABBNY-DELISTED	Stock	23.58	23.695	23.56	23.63	3017064.0
2017-02-03	ABBV	Stock	60.9	61.06	60.44	60.67	6470300.0
2017-02-03	ABC-DELISTED	Stock	88.57	89.61	87.74	89.28	2636834.0
2017-02-03	ABCB	Stock	45.35	46.45	45.2	46.4	166900.0
2017-02-03	ABCD-DELISTED	Stock	5.05	5.17	5.04	5.09	42235.0
2017-02-03	ABCO-DELISTED	Stock	46.9	47.15	46.155	47.05	599739.0
2017-02-03	ABDC-DELISTED	Stock	12.03	12.03	11.87	11.95	44045.0
2017-02-03	ABE-DELISTED	Stock	11.9027	11.93	11.8	11.93	21939.0
2017-02-03	ABEO	Stock	123.75	127.5	118.75	121.25	6828.0
2017-02-03	ABEOW-DELISTED	Stock	2.8	2.8	2.6	2.6499	12208.0
2017-02-03	ABEV	Stock	5.48	5.54	5.46	5.49	9229500.0
2017-02-03	ABG	Stock	65.0	66.15	64.2	64.45	264600.0
2017-02-03	ABIL-DELISTED	Stock	3.15	3.21	3.15	3.21	3700.0
2017-02-03	ABM	Stock	40.35	40.96	40.2	40.86	303400.0
2017-02-03	ABMD-DELISTED	Stock	104.85	105.93	103.82	104.93	653296.0

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

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