PREVIEW / stock_daily / 2019-07-23

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-23.parquet
  size:    220 KB
  rows:    6,573
  symbols: 2,538

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-23	AAPL	Stock	52.115	52.2275	51.8225	52.21	73420800.0
2019-07-23	MSFT	Stock	139.76	139.99	138.03	139.29	18034600.0
2019-07-23	NVDA	Stock	4.3225	4.3935	4.3068	4.3915	428176000.0
2019-07-23	AMZN	Stock	99.7995	99.8895	98.6565	99.7245	54070000.0
2019-07-23	GOOGL	Stock	57.1725	57.443	56.6425	57.4025	20648760.0
2019-07-23	META	Stock	202.84	204.24	200.96	202.36	14583700.0
2019-07-23	TSLA	Stock	17.114	17.3653	16.9667	17.3447	75346500.0
2019-07-23	TLT	Stock	131.6	131.74	130.965	131.22	8108940.0
2019-07-23	ES	Stock	76.97	76.97	76.25	76.75	1560800.0
2019-07-23	CL	Stock	72.88	73.15	72.1	72.28	3986700.0
2019-07-23	A	Stock	69.4	70.17	69.16	69.89	3304200.0
2019-07-23	AA	Stock	23.16	23.56	22.86	22.95	3088400.0
2019-07-23	AABA-DELISTED	Stock	70.69	71.09	70.62	70.99	1478422.0
2019-07-23	AAC-DELISTED	Stock	0.9205	0.986	0.92	0.97	216895.0
2019-07-23	AACG	Stock	2.63	2.7	2.62	2.64	53900.0
2019-07-23	AAIC-DELISTED	Stock	6.61	6.72	6.61	6.7	518912.0
2019-07-23	AAIC.C-DELISTED	Stock	22.75	22.99	22.6554	22.95	18420.0
2019-07-23	AAL	Stock	33.02	33.79	32.57	33.73	4524100.0
2019-07-23	AAM.A-DELISTED	Stock	26.0916	26.2053	26.0721	26.2053	3910.0
2019-07-23	AAM.B-DELISTED	Stock	26.15	26.48	26.15	26.47	14663.0
2019-07-23	AAMC-DELISTED	Stock	3.6529	3.6529	3.2089	3.2353	13134.0
2019-07-23	AAME	Stock	2.47	2.48	2.46	2.48	1700.0
2019-07-23	AAMI	Stock	10.92	11.135	10.87	11.04	285600.0
2019-07-23	AAOI	Stock	9.19	9.33	9.01	9.31	618100.0
2019-07-23	AAON	Stock	33.8333	34.6267	33.7333	34.5467	162300.0
2019-07-23	AAP	Stock	159.49	159.9	155.35	157.64	894500.0
2019-07-23	AAT	Stock	45.99	46.95	45.81	46.76	390500.0
2019-07-23	AAU-DELISTED	Stock	0.75	0.77	0.7201	0.7242	327070.0
2019-07-23	AAUAF-DELISTED	Stock	0.75	0.77	0.7201	0.7242	339692.0
2019-07-23	AAWW-DELISTED	Stock	42.73	44.12	41.94	43.94	104793.0
2019-07-23	AAXJ	Stock	69.77	69.945	69.66	69.94	972094.0
2019-07-23	AAXN-DELISTED	Stock	65.95	66.52	65.2	66.19	256247.0
2019-07-23	AB	Stock	29.75	30.14	29.7	30.01	148100.0
2019-07-23	ABB-DELISTED	Stock	19.17	19.39	19.15	19.365	3268410.0
2019-07-23	ABBNY-DELISTED	Stock	19.17	19.39	19.15	19.37	3436426.0
2019-07-23	ABBV	Stock	68.0	68.44	67.6	67.73	8025300.0
2019-07-23	ABC-DELISTED	Stock	85.27	86.16	84.77	85.78	629352.0
2019-07-23	ABCB	Stock	37.41	37.81	37.35	37.49	505200.0
2019-07-23	ABDC-DELISTED	Stock	8.31	8.35	8.31	8.33	20231.0
2019-07-23	ABEO	Stock	93.0	93.0	87.75	88.75	20864.0
2019-07-23	ABEOW-DELISTED	Stock	0.45	0.45	0.45	0.45	1500.0
2019-07-23	ABEV	Stock	4.81	4.84	4.77	4.79	16716400.0
2019-07-23	ABG	Stock	84.91	86.94	84.73	86.68	99500.0
2019-07-23	ABIL-DELISTED	Stock	0.8549	0.8549	0.81	0.84	52308.0
2019-07-23	ABM	Stock	41.23	41.49	40.85	41.42	215400.0
2019-07-23	ABMD-DELISTED	Stock	265.26	266.66	261.29	264.66	294610.0
2019-07-23	ABR	Stock	12.05	12.25	12.05	12.23	557100.0
2019-07-23	ABR.A-DELISTED	Stock	26.12	26.215	26.0301	26.215	2000.0
2019-07-23	ABR.B-DELISTED	Stock	25.72	25.7886	25.65	25.68	3252.0
2019-07-23	ABR.C-DELISTED	Stock	26.28	26.4634	26.25	26.4634	1303.0

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

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