PREVIEW / stock_daily / 2015-07-31

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-31.parquet
  size:    223 KB
  rows:    6,648
  symbols: 3,475

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
2015-07-31	AAPL	Stock	30.65	30.66	30.2275	30.325	171540000.0
2015-07-31	MSFT	Stock	47.29	47.37	46.5	46.7	31201500.0
2015-07-31	NVDA	Stock	0.5025	0.5028	0.4958	0.4988	218340000.0
2015-07-31	AMZN	Stock	26.9545	27.142	26.726	26.8075	60512000.0
2015-07-31	GOOGL	Stock	33.235	33.25	32.86	32.875	34921880.0
2015-07-31	META	Stock	94.95	96.33	93.95	94.01	46509000.0
2015-07-31	TSLA	Stock	17.84	17.9573	17.6747	17.7433	33339000.0
2015-07-31	TLT	Stock	122.44	122.9	122.06	122.53	9178422.0
2015-07-31	ES	Stock	49.57	49.99	49.07	49.72	1996100.0
2015-07-31	CL	Stock	68.06	68.29	67.8	68.02	3548000.0
2015-07-31	A	Stock	41.05	41.14	40.78	40.95	2247700.0
2015-07-31	AA.B-DELISTED	Stock	37.13	37.13	36.08	36.08	71997.0
2015-07-31	AABA-DELISTED	Stock	37.56	37.57	36.62	36.68	14158123.0
2015-07-31	AAC-DELISTED	Stock	37.49	38.23	37.43	38.01	502765.0
2015-07-31	AACG	Stock	3.4	3.8	3.33	3.46	70700.0
2015-07-31	AAIC-DELISTED	Stock	19.0	19.26	18.91	19.1	277041.0
2015-07-31	AAL	Stock	40.53	40.54	39.88	40.1	6955900.0
2015-07-31	AAMC-DELISTED	Stock	39.2382	39.7059	38.7882	38.9912	21155.0
2015-07-31	AAME	Stock	3.7	3.72	3.7	3.72	9300.0
2015-07-31	AAMI	Stock	17.71	18.0	17.56	17.67	168700.0
2015-07-31	AAOI	Stock	18.53	19.833	18.51	19.45	361400.0
2015-07-31	AAON	Stock	14.9533	15.1067	14.6667	14.7933	303150.0
2015-07-31	AAP	Stock	173.44	175.0	172.06	174.21	644400.0
2015-07-31	AAT	Stock	41.39	41.96	41.12	41.62	146200.0
2015-07-31	AAU-DELISTED	Stock	0.611	0.63	0.6067	0.6194	47246.0
2015-07-31	AAUAF-DELISTED	Stock	0.614	0.63	0.6101	0.6229	47187.0
2015-07-31	AAV-DELISTED	Stock	5.55	5.61	5.43	5.45	86333.0
2015-07-31	AAVL-DELISTED	Stock	14.37	15.28	14.21	14.72	285896.0
2015-07-31	AAWW-DELISTED	Stock	48.93	49.73	48.34	49.15	767142.0
2015-07-31	AAXJ	Stock	59.46	59.63	59.13	59.27	979369.0
2015-07-31	AAXN-DELISTED	Stock	28.61	28.8	26.25	27.22	5618544.0
2015-07-31	AB	Stock	27.25	27.65	26.93	27.47	184400.0
2015-07-31	ABAC-DELISTED	Stock	1.15	1.15	1.0999	1.1	3649.0
2015-07-31	ABAX-DELISTED	Stock	49.35	50.53	49.166	50.06	178318.0
2015-07-31	ABB-DELISTED	Stock	20.39	20.41	20.25	20.27	1470708.0
2015-07-31	ABBNY-DELISTED	Stock	20.39	20.41	20.25	20.28	1517149.0
2015-07-31	ABBV	Stock	70.38	70.38	69.73	70.01	6181300.0
2015-07-31	ABC-DELISTED	Stock	104.58	106.25	104.1333	105.76	2387461.0
2015-07-31	ABCB	Stock	26.92	27.05	26.73	27.01	164500.0
2015-07-31	ABCD-DELISTED	Stock	4.59	4.74	4.56	4.7	277195.0
2015-07-31	ABCO-DELISTED	Stock	59.49	60.38	59.05	59.93	190727.0
2015-07-31	ABCW-DELISTED	Stock	38.26	38.96	37.0	37.22	28289.0
2015-07-31	ABDC-DELISTED	Stock	12.58	12.74	12.51	12.5597	25356.0
2015-07-31	ABE-DELISTED	Stock	12.63	12.76	12.63	12.718	1723.0
2015-07-31	ABEO	Stock	150.5	164.75	150.5	161.25	10624.0
2015-07-31	ABEOW-DELISTED	Stock	2.6	2.6	2.251	2.45	6438.0
2015-07-31	ABEV	Stock	5.66	5.69	5.6	5.68	12965800.0
2015-07-31	ABG	Stock	87.92	88.86	87.55	88.3	268700.0
2015-07-31	ABGB-DELISTED	Stock	11.18	11.4	11.05	11.05	19072.0
2015-07-31	ABIL-DELISTED	Stock	9.96	9.96	9.95	9.95	3791.0

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

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