PREVIEW / stock_daily / 2017-03-10

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-10.parquet
  size:    216 KB
  rows:    6,481
  symbols: 3,062

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-10	AAPL	Stock	34.8125	34.84	34.66	34.785	78451200.0
2017-03-10	MSFT	Stock	65.11	65.26	64.75	64.93	19538200.0
2017-03-10	NVDA	Stock	2.4902	2.5022	2.4595	2.478	499740000.0
2017-03-10	AMZN	Stock	42.85	42.8675	42.586	42.623	48728000.0
2017-03-10	GOOGL	Stock	43.135	43.2115	42.8805	43.0702	26731700.0
2017-03-10	META	Stock	138.91	139.49	138.22	138.79	16314100.0
2017-03-10	TSLA	Stock	16.414	16.4333	16.2	16.246	45994500.0
2017-03-10	TLT	Stock	117.14	117.32	116.68	117.25	9218505.0
2017-03-10	ES	Stock	57.79	58.12	57.43	57.71	1221200.0
2017-03-10	CL	Stock	73.74	74.34	73.45	74.26	3375600.0
2017-03-10	A	Stock	51.69	52.36	51.48	52.15	1860500.0
2017-03-10	AA	Stock	35.9	36.0	34.235	34.53	4052400.0
2017-03-10	AAAP-DELISTED	Stock	38.35	38.35	37.555	37.95	66143.0
2017-03-10	AABA-DELISTED	Stock	46.19	46.2	45.75	45.98	3620825.0
2017-03-10	AAC-DELISTED	Stock	8.63	8.76	8.54	8.75	82474.0
2017-03-10	AACG	Stock	3.71	3.94	3.7	3.7	28700.0
2017-03-10	AAIC-DELISTED	Stock	13.57	13.79	13.57	13.77	239169.0
2017-03-10	AAL	Stock	43.46	43.95	42.97	43.9	6842300.0
2017-03-10	AAM.A-DELISTED	Stock	24.55	24.68	24.41	24.65	261565.0
2017-03-10	AAMC-DELISTED	Stock	22.3235	23.2343	21.2941	22.3382	29624.0
2017-03-10	AAME	Stock	3.7	3.7	3.7	3.7	400.0
2017-03-10	AAMI	Stock	15.2	15.27	14.95	15.11	364300.0
2017-03-10	AAOI	Stock	52.01	52.46	49.42	50.92	1418100.0
2017-03-10	AAON	Stock	23.4333	23.6667	23.2	23.6	291750.0
2017-03-10	AAP	Stock	155.52	155.81	153.39	153.97	1064500.0
2017-03-10	AAT	Stock	41.23	41.45	40.67	41.18	269800.0
2017-03-10	AAU-DELISTED	Stock	0.975	0.99	0.975	0.99	206091.0
2017-03-10	AAUAF-DELISTED	Stock	0.975	0.99	0.975	0.99	207064.0
2017-03-10	AAV-DELISTED	Stock	5.9	5.925	5.775	5.85	132411.0
2017-03-10	AAWW-DELISTED	Stock	54.5	55.95	54.15	54.3	125865.0
2017-03-10	AAXJ	Stock	60.37	60.57	60.3	60.56	414958.0
2017-03-10	AAXN-DELISTED	Stock	22.62	22.86	22.5	22.64	639603.0
2017-03-10	AB	Stock	22.8	23.05	22.65	22.75	199500.0
2017-03-10	ABAC-DELISTED	Stock	2.45	2.53	2.45	2.508	2484.0
2017-03-10	ABAX-DELISTED	Stock	49.18	49.19	48.55	49.01	54522.0
2017-03-10	ABB-DELISTED	Stock	22.51	22.66	22.47	22.64	2780469.0
2017-03-10	ABBNY-DELISTED	Stock	22.51	22.66	22.47	22.64	2832498.0
2017-03-10	ABBV	Stock	65.3	66.45	65.11	65.88	12788100.0
2017-03-10	ABC-DELISTED	Stock	88.99	89.0	87.76	88.34	1336661.0
2017-03-10	ABCB	Stock	46.25	46.25	43.1	45.8	442700.0
2017-03-10	ABCD-DELISTED	Stock	4.77	4.77	4.56	4.6301	13573.0
2017-03-10	ABCO-DELISTED	Stock	44.6	45.2	43.85	45.05	1707081.0
2017-03-10	ABDC-DELISTED	Stock	12.64	12.96	12.6179	12.95	71548.0
2017-03-10	ABE-DELISTED	Stock	12.05	12.15	12.05	12.15	11749.0
2017-03-10	ABEO	Stock	130.0	130.0	125.0	127.5	6848.0
2017-03-10	ABEOW-DELISTED	Stock	3.0	3.0	3.0	3.0	100.0
2017-03-10	ABEV	Stock	5.48	5.49	5.44	5.46	20783100.0
2017-03-10	ABG	Stock	61.8	62.4	61.4	61.55	267000.0
2017-03-10	ABIL-DELISTED	Stock	2.21	2.23	2.2	2.2	2600.0
2017-03-10	ABM	Stock	42.72	43.36	42.49	43.25	500900.0

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

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