PREVIEW / stock_daily / 2019-10-01

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-01.parquet
  size:    219 KB
  rows:    6,559
  symbols: 2,470

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-10-01	AAPL	Stock	56.2675	57.055	56.05	56.1475	139223200.0
2019-10-01	MSFT	Stock	139.66	140.25	137.0	137.07	21466600.0
2019-10-01	NVDA	Stock	4.375	4.525	4.3452	4.35	366008000.0
2019-10-01	AMZN	Stock	87.3	87.78	86.4205	86.7825	61690000.0
2019-10-01	GOOGL	Stock	61.1245	61.6429	60.2775	60.3	25654700.0
2019-10-01	META	Stock	179.15	179.84	174.88	175.81	17073000.0
2019-10-01	TSLA	Stock	16.1	16.3967	15.942	16.3127	92439000.0
2019-10-01	TLT	Stock	141.26	143.91	141.14	143.26	16869140.0
2019-10-01	ES	Stock	85.06	85.45	84.53	85.36	1257400.0
2019-10-01	CL	Stock	72.78	73.21	71.49	71.73	3241800.0
2019-10-01	A	Stock	76.5	76.89	74.59	74.84	2189100.0
2019-10-01	AA	Stock	20.19	20.87	19.7	19.86	3241700.0
2019-10-01	AABA-DELISTED	Stock	19.4	19.69	19.37	19.61	24756529.0
2019-10-01	AAC-DELISTED	Stock	0.6724	0.73	0.67	0.6986	59999.0
2019-10-01	AACG	Stock	1.6	1.6	1.5	1.51	12400.0
2019-10-01	AAIC-DELISTED	Stock	5.49	5.55	5.31	5.38	331443.0
2019-10-01	AAIC.C-DELISTED	Stock	21.33	21.33	21.23	21.245	3071.0
2019-10-01	AAL	Stock	27.08	27.66	26.59	26.8	6547000.0
2019-10-01	AAM.A-DELISTED	Stock	26.6044	26.75	26.6	26.73	10524.0
2019-10-01	AAM.B-DELISTED	Stock	26.64	26.9738	26.631	26.79	24027.0
2019-10-01	AAMC-DELISTED	Stock	2.85	2.9118	2.5963	2.75	48100.0
2019-10-01	AAME	Stock	2.62	2.62	2.62	2.62	700.0
2019-10-01	AAMI	Stock	10.0	10.12	9.345	9.49	701800.0
2019-10-01	AAOI	Stock	11.28	11.385	10.165	10.23	505200.0
2019-10-01	AAON	Stock	30.9333	31.4267	30.4467	30.52	360150.0
2019-10-01	AAP	Stock	165.59	167.64	163.94	167.29	1086300.0
2019-10-01	AAT	Stock	46.66	46.82	46.19	46.24	218000.0
2019-10-01	AAU-DELISTED	Stock	0.631	0.677	0.62	0.6485	92458.0
2019-10-01	AAUAF-DELISTED	Stock	0.631	0.677	0.62	0.647	95465.0
2019-10-01	AAWW-DELISTED	Stock	25.4	26.06	23.52	23.59	562763.0
2019-10-01	AAXJ	Stock	66.47	66.47	65.81	65.95	761857.0
2019-10-01	AAXN-DELISTED	Stock	56.85	57.33	53.95	54.195	809355.0
2019-10-01	AB	Stock	29.4	29.4	28.82	29.11	142300.0
2019-10-01	ABB-DELISTED	Stock	19.62	19.64	19.13	19.21	1978181.0
2019-10-01	ABBNY-DELISTED	Stock	19.62	19.64	19.13	19.2	2060126.0
2019-10-01	ABBV	Stock	75.89	76.03	72.94	73.23	10910800.0
2019-10-01	ABC-DELISTED	Stock	82.48	84.21	82.07	82.13	970314.0
2019-10-01	ABCB	Stock	40.78	41.34	39.76	39.89	997900.0
2019-10-01	ABDC-DELISTED	Stock	8.87	8.92	8.82	8.87	35100.0
2019-10-01	ABEO	Stock	55.75	58.75	55.75	57.0	8660.0
2019-10-01	ABEOW-DELISTED	Stock	0.21	0.21	0.2	0.2	5792.0
2019-10-01	ABEV	Stock	4.62	4.69	4.58	4.67	26957700.0
2019-10-01	ABG	Stock	102.7	104.55	98.49	99.14	216400.0
2019-10-01	ABIL-DELISTED	Stock	0.588	0.599	0.5309	0.5574	9052.0
2019-10-01	ABM	Stock	36.55	36.85	35.74	35.82	309500.0
2019-10-01	ABMD-DELISTED	Stock	177.89	180.81	169.85	170.3	558125.0
2019-10-01	ABR	Stock	13.13	13.2	13.02	13.07	667300.0
2019-10-01	ABR.A-DELISTED	Stock	26.11	26.2982	26.1	26.2982	2000.0
2019-10-01	ABR.B-DELISTED	Stock	25.8	25.8	25.8	25.8	100.0
2019-10-01	ABR.C-DELISTED	Stock	26.3	26.318	26.2	26.2	1455.0

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

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