PREVIEW / stock_daily / 2014-02-06

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-06.parquet
  size:    217 KB
  rows:    6,485
  symbols: 3,557

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-06	AAPL	Stock	18.2164	18.3393	18.1361	18.3039	257765200.0
2014-02-06	MSFT	Stock	35.8	36.25	35.69	36.18	35351800.0
2014-02-06	NVDA	Stock	0.3865	0.392	0.386	0.391	168380000.0
2014-02-06	AMZN	Stock	17.37	17.741	17.37	17.7295	66714000.0
2014-02-06	META	Stock	61.46	62.78	61.46	62.16	42086500.0
2014-02-06	TSLA	Stock	11.7533	12.0073	11.7333	11.892	87624000.0
2014-02-06	TLT	Stock	106.97	107.02	106.52	106.7	5708710.0
2014-02-06	ES	Stock	43.1	43.1	42.52	42.87	2846000.0
2014-02-06	CL	Stock	60.51	60.84	60.27	60.6	4190900.0
2014-02-06	A	Stock	41.1373	41.7382	41.1016	41.6953	2250081.0
2014-02-06	AABA-DELISTED	Stock	35.64	36.75	35.61	36.24	12580366.0
2014-02-06	AACG	Stock	4.0	4.0	3.92	3.92	3500.0
2014-02-06	AAIC-DELISTED	Stock	24.94	25.34	24.81	24.86	196383.0
2014-02-06	AAL	Stock	33.71	34.92	33.7	34.66	13920500.0
2014-02-06	AAMC-DELISTED	Stock	279.7029	280.8824	247.0588	264.9324	126317.0
2014-02-06	AAME	Stock	3.94	3.97	3.94	3.96	5900.0
2014-02-06	AAOI	Stock	13.23	13.33	13.11	13.16	30500.0
2014-02-06	AAON	Stock	12.2356	12.5022	12.2356	12.4533	256950.0
2014-02-06	AAP	Stock	121.5	127.09	120.0	124.86	3374200.0
2014-02-06	AAT	Stock	31.86	32.07	31.82	32.01	164100.0
2014-02-06	AAU-DELISTED	Stock	1.49	1.53	1.4	1.4207	87878.0
2014-02-06	AAUAF-DELISTED	Stock	1.49	1.53	1.4	1.43	89638.0
2014-02-06	AAV-DELISTED	Stock	3.71	3.88	3.71	3.85	137358.0
2014-02-06	AAWW-DELISTED	Stock	33.95	34.37	33.95	34.06	196967.0
2014-02-06	AAXJ	Stock	55.49	56.09	55.42	56.09	810353.0
2014-02-06	AAXN-DELISTED	Stock	16.47	17.09	16.41	16.73	1183788.0
2014-02-06	AB	Stock	21.84	22.25	21.71	21.88	280200.0
2014-02-06	ABAC-DELISTED	Stock	1.8948	1.9	1.86	1.86	9389.0
2014-02-06	ABAX-DELISTED	Stock	37.22	37.22	36.298	36.98	253432.0
2014-02-06	ABB-DELISTED	Stock	25.0	25.1	24.97	25.09	1475407.0
2014-02-06	ABBNY-DELISTED	Stock	25.0	25.1	24.97	25.1	1574110.0
2014-02-06	ABBV	Stock	47.89	48.18	47.45	47.93	4957800.0
2014-02-06	ABC-DELISTED	Stock	64.86	65.61	64.4	65.51	1416933.0
2014-02-06	ABCB	Stock	19.79	20.2	19.77	20.04	129100.0
2014-02-06	ABCD-DELISTED	Stock	1.79	1.79	1.6118	1.77	33166.0
2014-02-06	ABCO-DELISTED	Stock	59.09	61.48	57.75	61.01	264493.0
2014-02-06	ABE-DELISTED	Stock	12.34	12.54	12.34	12.54	12735.0
2014-02-06	ABEO	Stock	375.0	412.5	375.0	412.5	20.0
2014-02-06	ABEV	Stock	6.46	6.79	6.45	6.68	13412300.0
2014-02-06	ABFS-DELISTED	Stock	31.16	31.54	30.31	31.09	439948.0
2014-02-06	ABG	Stock	49.53	50.71	49.15	50.35	339900.0
2014-02-06	ABGB-DELISTED	Stock	18.3	19.15	18.3	19.15	17563.0
2014-02-06	ABIL-DELISTED	Stock	10.0	10.0	9.7	9.88	1144.0
2014-02-06	ABM	Stock	26.13	26.27	26.05	26.2	205200.0
2014-02-06	ABMD-DELISTED	Stock	26.2	26.58	26.0001	26.5	253501.0
2014-02-06	ABR	Stock	6.78	7.01	6.78	6.95	187300.0
2014-02-06	ABR.A-DELISTED	Stock	25.13	25.13	25.0	25.0	722.0
2014-02-06	ABR.B-DELISTED	Stock	23.5	23.5	23.499	23.5	8390.0
2014-02-06	ABT	Stock	36.41	36.93	36.38	36.65	9982300.0
2014-02-06	ABTL-DELISTED	Stock	13.7	14.19	13.4	14.075	177327.0

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

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