PREVIEW / stock_daily / 2019-08-27

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-27.parquet
  size:    220 KB
  rows:    6,601
  symbols: 2,533

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-08-27	AAPL	Stock	51.965	52.1375	50.8825	51.04	103493200.0
2019-08-27	MSFT	Stock	136.39	136.72	134.66	135.74	23102100.0
2019-08-27	NVDA	Stock	4.1748	4.1775	4.0155	4.045	290968000.0
2019-08-27	AMZN	Stock	88.7865	88.97	87.334	88.0915	60394000.0
2019-08-27	GOOGL	Stock	59.15	59.25	58.2279	58.541	23469780.0
2019-08-27	META	Stock	181.93	184.04	181.01	181.3	14399600.0
2019-08-27	TSLA	Stock	14.3827	14.5867	14.1353	14.272	81243000.0
2019-08-27	TLT	Stock	146.63	147.72	146.48	147.61	11332754.0
2019-08-27	ES	Stock	80.29	81.15	80.17	80.56	1339400.0
2019-08-27	CL	Stock	73.28	73.73	73.03	73.44	2582100.0
2019-08-27	A	Stock	70.05	70.33	69.11	69.48	2032300.0
2019-08-27	AA	Stock	17.31	17.37	16.68	16.73	2376000.0
2019-08-27	AABA-DELISTED	Stock	69.59	69.67	69.2375	69.56	6410241.0
2019-08-27	AAC-DELISTED	Stock	0.5955	0.6	0.5203	0.552	176986.0
2019-08-27	AACG	Stock	1.85	1.85	1.8	1.85	22100.0
2019-08-27	AAIC-DELISTED	Stock	5.23	5.25	5.17	5.17	424043.0
2019-08-27	AAIC.C-DELISTED	Stock	22.25	22.25	22.16	22.2	6040.0
2019-08-27	AAL	Stock	25.27	25.34	24.32	24.45	7503700.0
2019-08-27	AAM.A-DELISTED	Stock	26.78	26.78	26.62	26.6345	12822.0
2019-08-27	AAM.B-DELISTED	Stock	26.7935	26.8185	26.75	26.76	8527.0
2019-08-27	AAMC-DELISTED	Stock	2.9971	2.9971	2.9971	2.9971	381.0
2019-08-27	AAME	Stock	2.75	2.79	2.66	2.66	1600.0
2019-08-27	AAMI	Stock	9.04	9.09	8.68	8.76	466500.0
2019-08-27	AAOI	Stock	9.16	9.18	8.422	8.5	901400.0
2019-08-27	AAON	Stock	31.1667	31.1667	30.3267	30.5067	184200.0
2019-08-27	AAP	Stock	135.82	137.13	134.87	134.89	746800.0
2019-08-27	AAT	Stock	46.78	46.87	46.11	46.18	219200.0
2019-08-27	AAU-DELISTED	Stock	0.72	0.78	0.7051	0.76	452496.0
2019-08-27	AAUAF-DELISTED	Stock	0.72	0.78	0.7051	0.76	456342.0
2019-08-27	AAWW-DELISTED	Stock	25.3	25.39	24.57	24.63	316415.0
2019-08-27	AAXJ	Stock	64.67	64.88	64.39	64.4	2216158.0
2019-08-27	AAXN-DELISTED	Stock	61.45	62.35	60.4	60.98	446310.0
2019-08-27	AB	Stock	28.1	28.42	27.8	28.2	185000.0
2019-08-27	ABB-DELISTED	Stock	18.52	18.57	18.3913	18.43	1033834.0
2019-08-27	ABBNY-DELISTED	Stock	18.52	18.57	18.3913	18.43	1137182.0
2019-08-27	ABBV	Stock	66.67	66.98	65.49	65.67	7591200.0
2019-08-27	ABC-DELISTED	Stock	85.94	86.585	81.2	81.29	1457900.0
2019-08-27	ABCB	Stock	35.53	35.53	33.95	34.16	280800.0
2019-08-27	ABDC-DELISTED	Stock	8.83	8.88	8.8	8.83	49572.0
2019-08-27	ABEO	Stock	47.25	47.25	43.25	43.25	13316.0
2019-08-27	ABEOW-DELISTED	Stock	0.12	0.1399	0.1114	0.1114	1800.0
2019-08-27	ABEV	Stock	4.38	4.45	4.31	4.37	31087300.0
2019-08-27	ABG	Stock	91.2	92.01	90.06	90.35	99900.0
2019-08-27	ABIL-DELISTED	Stock	0.69	0.69	0.62	0.62	55260.0
2019-08-27	ABM	Stock	37.57	37.62	36.61	36.63	253200.0
2019-08-27	ABMD-DELISTED	Stock	191.46	193.04	188.86	190.0	243455.0
2019-08-27	ABR	Stock	12.58	12.61	12.4	12.45	899700.0
2019-08-27	ABR.A-DELISTED	Stock	25.8855	25.8855	25.8855	25.8855	200.0
2019-08-27	ABR.B-DELISTED	Stock	25.75	25.77	25.7249	25.74	1349.0
2019-08-27	ABR.C-DELISTED	Stock	26.3	26.3	26.3	26.3	100.0

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

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