PREVIEW / stock_daily / 2017-02-06

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-06.parquet
  size:    215 KB
  rows:    6,489
  symbols: 3,087

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-02-06	AAPL	Stock	32.2825	32.625	32.225	32.5725	107383600.0
2017-02-06	MSFT	Stock	63.5	63.65	63.14	63.64	19796400.0
2017-02-06	NVDA	Stock	2.85	2.9332	2.85	2.9328	506768000.0
2017-02-06	AMZN	Stock	40.49	40.536	40.15	40.382	77946000.0
2017-02-06	GOOGL	Stock	41.046	41.1195	40.7145	41.081	27017500.0
2017-02-06	META	Stock	130.98	132.06	130.3	132.06	17058500.0
2017-02-06	TSLA	Stock	16.7333	17.188	16.7087	17.1847	53437500.0
2017-02-06	TLT	Stock	119.76	120.13	119.12	119.72	8433772.0
2017-02-06	ES	Stock	55.91	56.0	55.53	55.68	900000.0
2017-02-06	CL	Stock	66.08	66.08	65.45	65.49	2897500.0
2017-02-06	A	Stock	49.13	49.38	48.96	49.27	952100.0
2017-02-06	AA	Stock	36.9	38.0	36.8	37.75	2833900.0
2017-02-06	AAAP-DELISTED	Stock	34.4	35.12	34.2	34.85	201979.0
2017-02-06	AABA-DELISTED	Stock	43.62	44.53	43.56	44.4	6970549.0
2017-02-06	AAC-DELISTED	Stock	8.0	8.19	7.891	7.95	115311.0
2017-02-06	AACG	Stock	3.49	3.49	3.36	3.45	500.0
2017-02-06	AAIC-DELISTED	Stock	15.35	15.495	15.28	15.45	386327.0
2017-02-06	AAL	Stock	44.8	45.6	44.74	45.3	6496100.0
2017-02-06	AAMC-DELISTED	Stock	22.4412	23.6029	22.2647	23.6029	35340.0
2017-02-06	AAME	Stock	3.85	3.87	3.65	3.65	2300.0
2017-02-06	AAMI	Stock	15.08	15.2	14.84	14.84	476300.0
2017-02-06	AAOI	Stock	31.91	32.79	31.376	31.79	439500.0
2017-02-06	AAON	Stock	22.6	22.6533	22.3667	22.4	165150.0
2017-02-06	AAP	Stock	161.73	163.03	159.93	160.27	944700.0
2017-02-06	AAT	Stock	42.97	43.17	42.59	43.02	109100.0
2017-02-06	AAU-DELISTED	Stock	1.24	1.28	1.2	1.26	553513.0
2017-02-06	AAUAF-DELISTED	Stock	1.24	1.28	1.2	1.27	569179.0
2017-02-06	AAV-DELISTED	Stock	6.45	6.45	6.05	6.15	129764.0
2017-02-06	AAWW-DELISTED	Stock	52.3	52.6	51.2	51.5	115936.0
2017-02-06	AAXJ	Stock	59.51	59.63	59.46	59.54	467143.0
2017-02-06	AAXN-DELISTED	Stock	26.33	26.99	26.18	26.94	925587.0
2017-02-06	AB	Stock	23.8	24.0	23.35	23.45	391400.0
2017-02-06	ABAC-DELISTED	Stock	3.8	3.96	3.55	3.68	44756.0
2017-02-06	ABAX-DELISTED	Stock	51.22	51.85	50.64	51.04	81665.0
2017-02-06	ABB-DELISTED	Stock	23.33	23.3951	23.27	23.375	1722563.0
2017-02-06	ABBNY-DELISTED	Stock	23.33	23.3951	23.27	23.37	1819929.0
2017-02-06	ABBV	Stock	60.51	60.97	60.35	60.65	5358100.0
2017-02-06	ABC-DELISTED	Stock	89.17	91.65	88.931	89.99	2475656.0
2017-02-06	ABCB	Stock	46.1	46.3	45.85	46.15	190700.0
2017-02-06	ABCD-DELISTED	Stock	5.1	5.12	5.05	5.07	18691.0
2017-02-06	ABCO-DELISTED	Stock	47.15	47.65	46.5	46.75	606285.0
2017-02-06	ABDC-DELISTED	Stock	11.9	12.21	11.877	12.16	70741.0
2017-02-06	ABE-DELISTED	Stock	11.86	11.9301	11.79	11.85	64155.0
2017-02-06	ABEO	Stock	122.5	129.0	122.25	125.0	6100.0
2017-02-06	ABEOW-DELISTED	Stock	2.85	2.85	2.85	2.85	350.0
2017-02-06	ABEV	Stock	5.47	5.49	5.42	5.46	8229100.0
2017-02-06	ABG	Stock	64.5	64.55	63.05	63.85	446900.0
2017-02-06	ABIL-DELISTED	Stock	3.23	3.3	3.22	3.25	12225.0
2017-02-06	ABM	Stock	40.59	40.83	40.33	40.4	308100.0
2017-02-06	ABMD-DELISTED	Stock	105.11	111.22	105.11	110.51	1101136.0

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

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