PREVIEW / stock_daily / 2017-06-29

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-29.parquet
  size:    215 KB
  rows:    6,463
  symbols: 2,994

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-06-29	AAPL	Stock	36.1775	36.2825	35.57	35.92	125997600.0
2017-06-29	MSFT	Stock	69.38	69.49	68.09	68.49	28918700.0
2017-06-29	NVDA	Stock	3.765	3.768	3.602	3.667	1064424000.0
2017-06-29	AMZN	Stock	48.95	49.378	48.2625	48.7965	86060000.0
2017-06-29	GOOGL	Stock	47.5675	47.583	46.48	46.891	64133480.0
2017-06-29	META	Stock	152.28	152.5	148.92	151.04	23973500.0
2017-06-29	TSLA	Stock	24.7073	24.7333	23.6067	24.05	123315000.0
2017-06-29	TLT	Stock	125.01	125.72	124.9	125.41	9116011.0
2017-06-29	ES	Stock	61.04	61.67	60.52	60.7	1076700.0
2017-06-29	CL	Stock	74.82	75.04	74.04	74.12	2882800.0
2017-06-29	A	Stock	59.35	59.63	58.49	58.8	1356800.0
2017-06-29	AA	Stock	33.11	33.34	32.61	33.18	3841300.0
2017-06-29	AAAP-DELISTED	Stock	39.33	39.33	38.73	38.75	27986.0
2017-06-29	AABA-DELISTED	Stock	54.49	54.92	53.13	54.3	10877095.0
2017-06-29	AAC-DELISTED	Stock	7.0	7.11	6.63	7.04	75068.0
2017-06-29	AACG	Stock	4.8	4.8	4.72	4.72	5400.0
2017-06-29	AAIC-DELISTED	Stock	13.88	13.88	13.7	13.77	461146.0
2017-06-29	AAL	Stock	49.28	49.69	48.82	49.62	6170100.0
2017-06-29	AAM.A-DELISTED	Stock	25.65	25.67	25.62	25.63	61340.0
2017-06-29	AAMC-DELISTED	Stock	25.9706	26.0147	24.8824	25.6779	30382.0
2017-06-29	AAME	Stock	3.75	3.75	3.68	3.7	1200.0
2017-06-29	AAMI	Stock	15.21	15.28	14.88	15.15	1192900.0
2017-06-29	AAOI	Stock	60.16	60.854	58.77	60.0	1379000.0
2017-06-29	AAON	Stock	24.2667	24.5667	23.9	24.2667	236100.0
2017-06-29	AAP	Stock	116.25	118.25	115.62	116.05	2184100.0
2017-06-29	AAT	Stock	39.95	40.4	39.81	39.9	232400.0
2017-06-29	AAU-DELISTED	Stock	1.3	1.35	1.29	1.305	125179.0
2017-06-29	AAUAF-DELISTED	Stock	1.3	1.35	1.29	1.3	126154.0
2017-06-29	AAV-DELISTED	Stock	6.65	6.65	6.55	6.6	69953.0
2017-06-29	AAWW-DELISTED	Stock	51.9	52.05	50.125	51.0	257552.0
2017-06-29	AAXJ	Stock	67.75	67.75	66.78	67.16	1239815.0
2017-06-29	AAXN-DELISTED	Stock	25.87	25.97	24.76	25.17	432743.0
2017-06-29	AB	Stock	23.35	23.55	23.25	23.3	240900.0
2017-06-29	ABAC-DELISTED	Stock	2.14	2.169	2.1	2.1	7737.0
2017-06-29	ABAX-DELISTED	Stock	53.71	53.71	52.16	52.73	137764.0
2017-06-29	ABB-DELISTED	Stock	25.05	25.06	24.58	24.74	2204578.0
2017-06-29	ABBNY-DELISTED	Stock	25.05	25.06	24.58	24.74	2254280.0
2017-06-29	ABBV	Stock	73.15	73.17	71.91	72.48	4444700.0
2017-06-29	ABC-DELISTED	Stock	96.68	97.85	95.39	95.78	874287.0
2017-06-29	ABCB	Stock	49.1	49.25	48.05	48.75	192000.0
2017-06-29	ABCD-DELISTED	Stock	5.06	5.07	4.91	4.97	23448.0
2017-06-29	ABCO-DELISTED	Stock	51.4	51.4	50.65	51.05	363814.0
2017-06-29	ABDC-DELISTED	Stock	13.25	13.59	13.2201	13.5	107178.0
2017-06-29	ABE-DELISTED	Stock	13.9899	13.9899	13.85	13.86	4283.0
2017-06-29	ABEO	Stock	156.25	161.25	150.0	156.25	17592.0
2017-06-29	ABEOW-DELISTED	Stock	3.3176	3.3176	3.2	3.2048	3690.0
2017-06-29	ABEV	Stock	5.52	5.53	5.43	5.47	28257700.0
2017-06-29	ABG	Stock	55.25	56.55	54.85	55.85	192500.0
2017-06-29	ABIL-DELISTED	Stock	1.38	1.54	1.26	1.31	1351152.0
2017-06-29	ABM	Stock	42.21	42.21	41.08	41.59	247000.0

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

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