PREVIEW / stock_daily / 2020-09-09

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-09.parquet
  size:    226 KB
  rows:    6,828
  symbols: 2,422

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-09-09	AAPL	Stock	117.26	119.14	115.26	117.32	176940500.0
2020-09-09	MSFT	Stock	207.6	214.84	206.7	211.29	45679000.0
2020-09-09	NVDA	Stock	12.4	12.8092	12.2318	12.715	736200000.0
2020-09-09	AMZN	Stock	160.1495	165.159	159.25	163.4305	103774000.0
2020-09-09	GOOGL	Stock	77.445	77.936	76.2585	77.3615	39241560.0
2020-09-09	META	Stock	275.77	278.48	271.35	273.72	22918800.0
2020-09-09	TSLA	Stock	118.8667	123.0	113.8367	122.0933	238397400.0
2020-09-09	TLT	Stock	163.94	164.25	162.7582	163.3	9559005.0
2020-09-09	ES	Stock	85.85	87.96	85.6	85.79	1144400.0
2020-09-09	CL	Stock	76.46	78.36	76.46	77.57	3128600.0
2020-09-09	A	Stock	96.1	98.47	95.86	97.93	954400.0
2020-09-09	AA	Stock	14.32	14.4	14.05	14.1	3084100.0
2020-09-09	AACG	Stock	1.11	1.14	1.07	1.09	9900.0
2020-09-09	AACQ-DELISTED	Stock	10.0	10.01	9.91	9.99	1775622.0
2020-09-09	AACQU-DELISTED	Stock	10.39	10.47	10.33	10.43	249344.0
2020-09-09	AACQW-DELISTED	Stock	1.98	1.98	1.5	1.6	220561.0
2020-09-09	AAIC-DELISTED	Stock	2.7	2.72	2.67	2.69	287694.0
2020-09-09	AAIC.C-DELISTED	Stock	19.32	19.43	19.16	19.35	2956.0
2020-09-09	AAL	Stock	13.48	13.58	12.8	13.05	79030200.0
2020-09-09	AAM.A-DELISTED	Stock	26.2	26.5	26.2	26.5	3267.0
2020-09-09	AAM.B-DELISTED	Stock	26.8255	27.19	26.8	27.19	7360.0
2020-09-09	AAMC-DELISTED	Stock	6.1794	6.8382	6.1794	6.4118	94183.0
2020-09-09	AAME	Stock	2.1	2.1	1.96	1.96	2500.0
2020-09-09	AAMI	Stock	13.06	13.17	12.925	13.1	270600.0
2020-09-09	AAOI	Stock	10.11	10.38	9.91	10.24	594900.0
2020-09-09	AAON	Stock	37.24	37.6733	37.0133	37.0933	235800.0
2020-09-09	AAP	Stock	152.62	155.68	152.62	154.35	715900.0
2020-09-09	AAT	Stock	25.8	26.12	25.24	25.3	222800.0
2020-09-09	AAU-DELISTED	Stock	0.67	0.7	0.6602	0.686	328846.0
2020-09-09	AAUAF-DELISTED	Stock	0.67	0.7	0.6602	0.6882	356615.0
2020-09-09	AAWW-DELISTED	Stock	53.95	56.33	53.95	55.58	411430.0
2020-09-09	AAXJ	Stock	76.6	77.11	76.43	76.98	938666.0
2020-09-09	AAXN-DELISTED	Stock	82.25	85.58	82.195	85.17	2462308.0
2020-09-09	AB	Stock	27.39	27.39	26.87	27.18	418900.0
2020-09-09	ABB-DELISTED	Stock	26.2	26.475	26.18	26.39	2226315.0
2020-09-09	ABBNY-DELISTED	Stock	26.2	26.475	26.18	26.39	2639187.0
2020-09-09	ABBV	Stock	90.86	92.43	90.51	91.63	5373500.0
2020-09-09	ABC-DELISTED	Stock	95.83	96.85	94.82	96.19	581791.0
2020-09-09	ABCB	Stock	24.63	25.09	23.69	23.83	295400.0
2020-09-09	ABEO	Stock	52.5	54.75	50.75	50.75	23796.0
2020-09-09	ABEV	Stock	2.36	2.36	2.31	2.33	17794000.0
2020-09-09	ABG	Stock	108.43	111.64	105.42	110.82	220600.0
2020-09-09	ABM	Stock	37.78	39.5	36.97	38.53	718500.0
2020-09-09	ABMD-DELISTED	Stock	273.37	279.69	272.9627	277.93	191014.0
2020-09-09	ABR	Stock	11.41	11.74	11.41	11.65	997800.0
2020-09-09	ABR.A-DELISTED	Stock	25.2871	25.2871	25.05	25.1002	1369.0
2020-09-09	ABR.B-DELISTED	Stock	25.05	25.05	25.05	25.05	100.0
2020-09-09	ABR.C-DELISTED	Stock	25.31	25.4	25.19	25.3685	3012.0
2020-09-09	ABT	Stock	104.26	106.93	104.13	105.81	4365100.0
2020-09-09	ABTC	Stock	139800.0	142500.0	138900.0	140700.0	2.0666666666666664

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

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