PREVIEW / stock_daily / 2019-05-03

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-03.parquet
  size:    220 KB
  rows:    6,532
  symbols: 2,564

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-05-03	AAPL	Stock	52.7225	52.96	52.5575	52.9375	83569600.0
2019-05-03	MSFT	Stock	127.36	129.43	127.25	128.9	24911100.0
2019-05-03	NVDA	Stock	4.5883	4.5982	4.5132	4.5752	336824000.0
2019-05-03	AMZN	Stock	97.45	98.22	96.8	98.123	127632000.0
2019-05-03	GOOGL	Stock	58.8705	59.57	58.6773	59.4775	41587520.0
2019-05-03	META	Stock	194.38	196.16	193.71	195.47	14575400.0
2019-05-03	TSLA	Stock	16.2573	17.1073	16.2327	17.002	355602000.0
2019-05-03	TLT	Stock	123.66	123.875	123.37	123.66	6191750.0
2019-05-03	ES	Stock	71.62	72.11	71.36	72.08	896500.0
2019-05-03	CL	Stock	71.86	72.06	71.58	71.95	2436700.0
2019-05-03	A	Stock	78.58	79.56	78.58	79.29	1303200.0
2019-05-03	AA	Stock	26.23	26.83	26.05	26.68	3375900.0
2019-05-03	AABA-DELISTED	Stock	77.74	79.18	77.74	79.14	6319270.0
2019-05-03	AAC-DELISTED	Stock	1.63	2.45	1.63	1.97	918654.0
2019-05-03	AACG	Stock	1.69	2.1	1.66	1.81	735800.0
2019-05-03	AAIC-DELISTED	Stock	7.59	7.73	7.59	7.7	419089.0
2019-05-03	AAIC.C-DELISTED	Stock	23.48	23.57	23.4	23.43	15955.0
2019-05-03	AAL	Stock	34.21	34.9	34.15	34.79	5181400.0
2019-05-03	AAM.A-DELISTED	Stock	25.33	25.65	25.33	25.64	40753.0
2019-05-03	AAM.B-DELISTED	Stock	25.4219	25.65	25.4219	25.6	58445.0
2019-05-03	AAMC-DELISTED	Stock	8.2353	8.2353	7.6471	7.7971	19788.0
2019-05-03	AAME	Stock	2.52	2.52	2.52	2.52	100.0
2019-05-03	AAMI	Stock	13.84	14.2	13.62	14.05	712700.0
2019-05-03	AAOI	Stock	12.1	12.63	12.05	12.6	574400.0
2019-05-03	AAON	Stock	33.0533	35.0	32.8733	34.54	229650.0
2019-05-03	AAP	Stock	167.05	167.39	163.19	163.27	760200.0
2019-05-03	AAT	Stock	46.24	46.41	45.79	46.22	148100.0
2019-05-03	AAU-DELISTED	Stock	0.49	0.52	0.49	0.51	180675.0
2019-05-03	AAUAF-DELISTED	Stock	0.49	0.52	0.49	0.51	183191.0
2019-05-03	AAWW-DELISTED	Stock	45.9	47.03	44.95	46.84	344878.0
2019-05-03	AAXJ	Stock	72.73	73.1	72.65	73.01	892776.0
2019-05-03	AAXN-DELISTED	Stock	64.7	66.11	64.42	65.28	608985.0
2019-05-03	AB	Stock	29.01	29.38	28.91	29.31	199500.0
2019-05-03	ABB-DELISTED	Stock	20.31	20.435	20.3	20.43	1158377.0
2019-05-03	ABBNY-DELISTED	Stock	20.31	20.435	20.3	20.42	1374069.0
2019-05-03	ABBV	Stock	78.72	78.8	78.25	78.71	4527300.0
2019-05-03	ABC-DELISTED	Stock	77.98	79.59	77.64	79.09	1727331.0
2019-05-03	ABCB	Stock	36.85	37.63	36.85	37.58	236400.0
2019-05-03	ABDC-DELISTED	Stock	8.37	8.44	8.25	8.25	19386.0
2019-05-03	ABEO	Stock	195.0	198.0	191.0	195.5	17620.0
2019-05-03	ABEV	Stock	4.57	4.59	4.49	4.57	25318700.0
2019-05-03	ABG	Stock	79.22	80.57	79.12	80.45	81600.0
2019-05-03	ABIL-DELISTED	Stock	1.39	1.43	1.33	1.37	35338.0
2019-05-03	ABM	Stock	37.61	38.39	37.6	38.36	191900.0
2019-05-03	ABMD-DELISTED	Stock	265.5	273.35	265.5	271.74	810644.0
2019-05-03	ABR	Stock	13.75	13.9	13.7	13.8	884700.0
2019-05-03	ABR.A-DELISTED	Stock	26.16	26.1891	26.11	26.1891	1545.0
2019-05-03	ABR.B-DELISTED	Stock	25.73	25.73	25.71	25.71	2460.0
2019-05-03	ABR.C-DELISTED	Stock	26.2251	26.3591	26.2251	26.3543	1500.0
2019-05-03	ABT	Stock	78.83	79.13	78.26	78.69	5452700.0

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

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