PREVIEW / stock_daily / 2019-02-13

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-13.parquet
  size:    220 KB
  rows:    6,514
  symbols: 2,619

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-13	AAPL	Stock	42.8475	43.12	42.48	42.545	89960800.0
2019-02-13	MSFT	Stock	107.5	107.78	106.71	106.81	18394900.0
2019-02-13	NVDA	Stock	3.809	3.8958	3.7952	3.822	605372000.0
2019-02-13	AMZN	Stock	82.35	82.819	81.8555	82.0	71206000.0
2019-02-13	GOOGL	Stock	56.652	57.1425	56.3	56.4315	28041740.0
2019-02-13	META	Stock	165.38	166.22	163.73	164.07	14205100.0
2019-02-13	TSLA	Stock	20.8233	20.85	20.3713	20.5447	77124000.0
2019-02-13	TLT	Stock	121.15	121.39	120.91	121.1	4757681.0
2019-02-13	ES	Stock	70.06	70.26	69.65	70.06	1412400.0
2019-02-13	CL	Stock	65.9	66.15	65.5	65.94	3505500.0
2019-02-13	A	Stock	77.37	77.49	76.74	77.25	1376400.0
2019-02-13	AA	Stock	28.81	29.55	28.7	29.05	4566800.0
2019-02-13	AABA-DELISTED	Stock	69.09	69.66	68.99	69.12	3124351.0
2019-02-13	AAC-DELISTED	Stock	2.77	3.01	2.76	2.97	245348.0
2019-02-13	AACG	Stock	1.09	1.09	1.02	1.04	86100.0
2019-02-13	AAIC-DELISTED	Stock	8.83	8.88	8.8	8.85	248714.0
2019-02-13	AAL	Stock	35.83	36.46	35.81	36.21	5837900.0
2019-02-13	AAM.A-DELISTED	Stock	24.79	24.88	24.7785	24.84	22165.0
2019-02-13	AAM.B-DELISTED	Stock	24.5799	24.58	24.49	24.49	37213.0
2019-02-13	AAMC-DELISTED	Stock	10.25	11.4618	9.8265	10.1618	81090.0
2019-02-13	AAME	Stock	2.58	2.6	2.58	2.6	2300.0
2019-02-13	AAMI	Stock	14.09	14.305	14.04	14.2	658100.0
2019-02-13	AAOI	Stock	14.58	15.22	14.58	14.94	788200.0
2019-02-13	AAON	Stock	25.6067	26.1333	25.2733	26.0867	242100.0
2019-02-13	AAP	Stock	168.68	169.58	165.63	166.46	1104700.0
2019-02-13	AAT	Stock	43.18	44.04	42.71	43.97	336900.0
2019-02-13	AAU-DELISTED	Stock	0.76	0.76	0.7	0.7003	192482.0
2019-02-13	AAUAF-DELISTED	Stock	0.76	0.76	0.7	0.7003	201804.0
2019-02-13	AAWW-DELISTED	Stock	54.46	54.8	53.61	53.79	135107.0
2019-02-13	AAXJ	Stock	69.03	69.06	68.45	68.6	560195.0
2019-02-13	AAXN-DELISTED	Stock	53.66	53.96	53.06	53.7	248796.0
2019-02-13	AB	Stock	30.19	31.34	30.0	30.7	561800.0
2019-02-13	ABB-DELISTED	Stock	19.26	19.34	19.175	19.3	3370568.0
2019-02-13	ABBNY-DELISTED	Stock	19.26	19.34	19.175	19.3	3601409.0
2019-02-13	ABBV	Stock	80.34	81.32	80.29	80.79	4237200.0
2019-02-13	ABC-DELISTED	Stock	85.91	86.77	85.49	86.4	596836.0
2019-02-13	ABCB	Stock	39.08	39.28	38.79	38.98	214500.0
2019-02-13	ABDC-DELISTED	Stock	7.4405	7.4405	7.35	7.38	5619.0
2019-02-13	ABEO	Stock	168.5	169.75	164.0	164.75	10408.0
2019-02-13	ABEV	Stock	4.91	4.95	4.83	4.86	60236100.0
2019-02-13	ABG	Stock	70.3	71.02	69.58	70.62	152200.0
2019-02-13	ABIL-DELISTED	Stock	1.97	1.9889	1.86	1.92	174091.0
2019-02-13	ABM	Stock	36.32	36.41	35.84	36.02	304200.0
2019-02-13	ABMD-DELISTED	Stock	357.74	364.15	353.37	361.5	225762.0
2019-02-13	ABR	Stock	12.0	12.01	11.86	11.96	819700.0
2019-02-13	ABR.A-DELISTED	Stock	25.65	25.65	25.48	25.48	5419.0
2019-02-13	ABR.B-DELISTED	Stock	25.9	25.9	25.6503	25.89	2462.0
2019-02-13	ABR.C-DELISTED	Stock	25.83	25.83	25.64	25.66	8601.0
2019-02-13	ABT	Stock	75.04	75.27	74.06	74.38	5696300.0
2019-02-13	ABTC	Stock	304800.0	304800.0	302700.0	303000.0	1.12

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

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