PREVIEW / stock_daily / 2021-01-27

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-27.parquet
  size:    243 KB
  rows:    7,377
  symbols: 2,695

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-27	AAPL	Stock	143.43	144.3	140.41	142.06	140843800.0
2021-01-27	MSFT	Stock	238.0	240.44	230.14	232.9	69870600.0
2021-01-27	NVDA	Stock	13.23	13.2328	12.7938	12.9178	371272000.0
2021-01-27	AMZN	Stock	167.0745	167.326	160.354	161.629	93204000.0
2021-01-27	GOOGL	Stock	93.7455	94.0235	89.864	90.947	82512620.0
2021-01-27	META	Stock	282.53	283.45	268.12	272.14	35346200.0
2021-01-27	TSLA	Stock	290.1167	297.1667	286.22	288.0533	82002000.0
2021-01-27	TLT	Stock	154.07	154.5	153.53	153.77	7895249.0
2021-01-27	ES	Stock	89.12	90.93	88.33	88.53	1981200.0
2021-01-27	CL	Stock	78.55	78.99	77.84	78.03	6289700.0
2021-01-27	A	Stock	122.08	123.0	118.11	118.8	1923500.0
2021-01-27	AA	Stock	18.69	18.97	17.3	18.66	9215300.0
2021-01-27	AACG	Stock	1.32	1.38	1.26	1.32	61100.0
2021-01-27	AACQ-DELISTED	Stock	10.65	10.65	10.49	10.53	2529898.0
2021-01-27	AACQU-DELISTED	Stock	11.33	11.35	11.08	11.15	345297.0
2021-01-27	AACQW-DELISTED	Stock	2.08	2.25	1.92	2.0399	1421054.0
2021-01-27	AAIC-DELISTED	Stock	3.78	3.8	3.66	3.74	200805.0
2021-01-27	AAIC.C-DELISTED	Stock	21.5	21.525	21.45	21.46	3284.0
2021-01-27	AAL	Stock	15.42	17.81	15.38	16.56	178529000.0
2021-01-27	AAM.A-DELISTED	Stock	26.41	26.6	26.4	26.44	12899.0
2021-01-27	AAM.B-DELISTED	Stock	26.97	26.97	26.44	26.53	19016.0
2021-01-27	AAMC-DELISTED	Stock	6.1029	6.3206	5.9088	6.3163	19754.0
2021-01-27	AAME	Stock	2.49	2.54	2.41	2.48	18600.0
2021-01-27	AAMI	Stock	19.96	20.09	18.18	18.51	753400.0
2021-01-27	AAN-DELISTED	Stock	18.97	19.17	17.9	18.01	482600.0
2021-01-27	AAOI	Stock	11.06	13.949	11.0	12.17	3545900.0
2021-01-27	AAON	Stock	48.16	50.6867	47.9133	50.3933	421350.0
2021-01-27	AAP	Stock	152.65	154.45	143.15	147.93	3368300.0
2021-01-27	AAT	Stock	28.15	28.65	27.86	28.12	368100.0
2021-01-27	AAU-DELISTED	Stock	0.55	0.5625	0.5221	0.5455	3660043.0
2021-01-27	AAUAF-DELISTED	Stock	0.55	0.5625	0.5221	0.5358	3748030.0
2021-01-27	AAWW-DELISTED	Stock	54.0	57.8131	53.29	55.06	487086.0
2021-01-27	AAXJ	Stock	96.09	96.48	95.302	95.32	953299.0
2021-01-27	AB	Stock	37.45	37.82	36.0	36.6	901200.0
2021-01-27	ABB-DELISTED	Stock	29.72	30.1	29.46	29.82	2712816.0
2021-01-27	ABBNY-DELISTED	Stock	29.72	30.1	29.46	29.82	3142152.0
2021-01-27	ABBV	Stock	106.28	106.7	102.59	102.79	11887900.0
2021-01-27	ABC-DELISTED	Stock	107.91	109.76	106.61	106.94	753298.0
2021-01-27	ABCB	Stock	41.66	42.16	40.91	41.0	430100.0
2021-01-27	ABCL	Stock	45.89	48.92	45.1	46.85	687300.0
2021-01-27	ABCM-DELISTED	Stock	22.96	23.34	22.41	23.07	67543.0
2021-01-27	ABEO	Stock	55.75	56.0	50.25	51.0	116656.0
2021-01-27	ABEV	Stock	2.87	2.93	2.84	2.86	26569200.0
2021-01-27	ABG	Stock	150.09	150.09	138.24	144.64	418300.0
2021-01-27	ABM	Stock	39.32	40.08	38.75	39.56	316600.0
2021-01-27	ABMD-DELISTED	Stock	334.38	342.69	327.13	328.18	272447.0
2021-01-27	ABNB	Stock	187.64	216.0	185.5	201.25	11019800.0
2021-01-27	ABR	Stock	14.4	14.46	14.1	14.13	1219700.0
2021-01-27	ABR.A-DELISTED	Stock	25.6579	25.6579	25.6579	25.6579	400.0
2021-01-27	ABR.B-DELISTED	Stock	25.25	25.28	25.25	25.25	5404.0

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

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