PREVIEW / stock_daily / 2020-11-30

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-30.parquet
  size:    236 KB
  rows:    7,150
  symbols: 2,585

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-30	AAPL	Stock	116.97	120.97	116.81	119.05	169410200.0
2020-11-30	MSFT	Stock	214.1	214.76	210.84	214.07	33064800.0
2020-11-30	NVDA	Stock	13.265	13.4125	12.9722	13.4015	286952000.0
2020-11-30	AMZN	Stock	160.424	161.4195	156.2775	158.402	81278000.0
2020-11-30	GOOGL	Stock	88.7825	89.0168	87.392	87.72	32417740.0
2020-11-30	META	Stock	276.03	277.7	271.01	276.97	16693300.0
2020-11-30	TSLA	Stock	200.7367	202.6	184.8367	189.2	189009300.0
2020-11-30	TLT	Stock	160.03	160.53	159.76	160.02	13071557.0
2020-11-30	ES	Stock	87.86	88.4	86.54	87.51	2331300.0
2020-11-30	CL	Stock	84.99	85.66	84.2	85.64	4355900.0
2020-11-30	A	Stock	113.89	117.07	113.67	116.9	3778400.0
2020-11-30	AA	Stock	20.32	20.45	19.65	19.9	4427600.0
2020-11-30	AACG	Stock	1.24	1.24	1.2	1.22	30500.0
2020-11-30	AACQ-DELISTED	Stock	10.0	10.02	9.91	9.945	346820.0
2020-11-30	AACQU-DELISTED	Stock	10.4	10.57	10.4	10.529	144759.0
2020-11-30	AACQW-DELISTED	Stock	1.33	1.5	1.31	1.42	327229.0
2020-11-30	AAIC-DELISTED	Stock	3.31	3.32	3.19	3.2	582933.0
2020-11-30	AAIC.C-DELISTED	Stock	21.09	21.5	20.9975	21.26	5000.0
2020-11-30	AAL	Stock	14.92	14.96	13.93	14.13	97536300.0
2020-11-30	AAM.A-DELISTED	Stock	26.09	26.2	26.0756	26.1	14962.0
2020-11-30	AAM.B-DELISTED	Stock	27.3	27.3	26.92	26.92	21933.0
2020-11-30	AAMC-DELISTED	Stock	6.7059	6.7941	6.5676	6.7794	18255.0
2020-11-30	AAME	Stock	2.05	2.16	2.05	2.14	5800.0
2020-11-30	AAMI	Stock	18.18	18.31	17.65	17.7	882400.0
2020-11-30	AAOI	Stock	8.18	8.385	8.14	8.31	587400.0
2020-11-30	AAON	Stock	43.6867	43.8333	42.7667	43.42	339450.0
2020-11-30	AAP	Stock	149.33	150.31	147.37	147.7	1521500.0
2020-11-30	AAT	Stock	29.96	30.14	28.69	28.69	452500.0
2020-11-30	AAU-DELISTED	Stock	1.13	1.13	1.0	1.015	396340.0
2020-11-30	AAUAF-DELISTED	Stock	1.13	1.13	1.0	1.02	494759.0
2020-11-30	AAWW-DELISTED	Stock	56.24	56.78	55.01	55.81	298588.0
2020-11-30	AAXJ	Stock	85.8	85.93	84.87	84.96	1177270.0
2020-11-30	AAXN-DELISTED	Stock	126.89	127.385	123.3612	125.69	255076.0
2020-11-30	AB	Stock	32.38	32.49	31.75	31.87	252000.0
2020-11-30	ABB-DELISTED	Stock	26.74	26.78	26.305	26.34	1406822.0
2020-11-30	ABBNY-DELISTED	Stock	26.74	26.78	26.305	26.34	1499614.0
2020-11-30	ABBV	Stock	105.12	105.42	103.65	104.58	20726500.0
2020-11-30	ABC-DELISTED	Stock	103.72	104.515	102.47	103.12	863663.0
2020-11-30	ABCB	Stock	35.09	35.25	33.86	34.01	600600.0
2020-11-30	ABCM-DELISTED	Stock	19.1	19.38	19.0469	19.12	123371.0
2020-11-30	ABEO	Stock	44.0	44.75	38.0	40.5	156836.0
2020-11-30	ABEV	Stock	2.71	2.72	2.63	2.66	18078300.0
2020-11-30	ABG	Stock	117.94	117.94	112.77	112.77	200800.0
2020-11-30	ABM	Stock	39.63	39.65	38.42	38.5	252600.0
2020-11-30	ABMD-DELISTED	Stock	273.72	274.91	269.01	274.11	268142.0
2020-11-30	ABR	Stock	13.69	13.69	13.17	13.32	1656000.0
2020-11-30	ABR.A-DELISTED	Stock	25.59	25.59	25.33	25.455	3798.0
2020-11-30	ABR.B-DELISTED	Stock	25.5	25.5707	25.25	25.25	3715.0
2020-11-30	ABR.C-DELISTED	Stock	25.5945	25.79	25.5731	25.79	1487.0
2020-11-30	ABST-DELISTED	Stock	10.2	10.38	10.18	10.35	208754.0

> showing 50 of 7,150 rows — these rows as CSV

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