PREVIEW / stock_daily / 2021-04-19

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-19.parquet
  size:    254 KB
  rows:    7,782
  symbols: 2,941

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-19	AAPL	Stock	133.51	135.47	133.34	134.84	94264200.0
2021-04-19	MSFT	Stock	260.19	261.48	257.82	258.74	23209300.0
2021-04-19	NVDA	Stock	15.5365	15.8075	15.233	15.3618	404420000.0
2021-04-19	AMZN	Stock	169.5165	171.7965	168.008	168.6005	54508000.0
2021-04-19	GOOGL	Stock	113.509	115.2045	113.509	114.488	30289400.0
2021-04-19	META	Stock	305.01	307.7	300.56	302.24	14553500.0
2021-04-19	TSLA	Stock	239.8667	241.8	230.6	238.21	119058600.0
2021-04-19	TLT	Stock	138.74	139.31	138.55	138.86	13886874.0
2021-04-19	ES	Stock	90.08	90.15	88.82	89.34	1198800.0
2021-04-19	CL	Stock	80.48	80.58	79.71	80.37	4021200.0
2021-04-19	A	Stock	134.38	134.65	133.07	133.5	1071600.0
2021-04-19	AA	Stock	35.4	36.54	34.81	36.03	10102400.0
2021-04-19	AAC-DELISTED	Stock	9.85	9.865	9.8	9.84	431151.0
2021-04-19	AACG	Stock	2.85	3.03	2.8	2.99	172800.0
2021-04-19	AACQ-DELISTED	Stock	10.08	10.18	9.95	10.03	2249684.0
2021-04-19	AACQU-DELISTED	Stock	10.47	10.696	10.47	10.62	17177.0
2021-04-19	AACQW-DELISTED	Stock	1.6401	1.9	1.6401	1.71	208068.0
2021-04-19	AAIC-DELISTED	Stock	3.98	4.03	3.91	4.01	206985.0
2021-04-19	AAIC.C-DELISTED	Stock	23.75	23.8	23.75	23.8	1471.0
2021-04-19	AAL	Stock	21.97	21.99	21.37	21.55	27424900.0
2021-04-19	AAM.A-DELISTED	Stock	26.24	26.24	26.03	26.08	2488.0
2021-04-19	AAM.B-DELISTED	Stock	26.84	26.84	26.75	26.7501	8349.0
2021-04-19	AAMC-DELISTED	Stock	6.1265	6.1265	5.3794	5.5882	94874.0
2021-04-19	AAME	Stock	3.64	3.78	3.57	3.75	214700.0
2021-04-19	AAMI	Stock	23.14	23.345	22.85	23.27	478100.0
2021-04-19	AAN-DELISTED	Stock	25.46	25.9	25.1	25.55	205400.0
2021-04-19	AAOI	Stock	7.88	8.02	7.59	7.72	544300.0
2021-04-19	AAON	Stock	46.4067	46.6333	45.8667	46.1867	154050.0
2021-04-19	AAP	Stock	193.59	196.17	192.35	192.54	869200.0
2021-04-19	AAT	Stock	33.64	33.71	33.23	33.64	204500.0
2021-04-19	AAU-DELISTED	Stock	0.5	0.5099	0.475	0.485	1228740.0
2021-04-19	AAUAF-DELISTED	Stock	0.5	0.5099	0.475	0.4885	1284049.0
2021-04-19	AAWW-DELISTED	Stock	67.0	67.58	65.63	67.38	315922.0
2021-04-19	AAXJ	Stock	93.91	94.11	93.441	93.79	419079.0
2021-04-19	AB	Stock	40.12	40.2	39.77	39.8	293900.0
2021-04-19	ABB-DELISTED	Stock	33.43	33.44	33.07	33.24	1219988.0
2021-04-19	ABBNY-DELISTED	Stock	33.43	33.44	33.07	33.24	1322847.0
2021-04-19	ABBV	Stock	107.97	108.73	107.12	108.61	4542900.0
2021-04-19	ABC-DELISTED	Stock	120.0	120.8	118.92	119.47	829604.0
2021-04-19	ABCB	Stock	51.14	52.0	50.33	50.73	381300.0
2021-04-19	ABCL	Stock	29.21	29.904	29.101	29.65	698300.0
2021-04-19	ABCM-DELISTED	Stock	20.14	20.34	19.86	20.31	50753.0
2021-04-19	ABEO	Stock	36.5	37.25	34.0	35.25	47496.0
2021-04-19	ABEV	Stock	2.84	2.93	2.83	2.86	23289500.0
2021-04-19	ABG	Stock	207.57	207.57	202.99	205.64	170300.0
2021-04-19	ABGI-DELISTED	Stock	9.92	9.97	9.89	9.94	21210.0
2021-04-19	ABM	Stock	53.36	53.36	52.19	52.58	208500.0
2021-04-19	ABMD-DELISTED	Stock	328.01	333.05	327.1825	329.34	95916.0
2021-04-19	ABNB	Stock	177.32	178.72	171.5	174.58	3125700.0
2021-04-19	ABR	Stock	16.58	16.64	16.38	16.43	836100.0

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

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