PREVIEW / stock_daily / 2017-10-12

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-12.parquet
  size:    215 KB
  rows:    6,455
  symbols: 2,921

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-12	AAPL	Stock	39.0875	39.3425	38.9325	39.0	64500400.0
2017-10-12	MSFT	Stock	76.49	77.29	76.37	77.12	16876500.0
2017-10-12	NVDA	Stock	4.777	4.8272	4.7483	4.7758	528292000.0
2017-10-12	AMZN	Stock	49.8405	50.422	49.62	50.0465	81346000.0
2017-10-12	GOOGL	Stock	50.192	50.5769	50.055	50.2825	30613280.0
2017-10-12	META	Stock	172.61	173.85	172.29	172.55	10351000.0
2017-10-12	TSLA	Stock	23.53	23.9853	23.5093	23.712	61305000.0
2017-10-12	TLT	Stock	124.55	124.98	124.24	124.95	7141586.0
2017-10-12	ES	Stock	61.26	61.95	61.11	61.67	1757400.0
2017-10-12	CL	Stock	74.69	75.27	74.22	75.16	3172500.0
2017-10-12	A	Stock	66.65	67.6	66.54	67.54	1455000.0
2017-10-12	AA	Stock	46.95	47.77	46.8	47.53	3027600.0
2017-10-12	AAAP-DELISTED	Stock	67.29	69.26	67.06	68.51	164822.0
2017-10-12	AABA-DELISTED	Stock	69.0	69.23	67.8	67.905	3806635.0
2017-10-12	AAC-DELISTED	Stock	7.8	7.99	7.41	7.73	169052.0
2017-10-12	AACG	Stock	4.7	4.7	4.69	4.69	900.0
2017-10-12	AAIC-DELISTED	Stock	12.71	12.73	12.61	12.66	383109.0
2017-10-12	AAL	Stock	52.72	52.83	52.34	52.65	2942800.0
2017-10-12	AAM.A-DELISTED	Stock	25.92	25.99	25.88	25.92	23316.0
2017-10-12	AAME	Stock	3.37	3.45	3.25	3.25	5900.0
2017-10-12	AAMI	Stock	15.24	15.5	15.24	15.41	313800.0
2017-10-12	AAOI	Stock	60.62	61.0	58.63	58.84	3651300.0
2017-10-12	AAON	Stock	22.8	23.0	22.7	22.7667	285150.0
2017-10-12	AAP	Stock	89.38	89.5	86.49	86.56	2514600.0
2017-10-12	AAT	Stock	41.37	41.52	41.13	41.25	199400.0
2017-10-12	AAU-DELISTED	Stock	1.16	1.18	1.14	1.18	121238.0
2017-10-12	AAUAF-DELISTED	Stock	1.16	1.18	1.14	1.18	127168.0
2017-10-12	AAV-DELISTED	Stock	5.6	5.8	5.6	5.6	76211.0
2017-10-12	AAWW-DELISTED	Stock	65.45	66.25	65.15	65.9	113774.0
2017-10-12	AAXJ	Stock	74.7	74.8	74.54	74.56	1086802.0
2017-10-12	AAXN-DELISTED	Stock	24.03	24.55	23.96	24.4501	603608.0
2017-10-12	AB	Stock	25.05	25.5	25.05	25.2	229000.0
2017-10-12	ABAC-DELISTED	Stock	3.48	3.55	3.4296	3.5499	7278.0
2017-10-12	ABAX-DELISTED	Stock	45.83	46.38	45.65	46.05	79017.0
2017-10-12	ABB-DELISTED	Stock	25.0	25.06	24.96	25.03	1018929.0
2017-10-12	ABBNY-DELISTED	Stock	25.0	25.06	24.96	25.04	1054080.0
2017-10-12	ABBV	Stock	91.77	91.99	90.91	91.42	4818200.0
2017-10-12	ABC-DELISTED	Stock	80.37	81.2984	80.37	80.81	1013328.0
2017-10-12	ABCB	Stock	50.75	51.1	49.85	49.95	151200.0
2017-10-12	ABCD-DELISTED	Stock	6.49	6.49	6.3607	6.45	21382.0
2017-10-12	ABCO-DELISTED	Stock	53.9	53.95	53.85	53.85	1025558.0
2017-10-12	ABDC-DELISTED	Stock	10.49	10.575	10.38	10.41	96165.0
2017-10-12	ABE-DELISTED	Stock	14.65	14.7325	14.65	14.6996	2673.0
2017-10-12	ABEO	Stock	485.0	496.25	436.25	438.75	72344.0
2017-10-12	ABEOW-DELISTED	Stock	14.52	14.52	12.37	12.38	34015.0
2017-10-12	ABEV	Stock	6.74	6.82	6.74	6.79	13990900.0
2017-10-12	ABG	Stock	58.7	58.8	56.8	57.4	199900.0
2017-10-12	ABIL-DELISTED	Stock	0.75	0.7599	0.739	0.7425	43705.0
2017-10-12	ABM	Stock	42.93	43.43	42.82	43.3	422500.0
2017-10-12	ABMD-DELISTED	Stock	173.59	173.595	170.6	172.99	291125.0

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

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