PREVIEW / stock_daily / 2014-12-02

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-02.parquet
  size:    223 KB
  rows:    6,646
  symbols: 3,559

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-12-02	AAPL	Stock	28.375	28.9375	28.1875	28.6575	237395600.0
2014-12-02	MSFT	Stock	48.84	49.05	48.2	48.46	25773500.0
2014-12-02	NVDA	Stock	0.514	0.5175	0.5093	0.5152	245952000.0
2014-12-02	AMZN	Stock	16.375	16.3965	16.1625	16.3155	55806000.0
2014-12-02	GOOGL	Stock	26.9725	27.0925	26.7328	26.9295	41479480.0
2014-12-02	META	Stock	75.33	75.91	75.04	75.46	16773900.0
2014-12-02	TSLA	Stock	15.638	15.6587	15.2	15.4287	88305000.0
2014-12-02	TLT	Stock	120.84	120.85	120.29	120.32	5757162.0
2014-12-02	ES	Stock	50.53	51.29	50.26	51.2	1887700.0
2014-12-02	CL	Stock	69.51	69.9	69.15	69.86	2365500.0
2014-12-02	A	Stock	41.6	42.1	41.55	41.98	2014400.0
2014-12-02	AA.B-DELISTED	Stock	53.69	53.69	53.34	53.34	136269.0
2014-12-02	AABA-DELISTED	Stock	50.2	51.12	50.01	50.66	15450208.0
2014-12-02	AAC-DELISTED	Stock	30.32	32.88	30.09	31.61	74681.0
2014-12-02	AACG	Stock	3.72	3.72	3.72	3.72	300.0
2014-12-02	AAIC-DELISTED	Stock	27.64	28.05	27.64	27.85	218232.0
2014-12-02	AAL	Stock	48.12	48.7	47.15	47.86	11853900.0
2014-12-02	AAMC-DELISTED	Stock	142.6441	148.8235	140.8235	148.8235	25966.0
2014-12-02	AAME	Stock	3.79	3.85	3.66	3.85	7100.0
2014-12-02	AAMI	Stock	15.58	16.0	15.47	15.55	349300.0
2014-12-02	AAOI	Stock	10.25	10.3	9.5	10.0	822500.0
2014-12-02	AAON	Stock	13.6933	13.8667	13.6933	13.7667	567000.0
2014-12-02	AAP	Stock	146.71	148.87	146.55	148.48	1022700.0
2014-12-02	AAT	Stock	38.7	39.35	38.7	39.12	231100.0
2014-12-02	AAU-DELISTED	Stock	1.08	1.0919	1.0399	1.04	191028.0
2014-12-02	AAUAF-DELISTED	Stock	1.04	1.05	1.0	1.04	199250.0
2014-12-02	AAV-DELISTED	Stock	4.4	4.61	4.32	4.4	287428.0
2014-12-02	AAVL-DELISTED	Stock	38.31	40.0	37.85	39.68	125429.0
2014-12-02	AAWW-DELISTED	Stock	44.38	47.01	44.25	46.66	315785.0
2014-12-02	AAXJ	Stock	62.17	62.3099	62.11	62.27	2239417.0
2014-12-02	AAXN-DELISTED	Stock	22.96	24.44	22.75	23.34	12339150.0
2014-12-02	AB	Stock	26.45	26.68	26.2	26.36	228200.0
2014-12-02	ABAC-DELISTED	Stock	2.02	2.07	2.02	2.0699	19834.0
2014-12-02	ABAX-DELISTED	Stock	56.16	57.51	55.732	57.22	97412.0
2014-12-02	ABB-DELISTED	Stock	22.01	22.03	21.86	21.97	1649692.0
2014-12-02	ABBNY-DELISTED	Stock	22.01	22.03	21.86	21.97	1849371.0
2014-12-02	ABBV	Stock	68.88	69.49	68.65	69.27	6491500.0
2014-12-02	ABC-DELISTED	Stock	90.93	92.51	90.87	92.05	1571311.0
2014-12-02	ABCB	Stock	24.65	25.23	24.63	24.7	74900.0
2014-12-02	ABCO-DELISTED	Stock	42.32	43.22	40.54	40.74	513209.0
2014-12-02	ABCW-DELISTED	Stock	31.59	31.59	30.3	30.75	650.0
2014-12-02	ABDC-DELISTED	Stock	13.01	13.01	12.75	12.84	11867.0
2014-12-02	ABE-DELISTED	Stock	13.73	14.16	13.73	14.03	2323.0
2014-12-02	ABEO	Stock	175.25	175.75	165.0	175.75	388.0
2014-12-02	ABEV	Stock	6.2	6.23	6.07	6.1	16611800.0
2014-12-02	ABG	Stock	74.75	76.49	74.75	75.7	368200.0
2014-12-02	ABGB-DELISTED	Stock	11.77	11.94	11.6	11.68	164224.0
2014-12-02	ABM	Stock	26.97	27.42	26.95	27.22	125300.0
2014-12-02	ABMD-DELISTED	Stock	35.0	35.48	34.53	35.27	282405.0
2014-12-02	ABR	Stock	6.92	6.95	6.84	6.94	74500.0

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

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