PREVIEW / stock_daily / 2019-12-03

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-03.parquet
  size:    222 KB
  rows:    6,606
  symbols: 2,448

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
2019-12-03	AAPL	Stock	64.5775	64.8825	64.0725	64.8625	114430400.0
2019-12-03	MSFT	Stock	147.49	149.43	146.65	149.31	24066000.0
2019-12-03	NVDA	Stock	5.0468	5.1955	5.0093	5.1915	465232000.0
2019-12-03	AMZN	Stock	88.0	88.6435	87.3615	88.498	67618000.0
2019-12-03	GOOGL	Stock	63.933	64.8615	63.8525	64.737	29600520.0
2019-12-03	META	Stock	197.6	198.93	195.08	198.82	11595300.0
2019-12-03	TSLA	Stock	22.1747	22.5273	22.146	22.4133	98605500.0
2019-12-03	TLT	Stock	140.04	141.77	139.93	141.21	13323804.0
2019-12-03	ES	Stock	82.34	82.55	81.64	82.03	1652300.0
2019-12-03	CL	Stock	67.63	67.63	66.8	67.3	3677000.0
2019-12-03	A	Stock	79.52	80.11	79.17	80.1	1978200.0
2019-12-03	AA	Stock	19.97	20.01	19.52	19.79	3053700.0
2019-12-03	AACG	Stock	1.8	1.8	1.74	1.74	3200.0
2019-12-03	AAIC-DELISTED	Stock	5.79	5.84	5.775	5.83	249747.0
2019-12-03	AAIC.C-DELISTED	Stock	22.22	22.22	22.0	22.18	5265.0
2019-12-03	AAL	Stock	27.73	27.77	26.96	27.29	7736600.0
2019-12-03	AAM.A-DELISTED	Stock	26.11	26.15	25.99	26.15	17641.0
2019-12-03	AAM.B-DELISTED	Stock	26.31	26.52	26.31	26.38	19094.0
2019-12-03	AAMC-DELISTED	Stock	3.8235	3.9706	3.6574	3.9559	34051.0
2019-12-03	AAME	Stock	1.48	1.81	1.48	1.79	4400.0
2019-12-03	AAMI	Stock	9.62	9.67	9.41	9.42	674700.0
2019-12-03	AAOI	Stock	10.47	10.55	10.16	10.35	568500.0
2019-12-03	AAON	Stock	32.1	32.3267	31.6667	31.72	150150.0
2019-12-03	AAP	Stock	155.25	155.25	151.88	152.61	1047200.0
2019-12-03	AAT	Stock	46.75	47.18	46.74	47.07	277300.0
2019-12-03	AAU-DELISTED	Stock	0.48	0.5379	0.4794	0.5239	309229.0
2019-12-03	AAUAF-DELISTED	Stock	0.48	0.5379	0.4794	0.5239	337127.0
2019-12-03	AAWW-DELISTED	Stock	24.77	24.92	24.15	24.68	249777.0
2019-12-03	AAXJ	Stock	68.72	69.03	68.46	69.0	906976.0
2019-12-03	AAXN-DELISTED	Stock	72.31	74.125	71.31	73.85	476849.0
2019-12-03	AB	Stock	28.35	28.81	28.2	28.4	355000.0
2019-12-03	ABB-DELISTED	Stock	21.72	21.865	21.59	21.855	1863351.0
2019-12-03	ABBNY-DELISTED	Stock	21.72	21.865	21.59	21.85	1957402.0
2019-12-03	ABBV	Stock	85.96	86.48	85.59	85.95	10054500.0
2019-12-03	ABC-DELISTED	Stock	87.19	87.56	86.54	87.43	703481.0
2019-12-03	ABCB	Stock	42.91	43.01	42.26	42.76	401200.0
2019-12-03	ABDC-DELISTED	Stock	9.05	9.05	8.9345	9.0	63348.0
2019-12-03	ABEO	Stock	93.0	96.0	79.25	81.25	48136.0
2019-12-03	ABEOW-DELISTED	Stock	0.15	0.15	0.1399	0.1399	855.0
2019-12-03	ABEV	Stock	4.23	4.26	4.2	4.24	16484100.0
2019-12-03	ABG	Stock	108.75	109.39	108.26	108.6	184800.0
2019-12-03	ABIL-DELISTED	Stock	0.67	0.81	0.5	0.5251	9673160.0
2019-12-03	ABM	Stock	37.38	37.62	37.04	37.62	160100.0
2019-12-03	ABMD-DELISTED	Stock	190.31	193.1	188.31	191.14	311623.0
2019-12-03	ABR	Stock	14.8	14.94	14.76	14.89	1131200.0
2019-12-03	ABR.A-DELISTED	Stock	26.0786	26.2	26.0786	26.19	1474.0
2019-12-03	ABR.B-DELISTED	Stock	25.8258	25.906	25.8	25.906	934.0
2019-12-03	ABR.C-DELISTED	Stock	26.1859	26.1859	26.1622	26.1622	1318.0
2019-12-03	ABT	Stock	83.59	84.42	83.27	84.36	2912400.0
2019-12-03	ABTC	Stock	275700.0	375000.0	249600.0	375000.0	57.266666666666666

> showing 50 of 6,606 rows — these rows as CSV

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