PREVIEW / stock_daily / 2017-10-10

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-10.parquet
  size:    214 KB
  rows:    6,434
  symbols: 2,913

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
2017-10-10	AAPL	Stock	39.015	39.5	38.775	38.975	62468000.0
2017-10-10	MSFT	Stock	76.33	76.63	76.14	76.29	13944500.0
2017-10-10	NVDA	Stock	4.7858	4.8238	4.6815	4.7232	974876000.0
2017-10-10	AMZN	Stock	49.8335	49.8975	49.005	49.36	61698000.0
2017-10-10	GOOGL	Stock	49.765	49.8735	49.0555	49.39	23268000.0
2017-10-10	META	Stock	173.0	173.2	170.8	171.59	11341100.0
2017-10-10	TSLA	Stock	23.12	23.7087	23.0353	23.706	104677500.0
2017-10-10	TLT	Stock	124.14	124.87	124.02	124.18	6666768.0
2017-10-10	ES	Stock	60.27	60.69	60.08	60.66	1636800.0
2017-10-10	CL	Stock	72.65	73.32	72.51	72.9	2078600.0
2017-10-10	A	Stock	66.68	66.86	66.22	66.6	1143100.0
2017-10-10	AA	Stock	47.28	47.45	46.58	46.89	3578600.0
2017-10-10	AAAP-DELISTED	Stock	67.28	68.3399	66.16	66.69	112812.0
2017-10-10	AABA-DELISTED	Stock	68.51	69.51	68.51	68.93	5078871.0
2017-10-10	AAC-DELISTED	Stock	8.48	8.49	8.16	8.33	132082.0
2017-10-10	AACG	Stock	4.75	4.75	4.65	4.65	8600.0
2017-10-10	AAIC-DELISTED	Stock	12.78	12.7801	12.6145	12.63	361905.0
2017-10-10	AAL	Stock	52.0	53.25	51.98	53.03	9387100.0
2017-10-10	AAM.A-DELISTED	Stock	25.74	25.87	25.74	25.8584	14340.0
2017-10-10	AAMC-DELISTED	Stock	25.5882	25.7647	24.7206	24.7206	5950.0
2017-10-10	AAME	Stock	3.4	3.4	3.3	3.34	2300.0
2017-10-10	AAMI	Stock	15.26	15.37	15.15	15.28	723700.0
2017-10-10	AAOI	Stock	59.06	60.65	59.03	60.35	1724700.0
2017-10-10	AAON	Stock	23.6333	23.7	23.0333	23.2	251400.0
2017-10-10	AAP	Stock	91.22	92.38	91.02	91.84	1260600.0
2017-10-10	AAT	Stock	40.64	40.95	40.58	40.83	166100.0
2017-10-10	AAU-DELISTED	Stock	1.2	1.23	1.19	1.2	181102.0
2017-10-10	AAUAF-DELISTED	Stock	1.2	1.23	1.19	1.2	186199.0
2017-10-10	AAV-DELISTED	Stock	5.8	5.9	5.55	5.65	604461.0
2017-10-10	AAWW-DELISTED	Stock	64.95	65.65	63.85	65.125	176734.0
2017-10-10	AAXJ	Stock	74.15	74.49	74.15	74.48	1897730.0
2017-10-10	AAXN-DELISTED	Stock	23.57	23.835	23.39	23.82	388329.0
2017-10-10	AB	Stock	24.95	25.2	24.85	24.85	136400.0
2017-10-10	ABAC-DELISTED	Stock	3.27	3.39	3.25	3.29	8116.0
2017-10-10	ABAX-DELISTED	Stock	46.14	46.58	45.72	45.8	47829.0
2017-10-10	ABB-DELISTED	Stock	25.09	25.12	25.04	25.085	737839.0
2017-10-10	ABBNY-DELISTED	Stock	25.09	25.12	25.04	25.08	771777.0
2017-10-10	ABBV	Stock	90.71	91.22	89.7	91.17	3560200.0
2017-10-10	ABC-DELISTED	Stock	79.49	80.4	79.01	79.56	1367103.0
2017-10-10	ABCB	Stock	49.9	51.28	49.86	51.05	284500.0
2017-10-10	ABCD-DELISTED	Stock	6.53	6.56	6.35	6.47	70925.0
2017-10-10	ABCO-DELISTED	Stock	53.85	53.95	53.6	53.6	398056.0
2017-10-10	ABDC-DELISTED	Stock	10.63	10.6893	10.48	10.56	30062.0
2017-10-10	ABE-DELISTED	Stock	14.65	14.73	14.64	14.65	9955.0
2017-10-10	ABEO	Stock	450.0	508.75	438.75	498.75	97772.0
2017-10-10	ABEOW-DELISTED	Stock	13.15	15.21	13.15	14.9501	10784.0
2017-10-10	ABEV	Stock	6.7	6.83	6.66	6.74	46174300.0
2017-10-10	ABG	Stock	60.25	60.65	59.7	60.3	205800.0
2017-10-10	ABIL-DELISTED	Stock	0.8297	0.8297	0.76	0.7816	150182.0
2017-10-10	ABM	Stock	43.03	43.3	42.77	42.97	271600.0

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

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