PREVIEW / stock_daily / 2014-02-05

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-05.parquet
  size:    216 KB
  rows:    6,462
  symbols: 3,537

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-02-05	AAPL	Stock	18.0914	18.4029	18.0804	18.3068	328344800.0
2014-02-05	MSFT	Stock	36.29	36.47	35.8	35.82	55814400.0
2014-02-05	NVDA	Stock	0.3868	0.388	0.383	0.386	214676000.0
2014-02-05	AMZN	Stock	17.3	17.4685	16.8865	17.3225	88708000.0
2014-02-05	META	Stock	62.74	63.16	61.27	62.19	51685100.0
2014-02-05	TSLA	Stock	11.8867	12.0393	11.2907	11.628	109020000.0
2014-02-05	TLT	Stock	107.69	107.78	107.01	107.16	10312498.0
2014-02-05	ES	Stock	43.25	43.33	42.88	43.11	1843200.0
2014-02-05	CL	Stock	60.15	60.79	60.02	60.42	5981000.0
2014-02-05	A	Stock	41.1874	41.2732	40.7439	41.0801	3192892.0
2014-02-05	AABA-DELISTED	Stock	35.6	35.94	34.995	35.5	12912304.0
2014-02-05	AAIC-DELISTED	Stock	25.7	25.73	24.77	24.91	348341.0
2014-02-05	AAL	Stock	33.82	33.97	33.4	33.8	15465100.0
2014-02-05	AAMC-DELISTED	Stock	277.9412	282.3382	264.7118	275.5588	71645.0
2014-02-05	AAME	Stock	3.94	3.99	3.94	3.97	5500.0
2014-02-05	AAOI	Stock	13.56	13.64	13.12	13.14	39700.0
2014-02-05	AAON	Stock	12.3156	12.3867	11.96	12.2311	274500.0
2014-02-05	AAP	Stock	109.86	112.22	109.65	110.75	1719100.0
2014-02-05	AAT	Stock	31.83	31.89	31.44	31.86	475200.0
2014-02-05	AAU-DELISTED	Stock	1.38	1.47	1.38	1.45	126011.0
2014-02-05	AAUAF-DELISTED	Stock	1.38	1.47	1.38	1.45	126934.0
2014-02-05	AAV-DELISTED	Stock	3.52	3.82	3.47	3.72	502805.0
2014-02-05	AAWW-DELISTED	Stock	34.11	34.51	33.6	33.81	228087.0
2014-02-05	AAXJ	Stock	54.94	55.35	54.74	55.07	473506.0
2014-02-05	AAXN-DELISTED	Stock	16.62	16.7	15.76	16.52	2022230.0
2014-02-05	AB	Stock	21.71	21.72	21.21	21.68	241100.0
2014-02-05	ABAC-DELISTED	Stock	1.9204	1.95	1.89	1.93	20581.0
2014-02-05	ABAX-DELISTED	Stock	36.19	37.625	35.67	37.1	229101.0
2014-02-05	ABB-DELISTED	Stock	24.85	24.915	24.66	24.77	2509904.0
2014-02-05	ABBNY-DELISTED	Stock	24.85	24.915	24.66	24.76	2757119.0
2014-02-05	ABBV	Stock	47.76	48.07	47.16	47.73	6987100.0
2014-02-05	ABC-DELISTED	Stock	64.82	65.12	64.28	64.73	2097487.0
2014-02-05	ABCB	Stock	20.1	20.32	19.81	19.86	94800.0
2014-02-05	ABCD-DELISTED	Stock	1.7	1.8	1.59	1.75	60001.0
2014-02-05	ABCO-DELISTED	Stock	59.99	61.25	58.76	58.99	262501.0
2014-02-05	ABE-DELISTED	Stock	12.37	12.38	12.3201	12.3597	8406.0
2014-02-05	ABEO	Stock	387.5	387.5	387.5	387.5	4.0
2014-02-05	ABEV	Stock	6.44	6.46	6.3	6.41	15166100.0
2014-02-05	ABFS-DELISTED	Stock	32.1	32.64	30.38	30.95	800250.0
2014-02-05	ABG	Stock	49.57	49.6	47.61	49.22	448800.0
2014-02-05	ABGB-DELISTED	Stock	18.17	18.2	18.12	18.1245	2550.0
2014-02-05	ABIL-DELISTED	Stock	10.0	10.0	10.0	10.0	200.0
2014-02-05	ABM	Stock	26.14	26.27	25.99	26.12	188400.0
2014-02-05	ABMD-DELISTED	Stock	26.25	26.7	25.32	26.08	356874.0
2014-02-05	ABR	Stock	6.8	6.9	6.79	6.8	116600.0
2014-02-05	ABR.B-DELISTED	Stock	23.57	23.78	23.56	23.75	8621.0
2014-02-05	ABT	Stock	36.12	36.6	35.98	36.35	7597300.0
2014-02-05	ABTL-DELISTED	Stock	14.35	14.4	13.51	13.73	186669.0
2014-02-05	ABUS	Stock	15.42	16.0	14.25	14.82	393900.0
2014-02-05	ABX-DELISTED	Stock	19.22	19.32	18.535	18.55	13824821.0

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

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