PREVIEW / stock_daily / 2018-02-09

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-09.parquet
  size:    217 KB
  rows:    6,510
  symbols: 2,874

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-09	AAPL	Stock	39.2675	39.4725	37.56	39.1025	282690400.0
2018-02-09	MSFT	Stock	86.3	88.93	83.83	88.18	63499100.0
2018-02-09	NVDA	Stock	5.9563	5.9722	5.438	5.802	1674604000.0
2018-02-09	AMZN	Stock	68.6745	69.175	63.2965	66.98	282830000.0
2018-02-09	GOOGL	Stock	51.294	52.586	49.85	52.3135	98359400.0
2018-02-09	META	Stock	174.76	176.9	167.18	176.11	39887600.0
2018-02-09	TSLA	Stock	21.3287	21.3987	19.6507	20.6947	194005500.0
2018-02-09	TLT	Stock	118.11	119.09	117.7901	117.94	15661576.0
2018-02-09	ES	Stock	56.27	57.43	55.93	57.02	2749800.0
2018-02-09	CL	Stock	69.54	70.06	68.49	69.76	6097600.0
2018-02-09	A	Stock	66.4	67.53	65.29	66.98	4517000.0
2018-02-09	AA	Stock	46.54	47.06	44.15	45.92	4579600.0
2018-02-09	AAAP-DELISTED	Stock	81.63	82.05	81.5	82.0	10514.0
2018-02-09	AABA-DELISTED	Stock	70.57	70.77	67.86	70.47	5581479.0
2018-02-09	AAC-DELISTED	Stock	8.03	8.1	7.79	8.01	112165.0
2018-02-09	AACG	Stock	5.76	6.0	5.76	5.8	16800.0
2018-02-09	AAIC-DELISTED	Stock	10.92	10.92	10.41	10.56	1214133.0
2018-02-09	AAL	Stock	49.7	49.73	46.33	48.36	6837800.0
2018-02-09	AAM.A-DELISTED	Stock	25.52	25.56	25.07	25.56	38670.0
2018-02-09	AAMC-DELISTED	Stock	19.8824	19.8824	19.8824	19.8824	857.0
2018-02-09	AAME	Stock	3.15	3.15	3.1	3.1	700.0
2018-02-09	AAMI	Stock	15.87	15.91	15.01	15.37	1862500.0
2018-02-09	AAOI	Stock	32.18	32.66	30.3	30.72	1931700.0
2018-02-09	AAON	Stock	22.3	22.3333	21.6667	22.1333	500400.0
2018-02-09	AAP	Stock	110.39	110.45	103.34	109.14	1577900.0
2018-02-09	AAT	Stock	32.17	33.07	31.5	32.86	271700.0
2018-02-09	AAU-DELISTED	Stock	0.86	0.8899	0.837	0.8577	272919.0
2018-02-09	AAUAF-DELISTED	Stock	0.86	0.8899	0.837	0.8577	290093.0
2018-02-09	AAV-DELISTED	Stock	2.95	3.025	2.75	2.975	708310.0
2018-02-09	AAWW-DELISTED	Stock	52.15	52.5	50.65	51.9	280650.0
2018-02-09	AAXJ	Stock	74.09	74.91	72.24	74.44	3253478.0
2018-02-09	AAXN-DELISTED	Stock	25.54	25.88	24.85	25.27	744290.0
2018-02-09	AB	Stock	24.8	25.0	24.36	24.8	276600.0
2018-02-09	ABAC-DELISTED	Stock	2.64	2.64	2.5	2.62	3367.0
2018-02-09	ABAX-DELISTED	Stock	63.48	65.45	61.96	64.56	231541.0
2018-02-09	ABB-DELISTED	Stock	24.45	24.585	23.7531	24.3	4740787.0
2018-02-09	ABBNY-DELISTED	Stock	24.46	24.585	23.7531	24.3	5081536.0
2018-02-09	ABBV	Stock	109.57	112.75	106.41	111.3	8909300.0
2018-02-09	ABC-DELISTED	Stock	92.54	92.54	85.8	89.19	2937757.0
2018-02-09	ABCB	Stock	52.25	53.05	51.2	52.7	232000.0
2018-02-09	ABCD-DELISTED	Stock	6.96	7.15	6.89	7.06	135020.0
2018-02-09	ABDC-DELISTED	Stock	7.54	7.56	7.35	7.52	60305.0
2018-02-09	ABE-DELISTED	Stock	14.6	14.6	14.33	14.5389	26253.0
2018-02-09	ABEO	Stock	401.25	401.25	345.0	352.0	100352.0
2018-02-09	ABEOW-DELISTED	Stock	10.75	10.75	8.8987	9.19	16617.0
2018-02-09	ABEV	Stock	6.56	6.59	6.36	6.54	25849500.0
2018-02-09	ABG	Stock	68.2	70.1	66.85	69.15	258600.0
2018-02-09	ABIL-DELISTED	Stock	0.3985	0.3985	0.37	0.3885	78559.0
2018-02-09	ABLX-DELISTED	Stock	53.2	53.28	52.8905	53.11	385731.0
2018-02-09	ABM	Stock	34.8	35.17	34.15	34.88	527600.0

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

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