PREVIEW / stock_daily / 2014-04-09

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-09.parquet
  size:    217 KB
  rows:    6,491
  symbols: 3,533

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-09	AAPL	Stock	18.6657	18.9461	18.6436	18.94	206169600.0
2014-04-09	MSFT	Stock	39.93	40.55	39.88	40.47	27398700.0
2014-04-09	NVDA	Stock	0.4738	0.4778	0.4673	0.471	421968000.0
2014-04-09	AMZN	Stock	16.4235	16.609	16.125	16.5905	101132000.0
2014-04-09	GOOGL	Stock	28.292	28.39	27.769	28.352	60671780.0
2014-04-09	META	Stock	59.63	62.46	59.19	62.41	100215000.0
2014-04-09	TSLA	Stock	14.4507	14.5633	14.0593	14.462	77368500.0
2014-04-09	TLT	Stock	108.88	109.35	108.64	108.83	5771491.0
2014-04-09	ES	Stock	45.56	45.73	44.97	45.56	1735400.0
2014-04-09	CL	Stock	65.6	65.98	65.46	65.73	3408700.0
2014-04-09	A	Stock	39.6567	39.7783	38.8984	39.7496	2820465.0
2014-04-09	AABA-DELISTED	Stock	34.19	35.0	33.95	34.88	20972391.0
2014-04-09	AACG	Stock	4.1	4.32	3.99	4.09	86400.0
2014-04-09	AAIC-DELISTED	Stock	25.78	25.93	25.68	25.89	116823.0
2014-04-09	AAL	Stock	36.08	37.0	35.16	36.9	11473300.0
2014-04-09	AAMC-DELISTED	Stock	308.8235	314.1176	304.765	308.8235	66365.0
2014-04-09	AAME	Stock	3.58	3.66	3.52	3.59	35700.0
2014-04-09	AAOI	Stock	21.94	23.64	21.94	23.3	352200.0
2014-04-09	AAON	Stock	11.6356	11.9022	11.5022	11.8622	211050.0
2014-04-09	AAP	Stock	120.15	121.7	119.36	121.58	580000.0
2014-04-09	AAT	Stock	33.61	33.73	33.35	33.49	110400.0
2014-04-09	AAU-DELISTED	Stock	1.45	1.5	1.41	1.44	44624.0
2014-04-09	AAUAF-DELISTED	Stock	1.47	1.5	1.43	1.44	44604.0
2014-04-09	AAV-DELISTED	Stock	5.14	5.37	5.11	5.21	376644.0
2014-04-09	AAWW-DELISTED	Stock	34.89	35.24	34.808	35.04	119827.0
2014-04-09	AAXJ	Stock	60.9	61.21	60.44	60.97	313661.0
2014-04-09	AAXN-DELISTED	Stock	17.03	17.4104	16.86	17.35	676383.0
2014-04-09	AB	Stock	25.43	25.58	25.11	25.47	228400.0
2014-04-09	ABAC-DELISTED	Stock	1.86	1.92	1.82	1.8201	12220.0
2014-04-09	ABAX-DELISTED	Stock	40.81	41.79	40.14	41.42	149325.0
2014-04-09	ABB-DELISTED	Stock	26.02	26.17	25.84	26.15	956504.0
2014-04-09	ABBNY-DELISTED	Stock	26.02	26.17	25.84	26.14	1022905.0
2014-04-09	ABBV	Stock	49.49	50.76	49.26	50.63	6018200.0
2014-04-09	ABC-DELISTED	Stock	64.77	65.71	64.64	65.64	2216406.0
2014-04-09	ABCB	Stock	23.15	23.3	22.95	23.18	58600.0
2014-04-09	ABCD-DELISTED	Stock	2.2	2.26	2.14	2.22	38214.0
2014-04-09	ABCO-DELISTED	Stock	62.22	63.1	61.18	63.01	105735.0
2014-04-09	ABE-DELISTED	Stock	13.45	13.5	13.42	13.4799	13278.0
2014-04-09	ABEO	Stock	612.5	625.0	587.5	625.0	15.0
2014-04-09	ABEV	Stock	7.55	7.65	7.45	7.59	9466100.0
2014-04-09	ABFS-DELISTED	Stock	36.08	37.26	35.655	37.2	187648.0
2014-04-09	ABG	Stock	55.51	56.48	54.93	56.29	166900.0
2014-04-09	ABGB-DELISTED	Stock	24.16	24.449	24.16	24.4399	1565.0
2014-04-09	ABIL-DELISTED	Stock	9.75	9.75	9.65	9.66	6800.0
2014-04-09	ABM	Stock	28.66	28.67	28.33	28.59	127500.0
2014-04-09	ABMD-DELISTED	Stock	23.85	24.61	23.84	24.58	370120.0
2014-04-09	ABR	Stock	7.13	7.13	7.0	7.09	103500.0
2014-04-09	ABR.A-DELISTED	Stock	24.989	24.989	24.79	24.94	3600.0
2014-04-09	ABR.B-DELISTED	Stock	23.0	23.0	22.99	22.99	2300.0
2014-04-09	ABR.C-DELISTED	Stock	24.849	24.849	24.8	24.82	5670.0

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

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