PREVIEW / stock_daily / 2017-01-31

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-31.parquet
  size:    217 KB
  rows:    6,500
  symbols: 3,107

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-01-31	AAPL	Stock	30.2875	30.3475	30.155	30.3375	196804000.0
2017-01-31	MSFT	Stock	64.86	65.15	64.26	64.65	25270500.0
2017-01-31	NVDA	Stock	2.7238	2.7513	2.705	2.7295	362756000.0
2017-01-31	AMZN	Stock	41.1875	41.3495	40.978	41.174	62744000.0
2017-01-31	GOOGL	Stock	40.975	41.1535	40.67	41.0095	40403600.0
2017-01-31	META	Stock	130.17	130.66	129.52	130.32	19790500.0
2017-01-31	TSLA	Stock	16.616	17.0593	16.5133	16.7953	61741500.0
2017-01-31	TLT	Stock	119.33	120.4	119.25	120.1	13298521.0
2017-01-31	ES	Stock	54.42	55.39	54.42	55.32	1572000.0
2017-01-31	CL	Stock	64.53	65.09	64.34	64.58	6983200.0
2017-01-31	A	Stock	48.04	49.15	48.01	48.97	2552600.0
2017-01-31	AA	Stock	36.78	37.23	36.01	36.45	2690300.0
2017-01-31	AAAP-DELISTED	Stock	31.5	32.55	31.03	32.55	67984.0
2017-01-31	AABA-DELISTED	Stock	43.78	44.15	43.67	44.07	4534021.0
2017-01-31	AAC-DELISTED	Stock	7.96	8.055	7.75	7.94	85983.0
2017-01-31	AACG	Stock	3.02	3.04	3.01	3.04	1700.0
2017-01-31	AAIC-DELISTED	Stock	15.2	15.2	14.7352	14.97	345647.0
2017-01-31	AAL	Stock	44.79	44.84	43.74	44.25	11719800.0
2017-01-31	AAMC-DELISTED	Stock	18.3824	18.5	17.9412	18.4706	17864.0
2017-01-31	AAME	Stock	3.65	3.75	3.65	3.75	3300.0
2017-01-31	AAMI	Stock	13.79	14.1	13.78	14.1	221200.0
2017-01-31	AAOI	Stock	30.11	30.92	29.4	30.76	520500.0
2017-01-31	AAON	Stock	22.4667	22.6867	22.22	22.6333	216000.0
2017-01-31	AAP	Stock	162.4	164.68	162.27	164.24	1056000.0
2017-01-31	AAT	Stock	42.29	43.07	42.18	42.93	176300.0
2017-01-31	AAU-DELISTED	Stock	1.02	1.05	1.01	1.04	178210.0
2017-01-31	AAUAF-DELISTED	Stock	1.02	1.05	1.01	1.02	179997.0
2017-01-31	AAV-DELISTED	Stock	6.45	6.475	6.4	6.4	53017.0
2017-01-31	AAWW-DELISTED	Stock	53.1	53.1	51.85	52.75	118809.0
2017-01-31	AAXJ	Stock	58.84	59.065	58.83	58.99	701969.0
2017-01-31	AAXN-DELISTED	Stock	24.83	25.03	24.5	24.97	538444.0
2017-01-31	AB	Stock	23.3	23.55	23.1	23.35	222500.0
2017-01-31	ABAC-DELISTED	Stock	3.21	3.5	3.04	3.35	27267.0
2017-01-31	ABAX-DELISTED	Stock	49.63	51.76	49.43	50.95	342038.0
2017-01-31	ABB-DELISTED	Stock	23.81	23.85	23.65	23.82	3192443.0
2017-01-31	ABBNY-DELISTED	Stock	23.81	23.85	23.65	23.82	3627774.0
2017-01-31	ABBV	Stock	60.01	61.32	59.75	61.11	8149800.0
2017-01-31	ABC-DELISTED	Stock	86.62	87.84	83.0	87.28	5340152.0
2017-01-31	ABCB	Stock	44.65	45.35	44.35	45.1	165600.0
2017-01-31	ABCD-DELISTED	Stock	5.0816	5.16	4.9999	5.04	35540.0
2017-01-31	ABCO-DELISTED	Stock	45.0	45.65	44.8	45.55	418156.0
2017-01-31	ABDC-DELISTED	Stock	12.2	12.2	11.9	11.94	46755.0
2017-01-31	ABE-DELISTED	Stock	11.6	11.68	11.58	11.65	114455.0
2017-01-31	ABEO	Stock	115.0	117.5	113.25	115.0	5312.0
2017-01-31	ABEV	Stock	5.4	5.43	5.36	5.39	8942300.0
2017-01-31	ABG	Stock	64.5	66.1	63.45	65.6	267500.0
2017-01-31	ABIL-DELISTED	Stock	3.29	3.29	3.21	3.24	18755.0
2017-01-31	ABM	Stock	40.43	40.7	40.01	40.39	3798300.0
2017-01-31	ABMD-DELISTED	Stock	106.3	107.0	105.16	106.39	390802.0
2017-01-31	ABR	Stock	7.43	7.43	7.11	7.38	154200.0

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

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