PREVIEW / stock_daily / 2019-01-08

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-08.parquet
  size:    219 KB
  rows:    6,547
  symbols: 2,660

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-08	AAPL	Stock	37.39	37.955	37.13	37.6875	164101200.0
2019-01-08	MSFT	Stock	103.04	103.97	101.71	102.8	31514400.0
2019-01-08	NVDA	Stock	3.6672	3.6695	3.4225	3.4958	786016000.0
2019-01-08	AMZN	Stock	83.2345	83.8305	80.8305	82.829	177628000.0
2019-01-08	GOOGL	Stock	54.3	54.6675	53.4174	54.2685	35413080.0
2019-01-08	META	Stock	139.89	143.14	139.54	142.53	26263800.0
2019-01-08	TSLA	Stock	22.7973	22.934	21.8013	22.3567	105127500.0
2019-01-08	TLT	Stock	121.69	121.94	121.39	121.43	7737103.0
2019-01-08	ES	Stock	63.84	65.31	63.64	65.1	1479300.0
2019-01-08	CL	Stock	60.02	60.95	60.02	60.55	5614400.0
2019-01-08	A	Stock	67.59	68.21	66.7	67.83	1578100.0
2019-01-08	AA	Stock	28.73	28.847	27.65	28.25	2218300.0
2019-01-08	AABA-DELISTED	Stock	60.7	61.41	59.5	61.06	6312721.0
2019-01-08	AAC-DELISTED	Stock	2.32	2.49	2.09	2.25	435972.0
2019-01-08	AACG	Stock	0.97	1.0	0.94	0.99	15000.0
2019-01-08	AAIC-DELISTED	Stock	8.0	8.07	7.88	8.0	462543.0
2019-01-08	AAL	Stock	33.36	33.65	32.2	32.42	7107700.0
2019-01-08	AAM.A-DELISTED	Stock	23.7	23.801	23.5	23.6322	44056.0
2019-01-08	AAM.B-DELISTED	Stock	23.68	23.7123	23.45	23.5	42501.0
2019-01-08	AAMC-DELISTED	Stock	8.7228	8.779	8.3353	8.5529	8299.0
2019-01-08	AAME	Stock	2.89	2.89	2.43	2.65	6200.0
2019-01-08	AAMI	Stock	11.55	11.591	11.24	11.26	739100.0
2019-01-08	AAOI	Stock	15.9	16.39	15.77	16.01	477500.0
2019-01-08	AAON	Stock	24.3667	24.6067	23.9267	24.22	212250.0
2019-01-08	AAP	Stock	162.01	162.95	157.18	160.02	1604700.0
2019-01-08	AAT	Stock	40.4	41.23	40.4	41.08	324700.0
2019-01-08	AAU-DELISTED	Stock	0.78	0.78	0.7	0.7271	231221.0
2019-01-08	AAUAF-DELISTED	Stock	0.78	0.78	0.7	0.73	295020.0
2019-01-08	AAWW-DELISTED	Stock	43.46	44.26	42.79	43.67	246363.0
2019-01-08	AAXJ	Stock	64.08	64.27	63.61	64.18	1385774.0
2019-01-08	AAXN-DELISTED	Stock	48.98	49.91	48.6466	49.41	650240.0
2019-01-08	AB	Stock	28.22	28.45	27.8	28.1	497400.0
2019-01-08	ABAC-DELISTED	Stock	1.16	1.24	1.16	1.22	13281.0
2019-01-08	ABB-DELISTED	Stock	19.66	19.7	19.36	19.5	1672502.0
2019-01-08	ABBNY-DELISTED	Stock	19.66	19.7	19.36	19.5	1775295.0
2019-01-08	ABBV	Stock	91.2	92.3	90.4	90.79	7478300.0
2019-01-08	ABC-DELISTED	Stock	75.1	75.93	74.105	75.54	1468926.0
2019-01-08	ABCB	Stock	34.85	34.89	33.57	34.31	339300.0
2019-01-08	ABDC-DELISTED	Stock	6.99	7.08	6.9	6.9	29099.0
2019-01-08	ABEO	Stock	190.25	192.0	181.0	182.75	18572.0
2019-01-08	ABEOW-DELISTED	Stock	3.3	3.3	3.2	3.2	3700.0
2019-01-08	ABEV	Stock	4.42	4.45	4.29	4.33	28894000.0
2019-01-08	ABG	Stock	71.2	71.2	69.1	69.83	459200.0
2019-01-08	ABIL-DELISTED	Stock	2.05	2.05	1.93	1.9402	118648.0
2019-01-08	ABM	Stock	34.03	35.89	33.86	34.98	1673300.0
2019-01-08	ABMD-DELISTED	Stock	318.45	323.095	312.22	318.43	420949.0
2019-01-08	ABR	Stock	10.94	11.05	10.83	11.05	1307600.0
2019-01-08	ABR.A-DELISTED	Stock	25.3424	25.435	25.3424	25.3501	1500.0
2019-01-08	ABR.B-DELISTED	Stock	25.43	25.45	25.231	25.34	6800.0
2019-01-08	ABR.C-DELISTED	Stock	25.8536	25.8536	25.8536	25.8536	233.0

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

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