PREVIEW / stock_daily / 2020-10-22

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-22.parquet
  size:    230 KB
  rows:    6,986
  symbols: 2,487

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-22	AAPL	Stock	117.45	118.04	114.59	115.75	101988000.0
2020-10-22	MSFT	Stock	213.93	216.06	211.7	214.89	22351500.0
2020-10-22	NVDA	Stock	13.5225	13.6118	13.2318	13.361	290480000.0
2020-10-22	AMZN	Stock	159.4935	159.9375	156.097	158.82	84240000.0
2020-10-22	GOOGL	Stock	79.25	80.671	78.874	80.333	30515460.0
2020-10-22	META	Stock	279.87	282.45	275.04	278.12	16720000.0
2020-10-22	TSLA	Stock	147.3067	148.41	141.5033	141.93	119979600.0
2020-10-22	TLT	Stock	158.29	158.63	156.97	157.05	12665822.0
2020-10-22	ES	Stock	92.33	93.21	91.77	92.92	1043700.0
2020-10-22	CL	Stock	79.38	79.68	78.68	79.29	2516400.0
2020-10-22	A	Stock	105.32	107.09	105.11	106.77	1064700.0
2020-10-22	AA	Stock	13.28	13.67	13.02	13.66	5368300.0
2020-10-22	AACG	Stock	1.19	1.28	1.17	1.26	296200.0
2020-10-22	AACQ-DELISTED	Stock	9.76	9.78	9.7	9.78	341180.0
2020-10-22	AACQU-DELISTED	Stock	10.2	10.2	10.17	10.17	3661.0
2020-10-22	AACQW-DELISTED	Stock	1.35	1.4	1.2977	1.309	111433.0
2020-10-22	AAIC-DELISTED	Stock	2.64	2.68	2.58	2.62	176886.0
2020-10-22	AAIC.C-DELISTED	Stock	18.75	18.92	18.75	18.92	400.0
2020-10-22	AAL	Stock	12.6	13.29	12.42	13.15	90788900.0
2020-10-22	AAM.A-DELISTED	Stock	26.05	26.19	26.05	26.165	24098.0
2020-10-22	AAM.B-DELISTED	Stock	26.95	27.0687	26.66	27.04	12465.0
2020-10-22	AAMC-DELISTED	Stock	7.0824	7.3529	6.9853	6.9853	26534.0
2020-10-22	AAME	Stock	2.21	2.28	2.18	2.19	1700.0
2020-10-22	AAMI	Stock	15.18	15.3	14.83	15.14	408300.0
2020-10-22	AAOI	Stock	10.63	10.645	10.29	10.39	604900.0
2020-10-22	AAON	Stock	40.84	41.1333	40.5533	40.82	184200.0
2020-10-22	AAP	Stock	153.84	154.07	150.82	152.93	621800.0
2020-10-22	AAT	Stock	24.07	24.39	23.86	24.34	147400.0
2020-10-22	AAU-DELISTED	Stock	0.93	0.9499	0.8901	0.9332	419575.0
2020-10-22	AAUAF-DELISTED	Stock	0.93	0.9499	0.8901	0.9432	432941.0
2020-10-22	AAWW-DELISTED	Stock	64.19	64.53	62.0	63.74	315932.0
2020-10-22	AAXJ	Stock	80.51	80.74	80.01	80.32	602193.0
2020-10-22	AAXN-DELISTED	Stock	104.17	105.49	102.67	103.69	335779.0
2020-10-22	AB	Stock	32.0	32.7	31.75	32.16	514200.0
2020-10-22	ABB-DELISTED	Stock	26.51	26.75	26.4	26.74	1316632.0
2020-10-22	ABBNY-DELISTED	Stock	26.51	26.75	26.4	26.75	1460401.0
2020-10-22	ABBV	Stock	83.02	84.89	82.92	84.31	8080100.0
2020-10-22	ABC-DELISTED	Stock	97.9	98.92	97.22	98.72	463211.0
2020-10-22	ABCB	Stock	27.82	29.3	27.76	29.11	575800.0
2020-10-22	ABCM-DELISTED	Stock	18.0	20.8099	17.71	19.75	2473153.0
2020-10-22	ABEO	Stock	30.75	32.5	30.5	31.75	35884.0
2020-10-22	ABEV	Stock	2.41	2.45	2.38	2.45	19198700.0
2020-10-22	ABG	Stock	123.69	123.95	117.69	119.95	160000.0
2020-10-22	ABM	Stock	33.84	34.97	33.61	34.95	364300.0
2020-10-22	ABMD-DELISTED	Stock	273.05	278.67	270.62	278.51	200502.0
2020-10-22	ABR	Stock	11.59	11.78	11.49	11.55	752100.0
2020-10-22	ABR.A-DELISTED	Stock	25.03	25.4699	24.96	25.4699	1333.0
2020-10-22	ABR.B-DELISTED	Stock	25.06	25.1499	25.03	25.1499	1642.0
2020-10-22	ABR.C-DELISTED	Stock	25.37	25.5091	25.37	25.45	1700.0
2020-10-22	ABT	Stock	106.42	110.05	106.24	109.48	4953800.0

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

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