PREVIEW / stock_daily / 2020-08-20

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-20.parquet
  size:    224 KB
  rows:    6,791
  symbols: 2,417

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-20	AAPL	Stock	115.75	118.3925	115.7325	118.275	126907200.0
2020-08-20	MSFT	Stock	209.54	215.0	208.91	214.58	26981500.0
2020-08-20	NVDA	Stock	11.975	12.375	11.8788	12.141	921388000.0
2020-08-20	AMZN	Stock	162.6	165.631	161.9	164.8685	66650000.0
2020-08-20	GOOGL	Stock	76.9985	79.0085	76.723	78.8125	26382620.0
2020-08-20	META	Stock	261.5	269.63	261.46	269.01	20299700.0
2020-08-20	TSLA	Stock	124.0453	134.7993	123.804	133.4553	309177000.0
2020-08-20	TLT	Stock	165.39	165.65	164.93	165.21	10320126.0
2020-08-20	ES	Stock	85.91	86.61	85.37	85.67	772300.0
2020-08-20	CL	Stock	77.83	78.31	77.55	78.25	2009200.0
2020-08-20	A	Stock	97.39	98.17	97.12	97.78	1428300.0
2020-08-20	AA	Stock	15.04	15.245	14.73	15.19	3140900.0
2020-08-20	AACG	Stock	1.06	1.14	1.06	1.14	17300.0
2020-08-20	AACQU-DELISTED	Stock	10.09	10.0965	10.02	10.0552	310472.0
2020-08-20	AAIC-DELISTED	Stock	2.78	2.86	2.76	2.83	205674.0
2020-08-20	AAIC.C-DELISTED	Stock	19.3	19.42	19.25	19.25	1875.0
2020-08-20	AAL	Stock	12.38	12.67	12.26	12.5	41956600.0
2020-08-20	AAM.A-DELISTED	Stock	26.47	26.889	26.47	26.88	14952.0
2020-08-20	AAM.B-DELISTED	Stock	27.01	27.43	27.01	27.39	14376.0
2020-08-20	AAMC-DELISTED	Stock	5.8853	5.9118	5.6676	5.8588	44571.0
2020-08-20	AAME	Stock	2.32	2.37	2.05	2.05	32500.0
2020-08-20	AAMI	Stock	13.18	13.44	13.05	13.39	479300.0
2020-08-20	AAOI	Stock	13.03	13.03	12.445	12.57	618400.0
2020-08-20	AAON	Stock	39.3933	39.9467	39.0333	39.12	234900.0
2020-08-20	AAP	Stock	159.3	160.02	157.06	157.44	1080200.0
2020-08-20	AAT	Stock	25.01	26.0	25.01	25.6	180000.0
2020-08-20	AAU-DELISTED	Stock	0.74	0.74	0.7	0.7141	478246.0
2020-08-20	AAUAF-DELISTED	Stock	0.74	0.74	0.7	0.724	491778.0
2020-08-20	AAWW-DELISTED	Stock	58.55	59.49	57.6	59.03	345257.0
2020-08-20	AAXJ	Stock	75.44	76.37	75.3	76.36	1122066.0
2020-08-20	AAXN-DELISTED	Stock	80.36	82.08	80.29	81.77	373081.0
2020-08-20	AB	Stock	28.61	28.63	28.01	28.17	277500.0
2020-08-20	ABB-DELISTED	Stock	25.87	26.02	25.83	26.0	1053640.0
2020-08-20	ABBNY-DELISTED	Stock	25.88	26.02	25.83	26.0	1119127.0
2020-08-20	ABBV	Stock	95.49	96.03	94.68	95.2	6798000.0
2020-08-20	ABC-DELISTED	Stock	101.72	102.2	99.04	99.13	803549.0
2020-08-20	ABCB	Stock	24.36	24.75	24.1	24.16	247500.0
2020-08-20	ABEO	Stock	66.0	66.5	63.75	64.25	19040.0
2020-08-20	ABEV	Stock	2.27	2.36	2.24	2.34	21473600.0
2020-08-20	ABG	Stock	106.07	107.12	105.24	105.27	81100.0
2020-08-20	ABM	Stock	36.18	37.31	36.07	37.16	287700.0
2020-08-20	ABMD-DELISTED	Stock	311.16	315.0	309.04	309.84	129123.0
2020-08-20	ABR	Stock	11.08	11.34	11.0	11.13	789500.0
2020-08-20	ABR.A-DELISTED	Stock	25.3	25.426	25.04	25.1138	5910.0
2020-08-20	ABR.B-DELISTED	Stock	25.22	25.22	25.22	25.22	100.0
2020-08-20	ABR.C-DELISTED	Stock	25.49	25.56	25.41	25.47	2885.0
2020-08-20	ABT	Stock	99.99	102.02	99.75	101.63	3548600.0
2020-08-20	ABTC	Stock	193500.0	242100.0	180000.0	186000.0	34.733333333333334
2020-08-20	ABTS	Stock	21.15	23.55	21.15	22.5	5560.0
2020-08-20	ABTX-DELISTED	Stock	25.01	25.01	24.77	24.87	19952.0

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

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