PREVIEW / stock_daily / 2021-09-20

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-20.parquet
  size:    257 KB
  rows:    7,864
  symbols: 2,687

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-20	AAPL	Stock	143.8	144.84	141.27	142.94	123478900.0
2021-09-20	MSFT	Stock	296.33	298.72	289.52	294.3	38278700.0
2021-09-20	NVDA	Stock	21.146	21.433	20.662	21.113	349440000.0
2021-09-20	AMZN	Stock	169.8	170.95	165.2505	167.7865	93382000.0
2021-09-20	GOOGL	Stock	138.1615	139.0	136.3218	138.7195	46518040.0
2021-09-20	META	Stock	359.3	361.03	349.8	355.7	19822800.0
2021-09-20	TSLA	Stock	244.8533	247.3333	239.54	243.39	74273100.0
2021-09-20	TLT	Stock	150.57	151.37	150.23	151.02	14660406.0
2021-09-20	ES	Stock	83.43	84.32	82.41	83.37	1286400.0
2021-09-20	CL	Stock	77.02	77.23	75.69	76.17	4942500.0
2021-09-20	A	Stock	170.5	172.58	169.11	171.34	1599400.0
2021-09-20	AA	Stock	45.71	48.48	45.24	48.46	9338100.0
2021-09-20	AAC-DELISTED	Stock	9.72	9.74	9.7	9.71	359136.0
2021-09-20	AACG	Stock	2.57	2.67	2.3	2.33	104000.0
2021-09-20	AACIU	Stock	9.88	9.905	9.88	9.88	126828.0
2021-09-20	AAIC-DELISTED	Stock	3.72	3.75	3.68	3.71	194500.0
2021-09-20	AAIC.C-DELISTED	Stock	25.05	25.0519	25.03	25.0405	3654.0
2021-09-20	AAL	Stock	19.72	20.37	19.34	20.33	43601300.0
2021-09-20	AAM.A-DELISTED	Stock	25.73	25.79	25.7	25.76	3959.0
2021-09-20	AAM.B-DELISTED	Stock	26.9	26.94	26.795	26.9	24278.0
2021-09-20	AAMC-DELISTED	Stock	7.5147	7.5735	7.0294	7.4	94520.0
2021-09-20	AAME	Stock	3.96	4.0	3.74	3.83	68700.0
2021-09-20	AAMI	Stock	26.17	26.19	25.82	26.14	658900.0
2021-09-20	AAN-DELISTED	Stock	26.33	26.69	25.93	26.64	244300.0
2021-09-20	AAOI	Stock	7.25	7.305	6.94	6.97	442600.0
2021-09-20	AAON	Stock	43.34	43.8933	43.18	43.78	317550.0
2021-09-20	AAP	Stock	203.01	204.74	200.78	203.71	444100.0
2021-09-20	AAQC-DELISTED	Stock	9.71	9.71	9.69	9.7	10639.0
2021-09-20	AAT	Stock	37.39	38.32	37.03	38.1	288000.0
2021-09-20	AATC	Stock	8.0	8.07	7.2	7.22	81091.0
2021-09-20	AAU-DELISTED	Stock	0.399	0.399	0.375	0.3873	658581.0
2021-09-20	AAUAF-DELISTED	Stock	0.399	0.399	0.375	0.3865	670067.0
2021-09-20	AAWW-DELISTED	Stock	73.87	74.535	71.51	74.33	355287.0
2021-09-20	AAXJ	Stock	84.86	85.14	83.74	84.37	1299872.0
2021-09-20	AB	Stock	50.6	50.95	46.87	48.28	972800.0
2021-09-20	ABB-DELISTED	Stock	34.56	34.79	34.33	34.68	1556269.0
2021-09-20	ABBNY-DELISTED	Stock	34.56	34.79	34.33	34.68	1738404.0
2021-09-20	ABBV	Stock	106.1	107.49	105.56	106.4	7103400.0
2021-09-20	ABC-DELISTED	Stock	122.74	123.09	120.51	121.96	601597.0
2021-09-20	ABCB	Stock	45.8	46.52	45.09	46.47	501400.0
2021-09-20	ABCL	Stock	19.37	21.29	19.17	20.65	4906000.0
2021-09-20	ABCM-DELISTED	Stock	20.3	20.79	20.3	20.5	42852.0
2021-09-20	ABEO	Stock	30.0	30.5	29.25	30.25	15108.0
2021-09-20	ABEV	Stock	2.92	2.93	2.84	2.9	32491900.0
2021-09-20	ABG	Stock	177.63	181.38	175.31	179.11	132600.0
2021-09-20	ABM	Stock	44.32	45.06	43.6	44.54	521600.0
2021-09-20	ABMD-DELISTED	Stock	352.65	360.53	343.31	347.32	193914.0
2021-09-20	ABNB	Stock	162.24	166.54	159.445	161.64	6846800.0
2021-09-20	ABOS	Stock	16.1	16.42	14.52	14.76	459500.0
2021-09-20	ABR	Stock	17.84	18.05	17.7	17.97	1525600.0

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

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