PREVIEW / stock_daily / 2019-02-06

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-06.parquet
  size:    219 KB
  rows:    6,513
  symbols: 2,629

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-06	AAPL	Stock	43.6625	43.8925	43.2125	43.56	112958400.0
2019-02-06	MSFT	Stock	107.0	107.0	105.53	106.03	20609800.0
2019-02-06	NVDA	Stock	3.7822	3.89	3.7768	3.825	702464000.0
2019-02-06	AMZN	Stock	83.5375	83.613	81.667	82.013	78798000.0
2019-02-06	GOOGL	Stock	57.4635	57.7	55.918	56.1445	48256400.0
2019-02-06	META	Stock	171.2	172.47	169.27	170.49	13281200.0
2019-02-06	TSLA	Stock	21.306	21.616	21.0413	21.148	75577500.0
2019-02-06	TLT	Stock	121.36	121.41	120.73	121.03	5184018.0
2019-02-06	ES	Stock	69.2	69.56	68.83	69.02	1109600.0
2019-02-06	CL	Stock	64.52	65.5	64.5	65.33	3474600.0
2019-02-06	A	Stock	76.11	76.69	76.0	76.3	1504900.0
2019-02-06	AA	Stock	29.01	29.3	28.51	28.55	2923700.0
2019-02-06	AABA-DELISTED	Stock	69.95	70.42	69.32	69.95	3056394.0
2019-02-06	AAC-DELISTED	Stock	2.8	2.805	2.6	2.72	161391.0
2019-02-06	AACG	Stock	1.07	1.09	1.02	1.06	41700.0
2019-02-06	AAIC-DELISTED	Stock	8.73	8.8	8.63	8.78	350208.0
2019-02-06	AAL	Stock	36.8	37.09	36.61	36.76	5802800.0
2019-02-06	AAM.A-DELISTED	Stock	24.63	24.65	24.53	24.6479	16954.0
2019-02-06	AAM.B-DELISTED	Stock	24.41	24.47	24.4	24.45	33204.0
2019-02-06	AAMC-DELISTED	Stock	8.2382	8.4912	8.0882	8.4706	33099.0
2019-02-06	AAME	Stock	2.55	2.55	2.55	2.55	700.0
2019-02-06	AAMI	Stock	12.42	12.68	12.29	12.32	1620100.0
2019-02-06	AAOI	Stock	17.31	17.71	17.22	17.39	366500.0
2019-02-06	AAON	Stock	24.8333	25.0933	24.7733	24.9133	97500.0
2019-02-06	AAP	Stock	161.38	161.8	156.7	157.22	1212000.0
2019-02-06	AAT	Stock	43.26	43.45	42.77	43.06	101300.0
2019-02-06	AAU-DELISTED	Stock	0.72	0.7399	0.717	0.73	132266.0
2019-02-06	AAUAF-DELISTED	Stock	0.72	0.7399	0.717	0.73	137698.0
2019-02-06	AAWW-DELISTED	Stock	54.08	54.41	52.49	52.64	241069.0
2019-02-06	AAXJ	Stock	69.78	69.78	69.03	69.16	865248.0
2019-02-06	AAXN-DELISTED	Stock	52.69	52.72	51.42	52.11	234988.0
2019-02-06	AB	Stock	30.0	30.15	29.92	29.97	316200.0
2019-02-06	ABB-DELISTED	Stock	19.61	19.7056	19.5801	19.6	1849618.0
2019-02-06	ABBNY-DELISTED	Stock	19.61	19.7056	19.5801	19.6	2318109.0
2019-02-06	ABBV	Stock	79.6	79.89	78.79	79.08	4907200.0
2019-02-06	ABC-DELISTED	Stock	85.42	87.27	85.19	86.64	931486.0
2019-02-06	ABCB	Stock	37.83	38.03	37.59	37.94	192700.0
2019-02-06	ABDC-DELISTED	Stock	7.68	7.72	7.55	7.67	32573.0
2019-02-06	ABEO	Stock	179.5	181.75	176.5	180.0	8416.0
2019-02-06	ABEV	Stock	4.92	5.0	4.85	4.88	22451200.0
2019-02-06	ABG	Stock	75.1	75.82	71.36	73.63	334000.0
2019-02-06	ABIL-DELISTED	Stock	2.01	2.0168	1.9	1.935	152052.0
2019-02-06	ABM	Stock	35.05	35.26	34.47	34.68	320200.0
2019-02-06	ABMD-DELISTED	Stock	345.25	350.0	340.01	344.93	308661.0
2019-02-06	ABR	Stock	11.91	11.96	11.78	11.92	559300.0
2019-02-06	ABR.A-DELISTED	Stock	25.7283	25.74	25.6	25.73	2700.0
2019-02-06	ABR.B-DELISTED	Stock	25.6007	25.68	25.5972	25.5972	1200.0
2019-02-06	ABR.C-DELISTED	Stock	25.836	25.836	25.71	25.71	2301.0
2019-02-06	ABT	Stock	72.9	73.56	72.63	73.49	4851900.0
2019-02-06	ABTC	Stock	304500.0	304500.0	303600.0	303750.0	0.38666666666666666

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

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