PREVIEW / stock_daily / 2021-11-15

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-15.parquet
  size:    262 KB
  rows:    8,006
  symbols: 2,673

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-11-15	AAPL	Stock	150.37	151.88	149.43	150.0	59222800.0
2021-11-15	MSFT	Stock	337.54	337.88	334.03	336.07	16723000.0
2021-11-15	NVDA	Stock	30.552	30.644	29.247	30.025	384909000.0
2021-11-15	AMZN	Stock	176.85	179.694	176.2905	177.284	58594000.0
2021-11-15	GOOGL	Stock	148.9005	149.5495	147.575	148.452	23507040.0
2021-11-15	META	Stock	344.34	353.65	343.2	347.56	25076600.0
2021-11-15	TSLA	Stock	339.21	343.9933	326.2	337.7967	104326800.0
2021-11-15	TLT	Stock	146.89	146.96	145.22	145.48	15232710.0
2021-11-15	ES	Stock	82.54	83.59	82.1	83.5	973600.0
2021-11-15	CL	Stock	78.25	78.35	77.88	78.3	3263900.0
2021-11-15	A	Stock	161.25	162.33	157.5	157.78	1121300.0
2021-11-15	AA	Stock	50.99	51.0	49.44	50.63	6352100.0
2021-11-15	AAC-DELISTED	Stock	9.85	9.85	9.82	9.84	97814.0
2021-11-15	AACG	Stock	2.19	2.24	2.15	2.16	11600.0
2021-11-15	AACIU	Stock	9.96	9.96	9.95	9.95	400.0
2021-11-15	AACIW-DELISTED	Stock	0.5	0.5199	0.5	0.518	305020.0
2021-11-15	AAIC-DELISTED	Stock	3.8	3.85	3.79	3.81	64699.0
2021-11-15	AAIC.C-DELISTED	Stock	25.65	25.6501	25.65	25.6501	312.0
2021-11-15	AAL	Stock	20.4	20.57	20.2	20.32	20874000.0
2021-11-15	AAM.A-DELISTED	Stock	25.76	25.79	25.71	25.735	8825.0
2021-11-15	AAM.B-DELISTED	Stock	26.82	27.0	26.82	26.85	18915.0
2021-11-15	AAMC-DELISTED	Stock	7.2941	7.3706	6.9059	7.2662	15745.0
2021-11-15	AAME	Stock	4.3	4.33	4.16	4.27	6400.0
2021-11-15	AAMI	Stock	30.75	30.85	30.49	30.63	1604100.0
2021-11-15	AAN-DELISTED	Stock	26.4	26.4	25.62	25.75	117100.0
2021-11-15	AAOI	Stock	6.09	6.3	5.99	6.04	653500.0
2021-11-15	AAON	Stock	51.56	51.8667	50.8933	51.1667	435000.0
2021-11-15	AAP	Stock	240.02	243.05	239.5	241.91	1085400.0
2021-11-15	AAQC-DELISTED	Stock	9.74	9.78	9.74	9.78	15300.0
2021-11-15	AAT	Stock	39.07	39.07	38.45	38.94	241000.0
2021-11-15	AATC	Stock	6.96	6.96	6.86	6.9	24663.0
2021-11-15	AAU-DELISTED	Stock	0.4089	0.415	0.3787	0.3942	957349.0
2021-11-15	AAUAF-DELISTED	Stock	0.4089	0.415	0.3787	0.3943	1043254.0
2021-11-15	AAWW-DELISTED	Stock	86.06	87.86	84.95	87.63	222208.0
2021-11-15	AAXJ	Stock	88.03	88.298	87.635	87.69	554547.0
2021-11-15	AB	Stock	56.51	56.51	55.55	55.99	142700.0
2021-11-15	ABB-DELISTED	Stock	35.06	35.085	34.87	34.88	549738.0
2021-11-15	ABBNY-DELISTED	Stock	35.06	35.085	34.87	34.88	633866.0
2021-11-15	ABBV	Stock	116.95	117.8	116.22	116.84	3941000.0
2021-11-15	ABC-DELISTED	Stock	125.34	125.68	124.02	124.4	475202.0
2021-11-15	ABCB	Stock	54.25	54.45	53.37	53.96	320300.0
2021-11-15	ABCL	Stock	15.57	16.77	15.51	16.39	3135400.0
2021-11-15	ABCM-DELISTED	Stock	22.79	22.9479	22.6672	22.77	16456.0
2021-11-15	ABEO	Stock	23.0	23.5	22.5	22.75	24988.0
2021-11-15	ABEV	Stock	3.15	3.19	3.13	3.14	14515600.0
2021-11-15	ABG	Stock	185.0	185.0	181.32	184.0	193700.0
2021-11-15	ABM	Stock	48.78	49.04	48.47	48.87	286900.0
2021-11-15	ABMD-DELISTED	Stock	361.35	366.49	346.505	348.48	105900.0
2021-11-15	ABNB	Stock	206.2	209.24	204.16	207.21	7479300.0
2021-11-15	ABOS	Stock	13.21	13.21	11.65	11.85	70700.0

> showing 50 of 8,006 rows — these rows as CSV

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