PREVIEW / stock_daily / 2019-03-04

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-04.parquet
  size:    221 KB
  rows:    6,530
  symbols: 2,614

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-03-04	AAPL	Stock	43.9225	44.4375	43.4925	43.9625	109744800.0
2019-03-04	MSFT	Stock	113.02	113.25	110.8	112.26	26608000.0
2019-03-04	NVDA	Stock	3.95	3.973	3.8625	3.9195	409992000.0
2019-03-04	AMZN	Stock	84.25	85.4715	83.718	84.8085	123348000.0
2019-03-04	GOOGL	Stock	57.728	58.276	56.9125	57.671	35489340.0
2019-03-04	META	Stock	163.9	167.5	163.83	167.37	18894700.0
2019-03-04	TSLA	Stock	19.8747	19.9333	18.852	19.024	256452000.0
2019-03-04	TLT	Stock	119.29	119.77	119.06	119.59	9808468.0
2019-03-04	ES	Stock	69.89	69.89	68.55	68.97	2297300.0
2019-03-04	CL	Stock	66.31	66.33	65.44	66.03	3352200.0
2019-03-04	A	Stock	81.5	81.76	79.53	80.13	3204100.0
2019-03-04	AA	Stock	29.91	29.97	28.73	29.16	2690900.0
2019-03-04	AABA-DELISTED	Stock	75.69	76.18	74.95	76.01	5024853.0
2019-03-04	AAC-DELISTED	Stock	2.87	2.87	2.5007	2.5359	249277.0
2019-03-04	AACG	Stock	1.12	1.18	1.11	1.13	146900.0
2019-03-04	AAIC-DELISTED	Stock	8.27	8.37	8.255	8.33	897096.0
2019-03-04	AAL	Stock	34.76	34.89	33.5	33.72	6998100.0
2019-03-04	AAM.A-DELISTED	Stock	25.0	25.1499	25.0	25.05	24122.0
2019-03-04	AAM.B-DELISTED	Stock	24.74	24.78	24.65	24.73	41164.0
2019-03-04	AAMC-DELISTED	Stock	11.4118	11.5882	10.6176	11.5882	9935.0
2019-03-04	AAME	Stock	2.85	2.87	2.85	2.85	8400.0
2019-03-04	AAMI	Stock	14.21	14.37	14.09	14.19	825000.0
2019-03-04	AAOI	Stock	13.39	14.12	13.11	13.97	1758200.0
2019-03-04	AAON	Stock	27.5267	28.0	27.1933	27.8533	325500.0
2019-03-04	AAP	Stock	161.92	161.92	156.92	158.4	1147200.0
2019-03-04	AAT	Stock	44.15	44.16	43.54	43.98	197200.0
2019-03-04	AAU-DELISTED	Stock	0.6236	0.6381	0.6236	0.635	92780.0
2019-03-04	AAUAF-DELISTED	Stock	0.6236	0.6381	0.6236	0.635	102565.0
2019-03-04	AAWW-DELISTED	Stock	54.14	54.92	51.535	51.88	304272.0
2019-03-04	AAXJ	Stock	69.89	69.96	69.07	69.64	1490889.0
2019-03-04	AAXN-DELISTED	Stock	54.54	54.86	50.81	51.22	690750.0
2019-03-04	AB	Stock	29.71	29.97	29.47	29.83	355700.0
2019-03-04	ABB-DELISTED	Stock	19.48	19.52	19.26	19.37	2990537.0
2019-03-04	ABBNY-DELISTED	Stock	19.48	19.52	19.26	19.37	3132547.0
2019-03-04	ABBV	Stock	80.4	80.73	79.11	79.46	5872500.0
2019-03-04	ABC-DELISTED	Stock	83.01	83.44	79.83	80.47	1034035.0
2019-03-04	ABCB	Stock	41.1	41.54	40.6	40.78	379700.0
2019-03-04	ABDC-DELISTED	Stock	7.3	7.37	7.05	7.27	46379.0
2019-03-04	ABEO	Stock	197.5	209.75	193.25	199.0	42736.0
2019-03-04	ABEOW-DELISTED	Stock	4.0	4.0	4.0	4.0	100.0
2019-03-04	ABEV	Stock	4.37	4.42	4.32	4.38	29755500.0
2019-03-04	ABG	Stock	71.22	71.22	68.57	68.76	213800.0
2019-03-04	ABIL-DELISTED	Stock	1.84	1.9	1.78	1.82	104327.0
2019-03-04	ABM	Stock	36.14	36.63	35.61	35.66	532900.0
2019-03-04	ABMD-DELISTED	Stock	348.22	352.87	332.53	338.49	249780.0
2019-03-04	ABR	Stock	12.95	12.95	12.75	12.87	943100.0
2019-03-04	ABR.A-DELISTED	Stock	25.56	25.67	25.542	25.6592	3420.0
2019-03-04	ABR.B-DELISTED	Stock	25.6	25.6	25.6	25.6	500.0
2019-03-04	ABR.C-DELISTED	Stock	25.5757	25.68	25.5757	25.68	4774.0
2019-03-04	ABT	Stock	78.84	78.97	77.47	78.62	5962800.0

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

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