PREVIEW / stock_daily / 2020-12-17

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-17.parquet
  size:    240 KB
  rows:    7,259
  symbols: 2,646

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-17	AAPL	Stock	128.9	129.58	128.04	128.7	94359800.0
2020-12-17	MSFT	Stock	219.87	220.89	217.92	219.42	32515800.0
2020-12-17	NVDA	Stock	13.3668	13.3795	13.1785	13.3412	231384000.0
2020-12-17	AMZN	Stock	162.5	163.1755	161.05	161.804	69486000.0
2020-12-17	GOOGL	Stock	88.1965	88.3355	86.5575	87.0255	34880100.0
2020-12-17	META	Stock	277.07	280.44	273.61	274.48	16377800.0
2020-12-17	TSLA	Stock	209.3967	219.6067	206.5	218.6333	168810300.0
2020-12-17	TLT	Stock	158.13	158.46	156.43	156.8	9422697.0
2020-12-17	ES	Stock	86.01	86.63	85.48	85.78	1824700.0
2020-12-17	CL	Stock	85.5	86.05	85.34	85.66	3086500.0
2020-12-17	A	Stock	118.05	119.39	117.04	118.97	2166700.0
2020-12-17	AA	Stock	22.28	23.21	21.74	22.18	7318400.0
2020-12-17	AACG	Stock	1.2	1.2	1.16	1.18	6000.0
2020-12-17	AACQ-DELISTED	Stock	10.3	10.36	10.27	10.35	576063.0
2020-12-17	AACQU-DELISTED	Stock	10.86	10.93	10.82	10.88	296900.0
2020-12-17	AACQW-DELISTED	Stock	1.76	1.8999	1.6302	1.65	208980.0
2020-12-17	AAIC-DELISTED	Stock	3.7	3.74	3.6	3.73	165777.0
2020-12-17	AAIC.C-DELISTED	Stock	21.13	21.13	20.95	21.1	4065.0
2020-12-17	AAL	Stock	16.95	16.99	16.65	16.8	49386300.0
2020-12-17	AAM.A-DELISTED	Stock	26.35	26.4365	26.3208	26.37	10588.0
2020-12-17	AAM.B-DELISTED	Stock	27.19	27.19	27.04	27.12	18824.0
2020-12-17	AAME	Stock	2.25	2.33	2.17	2.23	9800.0
2020-12-17	AAMI	Stock	18.83	18.95	18.48	18.74	811400.0
2020-12-17	AAN-DELISTED	Stock	17.88	18.82	17.53	18.75	670900.0
2020-12-17	AAOI	Stock	8.4	8.66	8.31	8.5	673100.0
2020-12-17	AAON	Stock	42.02	43.2933	42.02	43.2267	263550.0
2020-12-17	AAP	Stock	162.05	163.7	160.0	160.34	1347800.0
2020-12-17	AAT	Stock	29.41	29.68	29.09	29.57	320200.0
2020-12-17	AAU-DELISTED	Stock	0.74	0.792	0.7293	0.7874	1044117.0
2020-12-17	AAUAF-DELISTED	Stock	0.74	0.792	0.7293	0.7908	1086672.0
2020-12-17	AAWW-DELISTED	Stock	55.72	56.265	54.6	55.99	213844.0
2020-12-17	AAXJ	Stock	88.0	88.07	87.73	88.07	976066.0
2020-12-17	AAXN-DELISTED	Stock	119.81	122.81	118.53	120.76	422447.0
2020-12-17	AB	Stock	33.08	33.78	33.05	33.67	392800.0
2020-12-17	ABB-DELISTED	Stock	27.37	27.44	27.2501	27.34	732719.0
2020-12-17	ABBNY-DELISTED	Stock	27.37	27.44	27.2501	27.34	791307.0
2020-12-17	ABBV	Stock	104.86	105.5	104.11	104.89	6360600.0
2020-12-17	ABC-DELISTED	Stock	98.91	99.09	97.46	98.76	734812.0
2020-12-17	ABCB	Stock	38.59	38.81	37.91	38.59	295600.0
2020-12-17	ABCL	Stock	48.54	50.5	48.14	48.6	636300.0
2020-12-17	ABCM-DELISTED	Stock	19.68	20.19	19.6	19.895	69557.0
2020-12-17	ABEO	Stock	41.0	41.25	38.75	40.0	75516.0
2020-12-17	ABEV	Stock	3.17	3.2	3.16	3.19	17048700.0
2020-12-17	ABG	Stock	144.61	147.77	142.86	147.65	270800.0
2020-12-17	ABM	Stock	38.8	40.96	38.0	40.61	827000.0
2020-12-17	ABMD-DELISTED	Stock	275.86	282.31	272.43	281.76	157695.0
2020-12-17	ABNB	Stock	143.0	152.45	142.67	147.05	15054700.0
2020-12-17	ABR	Stock	14.5	14.74	14.4	14.73	1059300.0
2020-12-17	ABR.A-DELISTED	Stock	25.4298	25.43	25.3951	25.43	1718.0
2020-12-17	ABR.B-DELISTED	Stock	25.345	25.355	25.32	25.3357	3000.0

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

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