PREVIEW / stock_daily / 2014-01-16

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-16.parquet
  size:    217 KB
  rows:    6,455
  symbols: 3,526

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-01-16	AAPL	Stock	19.8179	19.8875	19.7029	19.7946	229278000.0
2014-01-16	MSFT	Stock	36.69	37.0	36.31	36.89	38018700.0
2014-01-16	NVDA	Stock	0.4003	0.4022	0.3985	0.4015	220652000.0
2014-01-16	AMZN	Stock	19.684	19.9645	19.4705	19.79	52024000.0
2014-01-16	META	Stock	57.26	58.02	56.83	57.19	34541800.0
2014-01-16	TSLA	Stock	10.8333	11.5133	10.8267	11.398	179391000.0
2014-01-16	TLT	Stock	104.85	105.07	104.72	105.04	7137813.0
2014-01-16	ES	Stock	42.06	42.24	41.89	42.23	1056900.0
2014-01-16	CL	Stock	64.58	65.12	64.39	64.98	2636400.0
2014-01-16	A	Stock	43.0901	43.2761	42.9471	43.2761	2566728.0
2014-01-16	AABA-DELISTED	Stock	40.42	40.75	40.11	40.34	15665440.0
2014-01-16	AACG	Stock	3.93	3.93	3.93	3.93	100.0
2014-01-16	AAIC-DELISTED	Stock	26.48	26.59	26.26	26.29	98123.0
2014-01-16	AAL	Stock	28.94	29.39	28.7	29.34	7034200.0
2014-01-16	AAMC-DELISTED	Stock	351.4706	353.0471	331.1853	348.3824	199267.0
2014-01-16	AAME	Stock	3.93	4.04	3.84	4.04	17700.0
2014-01-16	AAOI	Stock	13.9	14.56	13.85	14.29	71400.0
2014-01-16	AAON	Stock	14.3289	14.5333	14.1467	14.4533	139950.0
2014-01-16	AAP	Stock	117.22	118.25	116.15	117.88	609900.0
2014-01-16	AAT	Stock	31.86	32.15	31.82	32.05	49100.0
2014-01-16	AAU-DELISTED	Stock	1.35	1.45	1.35	1.43	462930.0
2014-01-16	AAUAF-DELISTED	Stock	1.35	1.45	1.35	1.43	467534.0
2014-01-16	AAV-DELISTED	Stock	4.05	4.26	4.05	4.21	82577.0
2014-01-16	AAWW-DELISTED	Stock	43.64	43.99	43.43	43.63	178069.0
2014-01-16	AAXJ	Stock	58.28	58.47	58.16	58.28	1060849.0
2014-01-16	AAXN-DELISTED	Stock	17.94	18.07	17.5	17.55	903971.0
2014-01-16	AB	Stock	22.9	23.05	22.79	22.86	760800.0
2014-01-16	ABAC-DELISTED	Stock	2.02	2.09	2.02	2.06	13150.0
2014-01-16	ABAX-DELISTED	Stock	44.06	44.74	43.98	44.6	85557.0
2014-01-16	ABB-DELISTED	Stock	26.29	26.77	26.27	26.74	2354197.0
2014-01-16	ABBNY-DELISTED	Stock	26.31	26.77	26.27	26.75	2727214.0
2014-01-16	ABBV	Stock	50.1	50.62	50.02	50.5	4972300.0
2014-01-16	ABC-DELISTED	Stock	70.6	70.68	70.26	70.5	985884.0
2014-01-16	ABCB	Stock	20.65	20.65	19.78	20.32	107900.0
2014-01-16	ABCD-DELISTED	Stock	1.97	2.21	1.97	2.02	13940.0
2014-01-16	ABCO-DELISTED	Stock	60.66	61.11	59.73	60.78	102625.0
2014-01-16	ABE-DELISTED	Stock	13.45	13.45	13.35	13.38	6260.0
2014-01-16	ABEO	Stock	362.5	362.5	337.5	362.5	8.0
2014-01-16	ABEV	Stock	7.17	7.19	7.02	7.07	6248500.0
2014-01-16	ABFS-DELISTED	Stock	34.76	35.6591	34.44	35.33	331427.0
2014-01-16	ABG	Stock	48.12	49.19	47.67	48.98	510800.0
2014-01-16	ABGB-DELISTED	Stock	17.76	17.76	17.34	17.4	5215.0
2014-01-16	ABM	Stock	27.76	27.85	27.69	27.77	190200.0
2014-01-16	ABMD-DELISTED	Stock	28.29	28.48	27.9	27.97	296201.0
2014-01-16	ABR	Stock	6.99	7.01	6.88	6.9	184500.0
2014-01-16	ABR.A-DELISTED	Stock	25.04	25.04	24.6101	24.8	900.0
2014-01-16	ABR.B-DELISTED	Stock	22.75	22.9399	22.63	22.9399	2100.0
2014-01-16	ABT	Stock	39.53	39.69	39.41	39.54	3716100.0
2014-01-16	ABTL-DELISTED	Stock	17.385	17.825	16.9642	17.705	324714.0
2014-01-16	ABUS	Stock	11.45	12.23	11.2	12.08	228500.0

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

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