PREVIEW / stock_daily / 2021-05-03

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-03.parquet
  size:    257 KB
  rows:    7,838
  symbols: 2,971

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-05-03	AAPL	Stock	132.04	134.07	131.83	132.54	75135100.0
2021-05-03	MSFT	Stock	253.4	254.35	251.12	251.86	19626600.0
2021-05-03	NVDA	Stock	15.125	15.2468	14.7875	14.8368	203912000.0
2021-05-03	AMZN	Stock	174.2365	174.3325	168.635	169.3245	117510000.0
2021-05-03	GOOGL	Stock	118.2455	119.0775	116.775	117.154	28242780.0
2021-05-03	META	Stock	326.17	328.55	321.84	322.58	18719500.0
2021-05-03	TSLA	Stock	234.6	235.3333	226.8333	228.3	81129300.0
2021-05-03	TLT	Stock	138.7	139.645	138.28	138.52	16447651.0
2021-05-03	ES	Stock	86.26	87.44	85.8	86.42	1653500.0
2021-05-03	CL	Stock	80.84	81.25	80.19	81.07	3709100.0
2021-05-03	A	Stock	134.29	134.31	132.61	133.19	1032000.0
2021-05-03	AA	Stock	37.18	38.055	36.05	37.61	4657700.0
2021-05-03	AAC-DELISTED	Stock	9.87	9.87	9.8	9.82	2187049.0
2021-05-03	AACG	Stock	3.09	3.29	3.0	3.03	119000.0
2021-05-03	AACQ-DELISTED	Stock	10.11	10.15	10.02	10.07	1088412.0
2021-05-03	AACQU-DELISTED	Stock	10.79	10.8	10.6	10.75	2159.0
2021-05-03	AACQW-DELISTED	Stock	1.84	1.9499	1.8	1.85	259391.0
2021-05-03	AAIC-DELISTED	Stock	4.13	4.19	4.09	4.15	211132.0
2021-05-03	AAIC.C-DELISTED	Stock	24.49	24.49	24.4	24.475	1344.0
2021-05-03	AAL	Stock	21.87	22.01	21.4	21.95	27606100.0
2021-05-03	AAM.A-DELISTED	Stock	26.14	26.21	26.11	26.2	15446.0
2021-05-03	AAM.B-DELISTED	Stock	26.9	27.17	26.9	27.17	12177.0
2021-05-03	AAMC-DELISTED	Stock	5.0294	5.3324	5.0294	5.2118	156934.0
2021-05-03	AAME	Stock	4.06	4.23	3.98	4.22	264900.0
2021-05-03	AAMI	Stock	22.73	22.98	22.62	22.82	471100.0
2021-05-03	AAN-DELISTED	Stock	31.31	31.44	30.5	30.71	494100.0
2021-05-03	AAOI	Stock	7.49	7.545	7.22	7.3	852600.0
2021-05-03	AAON	Stock	44.06	44.5	43.6533	44.1333	327450.0
2021-05-03	AAP	Stock	201.34	203.63	201.34	201.86	780700.0
2021-05-03	AAT	Stock	35.29	35.5	34.92	35.17	399300.0
2021-05-03	AAU-DELISTED	Stock	0.6	0.6	0.55	0.5751	1251569.0
2021-05-03	AAUAF-DELISTED	Stock	0.6	0.6	0.55	0.5742	1288074.0
2021-05-03	AAWW-DELISTED	Stock	69.13	70.64	68.13	70.6	268299.0
2021-05-03	AAXJ	Stock	93.54	93.875	93.16	93.51	384594.0
2021-05-03	AB	Stock	43.42	44.99	43.17	44.58	627800.0
2021-05-03	ABB-DELISTED	Stock	32.85	32.9681	32.81	32.9	702158.0
2021-05-03	ABBNY-DELISTED	Stock	32.85	32.9681	32.81	32.89	775374.0
2021-05-03	ABBV	Stock	112.4	115.1	111.59	114.68	9138200.0
2021-05-03	ABC-DELISTED	Stock	121.52	124.28	121.51	123.86	1005009.0
2021-05-03	ABCB	Stock	54.89	55.29	53.46	54.48	578000.0
2021-05-03	ABCL	Stock	27.0	27.22	25.5	26.0	697000.0
2021-05-03	ABCM-DELISTED	Stock	21.66	22.2299	21.57	22.0	105052.0
2021-05-03	ABEO	Stock	46.5	51.0	45.5	50.75	257612.0
2021-05-03	ABEV	Stock	2.78	2.8	2.73	2.75	18013000.0
2021-05-03	ABG	Stock	201.0	205.34	200.12	202.22	187500.0
2021-05-03	ABGI-DELISTED	Stock	10.0	10.0	9.97	10.0	28919.0
2021-05-03	ABM	Stock	52.11	53.93	51.75	53.48	735500.0
2021-05-03	ABMD-DELISTED	Stock	317.88	319.92	305.51	308.43	250553.0
2021-05-03	ABNB	Stock	173.19	173.44	167.8	168.11	3149700.0
2021-05-03	ABR	Stock	17.83	17.95	17.68	17.82	1020700.0

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

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