PREVIEW / stock_daily / 2015-07-10

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-10.parquet
  size:    223 KB
  rows:    6,658
  symbols: 3,490

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
2015-07-10	AAPL	Stock	30.485	30.9625	30.3025	30.82	245418000.0
2015-07-10	MSFT	Stock	45.01	45.14	44.57	44.61	25465800.0
2015-07-10	NVDA	Stock	0.4915	0.4982	0.4902	0.4938	216708000.0
2015-07-10	AMZN	Stock	22.0245	22.236	21.95	22.1755	48020000.0
2015-07-10	GOOGL	Stock	27.6855	27.9645	27.6	27.8055	43435000.0
2015-07-10	META	Stock	87.35	88.22	86.77	87.95	23245900.0
2015-07-10	TSLA	Stock	17.4813	17.5333	17.188	17.2767	39163500.0
2015-07-10	TLT	Stock	116.04	116.72	115.76	116.05	13636624.0
2015-07-10	ES	Stock	46.74	47.37	46.54	46.89	1830700.0
2015-07-10	CL	Stock	66.76	66.91	66.53	66.64	2221800.0
2015-07-10	A	Stock	39.29	39.44	39.16	39.4	2107100.0
2015-07-10	AA.B-DELISTED	Stock	39.18	39.71	38.98	39.13	73176.0
2015-07-10	AABA-DELISTED	Stock	38.35	38.42	37.78	37.91	8905450.0
2015-07-10	AAC-DELISTED	Stock	44.09	44.2	41.7	42.42	147647.0
2015-07-10	AACG	Stock	4.55	4.95	4.51	4.65	18900.0
2015-07-10	AAIC-DELISTED	Stock	19.9	20.17	19.83	19.99	285128.0
2015-07-10	AAL	Stock	40.51	41.64	40.5	41.21	16451700.0
2015-07-10	AAMC-DELISTED	Stock	39.4118	40.5853	39.4118	40.5853	6426.0
2015-07-10	AAME	Stock	3.65	3.65	3.56	3.56	1700.0
2015-07-10	AAMI	Stock	17.4	17.71	17.4	17.6	150400.0
2015-07-10	AAOI	Stock	16.51	17.065	16.35	16.91	235000.0
2015-07-10	AAON	Stock	14.9667	15.1067	14.8533	15.0867	129000.0
2015-07-10	AAP	Stock	163.95	164.98	162.96	164.11	506000.0
2015-07-10	AAT	Stock	40.51	41.2	40.44	41.06	110300.0
2015-07-10	AAU-DELISTED	Stock	0.7701	0.7701	0.75	0.76	92210.0
2015-07-10	AAUAF-DELISTED	Stock	0.7701	0.7701	0.75	0.76	92571.0
2015-07-10	AAV-DELISTED	Stock	6.25	6.25	6.15	6.22	55207.0
2015-07-10	AAVL-DELISTED	Stock	15.82	16.46	15.7	16.24	268232.0
2015-07-10	AAWW-DELISTED	Stock	52.84	54.18	52.37	53.64	340111.0
2015-07-10	AAXJ	Stock	61.03	61.2	60.65	61.12	2208809.0
2015-07-10	AAXN-DELISTED	Stock	32.95	33.18	32.6	33.04	901120.0
2015-07-10	AB	Stock	28.87	29.16	28.71	28.91	107600.0
2015-07-10	ABAC-DELISTED	Stock	1.12	1.35	1.05	1.08	216414.0
2015-07-10	ABAX-DELISTED	Stock	50.96	53.55	50.91	53.46	140883.0
2015-07-10	ABB-DELISTED	Stock	20.75	20.75	20.5	20.59	1736361.0
2015-07-10	ABBNY-DELISTED	Stock	20.75	20.75	20.5	20.59	1865991.0
2015-07-10	ABBV	Stock	68.94	69.5	68.53	69.23	6891400.0
2015-07-10	ABC-DELISTED	Stock	109.74	109.98	109.27	109.46	993292.0
2015-07-10	ABCB	Stock	25.92	26.01	25.78	25.99	87100.0
2015-07-10	ABCD-DELISTED	Stock	4.79	4.85	4.72	4.76	179041.0
2015-07-10	ABCO-DELISTED	Stock	57.78	58.38	56.46	57.94	457254.0
2015-07-10	ABCW-DELISTED	Stock	40.23	40.97	39.89	40.4	15481.0
2015-07-10	ABDC-DELISTED	Stock	12.7476	13.1	12.7185	13.09	28815.0
2015-07-10	ABE-DELISTED	Stock	12.9999	13.18	12.84	13.18	11641.0
2015-07-10	ABEO	Stock	125.25	142.0	125.25	138.75	15200.0
2015-07-10	ABEOW-DELISTED	Stock	1.95	2.21	1.95	2.05	15001.0
2015-07-10	ABEV	Stock	6.02	6.18	6.01	6.16	15690600.0
2015-07-10	ABG	Stock	90.96	91.61	90.66	90.98	173100.0
2015-07-10	ABGB-DELISTED	Stock	15.81	15.84	15.68	15.7899	8984.0
2015-07-10	ABIL-DELISTED	Stock	10.0	10.0	10.0	10.0	416.0

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

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