PREVIEW / stock_daily / 2020-10-21

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-21.parquet
  size:    229 KB
  rows:    6,982
  symbols: 2,481

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-10-21	AAPL	Stock	116.67	118.71	116.45	116.87	89946000.0
2020-10-21	MSFT	Stock	213.12	216.92	213.12	214.8	22724900.0
2020-10-21	NVDA	Stock	13.625	13.7915	13.4775	13.5248	219596000.0
2020-10-21	AMZN	Stock	160.625	161.694	158.0	159.247	91854000.0
2020-10-21	GOOGL	Stock	78.4925	80.757	78.3568	79.2995	60321060.0
2020-10-21	META	Stock	279.56	283.05	276.37	278.73	28998600.0
2020-10-21	TSLA	Stock	140.9	144.3167	140.4167	140.88	97111500.0
2020-10-21	TLT	Stock	158.79	159.37	158.37	158.7	10453705.0
2020-10-21	ES	Stock	92.01	92.92	91.63	92.08	856000.0
2020-10-21	CL	Stock	79.52	80.74	79.52	80.2	3591700.0
2020-10-21	A	Stock	105.92	106.69	104.12	104.83	894000.0
2020-10-21	AA	Stock	12.83	13.6	12.8	13.32	7320900.0
2020-10-21	AACG	Stock	1.28	1.28	1.18	1.18	51700.0
2020-10-21	AACQ-DELISTED	Stock	9.8	9.8	9.74	9.75	673464.0
2020-10-21	AACQU-DELISTED	Stock	10.2849	10.2849	10.2	10.2	67180.0
2020-10-21	AACQW-DELISTED	Stock	1.37	1.3701	1.25	1.3399	416334.0
2020-10-21	AAIC-DELISTED	Stock	2.65	2.705	2.64	2.64	105127.0
2020-10-21	AAIC.C-DELISTED	Stock	18.76	19.04	18.75	19.04	2900.0
2020-10-21	AAL	Stock	12.69	12.87	12.55	12.75	37503600.0
2020-10-21	AAM.A-DELISTED	Stock	26.11	26.11	26.03	26.0828	9865.0
2020-10-21	AAM.B-DELISTED	Stock	26.9	27.01	26.61	26.948	24803.0
2020-10-21	AAMC-DELISTED	Stock	6.8412	7.0	6.6471	6.8235	7837.0
2020-10-21	AAME	Stock	2.11	2.29	2.11	2.18	1700.0
2020-10-21	AAMI	Stock	15.52	15.64	15.08	15.12	695700.0
2020-10-21	AAOI	Stock	10.85	10.95	10.64	10.645	396400.0
2020-10-21	AAON	Stock	41.0	41.2867	40.66	40.66	138000.0
2020-10-21	AAP	Stock	155.99	157.7	153.88	154.38	884500.0
2020-10-21	AAT	Stock	23.86	24.04	23.58	23.99	247700.0
2020-10-21	AAU-DELISTED	Stock	0.95	0.9737	0.8901	0.9202	378745.0
2020-10-21	AAUAF-DELISTED	Stock	0.95	0.9737	0.8901	0.9242	400562.0
2020-10-21	AAWW-DELISTED	Stock	64.56	66.11	62.79	62.8	358100.0
2020-10-21	AAXJ	Stock	80.36	80.87	80.32	80.47	1392367.0
2020-10-21	AAXN-DELISTED	Stock	106.69	107.62	103.06	103.25	419009.0
2020-10-21	AB	Stock	33.08	33.19	32.3	32.33	393400.0
2020-10-21	ABB-DELISTED	Stock	26.67	26.825	26.42	26.42	940073.0
2020-10-21	ABBNY-DELISTED	Stock	26.67	26.825	26.41	26.41	1024725.0
2020-10-21	ABBV	Stock	83.58	84.14	82.56	82.89	9776900.0
2020-10-21	ABC-DELISTED	Stock	97.75	100.22	97.73	97.73	611493.0
2020-10-21	ABCB	Stock	27.04	27.78	26.85	27.65	269900.0
2020-10-21	ABEO	Stock	33.0	33.25	31.0	31.0	42212.0
2020-10-21	ABEV	Stock	2.39	2.45	2.38	2.41	19722500.0
2020-10-21	ABG	Stock	123.0	125.0	119.9	123.0	306500.0
2020-10-21	ABM	Stock	33.99	34.11	33.51	33.73	165400.0
2020-10-21	ABMD-DELISTED	Stock	277.78	280.35	269.935	272.61	161564.0
2020-10-21	ABR	Stock	11.32	11.77	11.14	11.6	1735100.0
2020-10-21	ABR.A-DELISTED	Stock	25.19	25.2	25.13	25.18	2414.0
2020-10-21	ABR.C-DELISTED	Stock	25.38	25.495	25.38	25.4833	3246.0
2020-10-21	ABT	Stock	108.01	109.0	104.75	105.93	5716000.0
2020-10-21	ABTC	Stock	111600.0	113400.0	105600.0	110700.0	7.733333333333333
2020-10-21	ABTS	Stock	17.55	18.0	16.8	17.55	24013.0

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

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