PREVIEW / stock_daily / 2015-09-01

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-01.parquet
  size:    222 KB
  rows:    6,669
  symbols: 3,464

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
2015-09-01	AAPL	Stock	27.5375	27.97	26.84	26.93	307383600.0
2015-09-01	MSFT	Stock	42.17	42.59	41.66	41.82	49688900.0
2015-09-01	NVDA	Stock	0.5458	0.555	0.535	0.539	353408000.0
2015-09-01	AMZN	Stock	24.957	25.5	24.6715	24.827	77290000.0
2015-09-01	GOOGL	Stock	31.6905	32.222	31.253	31.478	51457680.0
2015-09-01	META	Stock	86.85	89.39	86.5	87.23	36097400.0
2015-09-01	TSLA	Stock	16.0227	16.4	15.798	15.9087	81822000.0
2015-09-01	TLT	Stock	121.64	122.09	120.98	122.03	15298248.0
2015-09-01	ES	Stock	46.72	46.75	45.83	46.07	2329300.0
2015-09-01	CL	Stock	61.62	62.27	60.91	61.27	4289000.0
2015-09-01	A	Stock	35.3	35.58	34.57	34.75	2953900.0
2015-09-01	AA.B-DELISTED	Stock	34.5	34.89	34.39	34.52	19950.0
2015-09-01	AABA-DELISTED	Stock	31.49	32.1	31.23	31.61	18762899.0
2015-09-01	AAC-DELISTED	Stock	23.14	23.255	21.72	22.14	566434.0
2015-09-01	AACG	Stock	2.4	2.7	2.31	2.4	56300.0
2015-09-01	AAIC-DELISTED	Stock	16.31	16.5394	16.16	16.23	252910.0
2015-09-01	AAL	Stock	38.63	39.81	38.5	39.2	16042600.0
2015-09-01	AAMC-DELISTED	Stock	11.3088	12.5	11.1853	11.6265	74042.0
2015-09-01	AAME	Stock	3.59	3.6	3.51	3.59	2000.0
2015-09-01	AAMI	Stock	16.17	16.31	16.09	16.14	201100.0
2015-09-01	AAOI	Stock	20.13	20.5	19.51	19.67	334300.0
2015-09-01	AAON	Stock	13.46	13.7333	13.1867	13.2067	223050.0
2015-09-01	AAP	Stock	172.53	173.92	171.47	172.62	802800.0
2015-09-01	AAT	Stock	38.03	38.42	37.5	37.75	187600.0
2015-09-01	AAU-DELISTED	Stock	0.6016	0.6016	0.54	0.5542	31289.0
2015-09-01	AAUAF-DELISTED	Stock	0.6016	0.6016	0.54	0.5542	32142.0
2015-09-01	AAV-DELISTED	Stock	5.41	5.54	5.27	5.34	259179.0
2015-09-01	AAVL-DELISTED	Stock	10.21	10.56	10.12	10.26	318424.0
2015-09-01	AAWW-DELISTED	Stock	40.38	42.7	38.2	38.39	460430.0
2015-09-01	AAXJ	Stock	52.01	52.25	51.37	51.62	1902892.0
2015-09-01	AAXN-DELISTED	Stock	22.75	23.07	22.4	22.5	1383269.0
2015-09-01	AB	Stock	26.92	27.04	26.19	26.19	268800.0
2015-09-01	ABAC-DELISTED	Stock	0.8	0.8	0.71	0.7459	7000.0
2015-09-01	ABAX-DELISTED	Stock	46.14	47.69	45.73	47.03	229702.0
2015-09-01	ABB-DELISTED	Stock	19.09	19.15	18.83	18.92	2914102.0
2015-09-01	ABBNY-DELISTED	Stock	19.09	19.15	18.83	18.91	2976476.0
2015-09-01	ABBV	Stock	61.0	61.63	60.16	60.5	12703200.0
2015-09-01	ABC-DELISTED	Stock	97.55	100.86	97.55	99.28	2046129.0
2015-09-01	ABCB	Stock	26.84	27.03	26.27	26.38	110300.0
2015-09-01	ABCD-DELISTED	Stock	5.11	5.15	4.89	4.98	120820.0
2015-09-01	ABCO-DELISTED	Stock	47.77	48.895	47.16	47.42	334767.0
2015-09-01	ABCW-DELISTED	Stock	40.23	41.0	40.0	40.07	26032.0
2015-09-01	ABDC-DELISTED	Stock	12.83	12.98	12.71	12.89	13523.0
2015-09-01	ABE-DELISTED	Stock	11.01	11.014	10.85	10.85	7153.0
2015-09-01	ABEO	Stock	115.25	121.25	113.5	116.0	5820.0
2015-09-01	ABEOW-DELISTED	Stock	1.6001	1.6001	1.6001	1.6001	500.0
2015-09-01	ABEV	Stock	5.11	5.19	5.03	5.07	20771100.0
2015-09-01	ABG	Stock	79.0	79.98	78.2	78.51	203400.0
2015-09-01	ABGB-DELISTED	Stock	5.9	6.04	5.62	5.64	81024.0
2015-09-01	ABIL-DELISTED	Stock	9.95	9.95	9.95	9.95	1028.0

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

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