PREVIEW / stock_daily / 2020-11-03

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-03.parquet
  size:    230 KB
  rows:    6,999
  symbols: 2,490

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-11-03	AAPL	Stock	109.66	111.49	108.73	110.44	107624400.0
2020-11-03	MSFT	Stock	203.89	208.12	203.12	206.43	27512000.0
2020-11-03	NVDA	Stock	12.7085	13.105	12.6028	13.0195	272900000.0
2020-11-03	AMZN	Stock	150.9265	153.745	149.049	152.4205	97958000.0
2020-11-03	GOOGL	Stock	81.538	82.95	80.6054	82.283	31432820.0
2020-11-03	META	Stock	263.16	270.05	260.88	265.3	17961900.0
2020-11-03	TSLA	Stock	136.5767	142.59	135.5633	141.3	103055100.0
2020-11-03	TLT	Stock	157.85	157.98	157.04	157.66	16228695.0
2020-11-03	ES	Stock	91.32	92.66	90.9	91.98	1389500.0
2020-11-03	CL	Stock	80.88	83.42	80.83	83.11	5327800.0
2020-11-03	A	Stock	106.43	108.11	106.14	107.03	1175000.0
2020-11-03	AA	Stock	13.94	14.13	13.69	13.83	4717100.0
2020-11-03	AACG	Stock	1.12	1.17	1.12	1.13	56500.0
2020-11-03	AACQ-DELISTED	Stock	9.61	9.76	9.6	9.71	721013.0
2020-11-03	AACQU-DELISTED	Stock	10.0	10.15	10.0	10.0332	115446.0
2020-11-03	AACQW-DELISTED	Stock	1.2	1.27	1.1	1.1	37366.0
2020-11-03	AAIC-DELISTED	Stock	2.63	2.71	2.61	2.67	224561.0
2020-11-03	AAIC.C-DELISTED	Stock	18.85	18.95	18.85	18.95	11254.0
2020-11-03	AAL	Stock	11.34	11.45	11.15	11.25	43775200.0
2020-11-03	AAM.A-DELISTED	Stock	25.99	26.09	25.91	25.91	30449.0
2020-11-03	AAM.B-DELISTED	Stock	26.8	26.8	26.53	26.53	6943.0
2020-11-03	AAMC-DELISTED	Stock	7.0588	7.0588	6.6971	6.7647	7857.0
2020-11-03	AAME	Stock	2.15	2.15	2.05	2.05	500.0
2020-11-03	AAMI	Stock	14.07	14.42	14.01	14.11	601200.0
2020-11-03	AAOI	Stock	8.8	9.36	8.63	9.14	583600.0
2020-11-03	AAON	Stock	40.1933	40.74	39.7667	40.4133	233250.0
2020-11-03	AAP	Stock	153.48	158.12	152.68	157.43	847600.0
2020-11-03	AAT	Stock	21.64	22.13	21.54	21.97	442200.0
2020-11-03	AAU-DELISTED	Stock	1.15	1.16	1.05	1.07	806584.0
2020-11-03	AAUAF-DELISTED	Stock	1.15	1.16	1.05	1.05	843925.0
2020-11-03	AAWW-DELISTED	Stock	62.79	63.04	61.87	62.03	323181.0
2020-11-03	AAXJ	Stock	79.7	80.199	79.36	79.92	896925.0
2020-11-03	AAXN-DELISTED	Stock	97.92	101.98	97.72	101.72	277024.0
2020-11-03	AB	Stock	29.49	30.13	29.29	29.87	472200.0
2020-11-03	ABB-DELISTED	Stock	25.3	25.59	25.24	25.47	1260583.0
2020-11-03	ABBNY-DELISTED	Stock	25.3	25.59	25.24	25.45	1336548.0
2020-11-03	ABBV	Stock	89.14	89.39	87.43	87.96	8518800.0
2020-11-03	ABC-DELISTED	Stock	100.14	102.9899	100.14	102.07	949762.0
2020-11-03	ABCB	Stock	30.59	31.14	30.12	30.95	348800.0
2020-11-03	ABCM-DELISTED	Stock	19.65	20.11	19.29	20.01	268610.0
2020-11-03	ABEO	Stock	25.75	26.75	24.75	26.25	193696.0
2020-11-03	ABEV	Stock	2.23	2.28	2.22	2.25	33984900.0
2020-11-03	ABG	Stock	111.65	115.76	111.64	114.73	156300.0
2020-11-03	ABM	Stock	36.19	36.67	35.96	36.47	338500.0
2020-11-03	ABMD-DELISTED	Stock	259.4	261.865	253.585	260.8	225951.0
2020-11-03	ABR	Stock	12.9	13.1	12.4	12.61	1625600.0
2020-11-03	ABR.A-DELISTED	Stock	25.5586	25.7	25.5	25.7	1800.0
2020-11-03	ABR.B-DELISTED	Stock	25.48	25.52	25.48	25.52	200.0
2020-11-03	ABR.C-DELISTED	Stock	25.95	25.97	25.83	25.87	4358.0
2020-11-03	ABST-DELISTED	Stock	11.6	11.705	11.1	11.13	105520.0

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

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