PREVIEW / stock_daily / 2021-11-02

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-02.parquet
  size:    261 KB
  rows:    7,962
  symbols: 2,664

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-02	AAPL	Stock	148.66	151.57	148.65	150.02	69122000.0
2021-11-02	MSFT	Stock	330.31	333.45	330.0	333.13	26487100.0
2021-11-02	NVDA	Stock	25.822	26.678	25.8	26.401	294112000.0
2021-11-02	AMZN	Stock	165.7505	166.556	164.1775	165.6375	52552000.0
2021-11-02	GOOGL	Stock	144.5795	146.609	144.3355	145.4325	33482240.0
2021-11-02	META	Stock	331.38	334.79	323.8	328.08	28353000.0
2021-11-02	TSLA	Stock	386.4533	402.8633	382.0	390.6667	128213400.0
2021-11-02	TLT	Stock	146.5	147.57	146.5	147.09	9836737.0
2021-11-02	ES	Stock	85.25	85.52	83.83	84.55	1440900.0
2021-11-02	CL	Stock	75.79	76.61	75.57	76.27	4132200.0
2021-11-02	A	Stock	157.55	158.0	155.44	157.85	1714200.0
2021-11-02	AA	Stock	46.86	47.48	45.9	47.08	10040500.0
2021-11-02	AAC-DELISTED	Stock	9.84	9.84	9.81	9.83	58748.0
2021-11-02	AACG	Stock	2.27	2.37	2.27	2.37	20500.0
2021-11-02	AACIU	Stock	9.92	9.92	9.88	9.88	137133.0
2021-11-02	AAIC-DELISTED	Stock	3.86	3.89	3.85	3.87	71977.0
2021-11-02	AAIC.C-DELISTED	Stock	25.45	25.55	25.25	25.55	2145.0
2021-11-02	AAL	Stock	19.67	19.89	19.57	19.83	19979100.0
2021-11-02	AAM.A-DELISTED	Stock	26.05	26.09	26.01	26.0342	7303.0
2021-11-02	AAM.B-DELISTED	Stock	26.92	27.09	26.9101	26.93	21640.0
2021-11-02	AAMC-DELISTED	Stock	7.2588	7.7912	7.2588	7.7618	5967.0
2021-11-02	AAME	Stock	4.26	4.35	4.12	4.27	17200.0
2021-11-02	AAMI	Stock	29.96	30.71	29.96	30.37	1010800.0
2021-11-02	AAN-DELISTED	Stock	25.38	25.66	24.89	25.59	260600.0
2021-11-02	AAOI	Stock	7.76	8.0	7.72	7.86	666800.0
2021-11-02	AAON	Stock	48.3333	48.7667	47.7133	47.9133	232650.0
2021-11-02	AAP	Stock	225.09	228.56	224.5	226.77	397400.0
2021-11-02	AAQC-DELISTED	Stock	9.75	9.75	9.74	9.75	50734.0
2021-11-02	AAT	Stock	39.01	39.01	38.04	38.15	260000.0
2021-11-02	AATC	Stock	6.89	6.9492	6.85	6.93	5942.0
2021-11-02	AAU-DELISTED	Stock	0.3801	0.3801	0.3701	0.3731	670787.0
2021-11-02	AAUAF-DELISTED	Stock	0.3801	0.3801	0.3701	0.3731	699849.0
2021-11-02	AAWW-DELISTED	Stock	83.63	86.64	83.18	83.92	622223.0
2021-11-02	AAXJ	Stock	86.37	86.37	86.0	86.04	1307729.0
2021-11-02	AB	Stock	57.2	57.22	55.81	56.12	264200.0
2021-11-02	ABB-DELISTED	Stock	33.46	33.83	33.44	33.83	1768816.0
2021-11-02	ABBNY-DELISTED	Stock	33.46	33.83	33.44	33.81	2543488.0
2021-11-02	ABBV	Stock	115.25	117.69	115.16	116.53	10357800.0
2021-11-02	ABC-DELISTED	Stock	124.49	126.48	122.74	125.18	889733.0
2021-11-02	ABCB	Stock	54.02	54.36	52.8	52.97	353600.0
2021-11-02	ABCL	Stock	16.96	17.9	16.57	17.73	1777500.0
2021-11-02	ABCM-DELISTED	Stock	22.79	23.04	22.7	22.97	44545.0
2021-11-02	ABEO	Stock	23.0	23.25	22.25	22.75	32592.0
2021-11-02	ABEV	Stock	3.03	3.05	2.97	3.0	18698100.0
2021-11-02	ABG	Stock	196.47	197.0	184.14	184.88	510900.0
2021-11-02	ABGI-DELISTED	Stock	9.78	9.78	9.77	9.78	10800.0
2021-11-02	ABM	Stock	45.38	45.85	45.14	45.28	205100.0
2021-11-02	ABMD-DELISTED	Stock	347.88	351.598	337.21	350.26	196504.0
2021-11-02	ABNB	Stock	174.95	175.3	170.58	172.87	3292100.0
2021-11-02	ABOS	Stock	13.7	14.91	13.1	13.54	51700.0

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

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