PREVIEW / stock_daily / 2014-12-19

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-19.parquet
  size:    225 KB
  rows:    6,688
  symbols: 3,577

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-19	AAPL	Stock	28.065	28.31	27.915	27.945	353719200.0
2014-12-19	MSFT	Stock	47.63	48.1	47.17	47.66	64551200.0
2014-12-19	NVDA	Stock	0.509	0.5125	0.5043	0.5105	325528000.0
2014-12-19	AMZN	Stock	14.8455	15.077	14.776	14.995	174182000.0
2014-12-19	GOOGL	Stock	25.8495	26.0405	25.443	26.002	97441180.0
2014-12-19	META	Stock	78.75	80.0	78.33	79.88	43335000.0
2014-12-19	TSLA	Stock	14.6793	14.6933	14.3	14.6193	103657500.0
2014-12-19	TLT	Stock	124.58	125.95	124.44	125.87	7894461.0
2014-12-19	ES	Stock	53.0	53.36	52.56	52.7	3052500.0
2014-12-19	CL	Stock	69.66	70.31	69.58	69.98	5595600.0
2014-12-19	A	Stock	40.9	41.43	40.86	41.38	3736300.0
2014-12-19	AA.B-DELISTED	Stock	50.15	50.65	50.15	50.57	105007.0
2014-12-19	AABA-DELISTED	Stock	51.14	51.47	50.83	50.925	23280233.0
2014-12-19	AAC-DELISTED	Stock	29.93	30.89	28.79	29.67	605705.0
2014-12-19	AACG	Stock	3.38	3.6	3.38	3.5	16800.0
2014-12-19	AAIC-DELISTED	Stock	27.38	27.9246	27.32	27.71	477077.0
2014-12-19	AAL	Stock	49.67	50.94	49.1	50.71	26787700.0
2014-12-19	AAMC-DELISTED	Stock	132.9206	142.6647	132.9206	136.8529	83358.0
2014-12-19	AAME	Stock	3.81	3.88	3.81	3.88	2800.0
2014-12-19	AAMI	Stock	16.57	16.94	16.15	16.68	2114300.0
2014-12-19	AAOI	Stock	10.66	10.84	10.04	10.64	246200.0
2014-12-19	AAON	Stock	14.6067	14.86	14.38	14.44	764550.0
2014-12-19	AAP	Stock	160.71	161.21	159.01	159.85	1017900.0
2014-12-19	AAT	Stock	39.2	39.8	39.14	39.55	755300.0
2014-12-19	AAU-DELISTED	Stock	0.99	0.99	0.9307	0.97	279972.0
2014-12-19	AAUAF-DELISTED	Stock	0.95	0.967	0.8922	0.967	293093.0
2014-12-19	AAV-DELISTED	Stock	4.98	5.17	4.9	5.14	445246.0
2014-12-19	AAVL-DELISTED	Stock	50.71	52.56	50.02	51.35	737608.0
2014-12-19	AAWW-DELISTED	Stock	46.33	47.13	45.78	47.0	450025.0
2014-12-19	AAXJ	Stock	59.91	60.33	59.81	60.14	551247.0
2014-12-19	AAXN-DELISTED	Stock	24.18	24.26	23.61	24.0	2374283.0
2014-12-19	AB	Stock	25.0	25.27	24.49	24.87	280800.0
2014-12-19	ABAC-DELISTED	Stock	1.85	1.88	1.8201	1.88	6300.0
2014-12-19	ABAX-DELISTED	Stock	59.66	59.89	58.81	59.81	340064.0
2014-12-19	ABB-DELISTED	Stock	21.22	21.44	21.18	21.4	2908555.0
2014-12-19	ABBNY-DELISTED	Stock	21.22	21.44	21.18	21.41	2999599.0
2014-12-19	ABBV	Stock	67.69	68.62	66.84	67.71	12631000.0
2014-12-19	ABC-DELISTED	Stock	92.04	92.56	91.12	91.68	2421938.0
2014-12-19	ABCB	Stock	25.89	25.98	25.58	25.58	171800.0
2014-12-19	ABCD-DELISTED	Stock	1.54	1.66	1.54	1.65	25963.0
2014-12-19	ABCO-DELISTED	Stock	49.0	49.0	47.05	47.22	565298.0
2014-12-19	ABCW-DELISTED	Stock	33.25	35.0	32.03	35.0	659100.0
2014-12-19	ABDC-DELISTED	Stock	11.99	12.72	11.989	12.6	106615.0
2014-12-19	ABE-DELISTED	Stock	13.18	13.18	13.17	13.17	1213.0
2014-12-19	ABEO	Stock	112.5	112.5	93.5	93.75	2324.0
2014-12-19	ABEOW-DELISTED	Stock	0.9	0.9	0.75	0.75	10600.0
2014-12-19	ABEV	Stock	6.0	6.06	5.94	6.01	19697900.0
2014-12-19	ABG	Stock	75.25	76.13	74.99	75.53	694900.0
2014-12-19	ABGB-DELISTED	Stock	12.02	12.12	11.85	12.03	87005.0
2014-12-19	ABIL-DELISTED	Stock	9.88	9.88	9.75	9.79	400.0

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

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