PREVIEW / stock_daily / 2021-11-04

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-04.parquet
  size:    261 KB
  rows:    7,957
  symbols: 2,665

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-04	AAPL	Stock	151.58	152.43	150.64	150.96	60394600.0
2021-11-04	MSFT	Stock	332.89	336.54	329.51	336.44	23992200.0
2021-11-04	NVDA	Stock	27.229	31.365	27.118	29.801	1153631000.0
2021-11-04	AMZN	Stock	168.5	174.9315	168.25	173.85	107060000.0
2021-11-04	GOOGL	Stock	147.1245	149.7335	146.308	148.2675	38411260.0
2021-11-04	META	Stock	334.01	337.27	332.65	335.85	22495300.0
2021-11-04	TSLA	Stock	411.47	414.4967	405.6667	409.97	76192200.0
2021-11-04	TLT	Stock	145.87	147.36	145.85	147.1	15922377.0
2021-11-04	ES	Stock	84.42	84.74	82.73	83.82	1060200.0
2021-11-04	CL	Stock	76.89	77.53	76.87	77.29	3407000.0
2021-11-04	A	Stock	157.86	158.93	156.36	157.65	1015800.0
2021-11-04	AA	Stock	47.5	47.62	45.29	46.37	11378800.0
2021-11-04	AAC-DELISTED	Stock	9.818	9.82	9.8	9.8	26718.0
2021-11-04	AACG	Stock	2.36	2.38	2.27	2.33	21300.0
2021-11-04	AACIU	Stock	9.9	9.932	9.9	9.932	8959.0
2021-11-04	AAIC-DELISTED	Stock	3.86	3.88	3.83	3.84	104255.0
2021-11-04	AAL	Stock	20.73	20.84	20.35	20.63	23940500.0
2021-11-04	AAM.A-DELISTED	Stock	26.03	26.1	26.03	26.09	24913.0
2021-11-04	AAM.B-DELISTED	Stock	27.0949	27.0949	26.94	27.03	10936.0
2021-11-04	AAMC-DELISTED	Stock	7.3788	7.3788	7.2559	7.3765	11638.0
2021-11-04	AAME	Stock	4.51	4.55	4.32	4.4	9500.0
2021-11-04	AAMI	Stock	30.11	30.475	29.59	30.05	4776400.0
2021-11-04	AAN-DELISTED	Stock	26.28	26.7	24.89	25.2	317500.0
2021-11-04	AAOI	Stock	8.51	8.86	8.38	8.64	1252400.0
2021-11-04	AAON	Stock	48.4	50.08	48.4	49.3067	178500.0
2021-11-04	AAP	Stock	231.01	232.7	228.81	230.09	543100.0
2021-11-04	AAQC-DELISTED	Stock	9.75	9.84	9.75	9.84	68994.0
2021-11-04	AAT	Stock	38.87	39.06	38.17	38.33	202600.0
2021-11-04	AATC	Stock	7.0	7.0	6.84	7.0	18010.0
2021-11-04	AAU-DELISTED	Stock	0.38	0.38	0.372	0.3778	588020.0
2021-11-04	AAUAF-DELISTED	Stock	0.38	0.38	0.372	0.378	613311.0
2021-11-04	AAWW-DELISTED	Stock	89.33	91.175	88.33	89.5	500235.0
2021-11-04	AAXJ	Stock	86.39	86.71	85.88	86.28	769529.0
2021-11-04	AB	Stock	56.45	57.13	56.29	56.86	236700.0
2021-11-04	ABB-DELISTED	Stock	34.65	34.76	34.6	34.74	995535.0
2021-11-04	ABBNY-DELISTED	Stock	34.65	34.76	34.6	34.74	1094872.0
2021-11-04	ABBV	Stock	117.57	117.72	116.33	117.06	4912200.0
2021-11-04	ABC-DELISTED	Stock	126.0	128.09	123.2	126.85	703112.0
2021-11-04	ABCB	Stock	53.92	54.36	52.77	53.63	246300.0
2021-11-04	ABCL	Stock	17.57	17.7	16.96	17.37	775600.0
2021-11-04	ABCM-DELISTED	Stock	22.82	23.11	22.755	23.0	26722.0
2021-11-04	ABEO	Stock	23.0	23.0	22.25	22.5	21988.0
2021-11-04	ABEV	Stock	3.15	3.16	3.09	3.14	28484400.0
2021-11-04	ABG	Stock	182.14	185.84	181.81	184.48	2135100.0
2021-11-04	ABGI-DELISTED	Stock	9.79	9.8	9.75	9.8	12000.0
2021-11-04	ABM	Stock	45.86	46.5	45.69	46.31	261600.0
2021-11-04	ABMD-DELISTED	Stock	358.34	365.63	356.89	363.28	100982.0
2021-11-04	ABNB	Stock	175.95	179.435	173.96	178.45	9664600.0
2021-11-04	ABOS	Stock	14.49	14.9	14.3	14.73	37200.0
2021-11-04	ABR	Stock	19.75	19.76	19.48	19.64	1387400.0

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

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