PREVIEW / stock_daily / 2019-10-31

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-31.parquet
  size:    220 KB
  rows:    6,600
  symbols: 2,467

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-31	AAPL	Stock	61.81	62.2925	59.315	62.19	139162000.0
2019-10-31	MSFT	Stock	144.9	144.93	142.99	143.37	24605100.0
2019-10-31	NVDA	Stock	5.054	5.075	4.9453	5.0255	209732000.0
2019-10-31	AMZN	Stock	88.7995	89.6	88.574	88.833	55624000.0
2019-10-31	GOOGL	Stock	63.0	63.3258	62.474	62.94	31903080.0
2019-10-31	META	Stock	196.7	198.09	188.25	191.65	42286500.0
2019-10-31	TSLA	Stock	20.8733	21.2667	20.8667	20.9947	76005000.0
2019-10-31	TLT	Stock	140.48	141.677	140.43	141.24	15835800.0
2019-10-31	ES	Stock	83.39	84.05	82.96	83.74	1556800.0
2019-10-31	CL	Stock	68.42	68.96	67.92	68.6	4374200.0
2019-10-31	A	Stock	76.0	76.12	75.1	75.75	970500.0
2019-10-31	AA	Stock	20.94	21.3	20.36	20.79	5468700.0
2019-10-31	AACG	Stock	1.75	1.78	1.75	1.78	4000.0
2019-10-31	AAIC-DELISTED	Stock	5.82	5.82	5.7	5.78	272090.0
2019-10-31	AAIC.C-DELISTED	Stock	21.35	21.4	21.33	21.35	4024.0
2019-10-31	AAL	Stock	30.07	30.21	29.46	30.06	8779600.0
2019-10-31	AAM.A-DELISTED	Stock	26.64	26.75	26.36	26.37	96592.0
2019-10-31	AAM.B-DELISTED	Stock	27.05	27.15	26.92	26.93	100981.0
2019-10-31	AAMC-DELISTED	Stock	3.9529	4.0794	3.6765	3.9853	28682.0
2019-10-31	AAME	Stock	2.28	2.28	2.23	2.23	4600.0
2019-10-31	AAMI	Stock	9.97	9.97	9.68	9.82	610000.0
2019-10-31	AAOI	Stock	9.35	9.44	9.16	9.36	525000.0
2019-10-31	AAON	Stock	31.1	33.1067	31.1	32.44	467250.0
2019-10-31	AAP	Stock	163.84	164.17	161.06	162.48	826600.0
2019-10-31	AAT	Stock	48.75	49.26	47.85	48.96	507800.0
2019-10-31	AAU-DELISTED	Stock	0.55	0.55	0.485	0.4891	602522.0
2019-10-31	AAUAF-DELISTED	Stock	0.55	0.55	0.485	0.4891	615774.0
2019-10-31	AAWW-DELISTED	Stock	21.35	22.26	21.35	21.93	853602.0
2019-10-31	AAXJ	Stock	69.52	69.54	68.93	69.3	589360.0
2019-10-31	AAXN-DELISTED	Stock	52.47	52.67	50.78	51.13	782243.0
2019-10-31	AB	Stock	29.3	29.49	28.81	29.36	306600.0
2019-10-31	ABB-DELISTED	Stock	21.05	21.0535	20.86	21.0	1443541.0
2019-10-31	ABBNY-DELISTED	Stock	21.05	21.0535	20.86	20.99	1536538.0
2019-10-31	ABBV	Stock	79.71	79.74	78.74	79.55	10009400.0
2019-10-31	ABC-DELISTED	Stock	85.45	85.77	84.52	85.38	740907.0
2019-10-31	ABCB	Stock	43.14	43.21	42.18	42.85	323900.0
2019-10-31	ABDC-DELISTED	Stock	8.99	8.99	8.91	8.96	12173.0
2019-10-31	ABEO	Stock	62.5	62.5	58.25	59.25	10144.0
2019-10-31	ABEOW-DELISTED	Stock	0.27	0.27	0.16	0.16	605.0
2019-10-31	ABEV	Stock	4.37	4.39	4.28	4.31	25787100.0
2019-10-31	ABG	Stock	103.74	103.74	101.36	103.13	101300.0
2019-10-31	ABIL-DELISTED	Stock	0.4529	0.4536	0.4029	0.41	53106.0
2019-10-31	ABM	Stock	36.81	36.94	36.03	36.46	1027900.0
2019-10-31	ABMD-DELISTED	Stock	189.16	210.755	187.5	207.47	1785946.0
2019-10-31	ABR	Stock	13.62	13.67	13.56	13.66	1176700.0
2019-10-31	ABR.A-DELISTED	Stock	26.099	26.1	26.013	26.0627	1300.0
2019-10-31	ABR.B-DELISTED	Stock	26.0981	26.0981	26.0981	26.0981	1000.0
2019-10-31	ABR.C-DELISTED	Stock	26.1	26.35	26.02	26.02	5700.0
2019-10-31	ABT	Stock	83.77	84.35	82.92	83.61	4614000.0
2019-10-31	ABTC	Stock	150000.0	153660.0	147000.0	147000.0	0.41333333333333333

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

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