PREVIEW / stock_daily / 2021-02-16

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-16.parquet
  size:    249 KB
  rows:    7,540
  symbols: 2,797

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-02-16	AAPL	Stock	135.49	136.01	132.79	133.19	80576300.0
2021-02-16	MSFT	Stock	245.03	246.13	242.92	243.7	26728500.0
2021-02-16	NVDA	Stock	15.0642	15.3725	14.95	15.3302	321960000.0
2021-02-16	AMZN	Stock	162.7025	165.415	162.6795	163.4475	51494000.0
2021-02-16	GOOGL	Stock	104.5875	107.257	104.5875	105.535	31003900.0
2021-02-16	META	Stock	270.8	276.6	270.05	273.97	15417200.0
2021-02-16	TSLA	Stock	272.6667	273.6667	264.1467	265.4067	59406900.0
2021-02-16	TLT	Stock	145.22	145.655	144.6625	144.87	17789087.0
2021-02-16	ES	Stock	85.44	85.44	83.45	83.89	1251600.0
2021-02-16	CL	Stock	78.05	78.22	77.07	78.19	5147600.0
2021-02-16	A	Stock	129.31	131.08	127.85	127.95	2132500.0
2021-02-16	AA	Stock	22.09	22.62	22.055	22.43	4264300.0
2021-02-16	AACG	Stock	5.77	6.34	5.7	5.9	1548600.0
2021-02-16	AACQ-DELISTED	Stock	13.17	14.0	12.76	13.9999	13780876.0
2021-02-16	AACQU-DELISTED	Stock	14.72	15.27	13.9	15.25	1080095.0
2021-02-16	AACQW-DELISTED	Stock	4.03	4.14	3.54	3.97	3246806.0
2021-02-16	AAIC-DELISTED	Stock	3.89	4.1	3.84	4.07	511949.0
2021-02-16	AAIC.C-DELISTED	Stock	22.59	22.59	22.43	22.4998	9550.0
2021-02-16	AAL	Stock	17.63	17.9	17.51	17.82	33615500.0
2021-02-16	AAM.A-DELISTED	Stock	26.1	26.14	26.05	26.08	24154.0
2021-02-16	AAM.B-DELISTED	Stock	26.9	26.9	26.6	26.6	12853.0
2021-02-16	AAMC-DELISTED	Stock	7.5294	7.6809	7.3529	7.3529	14970.0
2021-02-16	AAME	Stock	5.56	5.71	5.21	5.38	559900.0
2021-02-16	AAMI	Stock	20.07	20.68	19.63	20.47	367600.0
2021-02-16	AAN-DELISTED	Stock	20.03	20.35	19.5	20.26	434000.0
2021-02-16	AAOI	Stock	12.3	12.97	12.08	12.83	746000.0
2021-02-16	AAON	Stock	52.7667	52.8933	51.0867	51.2067	232650.0
2021-02-16	AAP	Stock	151.01	157.99	151.01	155.51	1932900.0
2021-02-16	AAT	Stock	30.24	30.24	28.88	29.19	501500.0
2021-02-16	AAU-DELISTED	Stock	0.96	1.01	0.9306	0.9306	7223405.0
2021-02-16	AAUAF-DELISTED	Stock	0.96	1.01	0.9306	0.94	7445517.0
2021-02-16	AAWW-DELISTED	Stock	56.7	57.425	54.7	55.0	335555.0
2021-02-16	AAXJ	Stock	102.29	102.44	101.62	101.83	901726.0
2021-02-16	AB	Stock	38.39	38.94	38.15	38.37	657700.0
2021-02-16	ABB-DELISTED	Stock	29.71	30.02	29.69	29.75	1136449.0
2021-02-16	ABBNY-DELISTED	Stock	29.71	30.02	29.69	29.74	1229189.0
2021-02-16	ABBV	Stock	105.33	106.19	104.02	104.2	5637300.0
2021-02-16	ABC-DELISTED	Stock	105.62	105.62	103.08	103.31	585297.0
2021-02-16	ABCB	Stock	46.64	47.05	45.95	46.81	259600.0
2021-02-16	ABCL	Stock	44.198	44.7	42.6	44.04	1443100.0
2021-02-16	ABCM-DELISTED	Stock	23.79	23.91	23.43	23.77	35400.0
2021-02-16	ABEO	Stock	75.0	77.25	67.75	68.0	291776.0
2021-02-16	ABEV	Stock	2.8	2.89	2.8	2.88	18845200.0
2021-02-16	ABG	Stock	158.56	161.87	155.06	157.0	226100.0
2021-02-16	ABM	Stock	41.41	41.51	40.82	41.38	327400.0
2021-02-16	ABMD-DELISTED	Stock	330.67	334.49	319.22	322.91	187519.0
2021-02-16	ABNB	Stock	216.24	218.78	209.09	209.86	3487900.0
2021-02-16	ABR	Stock	15.5	15.93	15.39	15.85	1110300.0
2021-02-16	ABR.A-DELISTED	Stock	25.6	25.63	25.6	25.62	1400.0
2021-02-16	ABR.B-DELISTED	Stock	25.39	25.4	25.3	25.3597	878.0

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

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