PREVIEW / stock_daily / 2017-03-23

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-23.parquet
  size:    215 KB
  rows:    6,457
  symbols: 3,037

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-03-23	AAPL	Stock	35.315	35.395	35.1525	35.23	81385200.0
2017-03-23	MSFT	Stock	64.94	65.24	64.77	64.87	19269200.0
2017-03-23	NVDA	Stock	2.6938	2.714	2.6675	2.6773	533940000.0
2017-03-23	AMZN	Stock	42.41	42.5445	42.24	42.369	39060000.0
2017-03-23	GOOGL	Stock	42.0695	42.0845	41.65	41.9825	65753380.0
2017-03-23	META	Stock	139.48	140.39	139.09	139.53	13022800.0
2017-03-23	TSLA	Stock	17.026	17.178	16.8867	16.9853	49803000.0
2017-03-23	TLT	Stock	120.83	121.02	120.06	120.45	6746461.0
2017-03-23	ES	Stock	59.6	60.28	59.53	59.67	1245500.0
2017-03-23	CL	Stock	73.61	74.44	73.52	73.92	2843700.0
2017-03-23	A	Stock	53.04	53.78	52.72	53.18	1717900.0
2017-03-23	AA	Stock	33.41	33.69	33.11	33.31	3072000.0
2017-03-23	AAAP-DELISTED	Stock	35.5	39.96	35.5	39.68	203349.0
2017-03-23	AABA-DELISTED	Stock	46.13	46.78	46.09	46.61	7910518.0
2017-03-23	AAC-DELISTED	Stock	8.0	8.04	7.76	7.81	61574.0
2017-03-23	AACG	Stock	3.76	3.99	3.75	3.96	25900.0
2017-03-23	AAIC-DELISTED	Stock	14.27	14.395	14.2	14.34	310199.0
2017-03-23	AAL	Stock	40.7	41.86	40.48	41.41	9516600.0
2017-03-23	AAM.A-DELISTED	Stock	25.0	25.03	24.99	25.01	169237.0
2017-03-23	AAMC-DELISTED	Stock	16.9559	17.9412	15.5441	16.0147	250900.0
2017-03-23	AAME	Stock	3.66	3.9	3.66	3.9	900.0
2017-03-23	AAMI	Stock	14.25	14.48	14.084	14.43	344300.0
2017-03-23	AAOI	Stock	52.9	53.15	50.91	51.51	1399500.0
2017-03-23	AAON	Stock	23.7333	24.3	23.7	24.2333	176850.0
2017-03-23	AAP	Stock	151.3	152.38	150.12	150.78	653100.0
2017-03-23	AAT	Stock	41.13	42.61	41.13	42.07	437900.0
2017-03-23	AAU-DELISTED	Stock	1.13	1.15	1.11	1.15	162553.0
2017-03-23	AAUAF-DELISTED	Stock	1.13	1.15	1.11	1.15	163249.0
2017-03-23	AAV-DELISTED	Stock	5.9	6.16	5.9	6.1	72046.0
2017-03-23	AAWW-DELISTED	Stock	51.2	52.15	50.55	51.75	96702.0
2017-03-23	AAXJ	Stock	63.05	63.46	63.0444	63.24	1451763.0
2017-03-23	AAXN-DELISTED	Stock	22.5	22.7701	22.32	22.625	648651.0
2017-03-23	AB	Stock	21.7	21.95	21.65	21.65	607800.0
2017-03-23	ABAC-DELISTED	Stock	2.3	2.32	2.25	2.2602	15508.0
2017-03-23	ABAX-DELISTED	Stock	48.44	48.46	46.2	48.07	97919.0
2017-03-23	ABB-DELISTED	Stock	23.16	23.44	23.14	23.315	1726753.0
2017-03-23	ABBNY-DELISTED	Stock	23.16	23.44	23.14	23.31	1971807.0
2017-03-23	ABBV	Stock	65.52	66.07	65.36	65.65	4099500.0
2017-03-23	ABC-DELISTED	Stock	85.86	86.75	85.79	86.03	1230888.0
2017-03-23	ABCB	Stock	43.05	44.1	43.05	43.5	200400.0
2017-03-23	ABCD-DELISTED	Stock	5.1203	5.1999	5.11	5.12	27607.0
2017-03-23	ABCO-DELISTED	Stock	44.7	45.0	44.41	44.7	435747.0
2017-03-23	ABDC-DELISTED	Stock	13.26	13.5535	13.26	13.55	23012.0
2017-03-23	ABE-DELISTED	Stock	12.6	12.62	12.585	12.6085	7655.0
2017-03-23	ABEO	Stock	115.0	123.75	114.5	117.5	9376.0
2017-03-23	ABEV	Stock	5.52	5.57	5.5	5.53	22608400.0
2017-03-23	ABG	Stock	60.45	61.45	60.1	60.45	197300.0
2017-03-23	ABIL-DELISTED	Stock	2.33	2.36	2.32	2.34	3000.0
2017-03-23	ABM	Stock	43.26	43.68	43.12	43.41	291700.0
2017-03-23	ABMD-DELISTED	Stock	123.11	125.49	122.13	123.76	276776.0

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

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