PREVIEW / stock_daily / 2018-02-02

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-02.parquet
  size:    217 KB
  rows:    6,508
  symbols: 2,872

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
2018-02-02	AAPL	Stock	41.5	41.7	40.025	40.125	346375200.0
2018-02-02	MSFT	Stock	93.64	93.97	91.5	91.78	47867800.0
2018-02-02	NVDA	Stock	5.925	5.9492	5.7792	5.838	718464000.0
2018-02-02	AMZN	Stock	73.8695	74.9	70.7	71.4975	222514000.0
2018-02-02	GOOGL	Stock	56.371	56.565	55.5585	55.96	117842440.0
2018-02-02	META	Stock	192.04	194.21	189.98	190.28	26677500.0
2018-02-02	TSLA	Stock	23.2293	23.4633	22.7007	22.9167	55572000.0
2018-02-02	TLT	Stock	120.15	120.26	119.24	119.58	23944423.0
2018-02-02	ES	Stock	58.39	59.58	58.04	59.35	6519800.0
2018-02-02	CL	Stock	72.99	73.15	72.29	72.43	5130500.0
2018-02-02	A	Stock	72.32	72.76	71.22	71.25	1955700.0
2018-02-02	AA	Stock	52.0	52.0	49.0	49.09	6060500.0
2018-02-02	AAAP-DELISTED	Stock	80.49	80.989	80.3	80.98	3824.0
2018-02-02	AABA-DELISTED	Stock	76.45	76.7	74.17	74.39	7405693.0
2018-02-02	AAC-DELISTED	Stock	8.56	8.56	8.01	8.12	130804.0
2018-02-02	AACG	Stock	4.88	4.88	4.6	4.6	2000.0
2018-02-02	AAIC-DELISTED	Stock	10.53	10.6	10.3101	10.43	784612.0
2018-02-02	AAL	Stock	53.49	53.99	52.03	52.1	5109400.0
2018-02-02	AAM.A-DELISTED	Stock	25.21	25.2811	24.75	25.14	64759.0
2018-02-02	AAME	Stock	3.6	3.6	3.4	3.4	1600.0
2018-02-02	AAMI	Stock	17.57	17.73	17.41	17.5	685400.0
2018-02-02	AAOI	Stock	33.61	33.849	32.8	32.81	668900.0
2018-02-02	AAON	Stock	23.9667	24.0667	23.7	23.7333	293400.0
2018-02-02	AAP	Stock	115.92	117.18	113.13	113.93	1092300.0
2018-02-02	AAT	Stock	34.35	34.54	33.7	34.47	217000.0
2018-02-02	AAU-DELISTED	Stock	0.93	0.9509	0.91	0.92	658618.0
2018-02-02	AAUAF-DELISTED	Stock	0.93	0.9509	0.91	0.92	683904.0
2018-02-02	AAV-DELISTED	Stock	3.3	3.3	3.15	3.3	741317.0
2018-02-02	AAWW-DELISTED	Stock	56.3	56.3	54.45	54.8	269758.0
2018-02-02	AAXJ	Stock	79.98	80.0	78.62	78.64	1831100.0
2018-02-02	AAXN-DELISTED	Stock	25.66	26.17	25.4606	25.82	460075.0
2018-02-02	AB	Stock	27.05	27.1	26.45	26.6	299200.0
2018-02-02	ABAC-DELISTED	Stock	2.82	2.84	2.72	2.84	2071.0
2018-02-02	ABAX-DELISTED	Stock	72.16	72.1743	70.18	70.6	169548.0
2018-02-02	ABB-DELISTED	Stock	27.72	27.74	27.42	27.43	1757934.0
2018-02-02	ABBNY-DELISTED	Stock	27.72	27.74	27.42	27.43	1886469.0
2018-02-02	ABBV	Stock	115.5	117.93	114.92	115.17	7184400.0
2018-02-02	ABC-DELISTED	Stock	99.09	99.09	95.91	96.01	1453466.0
2018-02-02	ABCB	Stock	54.2	55.1	53.95	54.25	165000.0
2018-02-02	ABCD-DELISTED	Stock	6.91	7.02	6.8062	6.9	41288.0
2018-02-02	ABDC-DELISTED	Stock	7.9	7.92	7.64	7.7636	75937.0
2018-02-02	ABE-DELISTED	Stock	15.5	15.5	14.9801	15.2	18574.0
2018-02-02	ABEO	Stock	385.0	392.5	373.75	377.5	24868.0
2018-02-02	ABEOW-DELISTED	Stock	10.14	10.241	10.13	10.241	1039.0
2018-02-02	ABEV	Stock	6.79	6.83	6.69	6.75	18417900.0
2018-02-02	ABG	Stock	71.45	71.65	68.4	68.5	237800.0
2018-02-02	ABIL-DELISTED	Stock	0.46	0.46	0.41	0.4296	92186.0
2018-02-02	ABLX-DELISTED	Stock	54.63	54.87	54.39	54.62	487033.0
2018-02-02	ABM	Stock	37.34	37.5	36.9	37.1	444500.0
2018-02-02	ABMD-DELISTED	Stock	251.1	255.4225	246.61	248.11	316522.0

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

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