PREVIEW / stock_daily / 2021-12-31

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-31.parquet
  size:    262 KB
  rows:    8,093
  symbols: 2,641

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-12-31	AAPL	Stock	178.09	179.23	177.26	177.57	64062300.0
2021-12-31	MSFT	Stock	338.51	339.36	335.85	336.32	18000800.0
2021-12-31	NVDA	Stock	29.674	30.03	29.331	29.411	266530000.0
2021-12-31	AMZN	Stock	168.956	169.35	166.5585	166.717	47830000.0
2021-12-31	GOOGL	Stock	146.05	146.6985	144.852	144.852	18135180.0
2021-12-31	META	Stock	343.02	343.44	336.27	336.35	12870500.0
2021-12-31	TSLA	Stock	357.8133	360.6667	351.53	352.26	40733700.0
2021-12-31	TLT	Stock	147.81	149.03	147.43	148.19	13402321.0
2021-12-31	ES	Stock	91.06	91.46	90.22	90.98	980200.0
2021-12-31	CL	Stock	84.59	85.4	84.59	85.34	2940200.0
2021-12-31	A	Stock	160.35	161.45	159.52	159.65	1315500.0
2021-12-31	AA	Stock	59.16	60.045	58.7	59.58	3944000.0
2021-12-31	AAC-DELISTED	Stock	9.74	9.75	9.73	9.74	58708.0
2021-12-31	AACG	Stock	1.06	1.1	1.06	1.07	59200.0
2021-12-31	AACIU	Stock	10.03	10.03	10.03	10.03	200.0
2021-12-31	AACIW-DELISTED	Stock	0.5495	0.5596	0.5101	0.5595	2820.0
2021-12-31	AAIC-DELISTED	Stock	3.49	3.5297	3.49	3.5	172777.0
2021-12-31	AAIC.C-DELISTED	Stock	25.2192	25.3	25.2192	25.2585	1019.0
2021-12-31	AAL	Stock	18.07	18.36	17.93	17.96	20657000.0
2021-12-31	AAM.A-DELISTED	Stock	25.6	25.6	25.5	25.6	12287.0
2021-12-31	AAM.B-DELISTED	Stock	26.5	26.8	26.48	26.63	33792.0
2021-12-31	AAME	Stock	2.8	2.82	2.38	2.45	190200.0
2021-12-31	AAMI	Stock	25.7	26.05	25.56	25.6	734700.0
2021-12-31	AAN-DELISTED	Stock	24.55	24.78	24.33	24.65	177800.0
2021-12-31	AAOI	Stock	5.37	5.45	5.12	5.14	618500.0
2021-12-31	AAON	Stock	52.88	53.2933	52.5	52.9533	178350.0
2021-12-31	AAP	Stock	237.0	240.97	235.22	239.88	676100.0
2021-12-31	AAQC-DELISTED	Stock	9.71	9.72	9.7	9.72	23827.0
2021-12-31	AAT	Stock	37.32	37.87	37.11	37.53	159700.0
2021-12-31	AATC	Stock	6.43	6.43	6.26	6.29	13430.0
2021-12-31	AAU-DELISTED	Stock	0.3	0.3199	0.292	0.2975	727845.0
2021-12-31	AAUAF-DELISTED	Stock	0.3	0.3199	0.292	0.2995	732435.0
2021-12-31	AAWW-DELISTED	Stock	92.94	94.5848	91.99	94.08	133480.0
2021-12-31	AAXJ	Stock	83.09	83.5	82.68	82.7	702837.0
2021-12-31	AB	Stock	49.16	49.37	48.81	48.84	160000.0
2021-12-31	ABB-DELISTED	Stock	38.11	38.345	38.11	38.17	611117.0
2021-12-31	ABBNY-DELISTED	Stock	38.11	38.345	38.11	38.17	706875.0
2021-12-31	ABBV	Stock	136.04	136.21	135.3	135.4	3963400.0
2021-12-31	ABC-DELISTED	Stock	133.83	134.17	132.84	132.94	428032.0
2021-12-31	ABCB	Stock	49.53	50.06	49.03	49.68	209200.0
2021-12-31	ABCL	Stock	14.34	14.93	14.22	14.3	1026600.0
2021-12-31	ABCM-DELISTED	Stock	23.52	23.98	23.48	23.59	44402.0
2021-12-31	ABEO	Stock	8.0	8.75	8.0	8.5	153412.0
2021-12-31	ABEV	Stock	2.79	2.8	2.76	2.8	6036400.0
2021-12-31	ABG	Stock	169.14	173.1	169.14	172.73	421900.0
2021-12-31	ABGI-DELISTED	Stock	9.8	9.8	9.78	9.78	500.0
2021-12-31	ABM	Stock	40.59	41.26	40.46	40.85	275700.0
2021-12-31	ABMD-DELISTED	Stock	361.02	364.935	358.35	359.44	92107.0
2021-12-31	ABNB	Stock	168.78	170.87	166.08	166.49	2596000.0
2021-12-31	ABOS	Stock	6.81	7.095	6.7	6.76	203000.0

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

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