PREVIEW / stock_daily / 2014-02-04

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-04.parquet
  size:    217 KB
  rows:    6,465
  symbols: 3,540

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-04	AAPL	Stock	18.0661	18.195	17.9557	18.1711	376681200.0
2014-02-04	MSFT	Stock	36.97	37.19	36.25	36.35	54697900.0
2014-02-04	NVDA	Stock	0.387	0.3902	0.385	0.3895	280692000.0
2014-02-04	AMZN	Stock	17.4795	17.7	17.201	17.3975	96258000.0
2014-02-04	META	Stock	62.05	63.14	61.82	62.75	45985500.0
2014-02-04	TSLA	Stock	12.0467	12.1067	11.7467	11.9153	70294500.0
2014-02-04	TLT	Stock	108.52	108.67	107.97	108.16	9573468.0
2014-02-04	ES	Stock	43.58	43.58	43.1	43.48	1775100.0
2014-02-04	CL	Stock	60.35	60.67	60.14	60.35	5220800.0
2014-02-04	A	Stock	40.2861	41.402	40.1216	41.3519	4070836.0
2014-02-04	AABA-DELISTED	Stock	35.06	35.86	34.8555	35.65	20056700.0
2014-02-04	AACG	Stock	3.99	4.03	3.95	3.95	6700.0
2014-02-04	AAIC-DELISTED	Stock	25.45	26.14	25.32	25.83	272437.0
2014-02-04	AAL	Stock	34.04	34.38	33.58	34.05	11178900.0
2014-02-04	AAMC-DELISTED	Stock	275.8941	278.5294	264.7059	274.2794	49307.0
2014-02-04	AAME	Stock	3.95	3.98	3.94	3.95	5400.0
2014-02-04	AAOI	Stock	13.69	13.86	13.6	13.68	26800.0
2014-02-04	AAON	Stock	12.4933	12.7111	11.9156	12.4178	406125.0
2014-02-04	AAP	Stock	110.97	112.11	110.1	110.25	1086100.0
2014-02-04	AAT	Stock	32.13	32.64	31.82	32.0	199000.0
2014-02-04	AAU-DELISTED	Stock	1.42	1.42	1.35	1.38	128259.0
2014-02-04	AAUAF-DELISTED	Stock	1.42	1.42	1.35	1.38	130281.0
2014-02-04	AAV-DELISTED	Stock	3.95	4.0	3.95	3.96	79256.0
2014-02-04	AAWW-DELISTED	Stock	34.53	34.93	34.26	34.31	171991.0
2014-02-04	AAXJ	Stock	55.25	55.81	55.24	55.47	1003169.0
2014-02-04	AAXN-DELISTED	Stock	16.98	17.13	16.46	16.82	8041411.0
2014-02-04	AB	Stock	21.09	21.78	21.06	21.64	271200.0
2014-02-04	ABAC-DELISTED	Stock	1.93	1.96	1.92	1.96	10800.0
2014-02-04	ABAX-DELISTED	Stock	37.0	37.15	36.075	36.3	285261.0
2014-02-04	ABB-DELISTED	Stock	24.34	24.55	24.29	24.52	978184.0
2014-02-04	ABBNY-DELISTED	Stock	24.34	24.55	24.29	24.51	1013168.0
2014-02-04	ABBV	Stock	47.18	47.97	46.95	47.95	9606100.0
2014-02-04	ABC-DELISTED	Stock	65.38	65.68	64.86	65.01	1729399.0
2014-02-04	ABCB	Stock	20.35	20.66	20.0	20.17	181800.0
2014-02-04	ABCD-DELISTED	Stock	1.77	1.86	1.74	1.77	32186.0
2014-02-04	ABCO-DELISTED	Stock	61.93	62.53	59.87	60.18	244245.0
2014-02-04	ABE-DELISTED	Stock	12.35	12.44	12.35	12.38	31603.0
2014-02-04	ABEO	Stock	387.5	400.0	387.5	400.0	17.0
2014-02-04	ABEV	Stock	6.32	6.48	6.29	6.38	14572000.0
2014-02-04	ABFS-DELISTED	Stock	32.74	33.1	32.0501	32.34	344483.0
2014-02-04	ABG	Stock	47.6	51.44	47.49	49.11	730100.0
2014-02-04	ABGB-DELISTED	Stock	17.04	17.861	17.04	17.85	16525.0
2014-02-04	ABM	Stock	26.09	26.36	25.77	26.3	187200.0
2014-02-04	ABMD-DELISTED	Stock	26.59	26.59	25.97	26.31	414954.0
2014-02-04	ABR	Stock	6.8	6.92	6.78	6.8	144400.0
2014-02-04	ABR.A-DELISTED	Stock	25.1	25.1	25.1	25.1	200.0
2014-02-04	ABR.B-DELISTED	Stock	23.49	23.53	23.45	23.49	4371.0
2014-02-04	ABT	Stock	35.9	36.44	35.85	36.25	8237400.0
2014-02-04	ABTL-DELISTED	Stock	13.8711	14.67	13.721	14.62	158813.0
2014-02-04	ABUS	Stock	14.29	15.45	14.25	15.28	611400.0

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

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