PREVIEW / stock_daily / 2020-12-16

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-16.parquet
  size:    240 KB
  rows:    7,247
  symbols: 2,639

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-16	AAPL	Stock	127.41	128.37	126.56	127.81	98208600.0
2020-12-16	MSFT	Stock	214.75	220.11	214.72	219.28	35023300.0
2020-12-16	NVDA	Stock	13.4225	13.4372	13.2125	13.2425	223116000.0
2020-12-16	AMZN	Stock	158.8005	162.35	158.184	162.048	88552000.0
2020-12-16	GOOGL	Stock	88.4555	88.4555	87.453	87.8595	24676720.0
2020-12-16	META	Stock	274.76	277.86	272.51	275.67	15885000.0
2020-12-16	TSLA	Stock	209.41	210.8333	201.6667	207.59	126287400.0
2020-12-16	TLT	Stock	156.58	157.89	156.39	157.38	9954190.0
2020-12-16	ES	Stock	87.03	87.79	85.3	85.45	1872200.0
2020-12-16	CL	Stock	85.14	85.76	84.64	85.04	2862000.0
2020-12-16	A	Stock	117.58	117.74	116.4	117.24	1698600.0
2020-12-16	AA	Stock	22.06	22.13	21.304	21.58	5423800.0
2020-12-16	AACG	Stock	1.16	1.2	1.16	1.2	44400.0
2020-12-16	AACQ-DELISTED	Stock	10.22	10.35	10.22	10.3	634190.0
2020-12-16	AACQU-DELISTED	Stock	10.8	10.89	10.8	10.89	102453.0
2020-12-16	AACQW-DELISTED	Stock	1.76	1.8002	1.7	1.71	190978.0
2020-12-16	AAIC-DELISTED	Stock	3.71	3.7218	3.63	3.7	257272.0
2020-12-16	AAIC.C-DELISTED	Stock	21.15	21.15	21.0	21.023	1310.0
2020-12-16	AAL	Stock	16.88	17.04	16.58	16.86	59232600.0
2020-12-16	AAM.A-DELISTED	Stock	26.36	26.456	26.34	26.36	18299.0
2020-12-16	AAM.B-DELISTED	Stock	27.2	27.2	27.0606	27.14	13927.0
2020-12-16	AAME	Stock	2.2	2.33	2.2	2.29	8600.0
2020-12-16	AAMI	Stock	18.8	18.86	18.4	18.67	274400.0
2020-12-16	AAN-DELISTED	Stock	18.0	18.4	17.9	18.03	542400.0
2020-12-16	AAOI	Stock	8.49	8.51	8.25	8.32	453800.0
2020-12-16	AAON	Stock	42.4	42.6067	41.6333	41.92	180900.0
2020-12-16	AAP	Stock	159.95	161.93	158.31	161.32	1242600.0
2020-12-16	AAT	Stock	29.71	29.88	29.09	29.32	228400.0
2020-12-16	AAU-DELISTED	Stock	0.6992	0.724	0.695	0.7163	650744.0
2020-12-16	AAUAF-DELISTED	Stock	0.6992	0.724	0.695	0.7176	667927.0
2020-12-16	AAWW-DELISTED	Stock	56.49	57.3787	55.5	55.53	243253.0
2020-12-16	AAXJ	Stock	87.55	87.75	87.35	87.51	1073403.0
2020-12-16	AAXN-DELISTED	Stock	127.0	127.9	119.05	119.99	565163.0
2020-12-16	AB	Stock	32.64	33.31	32.51	33.08	562100.0
2020-12-16	ABB-DELISTED	Stock	26.97	27.135	26.84	27.045	958200.0
2020-12-16	ABBNY-DELISTED	Stock	26.97	27.135	26.84	27.05	1036614.0
2020-12-16	ABBV	Stock	102.5	105.41	101.9	104.64	9182100.0
2020-12-16	ABC-DELISTED	Stock	99.11	99.11	98.01	98.37	548154.0
2020-12-16	ABCB	Stock	39.2	39.44	38.49	38.54	394900.0
2020-12-16	ABCL	Stock	47.13	49.73	42.15	47.53	1688700.0
2020-12-16	ABCM-DELISTED	Stock	19.65	19.9	19.47	19.74	65058.0
2020-12-16	ABEO	Stock	41.0	42.25	39.5	40.75	96328.0
2020-12-16	ABEV	Stock	3.08	3.16	3.06	3.16	20753100.0
2020-12-16	ABG	Stock	142.54	145.0	142.06	144.78	246800.0
2020-12-16	ABM	Stock	41.11	41.19	40.14	40.34	354000.0
2020-12-16	ABMD-DELISTED	Stock	274.15	282.0	273.5	273.81	180066.0
2020-12-16	ABNB	Stock	125.83	142.0	124.91	137.99	20409600.0
2020-12-16	ABR	Stock	14.38	14.54	14.19	14.41	961900.0
2020-12-16	ABR.A-DELISTED	Stock	25.24	25.43	25.24	25.4299	5937.0
2020-12-16	ABR.B-DELISTED	Stock	25.2984	25.33	25.225	25.33	6823.0

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

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