PREVIEW / stock_daily / 2014-04-04

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-04.parquet
  size:    219 KB
  rows:    6,532
  symbols: 3,550

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
2014-04-04	AAPL	Stock	19.2789	19.2857	18.9493	18.9936	275251200.0
2014-04-04	MSFT	Stock	41.25	41.39	39.64	39.87	51409600.0
2014-04-04	NVDA	Stock	0.4708	0.4735	0.4518	0.4538	368032000.0
2014-04-04	AMZN	Stock	16.7575	16.772	15.7805	16.15	250692000.0
2014-04-04	GOOGL	Stock	28.9275	28.9859	27.2247	27.2625	107339440.0
2014-04-04	META	Stock	59.94	60.2	56.32	56.75	125214400.0
2014-04-04	TSLA	Stock	15.0673	15.218	14.0833	14.1487	170184000.0
2014-04-04	TLT	Stock	107.87	108.69	107.8499	108.46	8977484.0
2014-04-04	ES	Stock	45.1	45.65	45.01	45.09	1444300.0
2014-04-04	CL	Stock	64.57	64.65	64.13	64.22	2435300.0
2014-04-04	A	Stock	40.8441	40.9442	39.7353	39.7496	3226165.0
2014-04-04	AABA-DELISTED	Stock	35.96	36.0499	33.83	34.26	38705444.0
2014-04-04	AACG	Stock	4.27	4.27	4.08	4.08	15100.0
2014-04-04	AAIC-DELISTED	Stock	26.6	26.61	25.97	26.03	322478.0
2014-04-04	AAL	Stock	37.41	37.72	36.3	36.56	8731000.0
2014-04-04	AAMC-DELISTED	Stock	322.6191	332.0588	318.8294	319.1176	63947.0
2014-04-04	AAME	Stock	3.66	3.66	3.62	3.65	6400.0
2014-04-04	AAOI	Stock	23.64	23.64	22.22	22.38	329500.0
2014-04-04	AAON	Stock	12.4222	12.4489	11.7778	11.8622	289800.0
2014-04-04	AAP	Stock	125.14	125.77	121.57	121.64	904500.0
2014-04-04	AAT	Stock	34.17	34.17	33.53	33.75	113600.0
2014-04-04	AAU-DELISTED	Stock	1.45	1.51	1.4292	1.5	100767.0
2014-04-04	AAUAF-DELISTED	Stock	1.43	1.5	1.41	1.5	102899.0
2014-04-04	AAV-DELISTED	Stock	5.21	5.27	5.18	5.25	210562.0
2014-04-04	AAWW-DELISTED	Stock	35.78	36.04	35.1	35.73	166630.0
2014-04-04	AAXJ	Stock	60.21	60.6975	59.62	59.65	322329.0
2014-04-04	AAXN-DELISTED	Stock	18.45	18.5	17.51	17.62	1210866.0
2014-04-04	AB	Stock	25.4	26.0	25.18	25.42	712100.0
2014-04-04	ABAC-DELISTED	Stock	1.85	1.86	1.8	1.812	21177.0
2014-04-04	ABAX-DELISTED	Stock	39.43	39.47	37.04	37.95	196600.0
2014-04-04	ABB-DELISTED	Stock	26.09	26.17	25.7849	25.85	1045009.0
2014-04-04	ABBNY-DELISTED	Stock	26.09	26.17	25.7849	25.84	1093779.0
2014-04-04	ABBV	Stock	53.78	54.44	52.05	52.2	7013200.0
2014-04-04	ABC-DELISTED	Stock	65.99	66.34	64.85	65.05	1771073.0
2014-04-04	ABCB	Stock	24.0	24.05	23.37	23.44	188500.0
2014-04-04	ABCD-DELISTED	Stock	2.28	2.34	2.15	2.17	53290.0
2014-04-04	ABCO-DELISTED	Stock	65.99	65.99	62.78	62.79	412033.0
2014-04-04	ABE-DELISTED	Stock	13.42	13.5	13.38	13.38	10015.0
2014-04-04	ABEO	Stock	650.0	650.0	562.5	637.5	18.0
2014-04-04	ABEV	Stock	7.66	7.7	7.46	7.49	17869600.0
2014-04-04	ABFS-DELISTED	Stock	38.39	38.9	36.6001	36.93	278392.0
2014-04-04	ABG	Stock	57.88	58.08	56.32	56.66	214200.0
2014-04-04	ABGB-DELISTED	Stock	26.26	26.26	25.501	25.7612	23522.0
2014-04-04	ABIL-DELISTED	Stock	9.68	9.9	9.64	9.64	17800.0
2014-04-04	ABM	Stock	29.11	29.11	28.27	28.3	214600.0
2014-04-04	ABMD-DELISTED	Stock	26.18	26.21	24.855	25.15	317349.0
2014-04-04	ABR	Stock	7.18	7.36	7.12	7.18	417000.0
2014-04-04	ABR.A-DELISTED	Stock	24.77	24.84	24.75	24.8369	2102.0
2014-04-04	ABR.B-DELISTED	Stock	23.0	23.0	22.99	23.0	23970.0
2014-04-04	ABR.C-DELISTED	Stock	24.8452	24.85	24.8	24.85	10060.0

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

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