PREVIEW / stock_daily / 2014-02-19

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-19.parquet
  size:    218 KB
  rows:    6,493
  symbols: 3,543

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-19	AAPL	Stock	19.4554	19.5318	19.0839	19.1918	313768000.0
2014-02-19	MSFT	Stock	37.22	37.75	37.21	37.51	29750400.0
2014-02-19	NVDA	Stock	0.4475	0.4575	0.4455	0.4535	450340000.0
2014-02-19	AMZN	Stock	17.632	17.727	17.305	17.369	83362000.0
2014-02-19	META	Stock	67.05	69.08	67.0	68.06	62087100.0
2014-02-19	TSLA	Stock	13.58	13.58	12.894	12.9093	242535000.0
2014-02-19	TLT	Stock	107.18	107.18	106.3	106.37	5522754.0
2014-02-19	ES	Stock	44.75	45.14	44.36	44.44	1889100.0
2014-02-19	CL	Stock	61.97	62.19	61.44	61.53	3358500.0
2014-02-19	A	Stock	39.3491	40.5222	39.2704	40.0143	6764642.0
2014-02-19	AABA-DELISTED	Stock	38.06	38.33	37.68	37.82	15159887.0
2014-02-19	AACG	Stock	4.0	4.0	4.0	4.0	1800.0
2014-02-19	AAIC-DELISTED	Stock	25.9	25.976	25.55	25.57	167861.0
2014-02-19	AAL	Stock	34.25	35.09	34.11	34.59	7258100.0
2014-02-19	AAMC-DELISTED	Stock	297.0529	297.0529	267.9471	285.2971	51007.0
2014-02-19	AAME	Stock	3.94	3.97	3.93	3.94	11200.0
2014-02-19	AAOI	Stock	13.52	15.16	13.5	15.02	101300.0
2014-02-19	AAON	Stock	13.0444	13.1467	12.6978	12.7511	212850.0
2014-02-19	AAP	Stock	126.54	127.48	125.73	125.94	1096200.0
2014-02-19	AAT	Stock	33.37	33.98	33.28	33.62	248600.0
2014-02-19	AAU-DELISTED	Stock	1.84	1.84	1.6399	1.65	302891.0
2014-02-19	AAUAF-DELISTED	Stock	1.81	1.81	1.61	1.65	309855.0
2014-02-19	AAV-DELISTED	Stock	3.93	4.02	3.93	3.97	62216.0
2014-02-19	AAWW-DELISTED	Stock	32.18	32.75	32.01	32.07	274389.0
2014-02-19	AAXJ	Stock	57.47	57.81	57.32	57.52	456234.0
2014-02-19	AAXN-DELISTED	Stock	18.12	19.0	18.12	18.56	2253406.0
2014-02-19	AB	Stock	24.84	25.69	24.77	25.62	1251400.0
2014-02-19	ABAC-DELISTED	Stock	1.7	1.73	1.66	1.71	35045.0
2014-02-19	ABAX-DELISTED	Stock	38.79	39.1	38.495	38.7	280352.0
2014-02-19	ABB-DELISTED	Stock	25.35	25.595	25.28	25.3	2260093.0
2014-02-19	ABBNY-DELISTED	Stock	25.35	25.595	25.28	25.31	3044947.0
2014-02-19	ABBV	Stock	51.17	51.86	50.64	51.19	5242800.0
2014-02-19	ABC-DELISTED	Stock	68.12	69.02	67.98	68.1	1811953.0
2014-02-19	ABCB	Stock	20.23	20.37	20.14	20.15	99200.0
2014-02-19	ABCD-DELISTED	Stock	1.93	1.99	1.89	1.97	36618.0
2014-02-19	ABCO-DELISTED	Stock	62.42	64.5	62.05	63.85	337185.0
2014-02-19	ABE-DELISTED	Stock	12.5394	12.5394	12.47	12.496	8265.0
2014-02-19	ABEO	Stock	475.0	475.0	387.5	412.5	54.0
2014-02-19	ABEV	Stock	6.64	6.79	6.61	6.74	9856700.0
2014-02-19	ABFS-DELISTED	Stock	32.06	32.77	31.59	31.62	623096.0
2014-02-19	ABG	Stock	48.92	49.79	48.52	49.08	222900.0
2014-02-19	ABGB-DELISTED	Stock	20.2	20.2	20.191	20.191	200.0
2014-02-19	ABIL-DELISTED	Stock	9.55	9.62	9.55	9.62	509.0
2014-02-19	ABM	Stock	27.51	27.83	27.33	27.37	225200.0
2014-02-19	ABMD-DELISTED	Stock	28.74	29.0	28.6	28.71	302977.0
2014-02-19	ABR	Stock	7.2	7.21	7.06	7.09	154700.0
2014-02-19	ABR.A-DELISTED	Stock	24.14	24.3	24.14	24.25	2850.0
2014-02-19	ABR.B-DELISTED	Stock	23.0	23.0	23.0	23.0	1438.0
2014-02-19	ABT	Stock	38.74	39.37	38.68	38.76	7093200.0
2014-02-19	ABTL-DELISTED	Stock	17.75	18.05	17.67	17.85	106170.0

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

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