PREVIEW / stock_daily / 2014-05-02

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-02.parquet
  size:    219 KB
  rows:    6,513
  symbols: 3,532

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-05-02	AAPL	Stock	21.155	21.2214	21.0611	21.1636	191514400.0
2014-05-02	MSFT	Stock	40.31	40.34	39.66	39.69	43416600.0
2014-05-02	NVDA	Stock	0.4665	0.4665	0.458	0.4608	156376000.0
2014-05-02	AMZN	Stock	15.521	15.6645	15.2155	15.4005	79902000.0
2014-05-02	GOOGL	Stock	27.072	27.12	26.6635	26.6935	35631900.0
2014-05-02	META	Stock	61.3	61.89	60.18	60.46	54189000.0
2014-05-02	TSLA	Stock	13.9067	14.0907	13.768	14.0607	61302000.0
2014-05-02	TLT	Stock	111.54	113.1	111.3	112.71	12702096.0
2014-05-02	ES	Stock	46.26	46.82	45.82	45.98	2165900.0
2014-05-02	CL	Stock	66.9	67.33	66.8	67.1	2538900.0
2014-05-02	A	Stock	38.9843	39.3348	38.691	39.0129	2909098.0
2014-05-02	AABA-DELISTED	Stock	36.59	37.12	36.21	36.87	20614679.0
2014-05-02	AACG	Stock	4.36	4.38	4.34	4.38	500.0
2014-05-02	AAIC-DELISTED	Stock	26.31	26.49	26.15	26.21	201417.0
2014-05-02	AAL	Stock	36.27	36.72	36.06	36.49	6986300.0
2014-05-02	AAMC-DELISTED	Stock	291.7676	294.1206	287.0588	287.0588	30308.0
2014-05-02	AAME	Stock	3.52	3.52	3.48	3.48	2600.0
2014-05-02	AAOI	Stock	21.92	22.14	21.35	21.81	129800.0
2014-05-02	AAON	Stock	12.5956	12.9911	12.5022	12.8444	263475.0
2014-05-02	AAP	Stock	121.26	123.03	121.15	121.69	449300.0
2014-05-02	AAT	Stock	33.93	34.7	33.82	34.67	217000.0
2014-05-02	AAU-DELISTED	Stock	1.36	1.4	1.35	1.38	68903.0
2014-05-02	AAUAF-DELISTED	Stock	1.36	1.4	1.35	1.38	69928.0
2014-05-02	AAV-DELISTED	Stock	6.28	6.35	6.24	6.3	264411.0
2014-05-02	AAWW-DELISTED	Stock	39.49	39.5	37.87	37.95	762213.0
2014-05-02	AAXJ	Stock	59.6	59.99	59.6	59.85	276145.0
2014-05-02	AAXN-DELISTED	Stock	15.25	15.34	14.1	14.12	2736803.0
2014-05-02	AB	Stock	24.97	25.24	24.71	24.84	210500.0
2014-05-02	ABAC-DELISTED	Stock	1.9976	2.05	1.97	1.99	7414.0
2014-05-02	ABAX-DELISTED	Stock	41.24	41.61	40.79	41.19	82588.0
2014-05-02	ABB-DELISTED	Stock	24.01	24.28	23.99	24.145	5146992.0
2014-05-02	ABBNY-DELISTED	Stock	24.01	24.28	23.99	24.14	5687060.0
2014-05-02	ABBV	Stock	51.41	51.72	51.0	51.18	3341300.0
2014-05-02	ABC-DELISTED	Stock	64.89	64.89	64.15	64.26	1497408.0
2014-05-02	ABCB	Stock	21.08	21.5	20.85	21.09	76600.0
2014-05-02	ABCD-DELISTED	Stock	2.22	2.24	2.22	2.23	18900.0
2014-05-02	ABCO-DELISTED	Stock	56.83	59.555	54.09	56.48	194036.0
2014-05-02	ABE-DELISTED	Stock	13.54	13.65	13.5152	13.592	15025.0
2014-05-02	ABEO	Stock	625.0	625.0	575.0	612.5	11.0
2014-05-02	ABEV	Stock	7.2	7.33	7.13	7.24	27250500.0
2014-05-02	ABG	Stock	62.65	63.83	62.57	63.13	431500.0
2014-05-02	ABGB-DELISTED	Stock	22.47	22.84	22.47	22.77	10816.0
2014-05-02	ABIL-DELISTED	Stock	9.71	9.79	9.71	9.76	17400.0
2014-05-02	ABM	Stock	26.92	27.46	26.87	27.18	182700.0
2014-05-02	ABMD-DELISTED	Stock	22.61	23.03	22.28	22.69	724595.0
2014-05-02	ABR	Stock	7.05	7.19	7.03	7.16	99000.0
2014-05-02	ABR.A-DELISTED	Stock	25.14	25.25	25.08	25.25	64366.0
2014-05-02	ABR.B-DELISTED	Stock	23.65	24.14	23.65	24.14	13762.0
2014-05-02	ABR.C-DELISTED	Stock	25.3501	25.49	25.3501	25.36	52315.0
2014-05-02	ABT	Stock	38.67	38.84	38.49	38.56	4774500.0

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

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