PREVIEW / stock_daily / 2014-10-31

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-31.parquet
  size:    223 KB
  rows:    6,661
  symbols: 3,594

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-10-31	AAPL	Stock	27.0025	27.01	26.8025	27.0	178557200.0
2014-10-31	MSFT	Stock	46.94	46.97	46.48	46.95	35849700.0
2014-10-31	NVDA	Stock	0.478	0.4888	0.4755	0.4885	256316000.0
2014-10-31	AMZN	Stock	15.2575	15.286	15.075	15.273	91014000.0
2014-10-31	GOOGL	Stock	28.415	28.4365	28.2405	28.3935	46830780.0
2014-10-31	META	Stock	74.93	75.7	74.45	74.99	44544000.0
2014-10-31	TSLA	Stock	16.1673	16.208	15.9167	16.1133	56629500.0
2014-10-31	TLT	Stock	119.34	119.71	118.83	119.25	6664380.0
2014-10-31	ES	Stock	49.58	49.63	49.12	49.35	1609700.0
2014-10-31	CL	Stock	67.02	67.12	66.46	66.88	4362600.0
2014-10-31	A	Stock	39.4921	39.6352	39.2346	39.5422	2918744.0
2014-10-31	AA.B-DELISTED	Stock	51.08	52.0	50.94	51.9	95117.0
2014-10-31	AABA-DELISTED	Stock	46.16	46.52	45.67	46.03	17642102.0
2014-10-31	AAC-DELISTED	Stock	21.45	22.14	21.0	21.65	309009.0
2014-10-31	AACG	Stock	4.2	4.24	3.98	4.0	34900.0
2014-10-31	AAIC-DELISTED	Stock	27.48	27.5	27.32	27.38	284236.0
2014-10-31	AAL	Stock	41.1	41.75	40.8	41.35	13008200.0
2014-10-31	AAMC-DELISTED	Stock	168.3824	170.5882	158.8235	158.8235	24487.0
2014-10-31	AAME	Stock	3.86	3.93	3.84	3.85	8800.0
2014-10-31	AAMI	Stock	14.65	15.0	14.64	14.97	108700.0
2014-10-31	AAOI	Stock	15.58	16.19	15.26	16.14	243700.0
2014-10-31	AAON	Stock	13.2933	13.2933	12.9133	13.1	341100.0
2014-10-31	AAP	Stock	147.25	147.25	145.71	146.96	731400.0
2014-10-31	AAT	Stock	38.43	38.72	38.04	38.34	255400.0
2014-10-31	AAU-DELISTED	Stock	1.18	1.218	1.1	1.18	276015.0
2014-10-31	AAUAF-DELISTED	Stock	1.15	1.187	1.1	1.18	286277.0
2014-10-31	AAV-DELISTED	Stock	4.21	4.28	4.12	4.27	212680.0
2014-10-31	AAVL-DELISTED	Stock	36.57	36.9899	35.64	35.9	73032.0
2014-10-31	AAWW-DELISTED	Stock	37.25	37.38	36.3	36.92	213479.0
2014-10-31	AAXJ	Stock	62.92	63.1975	62.82	62.89	959930.0
2014-10-31	AAXN-DELISTED	Stock	18.03	18.979	17.9	18.83	7899854.0
2014-10-31	AB	Stock	26.67	27.19	26.13	26.6	460400.0
2014-10-31	ABAC-DELISTED	Stock	2.39	2.4	2.36	2.3999	85081.0
2014-10-31	ABAX-DELISTED	Stock	52.0	52.98	51.76	52.65	303730.0
2014-10-31	ABB-DELISTED	Stock	21.92	21.96	21.84	21.94	623941.0
2014-10-31	ABBNY-DELISTED	Stock	21.94	21.96	21.84	21.94	650581.0
2014-10-31	ABBV	Stock	63.06	63.99	62.37	63.46	15009900.0
2014-10-31	ABC-DELISTED	Stock	85.06	85.99	84.77	85.41	2981718.0
2014-10-31	ABCB	Stock	24.88	25.0	24.74	24.8	190200.0
2014-10-31	ABCD-DELISTED	Stock	1.4701	1.55	1.4701	1.52	17939.0
2014-10-31	ABCO-DELISTED	Stock	54.04	54.37	53.5	53.65	242737.0
2014-10-31	ABCW-DELISTED	Stock	30.03	30.07	30.0	30.04	1010.0
2014-10-31	ABDC-DELISTED	Stock	12.81	13.5	12.64	13.33	30073.0
2014-10-31	ABE-DELISTED	Stock	14.18	14.19	14.01	14.152	4265.0
2014-10-31	ABEO	Stock	250.0	250.0	250.0	250.0	4.0
2014-10-31	ABEV	Stock	6.36	6.68	6.36	6.68	22345700.0
2014-10-31	ABG	Stock	70.89	71.37	69.09	70.04	399500.0
2014-10-31	ABGB-DELISTED	Stock	20.9199	21.23	20.8701	21.2	3395.0
2014-10-31	ABM	Stock	27.95	28.01	27.25	27.64	383900.0
2014-10-31	ABMD-DELISTED	Stock	31.7	32.99	31.58	32.8	1230019.0

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

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