PREVIEW / stock_daily / 2020-12-28

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-28.parquet
  size:    240 KB
  rows:    7,275
  symbols: 2,643

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-28	AAPL	Stock	133.99	137.34	133.51	136.69	124486200.0
2020-12-28	MSFT	Stock	224.45	226.03	223.02	224.96	17933500.0
2020-12-28	NVDA	Stock	13.0625	13.0625	12.7632	12.9	212564000.0
2020-12-28	AMZN	Stock	159.7	165.2	158.6345	164.198	113736000.0
2020-12-28	GOOGL	Stock	87.2455	89.35	87.091	88.698	27650740.0
2020-12-28	META	Stock	268.74	277.3	265.66	277.0	23299700.0
2020-12-28	TSLA	Stock	224.8367	227.1333	220.2667	221.23	96835800.0
2020-12-28	TLT	Stock	156.38	157.45	156.095	157.36	7791093.0
2020-12-28	ES	Stock	84.66	85.1	84.29	85.04	1255500.0
2020-12-28	CL	Stock	85.28	85.68	84.98	85.41	1225800.0
2020-12-28	A	Stock	118.51	118.78	116.67	117.83	1003100.0
2020-12-28	AA	Stock	22.1	23.02	22.09	22.24	4336100.0
2020-12-28	AACG	Stock	1.28	1.28	1.2	1.21	49700.0
2020-12-28	AACQ-DELISTED	Stock	10.65	10.84	10.52	10.52	2499810.0
2020-12-28	AACQU-DELISTED	Stock	11.25	11.93	11.25	11.27	171923.0
2020-12-28	AACQW-DELISTED	Stock	2.36	2.75	2.3	2.32	730235.0
2020-12-28	AAIC-DELISTED	Stock	3.81	3.94	3.81	3.84	249643.0
2020-12-28	AAIC.C-DELISTED	Stock	21.01	21.05	20.8	20.925	3724.0
2020-12-28	AAL	Stock	15.97	16.46	15.91	16.06	61099000.0
2020-12-28	AAM.A-DELISTED	Stock	26.59	26.71	26.54	26.629	12969.0
2020-12-28	AAM.B-DELISTED	Stock	27.45	27.56	27.37	27.43	21206.0
2020-12-28	AAMC-DELISTED	Stock	6.6412	6.6676	6.6176	6.6176	3128.0
2020-12-28	AAME	Stock	2.12	2.14	2.1	2.1	3600.0
2020-12-28	AAMI	Stock	19.2	19.33	18.98	18.98	241300.0
2020-12-28	AAN-DELISTED	Stock	16.98	17.14	16.2	16.37	1187400.0
2020-12-28	AAOI	Stock	8.87	9.11	8.83	8.93	514700.0
2020-12-28	AAON	Stock	43.9533	44.9867	41.0067	44.4133	331800.0
2020-12-28	AAP	Stock	161.31	162.64	158.27	158.8	863300.0
2020-12-28	AAT	Stock	28.48	29.17	28.27	28.92	192500.0
2020-12-28	AAU-DELISTED	Stock	0.49	0.491	0.459	0.4778	2146455.0
2020-12-28	AAUAF-DELISTED	Stock	0.49	0.491	0.459	0.4779	2210399.0
2020-12-28	AAWW-DELISTED	Stock	56.36	56.525	54.51	54.78	233091.0
2020-12-28	AAXJ	Stock	87.15	87.28	86.81	86.95	839526.0
2020-12-28	AAXN-DELISTED	Stock	132.17	133.49	125.15	125.16	238174.0
2020-12-28	AB	Stock	33.41	33.63	33.09	33.13	293600.0
2020-12-28	ABB-DELISTED	Stock	27.8	28.03	27.78	27.86	1383321.0
2020-12-28	ABBNY-DELISTED	Stock	27.8	28.03	27.78	27.86	1468526.0
2020-12-28	ABBV	Stock	103.65	103.88	102.72	103.45	3948900.0
2020-12-28	ABC-DELISTED	Stock	97.71	98.2	96.37	96.75	383964.0
2020-12-28	ABCB	Stock	37.65	38.31	37.17	37.99	300600.0
2020-12-28	ABCL	Stock	42.65	42.96	38.3	40.55	1116800.0
2020-12-28	ABCM-DELISTED	Stock	20.42	20.9	20.42	20.7	56091.0
2020-12-28	ABEO	Stock	44.5	45.75	41.25	41.5	78412.0
2020-12-28	ABEV	Stock	3.02	3.06	3.0	3.03	11487000.0
2020-12-28	ABG	Stock	140.44	147.67	137.16	144.49	184000.0
2020-12-28	ABM	Stock	38.07	38.79	38.07	38.45	228900.0
2020-12-28	ABMD-DELISTED	Stock	307.34	312.98	306.16	312.84	163991.0
2020-12-28	ABNB	Stock	158.6	163.64	147.52	149.0	6229200.0
2020-12-28	ABR	Stock	14.14	14.33	14.07	14.21	724400.0
2020-12-28	ABR.A-DELISTED	Stock	25.61	25.615	25.47	25.47	4190.0

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

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