PREVIEW / stock_daily / 2020-08-28

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-28.parquet
  size:    225 KB
  rows:    6,800
  symbols: 2,419

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-28	AAPL	Stock	126.0125	126.4425	124.5775	124.8075	187630000.0
2020-08-28	MSFT	Stock	228.18	230.64	226.58	228.91	26292900.0
2020-08-28	NVDA	Stock	12.675	13.148	12.6425	13.1478	537160000.0
2020-08-28	AMZN	Stock	171.15	171.6685	169.325	170.09	57940000.0
2020-08-28	GOOGL	Stock	81.4735	82.0675	81.2803	81.9715	22423900.0
2020-08-28	META	Stock	295.0	297.23	290.98	293.66	17157400.0
2020-08-28	TSLA	Stock	153.008	154.566	145.768	147.56	301218000.0
2020-08-28	TLT	Stock	161.77	162.05	160.64	161.12	8415402.0
2020-08-28	ES	Stock	84.37	85.02	83.24	84.77	1136500.0
2020-08-28	CL	Stock	79.0	79.51	78.44	79.37	3039800.0
2020-08-28	A	Stock	99.0	99.93	98.54	99.9	866000.0
2020-08-28	AA	Stock	15.01	15.18	14.861	15.12	3143900.0
2020-08-28	AACG	Stock	1.11	1.27	1.11	1.2	250400.0
2020-08-28	AACQU-DELISTED	Stock	10.07	10.07	10.02	10.04	571579.0
2020-08-28	AAIC-DELISTED	Stock	2.8	2.8275	2.79	2.8	118904.0
2020-08-28	AAIC.C-DELISTED	Stock	19.187	19.3	19.187	19.3	2270.0
2020-08-28	AAL	Stock	13.59	13.63	13.23	13.59	54516400.0
2020-08-28	AAM.A-DELISTED	Stock	26.33	26.624	26.33	26.34	11377.0
2020-08-28	AAM.B-DELISTED	Stock	27.31	27.32	27.0	27.32	22104.0
2020-08-28	AAMC-DELISTED	Stock	6.7544	6.9853	6.6324	6.7353	26302.0
2020-08-28	AAME	Stock	2.08	2.1	2.05	2.09	4300.0
2020-08-28	AAMI	Stock	14.05	14.13	13.88	14.05	352300.0
2020-08-28	AAOI	Stock	11.46	11.77	11.39	11.65	572800.0
2020-08-28	AAON	Stock	38.8	38.8	37.8467	38.3267	205500.0
2020-08-28	AAP	Stock	155.38	155.59	153.13	154.77	611600.0
2020-08-28	AAT	Stock	25.95	25.95	25.45	25.72	299000.0
2020-08-28	AAU-DELISTED	Stock	0.651	0.7	0.65	0.6999	502760.0
2020-08-28	AAUAF-DELISTED	Stock	0.651	0.7	0.65	0.7	515550.0
2020-08-28	AAWW-DELISTED	Stock	56.67	57.51	56.4	57.26	267217.0
2020-08-28	AAXJ	Stock	78.93	79.37	78.81	79.29	656516.0
2020-08-28	AAXN-DELISTED	Stock	85.39	85.9686	83.29	83.84	302706.0
2020-08-28	AB	Stock	28.67	28.97	28.23	28.96	207300.0
2020-08-28	ABB-DELISTED	Stock	25.76	25.84	25.67	25.82	787644.0
2020-08-28	ABBNY-DELISTED	Stock	25.76	25.84	25.67	25.82	842262.0
2020-08-28	ABBV	Stock	94.52	94.65	93.53	94.17	4938300.0
2020-08-28	ABC-DELISTED	Stock	98.0	98.56	97.24	97.52	533655.0
2020-08-28	ABCB	Stock	25.47	25.47	24.8	24.99	266600.0
2020-08-28	ABEO	Stock	56.25	57.0	53.75	56.0	30392.0
2020-08-28	ABEV	Stock	2.33	2.38	2.3	2.38	21366400.0
2020-08-28	ABG	Stock	105.05	108.33	104.98	108.0	153000.0
2020-08-28	ABM	Stock	38.15	38.42	37.81	38.33	193700.0
2020-08-28	ABMD-DELISTED	Stock	309.39	312.28	301.36	303.14	160410.0
2020-08-28	ABR	Stock	11.54	11.62	11.41	11.62	1028600.0
2020-08-28	ABR.A-DELISTED	Stock	25.2538	25.44	25.12	25.25	1700.0
2020-08-28	ABR.B-DELISTED	Stock	25.04	25.1	24.46	24.78	4255.0
2020-08-28	ABR.C-DELISTED	Stock	25.6	25.6	25.41	25.48	1493.0
2020-08-28	ABT	Stock	113.54	114.2	109.41	110.79	17204000.0
2020-08-28	ABTC	Stock	180000.0	187500.0	180000.0	186000.0	2.2800000000000002
2020-08-28	ABTS	Stock	30.75	38.4	29.7	38.25	94360.0
2020-08-28	ABTX-DELISTED	Stock	26.26	26.6799	26.14	26.51	41583.0

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

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