PREVIEW / stock_daily / 2014-02-14

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-14.parquet
  size:    217 KB
  rows:    6,478
  symbols: 3,538

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-14	AAPL	Stock	19.3739	19.4993	19.3289	19.4282	272924400.0
2014-02-14	MSFT	Stock	37.39	37.78	37.33	37.62	31407500.0
2014-02-14	NVDA	Stock	0.43	0.4488	0.4298	0.4478	817536000.0
2014-02-14	AMZN	Stock	17.967	17.967	17.6675	17.8675	70404000.0
2014-02-14	META	Stock	67.5	67.58	66.72	67.09	36694900.0
2014-02-14	TSLA	Stock	13.2067	13.4587	13.1333	13.2153	92370000.0
2014-02-14	TLT	Stock	106.57	106.64	106.27	106.58	4999982.0
2014-02-14	ES	Stock	44.7	45.05	44.54	44.97	1288300.0
2014-02-14	CL	Stock	62.38	62.9	61.81	62.68	3116100.0
2014-02-14	A	Stock	40.8798	41.3233	39.2489	39.5207	24946891.0
2014-02-14	AABA-DELISTED	Stock	38.43	38.45	38.1131	38.22	9436994.0
2014-02-14	AACG	Stock	3.99	4.0	3.89	3.99	8800.0
2014-02-14	AAIC-DELISTED	Stock	25.63	25.71	25.45	25.61	78735.0
2014-02-14	AAL	Stock	34.85	35.18	34.22	34.41	7296900.0
2014-02-14	AAMC-DELISTED	Stock	288.6059	293.4118	288.6059	292.6529	9945.0
2014-02-14	AAME	Stock	3.95	3.98	3.94	3.94	7000.0
2014-02-14	AAOI	Stock	12.5	14.19	12.5	14.0	78500.0
2014-02-14	AAON	Stock	12.4978	12.9556	12.3778	12.8222	258975.0
2014-02-14	AAP	Stock	126.71	127.5	125.61	127.34	786000.0
2014-02-14	AAT	Stock	32.79	33.46	32.45	33.36	83600.0
2014-02-14	AAU-DELISTED	Stock	1.83	1.8501	1.8	1.84	177692.0
2014-02-14	AAUAF-DELISTED	Stock	1.81	1.84	1.8	1.84	181780.0
2014-02-14	AAV-DELISTED	Stock	3.92	3.95	3.85	3.87	82329.0
2014-02-14	AAWW-DELISTED	Stock	32.49	33.27	32.23	32.96	506499.0
2014-02-14	AAXJ	Stock	57.47	58.01	57.47	57.82	784865.0
2014-02-14	AAXN-DELISTED	Stock	17.08	17.1894	16.854	17.09	456081.0
2014-02-14	AB	Stock	23.42	24.02	23.06	23.83	471400.0
2014-02-14	ABAC-DELISTED	Stock	1.78	1.9	1.71	1.75	28116.0
2014-02-14	ABAX-DELISTED	Stock	38.64	38.78	38.01	38.54	130782.0
2014-02-14	ABB-DELISTED	Stock	25.25	25.42	25.23	25.4	1024421.0
2014-02-14	ABBNY-DELISTED	Stock	25.25	25.42	25.23	25.41	1187529.0
2014-02-14	ABBV	Stock	50.56	50.91	50.17	50.73	4118700.0
2014-02-14	ABC-DELISTED	Stock	67.73	68.355	67.6	68.01	1010640.0
2014-02-14	ABCB	Stock	20.2	20.29	19.91	20.09	45700.0
2014-02-14	ABCD-DELISTED	Stock	1.93	1.93	1.86	1.86	5847.0
2014-02-14	ABCO-DELISTED	Stock	60.62	61.51	60.12	61.41	205305.0
2014-02-14	ABE-DELISTED	Stock	12.53	12.665	12.4	12.43	74757.0
2014-02-14	ABEO	Stock	375.0	412.5	375.0	412.5	7.0
2014-02-14	ABEV	Stock	6.9	6.98	6.86	6.91	7439800.0
2014-02-14	ABFS-DELISTED	Stock	31.43	32.2	31.13	32.1	337122.0
2014-02-14	ABG	Stock	48.97	49.57	48.02	49.26	309500.0
2014-02-14	ABGB-DELISTED	Stock	20.32	20.41	20.11	20.35	7097.0
2014-02-14	ABIL-DELISTED	Stock	9.55	9.55	9.54	9.54	2174.0
2014-02-14	ABM	Stock	27.54	27.54	27.06	27.44	133800.0
2014-02-14	ABMD-DELISTED	Stock	28.13	28.65	27.89	28.18	278884.0
2014-02-14	ABR	Stock	7.06	7.06	6.96	7.04	142200.0
2014-02-14	ABR.A-DELISTED	Stock	24.3	24.45	24.16	24.3	23100.0
2014-02-14	ABR.B-DELISTED	Stock	22.996	23.14	22.96	23.0	19830.0
2014-02-14	ABT	Stock	38.68	38.98	38.55	38.81	7253400.0
2014-02-14	ABTL-DELISTED	Stock	18.0	18.23	17.63	18.04	160170.0

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

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