PREVIEW / stock_daily / 2014-04-24

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-24.parquet
  size:    218 KB
  rows:    6,517
  symbols: 3,541

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-24	AAPL	Stock	20.2932	20.3571	20.0261	20.2775	759911600.0
2014-04-24	MSFT	Stock	39.74	39.97	39.3	39.86	42381600.0
2014-04-24	NVDA	Stock	0.4805	0.4865	0.4805	0.4815	391492000.0
2014-04-24	AMZN	Stock	16.4835	16.87	16.1475	16.8575	185874000.0
2014-04-24	GOOGL	Stock	27.0845	27.125	26.55	26.722	41391180.0
2014-04-24	META	Stock	63.6	63.65	59.77	60.87	138769000.0
2014-04-24	TSLA	Stock	14.054	14.1867	13.5467	13.8573	82428000.0
2014-04-24	TLT	Stock	110.45	111.21	110.45	111.17	6337810.0
2014-04-24	ES	Stock	46.08	46.47	45.79	46.44	1460900.0
2014-04-24	CL	Stock	66.05	66.46	65.95	66.43	3992000.0
2014-04-24	A	Stock	39.5064	39.7139	39.0272	39.5422	2525347.0
2014-04-24	AABA-DELISTED	Stock	35.82	35.85	34.77	35.23	16587674.0
2014-04-24	AACG	Stock	4.05	4.09	3.9	4.01	15500.0
2014-04-24	AAIC-DELISTED	Stock	26.03	26.105	25.8	25.89	115717.0
2014-04-24	AAL	Stock	37.84	38.24	35.8	37.26	21038700.0
2014-04-24	AAMC-DELISTED	Stock	292.6706	294.1059	291.5	291.5	10941.0
2014-04-24	AAME	Stock	3.51	3.57	3.48	3.5	9400.0
2014-04-24	AAOI	Stock	23.79	23.79	23.09	23.51	216500.0
2014-04-24	AAON	Stock	12.7244	13.0978	12.4222	12.76	571725.0
2014-04-24	AAP	Stock	121.85	123.04	120.54	122.34	398800.0
2014-04-24	AAT	Stock	34.01	34.01	33.36	33.82	137300.0
2014-04-24	AAU-DELISTED	Stock	1.4	1.44	1.4	1.4201	74409.0
2014-04-24	AAUAF-DELISTED	Stock	1.4	1.44	1.4	1.4201	75725.0
2014-04-24	AAV-DELISTED	Stock	5.95	5.99	5.88	5.8958	637939.0
2014-04-24	AAWW-DELISTED	Stock	36.12	36.15	35.4	35.5	135957.0
2014-04-24	AAXJ	Stock	60.15	60.15	59.75	60.13	179983.0
2014-04-24	AAXN-DELISTED	Stock	18.3	18.436	17.71	18.18	722293.0
2014-04-24	AB	Stock	26.66	26.69	26.1	26.39	171800.0
2014-04-24	ABAC-DELISTED	Stock	2.21	2.22	2.1101	2.1938	22421.0
2014-04-24	ABAX-DELISTED	Stock	39.5	39.596	38.15	38.868	159076.0
2014-04-24	ABB-DELISTED	Stock	26.05	26.19	25.91	26.025	958897.0
2014-04-24	ABBNY-DELISTED	Stock	26.05	26.19	25.91	26.04	997461.0
2014-04-24	ABBV	Stock	50.13	50.13	49.0	49.32	6628800.0
2014-04-24	ABC-DELISTED	Stock	66.0	66.81	63.76	64.89	3326102.0
2014-04-24	ABCB	Stock	22.61	22.7	22.2	22.23	48700.0
2014-04-24	ABCD-DELISTED	Stock	2.2	2.2	2.13	2.15	2500.0
2014-04-24	ABCO-DELISTED	Stock	60.42	60.42	58.59	58.92	157150.0
2014-04-24	ABE-DELISTED	Stock	13.32	13.36	13.2658	13.34	6665.0
2014-04-24	ABEO	Stock	612.5	650.0	537.5	650.0	18.0
2014-04-24	ABEV	Stock	7.89	7.89	7.69	7.81	9921000.0
2014-04-24	ABFS-DELISTED	Stock	39.33	39.59	37.91	38.83	334589.0
2014-04-24	ABG	Stock	58.97	60.56	58.7	60.09	406500.0
2014-04-24	ABGB-DELISTED	Stock	22.9	22.9	22.35	22.5382	19072.0
2014-04-24	ABIL-DELISTED	Stock	9.64	9.64	9.64	9.64	247.0
2014-04-24	ABM	Stock	27.76	27.76	27.29	27.35	145600.0
2014-04-24	ABMD-DELISTED	Stock	25.51	25.63	25.04	25.08	199325.0
2014-04-24	ABR	Stock	7.03	7.03	6.97	7.03	57600.0
2014-04-24	ABR.A-DELISTED	Stock	25.05	25.1396	25.0	25.05	5084.0
2014-04-24	ABR.B-DELISTED	Stock	23.56	23.76	23.5519	23.76	31618.0
2014-04-24	ABR.C-DELISTED	Stock	25.18	25.36	24.94	25.11	44127.0

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

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