PREVIEW / stock_daily / 2021-03-02

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-02.parquet
  size:    248 KB
  rows:    7,549
  symbols: 2,815

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-03-02	AAPL	Stock	128.41	128.72	125.01	125.12	102260900.0
2021-03-02	MSFT	Stock	237.01	237.3	233.45	233.87	22812500.0
2021-03-02	NVDA	Stock	13.9	13.9205	13.396	13.4062	264116000.0
2021-03-02	AMZN	Stock	157.1735	158.176	154.356	154.7265	51916000.0
2021-03-02	GOOGL	Stock	103.242	104.737	102.8335	103.224	25563680.0
2021-03-02	META	Stock	265.78	266.71	258.65	259.0	15191700.0
2021-03-02	TSLA	Stock	239.4267	240.37	228.3333	228.8133	71196600.0
2021-03-02	TLT	Stock	140.4	141.13	140.295	141.07	12482218.0
2021-03-02	ES	Stock	80.7	81.14	79.52	80.72	1456200.0
2021-03-02	CL	Stock	75.64	76.05	75.26	75.42	4977000.0
2021-03-02	A	Stock	124.57	125.89	123.17	123.64	1267300.0
2021-03-02	AA	Stock	26.2	27.86	26.2	27.5	8530300.0
2021-03-02	AACG	Stock	5.17	5.17	4.91	5.07	128600.0
2021-03-02	AACQ-DELISTED	Stock	11.3473	11.3473	10.65	10.74	3366732.0
2021-03-02	AACQU-DELISTED	Stock	12.18	12.18	11.51	11.51	18880.0
2021-03-02	AACQW-DELISTED	Stock	2.9	2.96	2.56	2.58	540840.0
2021-03-02	AAIC-DELISTED	Stock	4.02	4.175	4.01	4.08	146934.0
2021-03-02	AAIC.C-DELISTED	Stock	21.934	22.2	21.85	22.0	7889.0
2021-03-02	AAL	Stock	21.28	21.63	21.12	21.44	27558200.0
2021-03-02	AAM.A-DELISTED	Stock	25.71	25.86	25.71	25.82	18558.0
2021-03-02	AAM.B-DELISTED	Stock	26.26	26.37	26.24	26.35	30729.0
2021-03-02	AAMC-DELISTED	Stock	7.0588	7.3206	6.8806	7.0589	106243.0
2021-03-02	AAME	Stock	4.78	4.88	4.67	4.7	30300.0
2021-03-02	AAMI	Stock	19.29	19.59	18.98	19.01	678200.0
2021-03-02	AAN-DELISTED	Stock	22.27	22.58	21.64	21.76	226200.0
2021-03-02	AAOI	Stock	8.7	8.84	8.38	8.625	1585500.0
2021-03-02	AAON	Stock	51.38	51.38	49.52	49.9467	217350.0
2021-03-02	AAP	Stock	163.13	166.25	161.19	164.84	847400.0
2021-03-02	AAT	Stock	31.83	32.52	31.19	32.41	472900.0
2021-03-02	AAU-DELISTED	Stock	0.77	0.7731	0.7469	0.7521	1100222.0
2021-03-02	AAUAF-DELISTED	Stock	0.77	0.7731	0.7469	0.7514	1140745.0
2021-03-02	AAWW-DELISTED	Stock	55.17	57.73	55.01	56.49	416999.0
2021-03-02	AAXJ	Stock	96.59	96.59	95.82	95.93	1029174.0
2021-03-02	AB	Stock	37.4	37.75	37.2	37.53	328500.0
2021-03-02	ABB-DELISTED	Stock	29.82	29.89	29.54	29.77	1463672.0
2021-03-02	ABBNY-DELISTED	Stock	29.82	29.89	29.54	29.77	1625927.0
2021-03-02	ABBV	Stock	108.85	109.38	107.81	107.85	5487000.0
2021-03-02	ABC-DELISTED	Stock	103.22	104.36	102.63	104.28	550598.0
2021-03-02	ABCB	Stock	49.23	49.46	48.31	48.97	402400.0
2021-03-02	ABCL	Stock	39.7	40.13	37.41	38.0	300600.0
2021-03-02	ABCM-DELISTED	Stock	22.33	22.98	22.22	22.85	77133.0
2021-03-02	ABEO	Stock	59.0	62.5	58.0	59.0	108392.0
2021-03-02	ABEV	Stock	2.42	2.54	2.38	2.52	48285800.0
2021-03-02	ABG	Stock	172.98	172.98	167.13	167.7	160500.0
2021-03-02	ABGI-DELISTED	Stock	10.32	10.33	10.14	10.14	91783.0
2021-03-02	ABM	Stock	43.86	43.88	43.13	43.33	180600.0
2021-03-02	ABMD-DELISTED	Stock	326.04	327.78	318.46	325.3	120466.0
2021-03-02	ABNB	Stock	195.63	200.0	188.5	189.9	9144900.0
2021-03-02	ABR	Stock	16.47	16.93	16.24	16.68	1808000.0
2021-03-02	ABR.A-DELISTED	Stock	25.94	25.94	25.94	25.94	662.0

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

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