PREVIEW / stock_daily / 2019-02-15

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-15.parquet
  size:    220 KB
  rows:    6,535
  symbols: 2,627

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-02-15	AAPL	Stock	42.8125	42.925	42.4375	42.605	98507200.0
2019-02-15	MSFT	Stock	107.91	108.3	107.36	108.22	26606900.0
2019-02-15	NVDA	Stock	4.0737	4.0968	3.9105	3.9335	1516748000.0
2019-02-15	AMZN	Stock	81.393	81.4455	80.225	80.3975	86878000.0
2019-02-15	GOOGL	Stock	56.965	56.965	55.836	55.9815	27826960.0
2019-02-15	META	Stock	164.51	164.7	160.86	162.5	15504400.0
2019-02-15	TSLA	Stock	20.3	20.5333	20.26	20.5253	58573500.0
2019-02-15	TLT	Stock	121.56	122.02	121.54	121.98	5527244.0
2019-02-15	ES	Stock	70.34	70.61	69.88	70.2	1582000.0
2019-02-15	CL	Stock	66.0	66.54	65.8	66.48	5370600.0
2019-02-15	A	Stock	77.63	78.31	77.47	78.3	1919700.0
2019-02-15	AA	Stock	28.71	28.93	28.2	28.27	3407600.0
2019-02-15	AABA-DELISTED	Stock	68.95	68.95	67.63	67.86	8079303.0
2019-02-15	AAC-DELISTED	Stock	2.99	3.0	2.89	2.97	172432.0
2019-02-15	AACG	Stock	1.02	1.09	1.02	1.05	68400.0
2019-02-15	AAIC-DELISTED	Stock	8.85	8.91	8.8	8.84	435766.0
2019-02-15	AAL	Stock	36.24	36.34	34.96	35.05	11471900.0
2019-02-15	AAM.A-DELISTED	Stock	24.9615	24.97	24.85	24.96	13238.0
2019-02-15	AAM.B-DELISTED	Stock	24.69	24.71	24.55	24.69	57414.0
2019-02-15	AAMC-DELISTED	Stock	10.1412	10.1412	9.9941	9.9941	1921.0
2019-02-15	AAME	Stock	2.73	2.73	2.73	2.73	300.0
2019-02-15	AAMI	Stock	13.9	14.11	13.8	13.86	985800.0
2019-02-15	AAOI	Stock	14.81	15.05	14.63	15.03	614900.0
2019-02-15	AAON	Stock	25.66	26.4067	25.66	26.3067	177900.0
2019-02-15	AAP	Stock	169.83	170.83	167.67	169.99	1379600.0
2019-02-15	AAT	Stock	43.89	44.06	43.44	44.05	216500.0
2019-02-15	AAU-DELISTED	Stock	0.702	0.7189	0.7	0.7115	91064.0
2019-02-15	AAUAF-DELISTED	Stock	0.702	0.7189	0.7	0.71	98949.0
2019-02-15	AAWW-DELISTED	Stock	54.35	54.865	53.9381	54.25	299921.0
2019-02-15	AAXJ	Stock	68.33	68.41	68.09	68.26	527538.0
2019-02-15	AAXN-DELISTED	Stock	54.9	55.59	54.41	55.42	310816.0
2019-02-15	AB	Stock	29.95	30.22	29.88	30.0	451900.0
2019-02-15	ABB-DELISTED	Stock	19.73	19.83	19.63	19.82	2509053.0
2019-02-15	ABBNY-DELISTED	Stock	19.73	19.83	19.63	19.82	2601745.0
2019-02-15	ABBV	Stock	81.13	81.7	80.16	80.85	6295400.0
2019-02-15	ABC-DELISTED	Stock	86.7	87.35	85.8975	86.67	785150.0
2019-02-15	ABCB	Stock	38.64	39.87	38.46	39.69	680100.0
2019-02-15	ABDC-DELISTED	Stock	7.34	7.5	7.3	7.33	16683.0
2019-02-15	ABEO	Stock	163.0	167.0	158.25	165.75	12232.0
2019-02-15	ABEV	Stock	4.99	5.01	4.9	4.95	21964800.0
2019-02-15	ABG	Stock	70.6	72.2	70.18	71.9	182600.0
2019-02-15	ABIL-DELISTED	Stock	1.92	1.98	1.86	1.9385	103250.0
2019-02-15	ABM	Stock	36.26	36.42	36.0	36.2	342000.0
2019-02-15	ABMD-DELISTED	Stock	360.0	362.33	357.1	362.09	231575.0
2019-02-15	ABR	Stock	11.99	12.33	11.76	12.3	2203000.0
2019-02-15	ABR.A-DELISTED	Stock	25.24	25.2963	25.23	25.28	3005.0
2019-02-15	ABR.B-DELISTED	Stock	25.5745	25.5745	25.5745	25.5745	762.0
2019-02-15	ABR.C-DELISTED	Stock	25.29	25.3548	25.13	25.3	11752.0
2019-02-15	ABT	Stock	74.56	75.4	74.33	75.25	8083200.0
2019-02-15	ABTC	Stock	304500.0	304800.0	304020.0	304500.0	0.5466666666666666

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

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