PREVIEW / stock_daily / 2021-05-07

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-07.parquet
  size:    256 KB
  rows:    7,827
  symbols: 2,962

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-05-07	AAPL	Stock	130.85	131.26	129.48	130.21	78973300.0
2021-05-07	MSFT	Stock	252.15	254.3	251.17	252.46	27032900.0
2021-05-07	NVDA	Stock	14.8082	14.9708	14.6718	14.8122	229328000.0
2021-05-07	AMZN	Stock	165.9545	166.5445	164.4535	164.5805	94206000.0
2021-05-07	GOOGL	Stock	118.1945	118.5625	117.3078	117.5965	28897240.0
2021-05-07	META	Stock	322.38	322.94	318.75	319.08	15916700.0
2021-05-07	TSLA	Stock	221.9333	230.0	220.0733	224.1233	70407600.0
2021-05-07	TLT	Stock	140.1	140.6	138.91	139.23	18346877.0
2021-05-07	ES	Stock	84.07	85.0	83.9	84.07	1302500.0
2021-05-07	CL	Stock	82.22	82.54	81.86	82.18	2263700.0
2021-05-07	A	Stock	133.19	134.82	133.19	133.9	1044200.0
2021-05-07	AA	Stock	39.76	41.38	39.25	41.2	4828300.0
2021-05-07	AAC-DELISTED	Stock	9.81	9.86	9.8	9.825	92963.0
2021-05-07	AACG	Stock	2.85	3.0	2.85	2.91	29500.0
2021-05-07	AACQ-DELISTED	Stock	9.92	10.01	9.9	9.94	812070.0
2021-05-07	AACQU-DELISTED	Stock	10.53	10.55	10.5	10.53	5274.0
2021-05-07	AACQW-DELISTED	Stock	1.65	1.8735	1.65	1.74	106965.0
2021-05-07	AAIC-DELISTED	Stock	4.05	4.17	4.05	4.11	390077.0
2021-05-07	AAIC.C-DELISTED	Stock	24.45	24.5	24.337	24.3699	7175.0
2021-05-07	AAL	Stock	21.4	22.19	21.27	22.0	32022900.0
2021-05-07	AAM.A-DELISTED	Stock	26.1	26.24	26.0864	26.24	14614.0
2021-05-07	AAM.B-DELISTED	Stock	26.97	27.12	26.93	27.1	8199.0
2021-05-07	AAMC-DELISTED	Stock	5.3326	5.3353	5.2363	5.2363	8109.0
2021-05-07	AAME	Stock	3.97	4.12	3.97	4.0	52200.0
2021-05-07	AAMI	Stock	23.09	23.44	22.83	22.93	338600.0
2021-05-07	AAN-DELISTED	Stock	31.89	32.86	31.85	32.21	238400.0
2021-05-07	AAOI	Stock	7.16	7.9	6.81	7.58	1067100.0
2021-05-07	AAON	Stock	42.4933	44.3333	42.4933	44.1933	169650.0
2021-05-07	AAP	Stock	202.9	204.98	202.88	204.47	392500.0
2021-05-07	AAT	Stock	34.48	35.24	34.48	35.23	157700.0
2021-05-07	AAU-DELISTED	Stock	0.54	0.5599	0.54	0.5535	1055005.0
2021-05-07	AAUAF-DELISTED	Stock	0.54	0.5599	0.54	0.5561	1108776.0
2021-05-07	AAWW-DELISTED	Stock	71.58	74.55	71.35	74.05	419377.0
2021-05-07	AAXJ	Stock	93.9208	94.605	93.8	94.12	1101704.0
2021-05-07	AB	Stock	44.68	45.4	44.04	44.62	736700.0
2021-05-07	ABB-DELISTED	Stock	33.87	34.175	33.73	34.1	871319.0
2021-05-07	ABBNY-DELISTED	Stock	33.87	34.175	33.73	34.11	972339.0
2021-05-07	ABBV	Stock	116.38	116.93	114.96	115.75	6808200.0
2021-05-07	ABC-DELISTED	Stock	118.15	121.37	117.26	120.86	951507.0
2021-05-07	ABCB	Stock	56.0	57.22	55.63	57.02	400700.0
2021-05-07	ABCL	Stock	28.4	29.9	28.2	29.09	484500.0
2021-05-07	ABCM-DELISTED	Stock	20.74	21.32	20.7	21.29	203827.0
2021-05-07	ABEO	Stock	37.5	40.0	37.5	38.5	31204.0
2021-05-07	ABEV	Stock	3.13	3.16	3.09	3.12	19108100.0
2021-05-07	ABG	Stock	208.52	209.95	206.73	209.02	69900.0
2021-05-07	ABGI-DELISTED	Stock	9.97	9.97	9.97	9.97	400.0
2021-05-07	ABM	Stock	51.99	52.86	51.86	52.81	241900.0
2021-05-07	ABMD-DELISTED	Stock	299.24	303.8609	296.35	296.91	96898.0
2021-05-07	ABNB	Stock	156.5	157.054	148.78	151.21	7134000.0
2021-05-07	ABR	Stock	17.38	17.89	17.27	17.81	1847100.0

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

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