PREVIEW / stock_daily / 2017-12-29

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-29.parquet
  size:    217 KB
  rows:    6,522
  symbols: 2,899

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-12-29	AAPL	Stock	42.63	42.6475	42.305	42.3075	103999600.0
2017-12-29	MSFT	Stock	85.63	86.05	85.5	85.54	18717400.0
2017-12-29	NVDA	Stock	4.9615	4.9615	4.8375	4.8375	279964000.0
2017-12-29	AMZN	Stock	59.1175	59.2	58.375	58.4735	53768000.0
2017-12-29	GOOGL	Stock	52.7745	52.9025	52.635	52.67	23606800.0
2017-12-29	META	Stock	178.0	178.85	176.46	176.46	10261500.0
2017-12-29	TSLA	Stock	21.0787	21.094	20.6667	20.7567	56658000.0
2017-12-29	TLT	Stock	126.5	127.12	126.475	126.86	7580515.0
2017-12-29	ES	Stock	62.87	63.41	62.87	63.18	1538400.0
2017-12-29	CL	Stock	75.33	75.69	75.28	75.45	1905200.0
2017-12-29	A	Stock	67.5	67.58	66.93	66.97	1064900.0
2017-12-29	AA	Stock	54.0	54.61	53.52	53.87	5174600.0
2017-12-29	AAAP-DELISTED	Stock	81.63	81.65	81.6	81.61	544855.0
2017-12-29	AABA-DELISTED	Stock	69.79	70.13	69.43	69.84	3913938.0
2017-12-29	AAC-DELISTED	Stock	9.02	9.26	9.0	9.01	82887.0
2017-12-29	AACG	Stock	4.85	4.96	4.61	4.62	7100.0
2017-12-29	AAIC-DELISTED	Stock	11.87	11.96	11.76	11.78	527635.0
2017-12-29	AAL	Stock	52.42	52.82	52.01	52.03	2696300.0
2017-12-29	AAM.A-DELISTED	Stock	26.24	26.36	26.21	26.29	25528.0
2017-12-29	AAMC-DELISTED	Stock	23.0882	24.4118	23.0882	24.0	21389.0
2017-12-29	AAME	Stock	3.59	3.59	3.3	3.4	2400.0
2017-12-29	AAMI	Stock	16.85	16.91	16.52	16.75	1119100.0
2017-12-29	AAOI	Stock	38.6	38.86	37.36	37.82	1493400.0
2017-12-29	AAON	Stock	24.6	24.7667	24.4667	24.4667	251100.0
2017-12-29	AAP	Stock	99.85	100.99	99.5	99.69	969200.0
2017-12-29	AAT	Stock	38.53	38.53	38.11	38.24	189700.0
2017-12-29	AAU-DELISTED	Stock	1.02	1.04	1.0	1.0261	290002.0
2017-12-29	AAUAF-DELISTED	Stock	1.02	1.04	1.0	1.03	320608.0
2017-12-29	AAV-DELISTED	Stock	4.35	4.4	4.25	4.275	103792.0
2017-12-29	AAWW-DELISTED	Stock	59.45	59.75	58.6	58.6	103175.0
2017-12-29	AAXJ	Stock	76.53	76.61	76.231	76.28	637912.0
2017-12-29	AAXN-DELISTED	Stock	26.9	26.92	26.47	26.49	320505.0
2017-12-29	AB	Stock	25.15	25.21	24.95	25.05	164400.0
2017-12-29	ABAC-DELISTED	Stock	2.8	3.0	2.8	2.95	18188.0
2017-12-29	ABAX-DELISTED	Stock	49.97	50.0	49.4	49.51	114552.0
2017-12-29	ABB-DELISTED	Stock	26.77	26.94	26.74	26.83	1722904.0
2017-12-29	ABBNY-DELISTED	Stock	26.77	26.94	26.74	26.82	1841776.0
2017-12-29	ABBV	Stock	98.14	98.43	96.71	96.71	3214400.0
2017-12-29	ABC-DELISTED	Stock	92.89	93.6	91.755	91.83	636722.0
2017-12-29	ABCB	Stock	48.8	48.9	48.15	48.2	171200.0
2017-12-29	ABCD-DELISTED	Stock	5.66	5.81	5.6	5.8	48756.0
2017-12-29	ABDC-DELISTED	Stock	8.34	8.52	8.29	8.41	167344.0
2017-12-29	ABE-DELISTED	Stock	14.58	14.6509	14.53	14.54	21743.0
2017-12-29	ABEO	Stock	400.0	411.25	395.0	396.25	24136.0
2017-12-29	ABEOW-DELISTED	Stock	11.35	11.6	11.35	11.6	200.0
2017-12-29	ABEV	Stock	6.43	6.57	6.43	6.46	23205500.0
2017-12-29	ABG	Stock	65.5	65.85	63.9	64.0	297000.0
2017-12-29	ABIL-DELISTED	Stock	0.42	0.44	0.4121	0.44	209204.0
2017-12-29	ABLX-DELISTED	Stock	24.71	25.07	24.57	24.98	100319.0
2017-12-29	ABM	Stock	38.01	38.31	37.68	37.72	488300.0

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

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