PREVIEW / stock_daily / 2020-12-31

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-31.parquet
  size:    240 KB
  rows:    7,269
  symbols: 2,641

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-12-31	AAPL	Stock	134.08	134.74	131.72	132.69	99116600.0
2020-12-31	MSFT	Stock	221.7	223.0	219.68	222.42	20942100.0
2020-12-31	NVDA	Stock	13.1365	13.151	12.915	13.055	192424000.0
2020-12-31	AMZN	Stock	163.75	164.146	162.06	162.8465	59144000.0
2020-12-31	GOOGL	Stock	86.8635	87.875	86.8045	87.632	21069580.0
2020-12-31	META	Stock	272.0	277.09	269.81	273.16	12900400.0
2020-12-31	TSLA	Stock	233.33	239.5733	230.3733	235.2233	148949700.0
2020-12-31	TLT	Stock	157.46	158.08	157.45	157.73	7742413.0
2020-12-31	ES	Stock	85.48	86.61	84.99	86.51	1117000.0
2020-12-31	CL	Stock	84.96	85.6	84.53	85.51	1893100.0
2020-12-31	A	Stock	117.59	118.6	116.6	118.49	1307200.0
2020-12-31	AA	Stock	23.0	23.43	22.4	23.05	3443600.0
2020-12-31	AACG	Stock	1.2	1.21	1.18	1.19	32200.0
2020-12-31	AACQ-DELISTED	Stock	10.45	10.655	10.44	10.63	1027961.0
2020-12-31	AACQU-DELISTED	Stock	11.2	11.3893	11.1614	11.34	65292.0
2020-12-31	AACQW-DELISTED	Stock	2.31	2.33	2.05	2.2	335382.0
2020-12-31	AAIC-DELISTED	Stock	3.79	3.87	3.74	3.81	191504.0
2020-12-31	AAIC.C-DELISTED	Stock	20.75	21.0	20.575	21.0	3093.0
2020-12-31	AAL	Stock	16.08	16.09	15.63	15.77	57891100.0
2020-12-31	AAM.A-DELISTED	Stock	26.75	27.02	26.46	27.02	52209.0
2020-12-31	AAM.B-DELISTED	Stock	27.49	27.49	27.2	27.28	40408.0
2020-12-31	AAMC-DELISTED	Stock	7.0426	7.0426	6.8971	6.9353	4342.0
2020-12-31	AAME	Stock	2.1	2.14	2.05	2.06	7800.0
2020-12-31	AAMI	Stock	19.25	19.77	19.03	19.28	769000.0
2020-12-31	AAN-DELISTED	Stock	18.07	19.38	17.92	18.96	541700.0
2020-12-31	AAOI	Stock	8.6	8.696	8.455	8.51	638400.0
2020-12-31	AAON	Stock	44.4533	44.5267	43.5867	44.42	259350.0
2020-12-31	AAP	Stock	157.07	157.67	155.52	157.51	621000.0
2020-12-31	AAT	Stock	28.17	28.93	28.09	28.88	129900.0
2020-12-31	AAU-DELISTED	Stock	0.465	0.48	0.46	0.4688	1211979.0
2020-12-31	AAUAF-DELISTED	Stock	0.465	0.48	0.46	0.4691	1242992.0
2020-12-31	AAWW-DELISTED	Stock	54.4	54.89	53.57	54.6	275612.0
2020-12-31	AAXJ	Stock	90.11	90.12	89.11	89.61	950680.0
2020-12-31	AAXN-DELISTED	Stock	123.88	123.88	121.3	122.53	278976.0
2020-12-31	AB	Stock	33.33	33.84	33.05	33.77	265500.0
2020-12-31	ABB-DELISTED	Stock	27.99	28.0457	27.87	27.96	508843.0
2020-12-31	ABBNY-DELISTED	Stock	27.99	28.0457	27.87	27.96	568847.0
2020-12-31	ABBV	Stock	105.26	107.28	104.85	107.15	6148100.0
2020-12-31	ABC-DELISTED	Stock	96.75	97.9731	96.08	97.72	394073.0
2020-12-31	ABCB	Stock	37.97	38.29	37.55	38.07	260800.0
2020-12-31	ABCL	Stock	41.45	41.5	38.6	40.24	1201000.0
2020-12-31	ABCM-DELISTED	Stock	22.03	22.03	20.7	21.5	222019.0
2020-12-31	ABEO	Stock	40.0	40.25	38.75	39.25	41444.0
2020-12-31	ABEV	Stock	3.05	3.07	3.02	3.06	3904200.0
2020-12-31	ABG	Stock	145.14	147.26	141.65	145.74	114100.0
2020-12-31	ABM	Stock	37.63	38.07	37.45	37.84	255000.0
2020-12-31	ABMD-DELISTED	Stock	324.38	325.27	318.565	324.3	152662.0
2020-12-31	ABNB	Stock	146.9	147.89	144.51	146.8	2795800.0
2020-12-31	ABR	Stock	14.11	14.24	13.88	14.18	922200.0
2020-12-31	ABR.A-DELISTED	Stock	25.64	25.66	25.47	25.555	2719.0

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

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