PREVIEW / stock_daily / 2021-01-29

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-29.parquet
  size:    244 KB
  rows:    7,386
  symbols: 2,708

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-01-29	AAPL	Stock	135.83	136.74	130.21	131.96	177523800.0
2021-01-29	MSFT	Stock	235.99	238.02	231.35	231.96	42503100.0
2021-01-29	NVDA	Stock	13.075	13.3348	12.9115	12.9898	271552000.0
2021-01-29	AMZN	Stock	161.5	161.8495	159.2275	160.31	85872000.0
2021-01-29	GOOGL	Stock	91.701	92.3768	90.078	91.368	44530180.0
2021-01-29	META	Stock	265.3	266.56	254.85	258.33	30389500.0
2021-01-29	TSLA	Stock	276.6667	280.8033	260.0333	264.51	104972400.0
2021-01-29	TLT	Stock	151.42	152.49	151.3	152.0	14966238.0
2021-01-29	ES	Stock	88.59	89.24	87.28	87.5	2211800.0
2021-01-29	CL	Stock	78.91	80.2	77.84	78.0	7405100.0
2021-01-29	A	Stock	121.21	121.69	119.28	120.17	1822000.0
2021-01-29	AA	Stock	18.65	18.84	17.775	18.0	7772500.0
2021-01-29	AACG	Stock	1.3	1.42	1.3	1.31	105000.0
2021-01-29	AACQ-DELISTED	Stock	10.55	10.72	10.545	10.58	705739.0
2021-01-29	AACQU-DELISTED	Stock	11.31	11.35	11.23	11.26	18731.0
2021-01-29	AACQW-DELISTED	Stock	2.05	2.1194	2.0	2.08	320276.0
2021-01-29	AAIC-DELISTED	Stock	3.68	3.68	3.6	3.62	157705.0
2021-01-29	AAL	Stock	18.69	18.73	16.75	17.17	113054800.0
2021-01-29	AAM.A-DELISTED	Stock	26.56	26.65	26.3501	26.55	17763.0
2021-01-29	AAM.B-DELISTED	Stock	26.79	26.98	26.65	26.93	49851.0
2021-01-29	AAMC-DELISTED	Stock	6.2882	6.2912	6.0134	6.2794	15218.0
2021-01-29	AAME	Stock	2.36	2.42	2.25	2.38	17100.0
2021-01-29	AAMI	Stock	19.05	19.18	18.33	18.33	509400.0
2021-01-29	AAN-DELISTED	Stock	17.43	17.81	16.76	16.94	502900.0
2021-01-29	AAOI	Stock	11.41	12.0	10.947	11.01	892500.0
2021-01-29	AAON	Stock	49.2067	49.6067	48.08	49.3333	597150.0
2021-01-29	AAP	Stock	153.0	154.55	148.28	149.14	1292800.0
2021-01-29	AAT	Stock	28.33	28.89	27.63	27.63	413600.0
2021-01-29	AAU-DELISTED	Stock	0.601	0.85	0.6	0.7189	30182766.0
2021-01-29	AAUAF-DELISTED	Stock	0.601	0.85	0.6	0.7277	30527864.0
2021-01-29	AAWW-DELISTED	Stock	53.04	54.26	51.06	51.88	400542.0
2021-01-29	AAXJ	Stock	94.05	94.46	93.15	93.52	1113698.0
2021-01-29	AB	Stock	36.87	36.91	35.09	35.35	710700.0
2021-01-29	ABB-DELISTED	Stock	29.87	29.915	29.36	29.52	2171273.0
2021-01-29	ABBNY-DELISTED	Stock	29.87	29.915	29.36	29.51	2483652.0
2021-01-29	ABBV	Stock	104.0	104.49	101.81	102.48	9380400.0
2021-01-29	ABC-DELISTED	Stock	106.81	107.62	103.8	104.2	887412.0
2021-01-29	ABCB	Stock	40.67	40.67	36.6	39.11	796300.0
2021-01-29	ABCL	Stock	52.1	55.22	50.33	52.83	1070400.0
2021-01-29	ABCM-DELISTED	Stock	22.92	23.35	22.65	23.15	85877.0
2021-01-29	ABEO	Stock	48.75	50.0	47.25	47.75	97224.0
2021-01-29	ABEV	Stock	2.86	2.87	2.78	2.79	26235800.0
2021-01-29	ABG	Stock	148.34	149.39	141.12	142.61	175800.0
2021-01-29	ABM	Stock	38.46	38.46	36.53	36.74	885800.0
2021-01-29	ABMD-DELISTED	Stock	349.96	354.69	337.93	349.03	262184.0
2021-01-29	ABNB	Stock	190.71	193.5	179.31	183.63	4529800.0
2021-01-29	ABR	Stock	14.57	14.61	14.1	14.26	1152100.0
2021-01-29	ABR.A-DELISTED	Stock	25.7768	25.78	25.7211	25.7601	1080.0
2021-01-29	ABR.B-DELISTED	Stock	25.28	25.28	25.27	25.27	351.0
2021-01-29	ABR.C-DELISTED	Stock	26.11	26.24	26.06	26.225	3750.0

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

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