PREVIEW / stock_daily / 2020-08-31

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-31.parquet
  size:    225 KB
  rows:    6,840
  symbols: 2,426

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
2020-08-31	AAPL	Stock	127.58	131.0	126.0	129.04	225702700.0
2020-08-31	MSFT	Stock	227.0	228.7	224.31	225.53	28774200.0
2020-08-31	NVDA	Stock	13.1828	13.575	13.0378	13.3745	500840000.0
2020-08-31	AMZN	Stock	170.4495	174.75	170.25	172.548	83718000.0
2020-08-31	GOOGL	Stock	82.1785	82.225	81.2665	81.4765	26421940.0
2020-08-31	META	Stock	293.95	296.88	291.55	293.2	17345100.0
2020-08-31	TSLA	Stock	148.2033	166.7133	146.7033	166.1067	355123200.0
2020-08-31	TLT	Stock	161.6	163.25	161.56	162.19	11388108.0
2020-08-31	ES	Stock	84.59	85.86	84.53	85.71	2385200.0
2020-08-31	CL	Stock	79.2	79.49	78.92	79.26	3272700.0
2020-08-31	A	Stock	99.9	101.04	99.75	100.42	1076900.0
2020-08-31	AA	Stock	15.23	15.23	14.62	14.62	4033200.0
2020-08-31	AACG	Stock	1.2	1.2	1.11	1.12	22200.0
2020-08-31	AACQU-DELISTED	Stock	10.02	10.05	10.01	10.02	66164.0
2020-08-31	AAIC-DELISTED	Stock	2.77	2.79	2.68	2.72	260465.0
2020-08-31	AAIC.C-DELISTED	Stock	19.12	19.275	19.12	19.12	1848.0
2020-08-31	AAL	Stock	13.6	13.74	13.05	13.05	45917200.0
2020-08-31	AAM.A-DELISTED	Stock	26.5314	26.87	26.505	26.87	16479.0
2020-08-31	AAM.B-DELISTED	Stock	27.2999	27.4	27.17	27.17	31817.0
2020-08-31	AAMC-DELISTED	Stock	7.0559	7.4706	6.8062	6.9694	51211.0
2020-08-31	AAME	Stock	2.11	2.11	2.0	2.0	13800.0
2020-08-31	AAMI	Stock	14.07	14.07	13.65	13.86	985300.0
2020-08-31	AAOI	Stock	11.68	11.8	11.46	11.63	558200.0
2020-08-31	AAON	Stock	38.2667	38.4933	37.66	37.9533	330300.0
2020-08-31	AAP	Stock	154.77	158.74	151.51	156.31	1242100.0
2020-08-31	AAT	Stock	25.6	25.78	25.25	25.55	376000.0
2020-08-31	AAU-DELISTED	Stock	0.7	0.714	0.69	0.6999	569164.0
2020-08-31	AAUAF-DELISTED	Stock	0.7	0.714	0.69	0.7053	606725.0
2020-08-31	AAWW-DELISTED	Stock	56.66	57.81	56.34	56.39	367295.0
2020-08-31	AAXJ	Stock	77.87	78.0	77.1799	77.76	3398860.0
2020-08-31	AAXN-DELISTED	Stock	83.74	85.95	83.5	85.7	272734.0
2020-08-31	AB	Stock	29.0	29.0	28.42	28.49	203300.0
2020-08-31	ABB-DELISTED	Stock	25.6	25.86	25.51	25.51	1125360.0
2020-08-31	ABBNY-DELISTED	Stock	25.6	25.86	25.5	25.5	1208403.0
2020-08-31	ABBV	Stock	94.12	96.01	94.01	95.77	9932300.0
2020-08-31	ABC-DELISTED	Stock	96.97	97.93	96.96	97.03	751999.0
2020-08-31	ABCB	Stock	24.76	24.88	24.34	24.52	341900.0
2020-08-31	ABEO	Stock	56.5	60.5	56.5	58.75	29848.0
2020-08-31	ABEV	Stock	2.33	2.34	2.25	2.25	20436200.0
2020-08-31	ABG	Stock	107.35	107.98	104.49	105.79	235800.0
2020-08-31	ABM	Stock	38.28	38.5	37.82	38.14	322500.0
2020-08-31	ABMD-DELISTED	Stock	303.05	310.41	301.505	308.0	210188.0
2020-08-31	ABR	Stock	11.71	11.71	11.32	11.32	1329200.0
2020-08-31	ABR.A-DELISTED	Stock	25.45	25.45	25.1	25.25	3432.0
2020-08-31	ABR.B-DELISTED	Stock	24.9773	25.0	24.9773	24.99	846.0
2020-08-31	ABR.C-DELISTED	Stock	25.45	25.53	25.45	25.53	400.0
2020-08-31	ABT	Stock	110.7	111.74	109.26	109.47	6943200.0
2020-08-31	ABTC	Stock	195000.0	195300.0	180300.0	181500.0	6.666666666666667
2020-08-31	ABTS	Stock	32.55	36.0	32.55	33.6	35060.0
2020-08-31	ABTX-DELISTED	Stock	26.32	26.33	25.39	25.43	40704.0

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

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