PREVIEW / stock_daily / 2014-05-05

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-05.parquet
  size:    218 KB
  rows:    6,529
  symbols: 3,548

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-05	AAPL	Stock	21.0764	21.4643	21.0714	21.4629	287067200.0
2014-05-05	MSFT	Stock	39.52	39.64	39.3	39.43	22460900.0
2014-05-05	NVDA	Stock	0.4603	0.4692	0.4598	0.4658	239260000.0
2014-05-05	AMZN	Stock	15.3185	15.5115	15.25	15.5025	50398000.0
2014-05-05	GOOGL	Stock	26.512	26.786	26.379	26.7665	24575940.0
2014-05-05	META	Stock	59.67	61.35	59.18	61.22	46057000.0
2014-05-05	TSLA	Stock	13.9653	14.5127	13.9013	14.4407	77205000.0
2014-05-05	TLT	Stock	112.76	112.81	111.89	112.03	8042997.0
2014-05-05	ES	Stock	46.06	46.7	45.99	46.62	1285100.0
2014-05-05	CL	Stock	66.87	67.14	66.67	66.9	2032600.0
2014-05-05	A	Stock	38.8484	39.5923	38.5479	39.578	2918045.0
2014-05-05	AABA-DELISTED	Stock	36.68	37.05	36.3	36.91	12108548.0
2014-05-05	AACG	Stock	4.32	4.37	4.32	4.37	400.0
2014-05-05	AAIC-DELISTED	Stock	26.15	26.2	25.92	26.05	195519.0
2014-05-05	AAL	Stock	36.08	36.78	35.79	36.6	5818100.0
2014-05-05	AAMC-DELISTED	Stock	289.4088	289.7059	280.0059	285.4662	16245.0
2014-05-05	AAOI	Stock	21.7	21.77	20.88	21.45	115700.0
2014-05-05	AAON	Stock	13.32	14.1867	13.32	14.0311	605250.0
2014-05-05	AAP	Stock	120.63	121.7	119.65	121.03	625600.0
2014-05-05	AAT	Stock	34.36	34.63	34.15	34.21	123700.0
2014-05-05	AAU-DELISTED	Stock	1.4	1.4	1.34	1.36	25555.0
2014-05-05	AAUAF-DELISTED	Stock	1.38	1.4	1.35	1.36	27795.0
2014-05-05	AAV-DELISTED	Stock	6.28	6.44	6.18	6.39	502264.0
2014-05-05	AAWW-DELISTED	Stock	37.47	37.94	37.1	37.1	405233.0
2014-05-05	AAXJ	Stock	59.53	59.67	59.31	59.67	141722.0
2014-05-05	AAXN-DELISTED	Stock	14.12	14.59	13.82	14.41	1315877.0
2014-05-05	AB	Stock	24.86	25.22	24.57	24.84	362100.0
2014-05-05	ABAC-DELISTED	Stock	2.0001	2.1	2.0	2.09	43721.0
2014-05-05	ABAX-DELISTED	Stock	41.05	41.4	40.23	40.67	119247.0
2014-05-05	ABB-DELISTED	Stock	23.31	23.41	23.2	23.375	3269918.0
2014-05-05	ABBNY-DELISTED	Stock	23.31	23.41	23.2	23.37	3381363.0
2014-05-05	ABBV	Stock	50.99	51.37	50.31	51.36	2580300.0
2014-05-05	ABC-DELISTED	Stock	64.0	65.3	63.88	65.09	1496406.0
2014-05-05	ABCB	Stock	20.89	20.99	20.55	20.89	62200.0
2014-05-05	ABCD-DELISTED	Stock	2.1	2.1999	2.01	2.14	49376.0
2014-05-05	ABCO-DELISTED	Stock	55.88	57.04	55.41	56.78	159291.0
2014-05-05	ABE-DELISTED	Stock	13.65	13.65	13.5563	13.62	8676.0
2014-05-05	ABEO	Stock	562.5	625.0	562.5	587.5	19.0
2014-05-05	ABEV	Stock	7.2	7.36	7.19	7.32	11521400.0
2014-05-05	ABG	Stock	62.86	63.29	61.77	62.77	179900.0
2014-05-05	ABGB-DELISTED	Stock	22.59	23.33	22.59	23.33	9993.0
2014-05-05	ABIL-DELISTED	Stock	9.73	9.83	9.73	9.76	14440.0
2014-05-05	ABM	Stock	27.1	27.21	26.85	27.16	192500.0
2014-05-05	ABMD-DELISTED	Stock	22.61	22.94	22.11	22.24	616967.0
2014-05-05	ABR	Stock	7.19	7.19	7.08	7.1	86200.0
2014-05-05	ABR.A-DELISTED	Stock	25.23	25.25	25.21	25.21	2676.0
2014-05-05	ABR.B-DELISTED	Stock	24.14	24.17	23.9902	24.1	21690.0
2014-05-05	ABR.C-DELISTED	Stock	25.49	25.49	25.31	25.4201	8714.0
2014-05-05	ABT	Stock	38.27	39.13	38.25	38.84	7593500.0
2014-05-05	ABTL-DELISTED	Stock	12.04	12.5	12.03	12.35	207887.0

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

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