PREVIEW / stock_daily / 2020-11-13

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-13.parquet
  size:    231 KB
  rows:    7,006
  symbols: 2,492

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-13	AAPL	Stock	119.44	119.67	117.87	119.26	81581900.0
2020-11-13	MSFT	Stock	216.36	217.42	214.16	216.51	18621100.0
2020-11-13	NVDA	Stock	13.6273	13.6688	13.0592	13.297	346312000.0
2020-11-13	AMZN	Stock	156.1	157.086	154.2695	156.4405	75124000.0
2020-11-13	GOOGL	Stock	87.4	88.8565	86.799	88.613	29757540.0
2020-11-13	META	Stock	277.72	277.76	273.1	276.95	10391200.0
2020-11-13	TSLA	Stock	136.95	137.51	133.8867	136.1667	59313300.0
2020-11-13	TLT	Stock	158.36	158.5	157.91	158.16	7345549.0
2020-11-13	ES	Stock	92.86	93.96	92.47	93.29	854200.0
2020-11-13	CL	Stock	84.78	85.41	84.69	85.36	3742400.0
2020-11-13	A	Stock	110.46	111.54	109.78	110.17	1356800.0
2020-11-13	AA	Stock	15.92	16.63	15.86	16.57	5056300.0
2020-11-13	AACG	Stock	1.15	1.17	1.1	1.13	67400.0
2020-11-13	AACQ-DELISTED	Stock	9.75	9.83	9.75	9.78	150825.0
2020-11-13	AACQU-DELISTED	Stock	10.15	10.155	10.105	10.13	50204.0
2020-11-13	AACQW-DELISTED	Stock	1.15	1.2	1.08	1.2	69270.0
2020-11-13	AAIC-DELISTED	Stock	2.82	2.9	2.81	2.86	135816.0
2020-11-13	AAIC.C-DELISTED	Stock	19.4	19.52	19.4	19.51	2900.0
2020-11-13	AAL	Stock	11.91	12.25	11.85	12.24	56421500.0
2020-11-13	AAM.A-DELISTED	Stock	26.37	26.4	26.35	26.37	18564.0
2020-11-13	AAM.B-DELISTED	Stock	27.05	27.21	27.05	27.14	10087.0
2020-11-13	AAME	Stock	2.02	2.2	2.0	2.2	4600.0
2020-11-13	AAMI	Stock	17.5	17.98	17.43	17.67	431400.0
2020-11-13	AAOI	Stock	7.67	7.724	7.38	7.59	708900.0
2020-11-13	AAON	Stock	42.2467	43.6533	42.2467	43.3933	231900.0
2020-11-13	AAP	Stock	152.99	154.84	152.13	154.0	1073800.0
2020-11-13	AAT	Stock	25.4	26.74	25.35	26.6	532100.0
2020-11-13	AAU-DELISTED	Stock	1.09	1.11	1.05	1.1073	384379.0
2020-11-13	AAUAF-DELISTED	Stock	1.09	1.11	1.05	1.11	396965.0
2020-11-13	AAWW-DELISTED	Stock	52.9	55.3	52.9	54.68	416792.0
2020-11-13	AAXJ	Stock	84.41	84.5	83.87	84.33	774918.0
2020-11-13	AAXN-DELISTED	Stock	119.05	121.2	117.36	120.94	295469.0
2020-11-13	AB	Stock	31.5	31.83	31.41	31.64	311800.0
2020-11-13	ABB-DELISTED	Stock	26.84	27.0	26.825	27.0	1148842.0
2020-11-13	ABBNY-DELISTED	Stock	26.84	27.0	26.825	27.0	1230322.0
2020-11-13	ABBV	Stock	97.41	99.55	97.4	99.04	6888600.0
2020-11-13	ABC-DELISTED	Stock	106.28	109.03	106.28	108.12	523117.0
2020-11-13	ABCB	Stock	32.89	33.81	31.81	33.51	337600.0
2020-11-13	ABCM-DELISTED	Stock	18.57	18.84	18.51	18.68	118012.0
2020-11-13	ABEO	Stock	30.25	32.0	30.0	32.0	63280.0
2020-11-13	ABEV	Stock	2.69	2.8	2.68	2.8	26701200.0
2020-11-13	ABG	Stock	118.53	121.5	118.39	119.96	88300.0
2020-11-13	ABM	Stock	37.92	38.66	37.68	38.49	226100.0
2020-11-13	ABMD-DELISTED	Stock	271.12	273.68	270.0	272.29	79023.0
2020-11-13	ABR	Stock	12.75	12.9	12.63	12.67	1899100.0
2020-11-13	ABR.A-DELISTED	Stock	25.3	25.32	25.19	25.25	18633.0
2020-11-13	ABR.B-DELISTED	Stock	25.32	25.32	25.32	25.32	800.0
2020-11-13	ABR.C-DELISTED	Stock	25.85	26.03	25.61	25.8	15435.0
2020-11-13	ABST-DELISTED	Stock	10.5	10.71	10.31	10.37	66343.0
2020-11-13	ABT	Stock	113.0	113.09	111.42	112.6	3918900.0

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

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