PREVIEW / stock_daily / 2014-11-24

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-24.parquet
  size:    222 KB
  rows:    6,655
  symbols: 3,570

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-11-24	AAPL	Stock	29.2125	29.6925	29.155	29.6575	189803200.0
2014-11-24	MSFT	Stock	47.99	48.0	47.39	47.59	35434200.0
2014-11-24	NVDA	Stock	0.5125	0.5168	0.5105	0.5145	136004000.0
2014-11-24	AMZN	Stock	16.739	16.8695	16.68	16.782	55084000.0
2014-11-24	GOOGL	Stock	27.3285	27.5595	27.2075	27.374	33075460.0
2014-11-24	META	Stock	73.54	74.35	73.35	74.01	22103800.0
2014-11-24	TSLA	Stock	16.3467	16.5067	16.0427	16.448	71845500.0
2014-11-24	TLT	Stock	119.67	120.27	119.55	120.2	4033915.0
2014-11-24	ES	Stock	50.38	50.45	49.86	50.01	1859000.0
2014-11-24	CL	Stock	68.5	68.54	67.91	67.95	2521200.0
2014-11-24	A	Stock	42.44	42.5	41.99	42.25	2122400.0
2014-11-24	AA.B-DELISTED	Stock	53.68	54.24	52.994	53.11	24657.0
2014-11-24	AABA-DELISTED	Stock	51.23	51.83	51.07	51.83	13929442.0
2014-11-24	AAC-DELISTED	Stock	26.05	28.85	25.885	26.48	110119.0
2014-11-24	AACG	Stock	3.9	3.91	3.86	3.86	5000.0
2014-11-24	AAIC-DELISTED	Stock	27.54	27.73	27.54	27.73	184735.0
2014-11-24	AAL	Stock	43.72	43.96	42.78	43.21	9576600.0
2014-11-24	AAMC-DELISTED	Stock	150.8971	158.8235	150.8824	157.35	41772.0
2014-11-24	AAME	Stock	3.69	3.82	3.68	3.82	8700.0
2014-11-24	AAMI	Stock	15.35	15.79	15.35	15.58	94400.0
2014-11-24	AAOI	Stock	12.51	12.62	12.24	12.34	400400.0
2014-11-24	AAON	Stock	13.76	14.16	13.74	14.1267	164700.0
2014-11-24	AAP	Stock	145.74	146.17	144.12	145.58	585900.0
2014-11-24	AAT	Stock	38.34	38.67	38.29	38.54	163500.0
2014-11-24	AAU-DELISTED	Stock	1.05	1.0801	1.049	1.06	101552.0
2014-11-24	AAUAF-DELISTED	Stock	1.04	1.07	1.039	1.06	104093.0
2014-11-24	AAV-DELISTED	Stock	5.13	5.14	4.839	4.915	258856.0
2014-11-24	AAVL-DELISTED	Stock	34.85	36.19	33.79	35.7	55380.0
2014-11-24	AAWW-DELISTED	Stock	44.27	45.75	44.1019	44.49	281805.0
2014-11-24	AAXJ	Stock	62.55	62.87	62.52	62.78	527872.0
2014-11-24	AAXN-DELISTED	Stock	19.17	19.78	19.17	19.72	2427623.0
2014-11-24	AB	Stock	26.81	27.28	26.6	27.09	214600.0
2014-11-24	ABAC-DELISTED	Stock	2.26	2.28	2.18	2.1999	24588.0
2014-11-24	ABAX-DELISTED	Stock	54.05	55.38	53.714	55.32	99832.0
2014-11-24	ABB-DELISTED	Stock	22.9	22.98	22.85	22.95	1051066.0
2014-11-24	ABBNY-DELISTED	Stock	22.89	22.98	22.85	22.95	1125334.0
2014-11-24	ABBV	Stock	67.4	68.06	67.4	67.78	7730400.0
2014-11-24	ABC-DELISTED	Stock	89.21	90.1	89.21	90.06	1131918.0
2014-11-24	ABCB	Stock	25.48	25.86	25.3	25.75	149400.0
2014-11-24	ABCD-DELISTED	Stock	1.77	1.77	1.7001	1.72	8196.0
2014-11-24	ABCO-DELISTED	Stock	41.47	43.43	41.1701	43.31	452100.0
2014-11-24	ABCW-DELISTED	Stock	29.68	30.15	29.68	30.0	40237.0
2014-11-24	ABDC-DELISTED	Stock	12.75	12.8499	12.66	12.82	54642.0
2014-11-24	ABE-DELISTED	Stock	14.02	14.14	13.97	14.12	15062.0
2014-11-24	ABEO	Stock	187.5	187.5	178.0	178.0	16.0
2014-11-24	ABEV	Stock	6.78	6.8	6.59	6.63	16211900.0
2014-11-24	ABG	Stock	74.77	75.81	74.62	74.92	236900.0
2014-11-24	ABGB-DELISTED	Stock	12.84	12.99	12.71	12.86	162224.0
2014-11-24	ABM	Stock	27.19	27.45	27.15	27.41	133400.0
2014-11-24	ABMD-DELISTED	Stock	35.04	35.54	34.93	35.5	229427.0

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

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