PREVIEW / stock_daily / 2021-11-03

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-03.parquet
  size:    261 KB
  rows:    7,995
  symbols: 2,693

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-11-03	AAPL	Stock	150.39	151.97	149.82	151.49	54511500.0
2021-11-03	MSFT	Stock	333.9	334.9	330.65	334.0	21500100.0
2021-11-03	NVDA	Stock	26.67	26.784	26.235	26.598	239910000.0
2021-11-03	AMZN	Stock	165.45	169.746	164.876	169.2	67944000.0
2021-11-03	GOOGL	Stock	145.9005	146.669	144.591	146.598	27493240.0
2021-11-03	META	Stock	327.49	332.15	323.2	331.62	20786500.0
2021-11-03	TSLA	Stock	392.4433	405.13	384.2067	404.62	103885500.0
2021-11-03	TLT	Stock	147.82	147.98	145.53	145.57	20639350.0
2021-11-03	ES	Stock	85.2	86.35	83.47	84.52	1215500.0
2021-11-03	CL	Stock	76.32	77.29	75.96	77.27	3916000.0
2021-11-03	A	Stock	158.03	158.29	154.57	158.2	1256500.0
2021-11-03	AA	Stock	47.2	48.65	46.76	47.43	6552200.0
2021-11-03	AAC-DELISTED	Stock	9.82	9.83	9.79	9.81	432411.0
2021-11-03	AACG	Stock	2.34	2.4	2.34	2.38	10500.0
2021-11-03	AACIU	Stock	9.89	9.95	9.89	9.9	512731.0
2021-11-03	AAIC-DELISTED	Stock	3.85	3.88	3.85	3.86	70484.0
2021-11-03	AAIC.C-DELISTED	Stock	25.51	25.52	25.51	25.52	659.0
2021-11-03	AAL	Stock	19.82	20.67	19.73	20.63	35014100.0
2021-11-03	AAM.A-DELISTED	Stock	26.06	26.1	26.02	26.0621	11245.0
2021-11-03	AAM.B-DELISTED	Stock	27.07	27.07	26.959	26.959	3702.0
2021-11-03	AAMC-DELISTED	Stock	7.3118	7.5647	7.3118	7.3853	14246.0
2021-11-03	AAME	Stock	4.25	4.54	4.25	4.49	45600.0
2021-11-03	AAMI	Stock	30.35	30.5	30.0	30.13	714500.0
2021-11-03	AAN-DELISTED	Stock	25.38	26.69	25.26	26.58	252100.0
2021-11-03	AAOI	Stock	7.89	8.46	7.84	8.37	709900.0
2021-11-03	AAON	Stock	47.7067	48.6667	46.9467	48.4333	150300.0
2021-11-03	AAP	Stock	226.72	232.0	226.72	230.96	635300.0
2021-11-03	AAQC-DELISTED	Stock	9.77	9.77	9.73	9.77	1331.0
2021-11-03	AAT	Stock	38.06	39.27	38.06	38.85	593800.0
2021-11-03	AATC	Stock	7.0	7.0	6.83	6.99	12379.0
2021-11-03	AAU-DELISTED	Stock	0.37	0.3768	0.3691	0.3712	701820.0
2021-11-03	AAUAF-DELISTED	Stock	0.37	0.377	0.3691	0.3712	768675.0
2021-11-03	AAWW-DELISTED	Stock	88.175	90.7	85.01	88.4	782265.0
2021-11-03	AAXJ	Stock	85.9	86.51	85.66	86.38	889285.0
2021-11-03	AB	Stock	56.0	56.48	55.81	56.34	220500.0
2021-11-03	ABB-DELISTED	Stock	34.5	34.81	34.2	34.75	1269591.0
2021-11-03	ABBNY-DELISTED	Stock	34.5	34.81	34.2	34.74	1607403.0
2021-11-03	ABBV	Stock	116.53	117.61	116.24	117.57	6186900.0
2021-11-03	ABC-DELISTED	Stock	124.82	128.62	124.58	128.32	780511.0
2021-11-03	ABCB	Stock	53.39	54.86	52.48	54.29	386600.0
2021-11-03	ABCL	Stock	17.93	17.93	17.2	17.62	898500.0
2021-11-03	ABCM-DELISTED	Stock	23.09	23.25	22.83	23.14	30732.0
2021-11-03	ABEO	Stock	22.0	23.5	22.0	22.75	26864.0
2021-11-03	ABEV	Stock	3.04	3.18	3.03	3.14	35388300.0
2021-11-03	ABG	Stock	184.0	186.0	179.11	182.2	2401500.0
2021-11-03	ABGI-DELISTED	Stock	9.76	9.79	9.76	9.79	9709.0
2021-11-03	ABM	Stock	44.98	45.99	44.96	45.66	343000.0
2021-11-03	ABMD-DELISTED	Stock	351.0	358.39	342.69	358.29	230553.0
2021-11-03	ABNB	Stock	171.89	173.75	170.93	172.87	2827100.0
2021-11-03	ABOS	Stock	13.61	14.54	13.342	14.42	32700.0

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

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