PREVIEW / stock_daily / 2019-07-02

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-02.parquet
  size:    221 KB
  rows:    6,603
  symbols: 2,565

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-02	AAPL	Stock	50.3525	50.7825	50.34	50.6825	67740800.0
2019-07-02	MSFT	Stock	136.12	136.59	135.34	136.58	15237800.0
2019-07-02	NVDA	Stock	4.1375	4.1588	4.0425	4.0558	400228000.0
2019-07-02	AMZN	Stock	95.969	96.7395	95.3315	96.7155	52918000.0
2019-07-02	GOOGL	Stock	55.2415	55.6445	54.9835	55.63	20638380.0
2019-07-02	META	Stock	193.0	195.0	192.71	195.0	9050000.0
2019-07-02	TSLA	Stock	15.2593	15.2767	14.8147	14.97	138885000.0
2019-07-02	TLT	Stock	132.57	133.39	132.46	133.26	10495462.0
2019-07-02	ES	Stock	75.96	76.94	75.82	76.66	1546600.0
2019-07-02	CL	Stock	72.12	72.99	72.06	72.74	2298100.0
2019-07-02	A	Stock	75.85	76.18	75.25	75.61	1877000.0
2019-07-02	AA	Stock	22.93	23.485	22.66	23.3	3259000.0
2019-07-02	AABA-DELISTED	Stock	70.35	70.77	70.34	70.7	3362091.0
2019-07-02	AAC-DELISTED	Stock	0.905	1.04	0.88	1.01	555618.0
2019-07-02	AACG	Stock	2.61	2.64	2.48	2.51	130200.0
2019-07-02	AAIC-DELISTED	Stock	6.82	6.85	6.6501	6.75	929363.0
2019-07-02	AAIC.C-DELISTED	Stock	21.52	21.94	21.52	21.7392	10716.0
2019-07-02	AAL	Stock	33.09	33.21	32.03	32.19	4765100.0
2019-07-02	AAM.A-DELISTED	Stock	25.73	25.82	25.73	25.8	37043.0
2019-07-02	AAM.B-DELISTED	Stock	25.85	25.99	25.85	25.98	18791.0
2019-07-02	AAMC-DELISTED	Stock	3.7294	3.7353	3.4949	3.7353	3631.0
2019-07-02	AAME	Stock	2.32	2.39	2.32	2.37	2400.0
2019-07-02	AAMI	Stock	11.65	11.72	11.55	11.68	268100.0
2019-07-02	AAOI	Stock	10.1	10.16	9.92	10.03	225400.0
2019-07-02	AAON	Stock	33.1667	33.4333	32.96	33.4133	155100.0
2019-07-02	AAP	Stock	157.0	160.49	156.32	159.79	1394000.0
2019-07-02	AAT	Stock	47.05	47.38	46.73	47.36	410800.0
2019-07-02	AAU-DELISTED	Stock	0.596	0.6512	0.5825	0.6512	191835.0
2019-07-02	AAUAF-DELISTED	Stock	0.596	0.6512	0.5825	0.6512	202240.0
2019-07-02	AAWW-DELISTED	Stock	44.05	44.05	41.31	41.77	228717.0
2019-07-02	AAXJ	Stock	70.81	70.9	70.54	70.77	720536.0
2019-07-02	AAXN-DELISTED	Stock	64.75	64.75	63.02	63.8	957521.0
2019-07-02	AB	Stock	29.95	30.1	29.75	29.83	167700.0
2019-07-02	ABB-DELISTED	Stock	20.09	20.195	20.055	20.14	1155077.0
2019-07-02	ABBNY-DELISTED	Stock	20.07	20.195	20.055	20.14	1750179.0
2019-07-02	ABBV	Stock	73.2	74.25	72.32	74.23	12862200.0
2019-07-02	ABC-DELISTED	Stock	85.59	86.05	84.52	85.46	842382.0
2019-07-02	ABCB	Stock	39.82	40.34	39.16	39.61	1036500.0
2019-07-02	ABDC-DELISTED	Stock	8.26	8.39	8.26	8.3	20327.0
2019-07-02	ABEO	Stock	118.5	120.25	115.0	119.0	27216.0
2019-07-02	ABEV	Stock	4.65	4.76	4.59	4.7	29151600.0
2019-07-02	ABG	Stock	84.1	85.05	82.78	84.52	127400.0
2019-07-02	ABIL-DELISTED	Stock	0.921	0.97	0.905	0.905	43184.0
2019-07-02	ABM	Stock	40.28	40.33	39.6	39.88	220900.0
2019-07-02	ABMD-DELISTED	Stock	265.91	268.32	260.35	261.49	238476.0
2019-07-02	ABR	Stock	12.21	12.29	12.09	12.11	1010400.0
2019-07-02	ABR.A-DELISTED	Stock	26.28	26.28	26.1304	26.131	1400.0
2019-07-02	ABR.B-DELISTED	Stock	25.94	26.04	25.9	25.9	2100.0
2019-07-02	ABR.C-DELISTED	Stock	25.93	26.0591	25.93	25.9475	4460.0
2019-07-02	ABT	Stock	84.75	84.96	84.15	84.95	4023300.0

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

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