PREVIEW / stock_daily / 2021-04-20

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-20.parquet
  size:    256 KB
  rows:    7,776
  symbols: 2,944

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-04-20	AAPL	Stock	135.02	135.53	131.81	133.11	94812300.0
2021-04-20	MSFT	Stock	257.82	260.2	256.84	258.26	19722900.0
2021-04-20	NVDA	Stock	15.3232	15.497	14.963	15.1712	334132000.0
2021-04-20	AMZN	Stock	168.68	169.1495	165.8	166.7345	52460000.0
2021-04-20	GOOGL	Stock	114.8745	114.95	112.856	113.9505	22288320.0
2021-04-20	META	Stock	301.99	305.1	297.21	302.65	16796400.0
2021-04-20	TSLA	Stock	239.14	245.75	236.8967	239.6633	106827000.0
2021-04-20	TLT	Stock	138.45	139.76	138.43	139.5	11476489.0
2021-04-20	ES	Stock	89.39	91.14	89.39	90.58	978500.0
2021-04-20	CL	Stock	79.93	81.88	79.82	81.33	4307300.0
2021-04-20	A	Stock	133.0	133.55	131.82	132.46	1261200.0
2021-04-20	AA	Stock	35.91	35.95	32.381	32.98	10494800.0
2021-04-20	AAC-DELISTED	Stock	10.0	10.0	9.74	9.81	153717.0
2021-04-20	AACG	Stock	2.93	2.99	2.77	2.85	73700.0
2021-04-20	AACQ-DELISTED	Stock	9.97	10.02	9.92	9.98	2498324.0
2021-04-20	AACQU-DELISTED	Stock	10.51	10.55	10.33	10.45	176629.0
2021-04-20	AACQW-DELISTED	Stock	1.7	1.74	1.45	1.52	415343.0
2021-04-20	AAIC-DELISTED	Stock	3.96	3.99	3.87	3.94	203682.0
2021-04-20	AAIC.C-DELISTED	Stock	23.7495	23.9	23.7	23.89	3360.0
2021-04-20	AAL	Stock	21.02	21.02	19.96	20.37	48820800.0
2021-04-20	AAM.A-DELISTED	Stock	26.0793	26.08	26.01	26.06	10209.0
2021-04-20	AAM.B-DELISTED	Stock	26.79	26.79	26.74	26.79	18964.0
2021-04-20	AAMC-DELISTED	Stock	5.4765	5.6412	5.2971	5.4412	66633.0
2021-04-20	AAME	Stock	3.71	3.92	3.62	3.78	246600.0
2021-04-20	AAMI	Stock	23.17	23.17	22.6	22.8	537200.0
2021-04-20	AAN-DELISTED	Stock	25.55	25.85	23.82	24.2	163100.0
2021-04-20	AAOI	Stock	7.67	7.71	7.395	7.58	633200.0
2021-04-20	AAON	Stock	45.9933	46.6	45.1867	45.6067	128250.0
2021-04-20	AAP	Stock	198.0	198.52	190.91	193.91	1772900.0
2021-04-20	AAT	Stock	33.37	34.1	33.27	33.64	195000.0
2021-04-20	AAU-DELISTED	Stock	0.4885	0.49	0.46	0.4779	1254744.0
2021-04-20	AAUAF-DELISTED	Stock	0.4885	0.49	0.46	0.4791	1295192.0
2021-04-20	AAWW-DELISTED	Stock	67.53	67.97	66.16	67.47	309031.0
2021-04-20	AAXJ	Stock	93.86	93.97	92.83	93.16	1036689.0
2021-04-20	AB	Stock	39.6	40.05	39.57	39.87	270000.0
2021-04-20	ABB-DELISTED	Stock	32.97	33.015	32.455	32.59	981655.0
2021-04-20	ABBNY-DELISTED	Stock	32.97	33.015	32.455	32.59	1080797.0
2021-04-20	ABBV	Stock	108.12	109.56	108.05	109.03	5411800.0
2021-04-20	ABC-DELISTED	Stock	119.3	120.94	119.065	120.5	442772.0
2021-04-20	ABCB	Stock	50.59	50.66	47.95	48.25	424500.0
2021-04-20	ABCL	Stock	29.64	29.76	27.01	27.73	1617300.0
2021-04-20	ABCM-DELISTED	Stock	20.08	20.31	19.9602	20.07	81133.0
2021-04-20	ABEO	Stock	34.25	37.0	34.0	36.5	38796.0
2021-04-20	ABEV	Stock	2.86	2.9	2.83	2.84	17456400.0
2021-04-20	ABG	Stock	205.11	206.39	198.9	201.15	196200.0
2021-04-20	ABGI-DELISTED	Stock	9.9105	9.98	9.9105	9.95	2093.0
2021-04-20	ABM	Stock	52.34	52.52	50.84	51.41	438800.0
2021-04-20	ABMD-DELISTED	Stock	330.79	334.39	328.65	330.1	129181.0
2021-04-20	ABNB	Stock	173.184	175.0	165.52	169.57	4575000.0
2021-04-20	ABR	Stock	16.38	16.41	15.96	16.14	1146800.0

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

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