PREVIEW / stock_daily / 2019-02-01

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-01.parquet
  size:    219 KB
  rows:    6,511
  symbols: 2,621

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-01	AAPL	Stock	41.74	42.245	41.4825	41.63	130672400.0
2019-02-01	MSFT	Stock	103.78	104.1	102.35	102.78	35535700.0
2019-02-01	NVDA	Stock	3.6125	3.6698	3.5645	3.6182	625048000.0
2019-02-01	AMZN	Stock	81.944	83.653	81.1005	81.3115	230124000.0
2019-02-01	GOOGL	Stock	56.1145	56.72	55.7125	55.931	33116260.0
2019-02-01	META	Stock	165.84	169.1	165.66	165.71	30806500.0
2019-02-01	TSLA	Stock	20.3613	21.0733	20.2333	20.814	109251000.0
2019-02-01	TLT	Stock	121.48	121.57	120.8446	120.96	12024576.0
2019-02-01	ES	Stock	69.41	69.54	68.38	69.14	1840400.0
2019-02-01	CL	Stock	64.9	65.25	64.2	65.05	5314500.0
2019-02-01	A	Stock	76.16	76.59	75.62	76.04	1343900.0
2019-02-01	AA	Stock	29.7	30.07	28.27	28.6	5042200.0
2019-02-01	AABA-DELISTED	Stock	68.43	68.87	68.26	68.48	5552569.0
2019-02-01	AAC-DELISTED	Stock	2.47	2.47	2.34	2.43	90481.0
2019-02-01	AACG	Stock	1.09	1.19	1.05	1.18	338000.0
2019-02-01	AAIC-DELISTED	Stock	8.65	8.77	8.56	8.73	413056.0
2019-02-01	AAL	Stock	35.77	36.59	35.77	36.11	6611900.0
2019-02-01	AAM.A-DELISTED	Stock	24.53	24.56	24.3872	24.56	26883.0
2019-02-01	AAM.B-DELISTED	Stock	24.4163	24.4163	24.17	24.33	53486.0
2019-02-01	AAMC-DELISTED	Stock	8.5294	8.5294	7.8735	7.8735	34646.0
2019-02-01	AAME	Stock	2.65	2.65	2.65	2.65	2100.0
2019-02-01	AAMI	Stock	12.4	12.615	12.4	12.44	548900.0
2019-02-01	AAOI	Stock	17.37	17.66	17.2	17.29	395100.0
2019-02-01	AAON	Stock	24.7	24.76	24.1533	24.36	127200.0
2019-02-01	AAP	Stock	159.9	161.68	158.53	159.04	941500.0
2019-02-01	AAT	Stock	43.0	43.13	41.87	42.6	120700.0
2019-02-01	AAU-DELISTED	Stock	0.79	0.79	0.7448	0.7522	160484.0
2019-02-01	AAUAF-DELISTED	Stock	0.79	0.79	0.7448	0.7522	166898.0
2019-02-01	AAWW-DELISTED	Stock	53.55	54.93	53.21	53.5	292299.0
2019-02-01	AAXJ	Stock	68.51	68.63	68.32	68.5	707253.0
2019-02-01	AAXN-DELISTED	Stock	51.11	51.25	50.45	50.62	290806.0
2019-02-01	AB	Stock	30.49	30.81	30.49	30.65	315000.0
2019-02-01	ABB-DELISTED	Stock	19.31	19.355	19.215	19.24	2261825.0
2019-02-01	ABBNY-DELISTED	Stock	19.31	19.355	19.215	19.24	2671080.0
2019-02-01	ABBV	Stock	80.25	80.73	79.11	80.5	6759500.0
2019-02-01	ABC-DELISTED	Stock	81.82	83.82	79.7	83.74	3962646.0
2019-02-01	ABCB	Stock	38.02	38.21	37.32	37.65	543100.0
2019-02-01	ABDC-DELISTED	Stock	7.34	7.39	7.31	7.31	17299.0
2019-02-01	ABEO	Stock	171.25	175.0	165.5	170.25	23152.0
2019-02-01	ABEOW-DELISTED	Stock	2.5632	2.6	2.5632	2.6	700.0
2019-02-01	ABEV	Stock	4.8	4.94	4.79	4.93	23082800.0
2019-02-01	ABG	Stock	70.48	70.69	69.8	70.51	277600.0
2019-02-01	ABIL-DELISTED	Stock	2.11	2.115	2.03	2.06	152202.0
2019-02-01	ABM	Stock	34.36	34.53	33.75	34.11	473100.0
2019-02-01	ABMD-DELISTED	Stock	348.79	351.45	340.92	351.0	365216.0
2019-02-01	ABR	Stock	12.0	12.02	11.8	11.91	1114400.0
2019-02-01	ABR.A-DELISTED	Stock	25.71	25.84	25.62	25.84	1521.0
2019-02-01	ABR.C-DELISTED	Stock	25.6852	25.74	25.63	25.63	3017.0
2019-02-01	ABT	Stock	73.02	73.24	71.97	72.36	5016500.0
2019-02-01	ABTC	Stock	304500.0	305100.0	303000.0	304200.0	0.56

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

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