PREVIEW / stock_daily / 2021-01-20

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-20.parquet
  size:    243 KB
  rows:    7,339
  symbols: 2,676

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
2021-01-20	AAPL	Stock	128.66	132.49	128.55	132.03	104319500.0
2021-01-20	MSFT	Stock	217.7	225.79	217.29	224.34	37777300.0
2021-01-20	NVDA	Stock	13.1118	13.4305	13.0568	13.3658	258572000.0
2021-01-20	AMZN	Stock	159.0995	163.99	158.75	163.169	106196000.0
2021-01-20	GOOGL	Stock	91.3185	94.9862	90.9755	94.0035	64151400.0
2021-01-20	META	Stock	268.93	270.32	263.6	267.48	25199900.0
2021-01-20	TSLA	Stock	286.2467	286.5	279.0933	283.4833	76997700.0
2021-01-20	TLT	Stock	151.985	152.48	151.79	152.46	5368933.0
2021-01-20	ES	Stock	86.53	87.86	86.08	87.62	1577700.0
2021-01-20	CL	Stock	79.5	80.45	78.9	80.2	6897200.0
2021-01-20	A	Stock	127.71	128.92	127.36	128.11	1843000.0
2021-01-20	AA	Stock	23.5	23.74	22.64	22.84	5578300.0
2021-01-20	AACG	Stock	1.31	1.51	1.3	1.38	206000.0
2021-01-20	AACQ-DELISTED	Stock	10.85	10.88	10.71	10.75	1080188.0
2021-01-20	AACQU-DELISTED	Stock	11.55	11.629	11.48	11.5	110467.0
2021-01-20	AACQW-DELISTED	Stock	2.34	2.5	2.31	2.33	326779.0
2021-01-20	AAIC-DELISTED	Stock	3.88	3.88	3.79	3.83	112731.0
2021-01-20	AAIC.C-DELISTED	Stock	21.39	21.39	21.1	21.1	500.0
2021-01-20	AAL	Stock	16.17	16.39	15.84	16.17	42354500.0
2021-01-20	AAM.A-DELISTED	Stock	26.574	26.8893	26.52	26.81	4972.0
2021-01-20	AAM.B-DELISTED	Stock	26.95	27.28	26.9493	27.28	16466.0
2021-01-20	AAMC-DELISTED	Stock	6.4206	6.5	6.3941	6.4382	12685.0
2021-01-20	AAME	Stock	2.4	2.4	2.34	2.39	6900.0
2021-01-20	AAMI	Stock	21.28	21.62	21.17	21.39	360900.0
2021-01-20	AAN-DELISTED	Stock	21.01	21.34	20.3	20.56	408600.0
2021-01-20	AAOI	Stock	10.87	11.11	10.68	10.77	796900.0
2021-01-20	AAON	Stock	47.0267	47.86	46.64	47.8	229050.0
2021-01-20	AAP	Stock	166.04	166.48	164.21	165.18	497300.0
2021-01-20	AAT	Stock	29.32	30.2	29.14	29.94	256100.0
2021-01-20	AAU-DELISTED	Stock	0.5651	0.5875	0.5325	0.5647	3594637.0
2021-01-20	AAUAF-DELISTED	Stock	0.5651	0.5875	0.5325	0.5681	3664537.0
2021-01-20	AAWW-DELISTED	Stock	52.9925	53.45	51.82	52.13	187479.0
2021-01-20	AAXJ	Stock	98.39	98.615	97.94	98.57	1155447.0
2021-01-20	AAXN-DELISTED	Stock	162.74	168.48	162.41	164.7	1090151.0
2021-01-20	AB	Stock	36.22	36.35	35.83	36.23	249700.0
2021-01-20	ABB-DELISTED	Stock	29.7	29.845	29.62	29.75	1277593.0
2021-01-20	ABBNY-DELISTED	Stock	29.7	29.845	29.62	29.75	1469345.0
2021-01-20	ABBV	Stock	112.91	113.1	111.47	112.62	6554600.0
2021-01-20	ABC-DELISTED	Stock	103.19	104.39	102.77	103.79	1036993.0
2021-01-20	ABCB	Stock	44.67	45.18	44.16	44.67	465700.0
2021-01-20	ABCL	Stock	49.53	49.74	47.5	48.2	475200.0
2021-01-20	ABCM-DELISTED	Stock	23.33	23.8	23.24	23.41	153871.0
2021-01-20	ABEO	Stock	54.25	59.5	49.25	49.75	207176.0
2021-01-20	ABEV	Stock	3.1	3.1	3.02	3.04	17570400.0
2021-01-20	ABG	Stock	160.39	168.42	160.39	167.01	394500.0
2021-01-20	ABM	Stock	39.67	39.84	38.83	39.43	344300.0
2021-01-20	ABMD-DELISTED	Stock	339.12	353.49	337.84	347.88	435228.0
2021-01-20	ABNB	Stock	176.01	176.31	161.0	161.83	8517400.0
2021-01-20	ABR	Stock	14.34	14.61	14.33	14.6	1169300.0
2021-01-20	ABR.A-DELISTED	Stock	25.65	25.74	25.65	25.74	3000.0

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

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