PREVIEW / stock_daily / 2019-02-22

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-22.parquet
  size:    220 KB
  rows:    6,523
  symbols: 2,615

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
2019-02-22	AAPL	Stock	42.895	43.25	42.845	43.2425	75652800.0
2019-02-22	MSFT	Stock	110.05	111.2	109.82	110.97	27763200.0
2019-02-22	NVDA	Stock	3.9465	3.9988	3.9328	3.9798	401740000.0
2019-02-22	AMZN	Stock	81.175	81.747	81.0585	81.578	61924000.0
2019-02-22	GOOGL	Stock	55.485	55.8625	55.025	55.828	29435660.0
2019-02-22	META	Stock	160.58	162.41	160.31	161.89	15858500.0
2019-02-22	TSLA	Stock	19.6327	19.7667	19.4733	19.6473	86109000.0
2019-02-22	TLT	Stock	121.47	121.945	121.42	121.57	6374560.0
2019-02-22	ES	Stock	70.0	70.55	69.78	70.3	2452900.0
2019-02-22	CL	Stock	66.71	67.47	66.46	66.9	4025000.0
2019-02-22	A	Stock	78.16	78.46	77.83	78.42	2797700.0
2019-02-22	AA	Stock	29.88	30.48	29.36	30.17	3197600.0
2019-02-22	AABA-DELISTED	Stock	70.33	71.77	69.93	71.72	8711647.0
2019-02-22	AAC-DELISTED	Stock	2.94	3.03	2.885	2.98	142695.0
2019-02-22	AACG	Stock	1.12	1.12	1.07	1.09	39600.0
2019-02-22	AAIC-DELISTED	Stock	8.2	8.29	8.2	8.23	606891.0
2019-02-22	AAL	Stock	35.0	35.55	35.0	35.49	5393300.0
2019-02-22	AAM.A-DELISTED	Stock	24.92	24.98	24.9	24.97	8807.0
2019-02-22	AAM.B-DELISTED	Stock	24.61	24.75	24.61	24.6801	26737.0
2019-02-22	AAMC-DELISTED	Stock	10.3088	12.3521	10.1618	11.4118	51133.0
2019-02-22	AAME	Stock	2.67	2.85	2.67	2.85	4200.0
2019-02-22	AAMI	Stock	14.0	14.08	13.9	14.03	992400.0
2019-02-22	AAOI	Stock	13.0	15.49	12.9	15.42	3756500.0
2019-02-22	AAON	Stock	27.6067	28.14	27.6	28.12	235800.0
2019-02-22	AAP	Stock	161.31	161.88	158.91	161.47	1158000.0
2019-02-22	AAT	Stock	43.78	43.96	43.39	43.78	96800.0
2019-02-22	AAU-DELISTED	Stock	0.701	0.727	0.701	0.7133	240451.0
2019-02-22	AAUAF-DELISTED	Stock	0.701	0.727	0.701	0.7133	252110.0
2019-02-22	AAWW-DELISTED	Stock	59.61	59.61	58.03	58.91	188864.0
2019-02-22	AAXJ	Stock	69.88	70.15	69.75	70.02	741731.0
2019-02-22	AAXN-DELISTED	Stock	55.62	55.95	55.01	55.74	348029.0
2019-02-22	AB	Stock	29.61	29.96	29.55	29.67	308100.0
2019-02-22	ABB-DELISTED	Stock	20.21	20.36	20.2	20.34	3070107.0
2019-02-22	ABBNY-DELISTED	Stock	20.21	20.36	20.2	20.33	3290097.0
2019-02-22	ABBV	Stock	79.16	80.19	78.24	80.02	5022700.0
2019-02-22	ABC-DELISTED	Stock	85.39	85.88	84.9	85.66	691198.0
2019-02-22	ABCB	Stock	40.68	41.48	40.67	41.44	411400.0
2019-02-22	ABDC-DELISTED	Stock	6.95	7.03	6.92	6.98	38465.0
2019-02-22	ABEO	Stock	160.5	162.75	159.0	161.75	7872.0
2019-02-22	ABEV	Stock	4.83	4.85	4.79	4.84	21977200.0
2019-02-22	ABG	Stock	70.93	71.92	70.02	70.37	121600.0
2019-02-22	ABIL-DELISTED	Stock	1.97	1.97	1.87	1.8912	55376.0
2019-02-22	ABM	Stock	36.77	37.15	36.63	36.98	424600.0
2019-02-22	ABMD-DELISTED	Stock	359.47	360.877	351.77	352.53	271224.0
2019-02-22	ABR	Stock	12.95	12.96	12.86	12.96	2070600.0
2019-02-22	ABR.A-DELISTED	Stock	25.3899	25.47	25.345	25.47	3068.0
2019-02-22	ABR.B-DELISTED	Stock	25.23	25.45	25.23	25.35	3950.0
2019-02-22	ABR.C-DELISTED	Stock	25.43	25.47	25.335	25.4501	5996.0
2019-02-22	ABT	Stock	75.35	76.45	75.35	76.13	5296600.0
2019-02-22	ABTC	Stock	304500.0	304800.0	303600.0	304200.0	0.43999999999999995

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

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