PREVIEW / stock_daily / 2017-06-14

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-14.parquet
  size:    215 KB
  rows:    6,464
  symbols: 3,008

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-06-14	AAPL	Stock	36.875	36.875	35.96	36.29	126124800.0
2017-06-14	MSFT	Stock	70.91	71.1	69.43	70.27	25510700.0
2017-06-14	NVDA	Stock	3.788	3.8515	3.7125	3.793	1184640000.0
2017-06-14	AMZN	Stock	49.4295	49.517	48.3355	48.8235	79498000.0
2017-06-14	GOOGL	Stock	48.775	48.985	47.9755	48.3965	30109720.0
2017-06-14	META	Stock	151.26	152.4	149.05	150.25	20808800.0
2017-06-14	TSLA	Stock	25.406	25.6167	25.0873	25.3773	192276000.0
2017-06-14	TLT	Stock	125.92	126.71	125.73	126.3	20212287.0
2017-06-14	ES	Stock	62.67	62.96	62.16	62.45	1060300.0
2017-06-14	CL	Stock	76.17	76.35	75.6	75.88	2532800.0
2017-06-14	A	Stock	59.54	59.78	59.05	59.38	1202800.0
2017-06-14	AA	Stock	32.57	32.68	31.21	31.54	3726600.0
2017-06-14	AAAP-DELISTED	Stock	36.38	36.7	36.05	36.13	25986.0
2017-06-14	AABA-DELISTED	Stock	52.48	54.26	52.16	52.63	58490151.0
2017-06-14	AAC-DELISTED	Stock	6.57	6.79	6.53	6.74	58791.0
2017-06-14	AACG	Stock	4.9	4.9	4.7	4.76	9600.0
2017-06-14	AAIC-DELISTED	Stock	14.65	14.77	14.56	14.68	504959.0
2017-06-14	AAL	Stock	49.64	49.78	48.89	49.39	4027800.0
2017-06-14	AAM.A-DELISTED	Stock	25.5	25.69	25.5	25.69	89622.0
2017-06-14	AAMC-DELISTED	Stock	25.8824	26.75	25.4559	26.0441	13790.0
2017-06-14	AAME	Stock	3.6	3.7	3.6	3.7	2800.0
2017-06-14	AAMI	Stock	14.38	14.91	14.335	14.8	2922100.0
2017-06-14	AAOI	Stock	64.0	64.9	59.61	60.95	3749400.0
2017-06-14	AAON	Stock	25.2333	25.4667	25.1667	25.4	180750.0
2017-06-14	AAP	Stock	131.93	131.93	130.13	130.59	880900.0
2017-06-14	AAT	Stock	41.31	41.31	40.58	40.82	227300.0
2017-06-14	AAU-DELISTED	Stock	1.42	1.4418	1.35	1.35	263227.0
2017-06-14	AAUAF-DELISTED	Stock	1.42	1.4418	1.35	1.35	269243.0
2017-06-14	AAV-DELISTED	Stock	6.25	6.25	6.1	6.1	60033.0
2017-06-14	AAWW-DELISTED	Stock	53.8	53.8	52.2	53.1	147317.0
2017-06-14	AAXJ	Stock	68.12	68.16	67.55	67.74	1209393.0
2017-06-14	AAXN-DELISTED	Stock	24.38	24.5	24.17	24.28	351241.0
2017-06-14	AB	Stock	23.1	23.5	23.05	23.3	303600.0
2017-06-14	ABAC-DELISTED	Stock	2.1625	2.2	2.1625	2.189	4500.0
2017-06-14	ABAX-DELISTED	Stock	51.68	52.35	51.3	51.82	78813.0
2017-06-14	ABB-DELISTED	Stock	25.51	25.51	25.075	25.18	1519251.0
2017-06-14	ABBNY-DELISTED	Stock	25.51	25.51	25.075	25.18	1559545.0
2017-06-14	ABBV	Stock	69.48	70.79	69.37	70.52	6639100.0
2017-06-14	ABC-DELISTED	Stock	93.0	94.592	92.9	93.91	766224.0
2017-06-14	ABCB	Stock	47.75	48.25	47.0	48.2	122200.0
2017-06-14	ABCD-DELISTED	Stock	4.93	4.99	4.8	4.93	40633.0
2017-06-14	ABCO-DELISTED	Stock	51.0	51.5	50.85	51.5	341562.0
2017-06-14	ABDC-DELISTED	Stock	13.32	13.51	13.25	13.31	32820.0
2017-06-14	ABE-DELISTED	Stock	13.892	13.92	13.8501	13.9143	5345.0
2017-06-14	ABEO	Stock	126.25	126.25	122.5	123.75	3764.0
2017-06-14	ABEV	Stock	5.55	5.58	5.44	5.5	31057500.0
2017-06-14	ABG	Stock	57.5	57.95	56.75	57.85	116300.0
2017-06-14	ABIL-DELISTED	Stock	1.44	1.5	1.26	1.4201	1319131.0
2017-06-14	ABM	Stock	41.39	41.39	40.59	40.89	328500.0
2017-06-14	ABMD-DELISTED	Stock	141.48	143.71	140.67	142.29	190365.0

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

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