PREVIEW / stock_daily / 2020-12-24

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-24.parquet
  size:    235 KB
  rows:    7,217
  symbols: 2,617

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-24	AAPL	Stock	131.32	133.46	131.1	131.97	54930100.0
2020-12-24	MSFT	Stock	221.42	223.61	221.2	222.75	10550600.0
2020-12-24	NVDA	Stock	13.0372	13.1325	12.9387	12.9938	97884000.0
2020-12-24	AMZN	Stock	159.695	160.1	158.45	158.6345	29038000.0
2020-12-24	GOOGL	Stock	86.45	87.1205	86.2175	86.708	9312760.0
2020-12-24	META	Stock	268.88	270.4	266.2	267.4	6702000.0
2020-12-24	TSLA	Stock	214.33	222.03	213.6667	220.59	68596800.0
2020-12-24	TLT	Stock	156.9	157.43	156.85	157.29	3117104.0
2020-12-24	ES	Stock	83.19	84.15	82.82	84.15	697700.0
2020-12-24	CL	Stock	84.62	85.1	84.49	85.04	733200.0
2020-12-24	A	Stock	117.04	118.37	116.84	117.31	733600.0
2020-12-24	AA	Stock	22.34	22.34	21.81	21.96	1075300.0
2020-12-24	AACG	Stock	1.27	1.28	1.2	1.28	49900.0
2020-12-24	AACQ-DELISTED	Stock	10.51	10.59	10.41	10.55	831818.0
2020-12-24	AACQU-DELISTED	Stock	11.23	11.23	11.1	11.2	84024.0
2020-12-24	AACQW-DELISTED	Stock	2.3	2.3	2.129	2.278	402044.0
2020-12-24	AAIC-DELISTED	Stock	3.86	3.89	3.8032	3.84	81431.0
2020-12-24	AAIC.C-DELISTED	Stock	21.0253	21.0253	21.0	21.0	200.0
2020-12-24	AAL	Stock	16.04	16.04	15.53	15.66	31048900.0
2020-12-24	AAM.A-DELISTED	Stock	26.4727	26.51	26.4727	26.5	1462.0
2020-12-24	AAM.B-DELISTED	Stock	27.04	27.345	27.04	27.26	15315.0
2020-12-24	AAME	Stock	2.14	2.14	2.08	2.08	500.0
2020-12-24	AAMI	Stock	19.0	19.08	18.61	19.0	121400.0
2020-12-24	AAN-DELISTED	Stock	16.76	17.06	16.54	16.78	356600.0
2020-12-24	AAOI	Stock	9.02	9.04	8.66	8.77	477200.0
2020-12-24	AAON	Stock	43.7067	43.86	43.3467	43.6533	58200.0
2020-12-24	AAP	Stock	159.86	160.98	158.93	160.68	308000.0
2020-12-24	AAT	Stock	28.19	28.54	27.94	28.45	115700.0
2020-12-24	AAU-DELISTED	Stock	0.515	0.5155	0.4885	0.4922	1640016.0
2020-12-24	AAUAF-DELISTED	Stock	0.515	0.5155	0.4885	0.4946	1667072.0
2020-12-24	AAWW-DELISTED	Stock	56.01	56.77	55.75	56.14	60731.0
2020-12-24	AAXJ	Stock	86.77	87.09	86.23	86.76	633614.0
2020-12-24	AAXN-DELISTED	Stock	132.0	132.455	129.31	130.75	133244.0
2020-12-24	AB	Stock	33.25	33.53	33.04	33.37	66700.0
2020-12-24	ABB-DELISTED	Stock	27.6	27.72	27.51	27.65	549658.0
2020-12-24	ABBNY-DELISTED	Stock	27.6	27.72	27.51	27.65	587376.0
2020-12-24	ABBV	Stock	103.11	103.39	102.6	103.26	1378600.0
2020-12-24	ABC-DELISTED	Stock	97.33	97.58	96.08	96.97	203908.0
2020-12-24	ABCB	Stock	37.63	37.63	36.8	37.48	97000.0
2020-12-24	ABCL	Stock	43.26	44.0	40.85	42.42	607700.0
2020-12-24	ABCM-DELISTED	Stock	20.26	20.37	20.0	20.3	12159.0
2020-12-24	ABEO	Stock	44.75	45.25	41.5	43.25	74380.0
2020-12-24	ABEV	Stock	3.05	3.06	3.0	3.05	3918800.0
2020-12-24	ABG	Stock	140.25	140.27	137.89	139.84	38900.0
2020-12-24	ABM	Stock	38.14	38.33	37.52	37.71	127500.0
2020-12-24	ABMD-DELISTED	Stock	304.45	306.08	300.58	303.41	43898.0
2020-12-24	ABNB	Stock	159.16	162.79	154.112	154.84	3621400.0
2020-12-24	ABR	Stock	14.13	14.13	13.87	14.05	435300.0
2020-12-24	ABR.A-DELISTED	Stock	25.602	25.69	25.45	25.54	6440.0
2020-12-24	ABR.B-DELISTED	Stock	25.24	25.26	25.24	25.26	200.0

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

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