PREVIEW / stock_daily / 2017-09-07

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-07.parquet
  size:    215 KB
  rows:    6,454
  symbols: 2,946

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-09-07	AAPL	Stock	40.5225	40.56	40.09	40.315	87714000.0
2017-09-07	MSFT	Stock	73.68	74.6	73.6	74.34	17471200.0
2017-09-07	NVDA	Stock	4.1622	4.1972	4.1238	4.1645	352868000.0
2017-09-07	AMZN	Stock	48.7	49.0295	48.6275	48.9735	51336000.0
2017-09-07	GOOGL	Stock	47.2125	47.5248	46.8765	47.4945	22331500.0
2017-09-07	META	Stock	171.94	173.31	170.27	173.21	18049500.0
2017-09-07	TSLA	Stock	23.0653	23.4987	22.8967	23.374	63588000.0
2017-09-07	TLT	Stock	128.33	129.565	128.33	129.28	13618862.0
2017-09-07	ES	Stock	62.77	63.27	62.57	63.2	1582200.0
2017-09-07	CL	Stock	71.45	71.72	71.11	71.56	2124600.0
2017-09-07	A	Stock	64.85	65.25	64.49	65.14	1075800.0
2017-09-07	AA	Stock	44.16	44.9	44.04	44.73	3329500.0
2017-09-07	AAAP-DELISTED	Stock	50.71	50.71	48.51	50.12	160538.0
2017-09-07	AABA-DELISTED	Stock	63.56	64.18	63.17	64.0201	2990074.0
2017-09-07	AAC-DELISTED	Stock	10.36	10.36	10.01	10.16	46300.0
2017-09-07	AACG	Stock	4.74	4.75	4.63	4.63	14500.0
2017-09-07	AAIC-DELISTED	Stock	12.86	12.89	12.76	12.81	182193.0
2017-09-07	AAL	Stock	44.19	44.63	43.53	43.84	5095000.0
2017-09-07	AAM.A-DELISTED	Stock	26.03	26.12	26.0	26.02	25425.0
2017-09-07	AAMC-DELISTED	Stock	31.3235	32.1324	28.7647	29.9853	31270.0
2017-09-07	AAME	Stock	3.45	3.45	3.4	3.45	4100.0
2017-09-07	AAMI	Stock	13.52	13.56	13.35	13.51	363100.0
2017-09-07	AAOI	Stock	58.52	59.25	56.1	56.16	1889700.0
2017-09-07	AAON	Stock	21.8333	21.8333	21.2	21.2333	190200.0
2017-09-07	AAP	Stock	96.0	96.33	92.77	93.53	2863200.0
2017-09-07	AAT	Stock	40.67	41.02	40.48	40.75	286400.0
2017-09-07	AAU-DELISTED	Stock	1.26	1.32	1.25	1.31	392552.0
2017-09-07	AAUAF-DELISTED	Stock	1.26	1.32	1.25	1.31	399529.0
2017-09-07	AAV-DELISTED	Stock	6.25	6.4	6.25	6.4	67925.0
2017-09-07	AAWW-DELISTED	Stock	66.35	66.4	65.0	66.25	189898.0
2017-09-07	AAXJ	Stock	72.01	72.22	71.94	72.22	585085.0
2017-09-07	AAXN-DELISTED	Stock	21.74	21.99	21.48	21.49	462817.0
2017-09-07	AB	Stock	23.55	23.65	23.26	23.35	155100.0
2017-09-07	ABAC-DELISTED	Stock	2.25	2.25	2.1991	2.1991	675.0
2017-09-07	ABAX-DELISTED	Stock	46.2	46.22	45.23	45.42	88841.0
2017-09-07	ABB-DELISTED	Stock	23.87	24.0	23.82	23.93	1249986.0
2017-09-07	ABBNY-DELISTED	Stock	23.87	24.0	23.82	23.93	1286827.0
2017-09-07	ABBV	Stock	77.29	82.45	77.0	81.78	15377300.0
2017-09-07	ABC-DELISTED	Stock	80.82	83.03	80.65	82.565	1567675.0
2017-09-07	ABCB	Stock	42.75	42.75	41.18	41.4	89300.0
2017-09-07	ABCD-DELISTED	Stock	6.17	6.3	6.0107	6.22	53704.0
2017-09-07	ABCO-DELISTED	Stock	53.4	53.45	53.3	53.3	809147.0
2017-09-07	ABDC-DELISTED	Stock	11.06	11.1589	10.96	11.01	28404.0
2017-09-07	ABE-DELISTED	Stock	14.0002	14.32	14.0002	14.31	20768.0
2017-09-07	ABEO	Stock	335.0	349.75	327.5	346.25	31488.0
2017-09-07	ABEOW-DELISTED	Stock	8.2	8.9088	8.2	8.67	5450.0
2017-09-07	ABEV	Stock	6.44	6.48	6.43	6.46	9880600.0
2017-09-07	ABG	Stock	54.35	54.9	53.85	54.8	126100.0
2017-09-07	ABIL-DELISTED	Stock	0.8	0.8	0.76	0.7601	64107.0
2017-09-07	ABM	Stock	40.68	40.87	37.12	40.04	1119900.0

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

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