PREVIEW / stock_daily / 2017-07-10

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-10.parquet
  size:    213 KB
  rows:    6,434
  symbols: 2,961

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-07-10	AAPL	Stock	36.0275	36.4875	35.8425	36.265	84362400.0
2017-07-10	MSFT	Stock	69.46	70.25	69.2	69.98	15014500.0
2017-07-10	NVDA	Stock	3.7435	3.85	3.717	3.8425	958492000.0
2017-07-10	AMZN	Stock	49.25	49.972	49.175	49.8235	70926000.0
2017-07-10	GOOGL	Stock	47.0975	47.6565	47.0975	47.55	29029200.0
2017-07-10	META	Stock	151.69	153.98	151.51	153.5	13378700.0
2017-07-10	TSLA	Stock	20.86	21.196	20.2087	21.07	207313500.0
2017-07-10	TLT	Stock	122.87	123.1	122.68	122.9	3859189.0
2017-07-10	ES	Stock	60.15	60.4	59.9	59.91	1321000.0
2017-07-10	CL	Stock	73.27	73.69	72.81	73.08	2427900.0
2017-07-10	A	Stock	59.48	60.05	59.38	59.86	1146000.0
2017-07-10	AA	Stock	33.91	34.45	33.68	34.14	3037400.0
2017-07-10	AAAP-DELISTED	Stock	38.66	39.67	38.29	39.67	152512.0
2017-07-10	AABA-DELISTED	Stock	54.28	54.98	54.27	54.81	3564522.0
2017-07-10	AAC-DELISTED	Stock	6.29	7.11	6.03	6.61	140436.0
2017-07-10	AACG	Stock	4.4	4.4	4.4	4.4	400.0
2017-07-10	AAIC-DELISTED	Stock	13.69	13.8	13.59	13.71	371815.0
2017-07-10	AAL	Stock	52.98	53.16	52.23	52.66	4600000.0
2017-07-10	AAM.A-DELISTED	Stock	25.78	25.78	25.75	25.78	42699.0
2017-07-10	AAMC-DELISTED	Stock	27.4559	27.4559	26.5885	26.9559	13828.0
2017-07-10	AAME	Stock	3.56	3.6	3.56	3.6	800.0
2017-07-10	AAMI	Stock	15.15	15.45	15.095	15.41	515000.0
2017-07-10	AAOI	Stock	67.39	69.05	64.79	68.64	2811200.0
2017-07-10	AAON	Stock	24.7333	25.0733	24.5	24.8333	150000.0
2017-07-10	AAP	Stock	101.94	102.39	99.5	101.17	1909300.0
2017-07-10	AAT	Stock	39.26	39.49	38.23	38.25	144800.0
2017-07-10	AAU-DELISTED	Stock	1.13	1.1701	1.12	1.17	240048.0
2017-07-10	AAUAF-DELISTED	Stock	1.13	1.1701	1.12	1.17	241315.0
2017-07-10	AAV-DELISTED	Stock	6.5	6.725	6.5	6.7	149310.0
2017-07-10	AAWW-DELISTED	Stock	55.1	56.55	54.85	56.25	323526.0
2017-07-10	AAXJ	Stock	66.99	67.52	66.99	67.44	783798.0
2017-07-10	AAXN-DELISTED	Stock	25.04	25.31	24.71	25.02	297416.0
2017-07-10	AB	Stock	23.9	24.3	23.87	24.05	314400.0
2017-07-10	ABAC-DELISTED	Stock	2.19	2.24	2.19	2.1901	5801.0
2017-07-10	ABAX-DELISTED	Stock	52.49	52.86	51.93	52.195	60354.0
2017-07-10	ABB-DELISTED	Stock	24.73	24.82	24.63	24.76	2277460.0
2017-07-10	ABBNY-DELISTED	Stock	24.73	24.82	24.63	24.75	2370659.0
2017-07-10	ABBV	Stock	71.8	72.22	71.58	71.83	3158300.0
2017-07-10	ABC-DELISTED	Stock	93.65	94.54	92.28	92.49	1093592.0
2017-07-10	ABCB	Stock	49.05	49.05	48.0	48.1	121200.0
2017-07-10	ABCD-DELISTED	Stock	5.13	5.13	4.97	5.05	22314.0
2017-07-10	ABCO-DELISTED	Stock	56.95	57.925	56.225	56.5	497808.0
2017-07-10	ABDC-DELISTED	Stock	13.45	13.61	13.29	13.46	33977.0
2017-07-10	ABE-DELISTED	Stock	13.89	13.94	13.89	13.92	1038.0
2017-07-10	ABEO	Stock	220.0	246.25	212.5	230.0	119436.0
2017-07-10	ABEOW-DELISTED	Stock	4.7	5.765	4.7	5.5	15494.0
2017-07-10	ABEV	Stock	5.49	5.61	5.47	5.59	37529400.0
2017-07-10	ABG	Stock	55.3	55.75	54.6	54.7	258600.0
2017-07-10	ABIL-DELISTED	Stock	1.11	1.16	1.07	1.13	147731.0
2017-07-10	ABM	Stock	40.92	41.2	40.68	40.68	185900.0

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

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