PREVIEW / stock_daily / 2021-10-13

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-13.parquet
  size:    257 KB
  rows:    7,894
  symbols: 2,672

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-10-13	AAPL	Stock	141.24	141.4	139.2	140.91	78762700.0
2021-10-13	MSFT	Stock	294.91	297.28	293.49	296.31	23416300.0
2021-10-13	NVDA	Stock	20.918	20.99	20.713	20.939	180652000.0
2021-10-13	AMZN	Stock	163.4855	164.419	163.0545	164.214	48402000.0
2021-10-13	GOOGL	Stock	137.4025	138.0	136.5188	137.582	19662320.0
2021-10-13	META	Stock	326.97	327.0	322.66	324.54	14761500.0
2021-10-13	TSLA	Stock	270.1567	271.8033	268.5933	270.36	42360300.0
2021-10-13	TLT	Stock	144.61	145.53	144.5754	145.34	23584827.0
2021-10-13	ES	Stock	84.89	86.53	84.79	86.24	1523300.0
2021-10-13	CL	Stock	75.75	76.22	75.08	76.07	3684000.0
2021-10-13	A	Stock	149.08	150.88	148.74	150.22	1509100.0
2021-10-13	AA	Stock	48.135	48.9	47.23	48.4	5829900.0
2021-10-13	AAC-DELISTED	Stock	9.76	9.77	9.75	9.76	621616.0
2021-10-13	AACG	Stock	2.39	2.41	2.25	2.28	29700.0
2021-10-13	AAIC-DELISTED	Stock	3.91	3.91	3.86	3.86	102264.0
2021-10-13	AAIC.C-DELISTED	Stock	25.48	25.48	25.25	25.48	1860.0
2021-10-13	AAL	Stock	20.25	20.25	19.53	19.61	33328000.0
2021-10-13	AAM.A-DELISTED	Stock	25.68	25.72	25.68	25.68	13733.0
2021-10-13	AAM.B-DELISTED	Stock	26.72	26.84	26.69	26.69	45151.0
2021-10-13	AAMC-DELISTED	Stock	6.85	7.1206	6.7735	6.8794	32157.0
2021-10-13	AAME	Stock	4.36	4.44	4.29	4.31	11300.0
2021-10-13	AAMI	Stock	26.24	26.245	25.9	26.1	334900.0
2021-10-13	AAN-DELISTED	Stock	27.24	27.341	26.46	26.84	125100.0
2021-10-13	AAOI	Stock	6.76	7.22	6.76	7.2	360900.0
2021-10-13	AAON	Stock	44.8133	45.2133	44.38	44.9333	149400.0
2021-10-13	AAP	Stock	212.26	213.24	205.5	210.32	920700.0
2021-10-13	AAQC-DELISTED	Stock	9.72	9.72	9.709	9.709	762.0
2021-10-13	AAT	Stock	39.3	39.45	38.98	39.44	181800.0
2021-10-13	AATC	Stock	7.0	7.0	6.88	6.95	16122.0
2021-10-13	AAU-DELISTED	Stock	0.39	0.3912	0.3875	0.39	541097.0
2021-10-13	AAUAF-DELISTED	Stock	0.39	0.3912	0.3875	0.39	548012.0
2021-10-13	AAWW-DELISTED	Stock	77.74	79.36	76.69	79.19	386127.0
2021-10-13	AAXJ	Stock	85.63	86.33	85.56	86.14	1056215.0
2021-10-13	AB	Stock	49.75	50.34	49.7	50.19	253200.0
2021-10-13	ABB-DELISTED	Stock	33.72	33.94	33.62	33.81	1573913.0
2021-10-13	ABBNY-DELISTED	Stock	33.72	33.94	33.62	33.81	1763587.0
2021-10-13	ABBV	Stock	108.59	109.04	108.0	108.53	5471100.0
2021-10-13	ABC-DELISTED	Stock	119.02	119.17	115.96	118.87	762243.0
2021-10-13	ABCB	Stock	52.73	52.85	51.5	52.0	293000.0
2021-10-13	ABCL	Stock	15.15	15.58	14.97	15.52	1221500.0
2021-10-13	ABCM-DELISTED	Stock	20.54	20.9566	20.54	20.68	15952.0
2021-10-13	ABEO	Stock	22.25	23.0	22.0	22.0	33316.0
2021-10-13	ABEV	Stock	2.72	2.79	2.71	2.76	23216600.0
2021-10-13	ABG	Stock	211.29	213.18	209.4	211.83	172900.0
2021-10-13	ABM	Stock	45.36	45.39	44.47	45.09	236900.0
2021-10-13	ABMD-DELISTED	Stock	335.72	339.225	334.27	336.64	59189.0
2021-10-13	ABNB	Stock	173.0	175.19	171.8	173.58	3521900.0
2021-10-13	ABOS	Stock	13.42	14.53	13.165	14.39	80100.0
2021-10-13	ABR	Stock	19.15	19.21	18.96	19.06	1050400.0
2021-10-13	ABR.D	Stock	25.4	25.57	25.4	25.53	67447.0

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

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