PREVIEW / stock_daily / 2019-01-31

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-31.parquet
  size:    220 KB
  rows:    6,551
  symbols: 2,653

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-01-31	AAPL	Stock	41.5275	42.25	41.14	41.61	162958400.0
2019-01-31	MSFT	Stock	103.8	105.22	103.18	104.43	55636400.0
2019-01-31	NVDA	Stock	3.4315	3.6298	3.4095	3.5938	842852000.0
2019-01-31	AMZN	Stock	84.6425	86.8205	83.954	85.9365	218206000.0
2019-01-31	GOOGL	Stock	55.612	56.3835	55.2625	56.2945	40231440.0
2019-01-31	META	Stock	165.6	171.68	165.0	166.69	77233600.0
2019-01-31	TSLA	Stock	20.0667	20.7707	19.6	20.468	188538000.0
2019-01-31	TLT	Stock	121.55	122.18	121.5	121.97	11843413.0
2019-01-31	ES	Stock	68.14	69.82	67.48	69.41	3903600.0
2019-01-31	CL	Stock	63.76	64.85	63.44	64.68	6182900.0
2019-01-31	A	Stock	75.21	76.31	74.67	76.05	2951300.0
2019-01-31	AA	Stock	29.28	30.265	29.15	29.68	6466800.0
2019-01-31	AABA-DELISTED	Stock	68.32	69.09	67.59	68.51	6368642.0
2019-01-31	AAC-DELISTED	Stock	2.27	2.47	2.26	2.44	226969.0
2019-01-31	AACG	Stock	1.02	1.11	1.02	1.08	141500.0
2019-01-31	AAIC-DELISTED	Stock	8.66	8.68	8.49	8.62	349548.0
2019-01-31	AAL	Stock	36.31	36.55	35.55	35.77	7706600.0
2019-01-31	AAM.A-DELISTED	Stock	24.62	24.66	24.53	24.53	88521.0
2019-01-31	AAM.B-DELISTED	Stock	24.44	24.5719	24.27	24.27	205538.0
2019-01-31	AAMC-DELISTED	Stock	7.8941	7.8941	7.8941	7.8941	687.0
2019-01-31	AAME	Stock	2.65	2.7	2.65	2.7	6600.0
2019-01-31	AAMI	Stock	12.27	12.51	12.015	12.37	617100.0
2019-01-31	AAOI	Stock	17.39	17.86	17.15	17.38	524100.0
2019-01-31	AAON	Stock	24.0	24.7	24.0	24.6267	173100.0
2019-01-31	AAP	Stock	158.4	160.11	155.78	159.2	1586600.0
2019-01-31	AAT	Stock	42.54	42.97	41.95	42.94	177100.0
2019-01-31	AAU-DELISTED	Stock	0.75	0.7899	0.7259	0.7848	99294.0
2019-01-31	AAUAF-DELISTED	Stock	0.75	0.7899	0.7259	0.7848	100960.0
2019-01-31	AAWW-DELISTED	Stock	52.8	54.125	52.75	53.22	386441.0
2019-01-31	AAXJ	Stock	68.44	69.05	68.44	68.98	1222512.0
2019-01-31	AAXN-DELISTED	Stock	49.63	51.29	49.63	50.99	278361.0
2019-01-31	AB	Stock	30.08	30.66	30.0	30.49	441800.0
2019-01-31	ABB-DELISTED	Stock	19.08	19.17	18.96	19.16	5302899.0
2019-01-31	ABBNY-DELISTED	Stock	19.09	19.17	18.96	19.15	9149324.0
2019-01-31	ABBV	Stock	78.95	81.31	78.71	80.29	11563900.0
2019-01-31	ABC-DELISTED	Stock	80.48	85.86	80.48	83.39	4095090.0
2019-01-31	ABCB	Stock	37.64	37.98	37.29	37.95	517200.0
2019-01-31	ABDC-DELISTED	Stock	7.22	7.31	7.2	7.2	36712.0
2019-01-31	ABEO	Stock	165.5	171.25	165.5	169.75	15028.0
2019-01-31	ABEOW-DELISTED	Stock	2.5	2.6	2.5	2.6	1300.0
2019-01-31	ABEV	Stock	4.86	4.88	4.76	4.81	18418700.0
2019-01-31	ABG	Stock	69.84	70.99	69.53	70.65	264900.0
2019-01-31	ABIL-DELISTED	Stock	2.04	2.1	2.0	2.0742	161566.0
2019-01-31	ABM	Stock	33.53	34.44	33.27	34.19	2440900.0
2019-01-31	ABMD-DELISTED	Stock	359.54	362.67	342.3479	351.08	855759.0
2019-01-31	ABR	Stock	11.82	11.98	11.76	11.96	1377100.0
2019-01-31	ABR.A-DELISTED	Stock	25.659	25.71	25.5632	25.7056	2881.0
2019-01-31	ABR.C-DELISTED	Stock	25.6	25.63	25.6	25.6183	2400.0
2019-01-31	ABT	Stock	71.31	73.07	71.14	72.98	10421900.0
2019-01-31	ABTC	Stock	303300.0	304500.0	303000.0	304200.0	0.9466666666666667

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

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