PREVIEW / stock_daily / 2014-02-10

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-10.parquet
  size:    216 KB
  rows:    6,466
  symbols: 3,535

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-10	AAPL	Stock	18.5236	18.9996	18.5	18.8925	345559200.0
2014-02-10	MSFT	Stock	36.63	36.8	36.29	36.8	26767000.0
2014-02-10	NVDA	Stock	0.3962	0.4032	0.396	0.398	324372000.0
2014-02-10	AMZN	Stock	18.0805	18.25	17.9675	18.0435	68994000.0
2014-02-10	META	Stock	64.3	64.49	63.47	63.55	43666100.0
2014-02-10	TSLA	Stock	12.6227	13.2867	12.6213	13.104	194560500.0
2014-02-10	TLT	Stock	106.61	107.12	106.57	107.09	4370474.0
2014-02-10	ES	Stock	43.21	43.82	42.94	43.79	1668200.0
2014-02-10	CL	Stock	60.84	61.62	60.81	61.52	4451800.0
2014-02-10	A	Stock	42.3963	42.5179	41.6953	42.2103	2461179.0
2014-02-10	AABA-DELISTED	Stock	38.0	38.13	37.25	37.76	16726174.0
2014-02-10	AAIC-DELISTED	Stock	24.95	25.09	24.85	25.03	114090.0
2014-02-10	AAL	Stock	36.1	36.15	35.38	35.58	11107300.0
2014-02-10	AAMC-DELISTED	Stock	282.3059	292.3382	279.4118	290.8088	46577.0
2014-02-10	AAME	Stock	3.98	3.98	3.95	3.95	300.0
2014-02-10	AAOI	Stock	13.12	13.25	12.75	13.12	31300.0
2014-02-10	AAON	Stock	12.3956	12.3956	12.1378	12.2133	293850.0
2014-02-10	AAP	Stock	124.52	125.43	123.0	123.32	1118500.0
2014-02-10	AAT	Stock	32.04	32.75	31.85	32.55	173100.0
2014-02-10	AAU-DELISTED	Stock	1.58	1.76	1.56	1.74	429110.0
2014-02-10	AAUAF-DELISTED	Stock	1.58	1.76	1.56	1.74	432428.0
2014-02-10	AAV-DELISTED	Stock	3.99	4.06	3.85	3.86	101088.0
2014-02-10	AAWW-DELISTED	Stock	34.1	34.77	34.0	34.76	204428.0
2014-02-10	AAXJ	Stock	55.96	56.05	55.56	55.77	1033057.0
2014-02-10	AAXN-DELISTED	Stock	16.84	16.92	16.33	16.92	1074540.0
2014-02-10	AB	Stock	22.06	22.46	21.95	22.32	291500.0
2014-02-10	ABAC-DELISTED	Stock	1.67	1.82	1.67	1.75	42320.0
2014-02-10	ABAX-DELISTED	Stock	36.88	37.25	36.4241	37.08	161639.0
2014-02-10	ABB-DELISTED	Stock	25.29	25.32	25.2	25.28	1135092.0
2014-02-10	ABBNY-DELISTED	Stock	25.29	25.32	25.2	25.28	1412496.0
2014-02-10	ABBV	Stock	48.75	50.19	48.72	49.55	7907500.0
2014-02-10	ABC-DELISTED	Stock	66.46	66.48	65.72	66.37	2573082.0
2014-02-10	ABCB	Stock	19.94	20.24	19.53	20.1	108600.0
2014-02-10	ABCD-DELISTED	Stock	1.78	1.89	1.77	1.8	37068.0
2014-02-10	ABCO-DELISTED	Stock	58.35	61.295	58.0701	59.25	332978.0
2014-02-10	ABE-DELISTED	Stock	12.48	12.78	12.32	12.4712	102855.0
2014-02-10	ABEO	Stock	425.0	425.0	387.5	425.0	15.0
2014-02-10	ABEV	Stock	6.8	6.8	6.62	6.7	6905600.0
2014-02-10	ABFS-DELISTED	Stock	30.87	31.69	30.52	30.95	369492.0
2014-02-10	ABG	Stock	50.13	50.19	49.13	49.45	210100.0
2014-02-10	ABGB-DELISTED	Stock	19.87	19.95	19.79	19.85	3731.0
2014-02-10	ABIL-DELISTED	Stock	9.53	9.78	9.53	9.65	622.0
2014-02-10	ABM	Stock	26.41	26.44	26.06	26.4	130800.0
2014-02-10	ABMD-DELISTED	Stock	27.1	27.1	26.51	26.96	214759.0
2014-02-10	ABR	Stock	6.95	7.0	6.91	6.94	83800.0
2014-02-10	ABR.B-DELISTED	Stock	23.76	23.78	23.64	23.74	800.0
2014-02-10	ABT	Stock	37.17	37.32	36.96	37.16	11207300.0
2014-02-10	ABTL-DELISTED	Stock	14.87	16.3	14.82	16.15	428529.0
2014-02-10	ABUS	Stock	14.81	15.62	14.67	14.84	369100.0
2014-02-10	ABX-DELISTED	Stock	19.13	19.41	19.1	19.29	10495050.0

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

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