PREVIEW / stock_daily / 2021-09-30

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-30.parquet
  size:    258 KB
  rows:    7,933
  symbols: 2,728

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-09-30	AAPL	Stock	143.66	144.38	141.28	141.5	89056700.0
2021-09-30	MSFT	Stock	285.71	287.83	281.62	281.92	32343600.0
2021-09-30	NVDA	Stock	20.768	21.066	20.688	20.716	221009000.0
2021-09-30	AMZN	Stock	165.8	166.3925	163.6995	164.252	56848000.0
2021-09-30	GOOGL	Stock	134.2615	135.5425	133.556	133.676	38028800.0
2021-09-30	META	Stock	340.45	342.8	338.15	339.39	16547100.0
2021-09-30	TSLA	Stock	260.3333	263.0433	258.3333	258.4933	53868000.0
2021-09-30	TLT	Stock	144.1	144.515	143.65	144.32	22567556.0
2021-09-30	ES	Stock	82.51	82.67	81.53	81.76	1979700.0
2021-09-30	CL	Stock	77.12	77.29	75.58	75.58	4178800.0
2021-09-30	A	Stock	161.23	162.48	157.46	157.53	1542800.0
2021-09-30	AA	Stock	50.06	50.47	48.93	48.94	6043900.0
2021-09-30	AAC-DELISTED	Stock	9.74	9.76	9.74	9.75	48641.0
2021-09-30	AACG	Stock	2.35	2.42	2.31	2.34	33900.0
2021-09-30	AACIU	Stock	9.91	9.92	9.91	9.92	28017.0
2021-09-30	AAIC-DELISTED	Stock	3.73	3.735	3.7	3.7	47720.0
2021-09-30	AAIC.C-DELISTED	Stock	25.265	25.27	25.01	25.03	1497.0
2021-09-30	AAL	Stock	20.87	20.87	20.37	20.52	24079400.0
2021-09-30	AAM.A-DELISTED	Stock	25.89	25.89	25.61	25.66	29314.0
2021-09-30	AAM.B-DELISTED	Stock	26.915	27.1876	26.76	27.1	200232.0
2021-09-30	AAMC-DELISTED	Stock	6.8059	6.9118	6.2118	6.5382	379182.0
2021-09-30	AAME	Stock	3.96	4.32	3.9	4.15	85700.0
2021-09-30	AAMI	Stock	26.25	26.66	26.1	26.13	581800.0
2021-09-30	AAN-DELISTED	Stock	28.53	28.53	27.43	27.54	141100.0
2021-09-30	AAOI	Stock	7.08	7.25	7.08	7.18	247900.0
2021-09-30	AAON	Stock	44.3867	45.7067	43.4733	43.56	141150.0
2021-09-30	AAP	Stock	216.03	216.03	208.76	208.89	864200.0
2021-09-30	AAQC-DELISTED	Stock	9.7286	9.74	9.7286	9.74	2942.0
2021-09-30	AAT	Stock	38.11	38.11	37.27	37.42	323000.0
2021-09-30	AATC	Stock	7.55	7.595	7.35	7.37	20899.0
2021-09-30	AAU-DELISTED	Stock	0.3915	0.4125	0.3851	0.4017	1098576.0
2021-09-30	AAUAF-DELISTED	Stock	0.3915	0.4125	0.3851	0.4017	1108522.0
2021-09-30	AAWW-DELISTED	Stock	85.57	85.57	81.12	81.74	482725.0
2021-09-30	AAXJ	Stock	85.05	85.61	84.88	84.93	1710926.0
2021-09-30	AB	Stock	50.0	50.48	49.27	49.58	314900.0
2021-09-30	ABB-DELISTED	Stock	33.67	33.74	33.3142	33.35	1483855.0
2021-09-30	ABBNY-DELISTED	Stock	33.67	33.74	33.3142	33.36	1623034.0
2021-09-30	ABBV	Stock	109.2	110.42	107.78	107.87	7886400.0
2021-09-30	ABC-DELISTED	Stock	123.23	123.84	119.44	119.47	775665.0
2021-09-30	ABCB	Stock	52.65	53.08	51.8	51.88	406500.0
2021-09-30	ABCL	Stock	19.4	20.3	19.12	20.04	1557900.0
2021-09-30	ABCM-DELISTED	Stock	20.13	20.55	20.13	20.29	44149.0
2021-09-30	ABEO	Stock	27.25	28.5	27.0	28.0	15928.0
2021-09-30	ABEV	Stock	2.81	2.83	2.75	2.76	52970000.0
2021-09-30	ABG	Stock	204.4	207.29	196.73	196.74	299400.0
2021-09-30	ABGI-DELISTED	Stock	9.7	9.74	9.7	9.74	600.0
2021-09-30	ABM	Stock	45.74	46.2	44.56	45.01	364200.0
2021-09-30	ABMD-DELISTED	Stock	330.46	334.665	325.51	325.51	104125.0
2021-09-30	ABNB	Stock	168.1	169.5	165.71	167.75	2662500.0
2021-09-30	ABOS	Stock	14.89	15.105	14.66	14.86	57500.0

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

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