PREVIEW / stock_daily / 2020-12-15

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-15.parquet
  size:    239 KB
  rows:    7,242
  symbols: 2,644

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-15	AAPL	Stock	124.34	127.9	124.13	127.88	157243700.0
2020-12-15	MSFT	Stock	215.17	215.42	212.24	214.13	27000600.0
2020-12-15	NVDA	Stock	13.4398	13.464	13.1868	13.3605	193016000.0
2020-12-15	AMZN	Stock	159.0505	159.425	156.5245	158.256	66390000.0
2020-12-15	GOOGL	Stock	87.993	88.2	87.0835	88.054	21365840.0
2020-12-15	META	Stock	274.83	276.08	267.47	275.55	23979500.0
2020-12-15	TSLA	Stock	214.4267	215.6333	207.9333	211.0833	135214500.0
2020-12-15	TLT	Stock	157.78	158.39	157.31	157.8	6847676.0
2020-12-15	ES	Stock	85.69	87.09	85.2	86.63	1292800.0
2020-12-15	CL	Stock	84.51	85.07	84.21	84.75	2555800.0
2020-12-15	A	Stock	117.3	118.04	116.85	117.39	1973800.0
2020-12-15	AA	Stock	22.115	22.6	21.758	22.17	4226500.0
2020-12-15	AACG	Stock	1.18	1.2	1.16	1.2	6000.0
2020-12-15	AACQ-DELISTED	Stock	10.4	10.4	10.26	10.26	716386.0
2020-12-15	AACQU-DELISTED	Stock	11.0322	11.07	10.8	10.8	70535.0
2020-12-15	AACQW-DELISTED	Stock	2.1	2.139	1.7	1.75	526930.0
2020-12-15	AAIC-DELISTED	Stock	3.59	3.7	3.5	3.69	108674.0
2020-12-15	AAIC.C-DELISTED	Stock	21.0001	21.188	20.87	20.9	8330.0
2020-12-15	AAL	Stock	16.99	17.06	16.16	17.01	88795200.0
2020-12-15	AAM.A-DELISTED	Stock	26.42	26.47	26.365	26.365	14944.0
2020-12-15	AAM.B-DELISTED	Stock	27.18	27.193	27.0932	27.13	13129.0
2020-12-15	AAMC-DELISTED	Stock	6.6088	6.7587	6.6088	6.7587	5977.0
2020-12-15	AAME	Stock	2.27	2.33	2.21	2.24	5700.0
2020-12-15	AAMI	Stock	18.57	18.78	18.405	18.68	559100.0
2020-12-15	AAN-DELISTED	Stock	18.01	18.27	17.44	17.99	964100.0
2020-12-15	AAOI	Stock	8.26	8.52	8.2	8.41	1128700.0
2020-12-15	AAON	Stock	41.8733	42.38	41.42	42.1533	213750.0
2020-12-15	AAP	Stock	157.9	159.94	156.11	159.84	1050400.0
2020-12-15	AAT	Stock	28.9	29.73	28.66	29.71	271100.0
2020-12-15	AAU-DELISTED	Stock	0.675	0.6969	0.675	0.6925	415459.0
2020-12-15	AAUAF-DELISTED	Stock	0.675	0.6969	0.675	0.6924	426033.0
2020-12-15	AAWW-DELISTED	Stock	54.89	56.5999	54.66	56.27	547539.0
2020-12-15	AAXJ	Stock	86.82	87.24	86.51	87.23	511785.0
2020-12-15	AAXN-DELISTED	Stock	129.13	129.36	126.71	128.63	333585.0
2020-12-15	AB	Stock	32.35	32.6	32.0	32.46	312600.0
2020-12-15	ABB-DELISTED	Stock	26.93	27.32	26.85	27.28	1167262.0
2020-12-15	ABBNY-DELISTED	Stock	26.92	27.32	26.85	27.28	1248683.0
2020-12-15	ABBV	Stock	105.44	105.45	102.32	102.82	12101000.0
2020-12-15	ABC-DELISTED	Stock	97.56	99.34	97.56	99.04	656418.0
2020-12-15	ABCB	Stock	38.16	39.53	38.0	39.2	443800.0
2020-12-15	ABCL	Stock	50.81	52.21	45.26	46.99	3958000.0
2020-12-15	ABCM-DELISTED	Stock	19.55	19.99	19.36	19.495	200340.0
2020-12-15	ABEO	Stock	38.75	41.75	38.0	40.0	98052.0
2020-12-15	ABEV	Stock	3.05	3.12	3.04	3.1	14108000.0
2020-12-15	ABG	Stock	141.3	143.56	140.96	143.19	190100.0
2020-12-15	ABM	Stock	40.03	41.27	39.86	41.1	412400.0
2020-12-15	ABMD-DELISTED	Stock	266.56	277.45	262.91	275.6	155742.0
2020-12-15	ABNB	Stock	126.69	127.6	121.5	124.8	10914400.0
2020-12-15	ABR	Stock	14.3	14.4	14.21	14.38	1150900.0
2020-12-15	ABR.A-DELISTED	Stock	25.3683	25.3683	25.28	25.28	7274.0

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

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