PREVIEW / stock_daily / 2021-12-23

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-23.parquet
  size:    261 KB
  rows:    8,013
  symbols: 2,617

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-23	AAPL	Stock	175.85	176.85	175.27	176.28	68356600.0
2021-12-23	MSFT	Stock	332.75	336.39	332.73	334.69	19617800.0
2021-12-23	NVDA	Stock	29.755	30.059	29.431	29.64	343022000.0
2021-12-23	AMZN	Stock	170.428	171.975	170.15	171.0685	36788000.0
2021-12-23	GOOGL	Stock	146.5	148.2435	146.452	146.9165	26383440.0
2021-12-23	META	Stock	330.1	336.67	328.36	335.24	13987700.0
2021-12-23	TSLA	Stock	335.6	357.66	332.52	355.6667	92713200.0
2021-12-23	TLT	Stock	149.59	149.6	148.03	148.52	11642576.0
2021-12-23	ES	Stock	89.37	90.09	89.21	89.44	779700.0
2021-12-23	CL	Stock	82.47	83.01	82.21	82.79	3936400.0
2021-12-23	A	Stock	157.29	158.86	156.65	157.8	1411000.0
2021-12-23	AA	Stock	59.0	60.59	58.46	59.36	7516400.0
2021-12-23	AAC-DELISTED	Stock	9.75	9.77	9.74	9.75	38490.0
2021-12-23	AACG	Stock	1.28	1.28	1.16	1.24	29100.0
2021-12-23	AACIW-DELISTED	Stock	0.4803	0.55	0.4803	0.4872	11595.0
2021-12-23	AAIC-DELISTED	Stock	3.45	3.595	3.4201	3.55	181179.0
2021-12-23	AAL	Stock	18.59	18.72	18.15	18.26	32321000.0
2021-12-23	AAM.A-DELISTED	Stock	25.58	25.58	25.43	25.4371	12415.0
2021-12-23	AAM.B-DELISTED	Stock	26.69	26.74	26.4684	26.5	4726.0
2021-12-23	AAME	Stock	3.19	3.21	3.07	3.21	27700.0
2021-12-23	AAMI	Stock	25.42	25.9	25.4	25.66	778400.0
2021-12-23	AAN-DELISTED	Stock	24.83	24.85	24.49	24.49	119500.0
2021-12-23	AAOI	Stock	5.45	5.65	5.45	5.64	640900.0
2021-12-23	AAON	Stock	52.6	53.1133	51.32	52.38	359550.0
2021-12-23	AAP	Stock	234.0	234.41	232.0	232.13	492800.0
2021-12-23	AAQC-DELISTED	Stock	9.7	9.71	9.7	9.71	14119.0
2021-12-23	AAT	Stock	36.71	36.96	36.1	36.36	386500.0
2021-12-23	AATC	Stock	6.44	6.48	6.4	6.48	3680.0
2021-12-23	AAU-DELISTED	Stock	0.308	0.32	0.3026	0.3044	417842.0
2021-12-23	AAUAF-DELISTED	Stock	0.308	0.32	0.3026	0.3049	421767.0
2021-12-23	AAWW-DELISTED	Stock	91.97	93.16	91.735	91.89	173609.0
2021-12-23	AAXJ	Stock	82.25	82.6399	81.905	82.48	1072205.0
2021-12-23	AB	Stock	47.94	49.37	47.94	48.97	300000.0
2021-12-23	ABB-DELISTED	Stock	37.42	37.865	37.4	37.77	734144.0
2021-12-23	ABBNY-DELISTED	Stock	37.42	37.865	37.4	37.77	837428.0
2021-12-23	ABBV	Stock	132.33	133.77	132.17	133.09	5702300.0
2021-12-23	ABC-DELISTED	Stock	128.3	129.92	127.75	129.51	459690.0
2021-12-23	ABCB	Stock	49.07	49.81	48.88	49.21	164900.0
2021-12-23	ABCL	Stock	15.43	15.488	14.51	14.93	1765800.0
2021-12-23	ABCM-DELISTED	Stock	22.06	22.3494	22.03	22.27	36048.0
2021-12-23	ABEO	Stock	8.5	9.25	8.5	9.0	204372.0
2021-12-23	ABEV	Stock	2.7	2.75	2.69	2.74	16973300.0
2021-12-23	ABG	Stock	163.5	165.66	161.54	164.42	131700.0
2021-12-23	ABM	Stock	41.0	42.16	41.0	41.53	417000.0
2021-12-23	ABMD-DELISTED	Stock	343.88	353.64	341.84	352.39	134861.0
2021-12-23	ABNB	Stock	170.5	171.99	166.89	171.31	4017400.0
2021-12-23	ABOS	Stock	7.07	7.19	6.84	7.07	141800.0
2021-12-23	ABR	Stock	18.01	18.24	17.97	18.12	1090200.0
2021-12-23	ABR.D	Stock	25.3	25.3	25.22	25.24	18616.0
2021-12-23	ABR.E	Stock	25.257	25.29	25.11	25.11	1009.0

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

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