PREVIEW / stock_daily / 2019-01-10

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-10.parquet
  size:    219 KB
  rows:    6,529
  symbols: 2,651

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-01-10	AAPL	Stock	38.125	38.4925	37.715	38.45	143122800.0
2019-01-10	MSFT	Stock	103.22	103.75	102.38	103.6	30067600.0
2019-01-10	NVDA	Stock	3.545	3.6395	3.484	3.6308	523156000.0
2019-01-10	AMZN	Stock	82.0505	83.1625	81.081	82.811	130154000.0
2019-01-10	GOOGL	Stock	53.747	53.9905	53.234	53.9415	26597220.0
2019-01-10	META	Stock	143.08	144.56	140.84	144.2	16125000.0
2019-01-10	TSLA	Stock	22.2933	23.026	22.1193	22.998	90846000.0
2019-01-10	TLT	Stock	121.28	121.41	120.34	120.46	8222860.0
2019-01-10	ES	Stock	64.89	66.15	64.64	66.05	1660300.0
2019-01-10	CL	Stock	61.02	61.87	60.72	61.82	3983100.0
2019-01-10	A	Stock	69.05	69.95	68.6	69.9	1080900.0
2019-01-10	AA	Stock	28.69	29.01	28.48	28.98	2351600.0
2019-01-10	AABA-DELISTED	Stock	62.31	63.15	61.95	63.09	5486804.0
2019-01-10	AAC-DELISTED	Stock	2.4	2.47	2.1401	2.24	277963.0
2019-01-10	AACG	Stock	1.08	1.1	1.02	1.06	51500.0
2019-01-10	AAIC-DELISTED	Stock	8.06	8.06	7.9	7.92	300076.0
2019-01-10	AAL	Stock	30.62	32.21	29.78	32.04	19726300.0
2019-01-10	AAM.A-DELISTED	Stock	23.6527	24.09	23.5	24.08	100265.0
2019-01-10	AAM.B-DELISTED	Stock	23.6	24.0	23.455	23.99	52828.0
2019-01-10	AAMC-DELISTED	Stock	8.8456	8.9706	8.2382	8.7059	14396.0
2019-01-10	AAME	Stock	2.43	2.45	2.43	2.45	600.0
2019-01-10	AAMI	Stock	11.02	11.47	11.01	11.4	482600.0
2019-01-10	AAOI	Stock	16.01	16.49	16.01	16.27	385600.0
2019-01-10	AAON	Stock	24.0533	24.1867	23.8667	24.14	94050.0
2019-01-10	AAP	Stock	163.03	165.23	160.76	165.07	999100.0
2019-01-10	AAT	Stock	40.55	41.2	40.55	40.93	153400.0
2019-01-10	AAU-DELISTED	Stock	0.84	0.8992	0.821	0.86	904501.0
2019-01-10	AAUAF-DELISTED	Stock	0.84	0.8992	0.821	0.86	958268.0
2019-01-10	AAWW-DELISTED	Stock	46.35	47.8	46.015	47.67	158545.0
2019-01-10	AAXJ	Stock	64.98	65.78	64.97	65.74	877235.0
2019-01-10	AAXN-DELISTED	Stock	49.85	50.22	48.81	49.69	453109.0
2019-01-10	AB	Stock	28.06	28.33	27.96	28.16	545200.0
2019-01-10	ABAC-DELISTED	Stock	1.22	1.28	1.2	1.225	20334.0
2019-01-10	ABB-DELISTED	Stock	19.7	19.935	19.68	19.81	1545242.0
2019-01-10	ABBNY-DELISTED	Stock	19.7	19.935	19.68	19.81	1591822.0
2019-01-10	ABBV	Stock	87.88	88.88	87.12	88.2	6527700.0
2019-01-10	ABC-DELISTED	Stock	75.95	76.33	74.78	76.0	1387571.0
2019-01-10	ABCB	Stock	34.39	34.5	33.98	34.38	243100.0
2019-01-10	ABDC-DELISTED	Stock	6.89	6.89	6.76	6.8	38935.0
2019-01-10	ABEO	Stock	182.75	183.5	177.75	180.75	10564.0
2019-01-10	ABEOW-DELISTED	Stock	2.92	2.92	2.82	2.86	18695.0
2019-01-10	ABEV	Stock	4.36	4.54	4.36	4.5	40476400.0
2019-01-10	ABG	Stock	69.51	69.58	67.64	68.96	316100.0
2019-01-10	ABIL-DELISTED	Stock	1.92	1.93	1.88	1.88	153752.0
2019-01-10	ABM	Stock	34.88	35.26	34.37	35.19	494100.0
2019-01-10	ABMD-DELISTED	Stock	334.1	340.87	322.77	335.29	389315.0
2019-01-10	ABR	Stock	11.23	11.33	11.08	11.29	1052100.0
2019-01-10	ABR.A-DELISTED	Stock	25.4666	25.55	25.36	25.55	800.0
2019-01-10	ABR.C-DELISTED	Stock	25.85	25.95	25.5	25.83	10653.0
2019-01-10	ABT	Stock	68.68	69.44	68.45	69.08	8051200.0

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

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