PREVIEW / stock_daily / 2018-12-26

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-26.parquet
  size:    219 KB
  rows:    6,571
  symbols: 2,695

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
2018-12-26	AAPL	Stock	37.075	39.3075	36.68	39.2925	234330000.0
2018-12-26	MSFT	Stock	95.14	100.69	93.96	100.56	51634800.0
2018-12-26	NVDA	Stock	3.2235	3.3285	3.1115	3.3275	695100000.0
2018-12-26	AMZN	Stock	68.4445	73.658	68.1505	73.545	208236000.0
2018-12-26	GOOGL	Stock	49.8995	52.4225	49.6322	52.3925	46317240.0
2018-12-26	META	Stock	126.0	134.24	125.89	134.18	39723400.0
2018-12-26	TSLA	Stock	20.0	21.798	19.606	21.7393	122446500.0
2018-12-26	TLT	Stock	120.99	121.39	119.97	120.02	11700412.0
2018-12-26	ES	Stock	63.54	64.36	62.61	64.24	1157000.0
2018-12-26	CL	Stock	58.2	59.4	57.51	59.4	6616200.0
2018-12-26	A	Stock	62.93	65.58	62.76	65.54	1701800.0
2018-12-26	AA	Stock	25.31	27.2	25.01	27.14	3237100.0
2018-12-26	AABA-DELISTED	Stock	56.45	57.98	55.16	57.9	4248983.0
2018-12-26	AAC-DELISTED	Stock	1.55	1.7	1.53	1.67	234539.0
2018-12-26	AACG	Stock	0.97	1.0	0.93	1.0	35800.0
2018-12-26	AAIC-DELISTED	Stock	7.6	7.84	7.53	7.84	526743.0
2018-12-26	AAL	Stock	30.12	32.33	29.59	32.29	8621300.0
2018-12-26	AAM.A-DELISTED	Stock	21.4	22.18	21.2925	21.85	56652.0
2018-12-26	AAM.B-DELISTED	Stock	21.35	22.15	21.301	22.13	75998.0
2018-12-26	AAMC-DELISTED	Stock	10.2941	12.1706	10.05	10.9412	83643.0
2018-12-26	AAME	Stock	2.38	2.38	2.24	2.24	1300.0
2018-12-26	AAMI	Stock	10.2	10.48	10.04	10.48	864700.0
2018-12-26	AAOI	Stock	14.0	14.975	13.887	14.93	667400.0
2018-12-26	AAON	Stock	21.6733	22.3067	21.5533	22.2667	228150.0
2018-12-26	AAP	Stock	149.72	155.13	149.03	155.03	962600.0
2018-12-26	AAT	Stock	38.72	39.95	38.15	39.95	238600.0
2018-12-26	AAU-DELISTED	Stock	0.59	0.65	0.588	0.6359	147506.0
2018-12-26	AAUAF-DELISTED	Stock	0.59	0.65	0.588	0.6359	153790.0
2018-12-26	AAWW-DELISTED	Stock	37.7	40.97	37.52	40.95	556290.0
2018-12-26	AAXJ	Stock	62.67	63.48	62.06	63.48	765147.0
2018-12-26	AAXN-DELISTED	Stock	39.81	41.81	39.54	41.75	531980.0
2018-12-26	AB	Stock	23.68	25.71	23.68	25.68	698000.0
2018-12-26	ABAC-DELISTED	Stock	0.9201	0.94	0.92	0.94	3127.0
2018-12-26	ABB-DELISTED	Stock	18.16	18.68	18.045	18.68	3092515.0
2018-12-26	ABBNY-DELISTED	Stock	18.16	18.68	18.045	18.68	3197874.0
2018-12-26	ABBV	Stock	84.74	89.09	84.62	89.04	6225000.0
2018-12-26	ABC-DELISTED	Stock	70.9	73.13	69.36	73.06	836932.0
2018-12-26	ABCB	Stock	30.44	31.74	29.99	31.69	463200.0
2018-12-26	ABDC-DELISTED	Stock	6.22	6.64	6.22	6.58	59666.0
2018-12-26	ABEO	Stock	161.5	167.0	158.75	166.75	21336.0
2018-12-26	ABEV	Stock	3.77	3.9	3.77	3.9	18761000.0
2018-12-26	ABG	Stock	62.24	65.04	62.19	64.86	137800.0
2018-12-26	ABIL-DELISTED	Stock	1.75	1.84	1.635	1.68	256231.0
2018-12-26	ABM	Stock	29.12	31.16	28.67	31.1	668400.0
2018-12-26	ABMD-DELISTED	Stock	282.0	307.81	282.0	307.79	377659.0
2018-12-26	ABR	Stock	9.83	10.31	9.81	10.27	1436800.0
2018-12-26	ABR.B-DELISTED	Stock	23.982	24.143	23.61	24.13	6725.0
2018-12-26	ABR.C-DELISTED	Stock	25.0	25.47	25.0	25.4001	1563.0
2018-12-26	ABT	Stock	65.9	69.64	65.9	69.62	7576500.0
2018-12-26	ABTC	Stock	303300.0	303900.0	302400.0	303900.0	0.18666666666666665

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

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