PREVIEW / stock_daily / 2017-01-03

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-03.parquet
  size:    217 KB
  rows:    6,507
  symbols: 3,120

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
2017-01-03	AAPL	Stock	28.95	29.0825	28.69	29.0375	115127600.0
2017-01-03	MSFT	Stock	62.79	62.84	62.13	62.58	20694100.0
2017-01-03	NVDA	Stock	2.61	2.6592	2.4845	2.5502	1501996000.0
2017-01-03	AMZN	Stock	37.896	37.938	37.385	37.6835	70422000.0
2017-01-03	GOOGL	Stock	40.031	40.5718	39.8445	40.4005	39180660.0
2017-01-03	META	Stock	116.03	117.84	115.51	116.86	20663900.0
2017-01-03	TSLA	Stock	14.324	14.6887	14.064	14.466	88849500.0
2017-01-03	TLT	Stock	118.41	119.99	118.18	119.64	13217317.0
2017-01-03	ES	Stock	55.25	55.43	54.77	55.08	1123100.0
2017-01-03	CL	Stock	65.56	65.65	65.1	65.54	3038900.0
2017-01-03	A	Stock	45.93	46.75	45.74	46.49	1739600.0
2017-01-03	AA	Stock	28.6	28.87	28.17	28.83	2746400.0
2017-01-03	AAAP-DELISTED	Stock	27.06	27.81	26.6	27.17	51969.0
2017-01-03	AABA-DELISTED	Stock	39.12	39.18	38.64	38.9	5588957.0
2017-01-03	AAC-DELISTED	Stock	7.29	7.73	7.075	7.72	203181.0
2017-01-03	AACG	Stock	3.81	3.94	3.63	3.94	1900.0
2017-01-03	AAIC-DELISTED	Stock	14.9	15.15	14.83	15.09	406718.0
2017-01-03	AAL	Stock	47.28	47.34	46.14	46.3	6737800.0
2017-01-03	AAMC-DELISTED	Stock	15.75	16.4559	15.2794	15.5882	15800.0
2017-01-03	AAME	Stock	4.05	4.2	4.05	4.1	9900.0
2017-01-03	AAMI	Stock	14.72	14.78	14.32	14.44	363500.0
2017-01-03	AAOI	Stock	23.71	24.09	22.87	23.1	268200.0
2017-01-03	AAON	Stock	22.3	22.4667	21.9667	22.2333	206550.0
2017-01-03	AAP	Stock	170.78	171.36	169.31	170.6	691300.0
2017-01-03	AAT	Stock	43.3	43.3	42.81	43.04	151400.0
2017-01-03	AAU-DELISTED	Stock	0.977	1.09	0.97	1.01	293888.0
2017-01-03	AAUAF-DELISTED	Stock	0.977	1.09	0.97	1.01	294819.0
2017-01-03	AAV-DELISTED	Stock	6.9	6.9	6.4105	6.55	197902.0
2017-01-03	AAWW-DELISTED	Stock	52.2	52.55	51.1	51.6	136960.0
2017-01-03	AAXJ	Stock	55.46	55.75	55.32	55.47	1530464.0
2017-01-03	AAXN-DELISTED	Stock	24.4	24.83	24.19	24.57	364365.0
2017-01-03	AB	Stock	23.75	24.3	23.55	24.05	292500.0
2017-01-03	ABAC-DELISTED	Stock	3.88	3.88	3.75	3.75	2834.0
2017-01-03	ABAX-DELISTED	Stock	53.19	53.955	52.63	53.57	89869.0
2017-01-03	ABB-DELISTED	Stock	21.14	21.28	21.11	21.28	1955990.0
2017-01-03	ABBNY-DELISTED	Stock	21.14	21.28	21.11	21.28	2009610.0
2017-01-03	ABBV	Stock	62.92	63.03	61.94	62.41	9328200.0
2017-01-03	ABC-DELISTED	Stock	78.51	83.1	78.31	82.55	3717461.0
2017-01-03	ABCB	Stock	44.15	44.68	43.25	43.7	231800.0
2017-01-03	ABCD-DELISTED	Stock	5.0	5.0	4.89	4.95	6238.0
2017-01-03	ABCO-DELISTED	Stock	33.45	34.45	32.975	34.4	449429.0
2017-01-03	ABDC-DELISTED	Stock	12.15	12.24	11.95	12.075	63565.0
2017-01-03	ABE-DELISTED	Stock	11.16	11.39	11.16	11.37	4854.0
2017-01-03	ABEO	Stock	127.5	130.0	120.0	125.0	7364.0
2017-01-03	ABEV	Stock	5.06	5.08	5.02	5.07	16284700.0
2017-01-03	ABG	Stock	62.7	63.25	61.55	62.5	160500.0
2017-01-03	ABIL-DELISTED	Stock	2.89	2.89	2.78	2.8799	10390.0
2017-01-03	ABM	Stock	40.57	41.09	40.2	40.8	548700.0
2017-01-03	ABMD-DELISTED	Stock	112.56	114.4082	111.48	112.36	229670.0
2017-01-03	ABR	Stock	7.5	7.63	7.43	7.62	122600.0

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

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