PREVIEW / stock_daily / 2017-02-22

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-22.parquet
  size:    216 KB
  rows:    6,501
  symbols: 3,091

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-22	AAPL	Stock	34.1075	34.28	34.0275	34.2775	83347600.0
2017-02-22	MSFT	Stock	64.33	64.39	64.05	64.36	19292700.0
2017-02-22	NVDA	Stock	2.7855	2.795	2.7498	2.769	433772000.0
2017-02-22	AMZN	Stock	42.8475	42.9215	42.609	42.7805	52340000.0
2017-02-22	GOOGL	Stock	42.4	42.6895	42.3355	42.568	24497780.0
2017-02-22	META	Stock	133.6	136.79	133.46	136.12	27360100.0
2017-02-22	TSLA	Stock	18.6873	18.8967	18.1733	18.234	131325000.0
2017-02-22	TLT	Stock	120.8	120.82	119.59	120.31	8101522.0
2017-02-22	ES	Stock	56.26	57.67	56.09	57.6	1857000.0
2017-02-22	CL	Stock	73.3	73.58	72.85	73.49	5811800.0
2017-02-22	A	Stock	51.31	51.72	51.19	51.34	1632400.0
2017-02-22	AA	Stock	36.4	36.71	36.21	36.6	2585700.0
2017-02-22	AAAP-DELISTED	Stock	36.99	37.02	36.57	36.92	85225.0
2017-02-22	AABA-DELISTED	Stock	45.47	46.345	45.45	45.98	7079966.0
2017-02-22	AAC-DELISTED	Stock	8.13	8.33	7.84	7.86	78811.0
2017-02-22	AACG	Stock	3.91	3.94	3.69	3.91	15000.0
2017-02-22	AAIC-DELISTED	Stock	15.0	15.08	14.82	14.94	220067.0
2017-02-22	AAL	Stock	46.5	46.7	45.87	46.32	5799600.0
2017-02-22	AAMC-DELISTED	Stock	21.7059	22.6471	21.5735	21.6176	21491.0
2017-02-22	AAME	Stock	3.75	3.9	3.75	3.8	2700.0
2017-02-22	AAMI	Stock	14.98	15.13	14.88	15.1	246000.0
2017-02-22	AAOI	Stock	37.7	38.3	37.07	37.12	654900.0
2017-02-22	AAON	Stock	23.0	23.0333	22.4	22.9333	250500.0
2017-02-22	AAP	Stock	160.74	161.99	155.27	159.68	3442900.0
2017-02-22	AAT	Stock	43.68	44.79	43.68	44.11	225200.0
2017-02-22	AAU-DELISTED	Stock	1.15	1.16	1.09	1.11	516365.0
2017-02-22	AAUAF-DELISTED	Stock	1.15	1.16	1.09	1.11	517330.0
2017-02-22	AAV-DELISTED	Stock	6.35	6.4	6.2	6.225	79760.0
2017-02-22	AAWW-DELISTED	Stock	52.5	53.6	52.15	53.5	201124.0
2017-02-22	AAXJ	Stock	61.2	61.32	61.12	61.32	399010.0
2017-02-22	AAXN-DELISTED	Stock	26.42	26.59	26.02	26.24	575791.0
2017-02-22	AB	Stock	24.0	24.05	23.75	23.9	340100.0
2017-02-22	ABAC-DELISTED	Stock	2.72	2.8252	2.66	2.75	13425.0
2017-02-22	ABAX-DELISTED	Stock	50.12	50.47	49.57	49.8	50414.0
2017-02-22	ABB-DELISTED	Stock	22.83	22.91	22.73	22.83	2284151.0
2017-02-22	ABBNY-DELISTED	Stock	22.83	22.91	22.73	22.82	2328105.0
2017-02-22	ABBV	Stock	61.72	61.95	61.3	61.36	6422200.0
2017-02-22	ABC-DELISTED	Stock	91.19	92.2	91.01	91.34	973190.0
2017-02-22	ABCB	Stock	48.65	49.45	48.52	49.2	94100.0
2017-02-22	ABCD-DELISTED	Stock	4.82	4.91	4.66	4.88	52117.0
2017-02-22	ABCO-DELISTED	Stock	46.55	46.85	46.375	46.6	307703.0
2017-02-22	ABDC-DELISTED	Stock	12.89	12.94	12.78	12.87	43661.0
2017-02-22	ABE-DELISTED	Stock	12.13	12.2	12.0601	12.1699	30961.0
2017-02-22	ABEO	Stock	132.5	133.75	125.0	127.5	14864.0
2017-02-22	ABEV	Stock	5.89	5.92	5.83	5.91	16619000.0
2017-02-22	ABG	Stock	69.45	69.65	68.2	68.45	520900.0
2017-02-22	ABIL-DELISTED	Stock	2.91	2.9545	2.81	2.8921	2030.0
2017-02-22	ABM	Stock	40.76	41.06	40.62	41.04	159500.0
2017-02-22	ABMD-DELISTED	Stock	117.98	118.15	116.92	117.01	130836.0
2017-02-22	ABR	Stock	7.37	7.4	7.35	7.38	54000.0

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

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