PREVIEW / stock_daily / 2019-12-10

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-10.parquet
  size:    221 KB
  rows:    6,594
  symbols: 2,447

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-10	AAPL	Stock	67.15	67.5175	66.465	67.12	90420400.0
2019-12-10	MSFT	Stock	151.29	151.89	150.76	151.13	16476100.0
2019-12-10	NVDA	Stock	5.3345	5.4015	5.2815	5.3495	256388000.0
2019-12-10	AMZN	Stock	87.37	87.5335	86.75	86.9605	50286000.0
2019-12-10	GOOGL	Stock	66.997	67.4	66.7	67.1445	17608600.0
2019-12-10	META	Stock	201.66	202.05	200.15	200.87	9475700.0
2019-12-10	TSLA	Stock	22.664	23.382	22.6207	23.256	132424500.0
2019-12-10	TLT	Stock	139.18	139.35	138.41	138.66	4947745.0
2019-12-10	ES	Stock	80.76	81.16	80.63	80.98	1127800.0
2019-12-10	CL	Stock	68.31	68.67	67.85	67.93	3820600.0
2019-12-10	A	Stock	82.9	83.8	82.7	82.93	3067700.0
2019-12-10	AA	Stock	20.22	20.72	20.19	20.65	3175800.0
2019-12-10	AACG	Stock	1.59	1.61	1.54	1.55	6200.0
2019-12-10	AAIC-DELISTED	Stock	5.91	5.92	5.83	5.85	190339.0
2019-12-10	AAIC.C-DELISTED	Stock	21.9948	22.0	21.9948	22.0	400.0
2019-12-10	AAL	Stock	27.55	27.63	26.9	27.0	7538700.0
2019-12-10	AAM.A-DELISTED	Stock	26.16	26.27	26.16	26.27	12613.0
2019-12-10	AAM.B-DELISTED	Stock	26.54	26.6086	26.54	26.6	11780.0
2019-12-10	AAMC-DELISTED	Stock	4.072	4.072	3.8265	3.9676	9156.0
2019-12-10	AAME	Stock	2.0	2.0	1.75	1.93	1300.0
2019-12-10	AAMI	Stock	10.05	10.37	10.0	10.26	552400.0
2019-12-10	AAOI	Stock	10.3	10.39	10.16	10.28	214000.0
2019-12-10	AAON	Stock	32.9933	33.04	32.2267	32.4067	186450.0
2019-12-10	AAP	Stock	153.18	157.34	152.44	156.17	1510600.0
2019-12-10	AAT	Stock	47.79	47.84	47.1	47.36	270400.0
2019-12-10	AAU-DELISTED	Stock	0.48	0.4999	0.475	0.484	234330.0
2019-12-10	AAUAF-DELISTED	Stock	0.48	0.4999	0.475	0.4828	264483.0
2019-12-10	AAWW-DELISTED	Stock	26.6	26.72	26.22	26.32	192895.0
2019-12-10	AAXJ	Stock	70.02	70.21	69.88	70.13	1819523.0
2019-12-10	AAXN-DELISTED	Stock	72.93	72.93	72.16	72.65	315000.0
2019-12-10	AB	Stock	28.5	28.92	28.49	28.75	388700.0
2019-12-10	ABB-DELISTED	Stock	22.57	22.75	22.49	22.68	2103918.0
2019-12-10	ABBNY-DELISTED	Stock	22.58	22.75	22.49	22.68	2238194.0
2019-12-10	ABBV	Stock	86.92	86.95	86.21	86.56	7816000.0
2019-12-10	ABC-DELISTED	Stock	86.37	87.05	84.9	86.79	1497440.0
2019-12-10	ABCB	Stock	43.34	43.67	43.15	43.35	170500.0
2019-12-10	ABDC-DELISTED	Stock	8.96	9.08	8.96	9.06	19262.0
2019-12-10	ABEO	Stock	71.75	83.75	68.5	82.0	86224.0
2019-12-10	ABEOW-DELISTED	Stock	0.16	0.16	0.1499	0.1499	4333.0
2019-12-10	ABEV	Stock	4.45	4.46	4.38	4.4	15397500.0
2019-12-10	ABG	Stock	110.18	110.82	109.27	110.15	227900.0
2019-12-10	ABIL-DELISTED	Stock	0.62	0.637	0.5502	0.5999	294062.0
2019-12-10	ABM	Stock	38.23	38.37	37.91	38.07	197200.0
2019-12-10	ABMD-DELISTED	Stock	182.16	185.02	178.05	179.88	416212.0
2019-12-10	ABR	Stock	14.33	14.53	14.19	14.29	6380400.0
2019-12-10	ABR.A-DELISTED	Stock	26.21	26.2341	25.95	25.95	677.0
2019-12-10	ABR.B-DELISTED	Stock	25.99	25.99	25.7976	25.8022	1361.0
2019-12-10	ABR.C-DELISTED	Stock	26.1589	26.2427	26.02	26.2427	550.0
2019-12-10	ABT	Stock	83.88	84.63	83.76	84.56	3904900.0
2019-12-10	ABTC	Stock	349200.0	388200.0	348000.0	348000.0	12.6

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

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