PREVIEW / stock_daily / 2019-07-03

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-03.parquet
  size:    215 KB
  rows:    6,452
  symbols: 2,480

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-07-03	AAPL	Stock	50.82	51.11	50.6725	51.1025	45448000.0
2019-07-03	MSFT	Stock	136.8	137.74	136.29	137.46	13629300.0
2019-07-03	NVDA	Stock	4.0792	4.085	4.0085	4.0688	246636000.0
2019-07-03	AMZN	Stock	96.7945	97.0795	96.525	96.95	33806000.0
2019-07-03	GOOGL	Stock	55.925	56.3994	55.7425	56.1495	20154360.0
2019-07-03	META	Stock	194.16	197.4	194.16	197.2	10246100.0
2019-07-03	TSLA	Stock	15.9593	16.1047	15.634	15.66	213016500.0
2019-07-03	TLT	Stock	133.52	134.29	133.51	134.21	5380269.0
2019-07-03	ES	Stock	76.9	77.64	76.9	77.12	703700.0
2019-07-03	CL	Stock	73.09	74.05	73.0	74.0	2291600.0
2019-07-03	A	Stock	75.86	76.93	75.7	76.8	1153100.0
2019-07-03	AA	Stock	23.23	23.44	22.365	22.7	3189200.0
2019-07-03	AABA-DELISTED	Stock	70.91	70.91	70.4	70.68	1273252.0
2019-07-03	AAC-DELISTED	Stock	1.05	1.08	1.0	1.07	178414.0
2019-07-03	AACG	Stock	2.49	2.49	2.38	2.45	78400.0
2019-07-03	AAIC-DELISTED	Stock	6.5	6.51	6.38	6.43	489545.0
2019-07-03	AAIC.C-DELISTED	Stock	21.76	21.94	21.652	21.94	17215.0
2019-07-03	AAL	Stock	32.4	32.85	32.35	32.72	2747700.0
2019-07-03	AAM.A-DELISTED	Stock	25.86	25.93	25.8	25.93	8676.0
2019-07-03	AAM.B-DELISTED	Stock	26.04	26.04	26.04	26.04	1876.0
2019-07-03	AAME	Stock	2.48	2.48	2.37	2.37	1300.0
2019-07-03	AAMI	Stock	11.7	11.86	11.58	11.84	168400.0
2019-07-03	AAOI	Stock	10.06	10.06	9.855	9.88	175600.0
2019-07-03	AAON	Stock	33.5	33.5	32.68	32.8467	125100.0
2019-07-03	AAP	Stock	159.51	161.63	158.67	160.63	588400.0
2019-07-03	AAT	Stock	47.48	47.95	47.4	47.84	192700.0
2019-07-03	AAU-DELISTED	Stock	0.68	0.68	0.63	0.6337	85817.0
2019-07-03	AAUAF-DELISTED	Stock	0.68	0.68	0.6301	0.6337	92718.0
2019-07-03	AAWW-DELISTED	Stock	41.93	42.4496	41.48	41.63	86671.0
2019-07-03	AAXJ	Stock	70.4	70.45	70.24	70.45	238871.0
2019-07-03	AAXN-DELISTED	Stock	64.05	64.475	63.92	64.3	662202.0
2019-07-03	AB	Stock	29.82	30.3	29.81	30.3	162900.0
2019-07-03	ABB-DELISTED	Stock	20.05	20.065	19.965	20.0	1023362.0
2019-07-03	ABBNY-DELISTED	Stock	20.05	20.065	19.965	20.01	1616023.0
2019-07-03	ABBV	Stock	74.35	74.97	73.78	74.96	7434100.0
2019-07-03	ABC-DELISTED	Stock	86.11	88.78	86.075	87.62	875549.0
2019-07-03	ABCB	Stock	39.64	40.0	38.94	39.04	593500.0
2019-07-03	ABDC-DELISTED	Stock	8.31	8.3947	8.27	8.34	12537.0
2019-07-03	ABEO	Stock	120.0	120.0	114.25	115.25	18392.0
2019-07-03	ABEV	Stock	4.74	4.87	4.74	4.82	25311200.0
2019-07-03	ABG	Stock	85.03	85.56	84.46	84.97	39400.0
2019-07-03	ABIL-DELISTED	Stock	0.905	0.95	0.9	0.95	18020.0
2019-07-03	ABM	Stock	39.89	40.36	39.65	40.22	222700.0
2019-07-03	ABMD-DELISTED	Stock	262.16	264.42	260.16	261.33	122255.0
2019-07-03	ABR	Stock	12.12	12.28	12.12	12.18	626900.0
2019-07-03	ABR.B-DELISTED	Stock	25.85	25.85	25.85	25.85	100.0
2019-07-03	ABR.C-DELISTED	Stock	26.029	26.05	26.029	26.0484	463.0
2019-07-03	ABT	Stock	85.05	85.65	84.92	85.64	2437500.0
2019-07-03	ABTC	Stock	541800.0	549000.0	450000.0	450300.0	18.266666666666666
2019-07-03	ABTS	Stock	33.9	35.4	32.85	33.15	2040.0

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

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