PREVIEW / stock_daily / 2018-03-08

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-08.parquet
  size:    216 KB
  rows:    6,473
  symbols: 2,837

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
2018-03-08	AAPL	Stock	43.87	44.28	43.7675	44.235	95096400.0
2018-03-08	MSFT	Stock	94.27	95.1	93.77	94.43	25887800.0
2018-03-08	NVDA	Stock	6.0738	6.0738	5.9848	6.0295	411912000.0
2018-03-08	AMZN	Stock	77.5	77.744	77.2625	77.593	77252000.0
2018-03-08	GOOGL	Stock	55.86	56.572	55.86	56.469	33862660.0
2018-03-08	META	Stock	183.56	184.4	181.45	182.34	17225900.0
2018-03-08	TSLA	Stock	22.1907	22.22	21.7513	21.94	53493000.0
2018-03-08	TLT	Stock	118.31	118.99	118.26	118.69	7086716.0
2018-03-08	ES	Stock	56.49	57.12	56.49	56.87	2284200.0
2018-03-08	CL	Stock	69.75	71.05	69.65	71.02	4134800.0
2018-03-08	A	Stock	69.72	70.27	69.19	69.85	2453400.0
2018-03-08	AA	Stock	47.88	48.73	46.545	47.47	3256000.0
2018-03-08	AABA-DELISTED	Stock	76.01	76.27	75.29	75.72	3049130.0
2018-03-08	AAC-DELISTED	Stock	11.02	12.78	11.02	12.09	585378.0
2018-03-08	AACG	Stock	5.2	5.28	5.2	5.28	2500.0
2018-03-08	AAIC-DELISTED	Stock	11.57	11.65	11.49	11.63	406172.0
2018-03-08	AAL	Stock	54.33	55.69	54.28	54.79	4189500.0
2018-03-08	AAM.A-DELISTED	Stock	25.676	25.71	25.6	25.71	22416.0
2018-03-08	AAMC-DELISTED	Stock	19.7059	19.7059	19.7059	19.7059	3536.0
2018-03-08	AAMI	Stock	15.43	15.45	15.2	15.44	451800.0
2018-03-08	AAOI	Stock	26.65	29.5	26.65	27.95	2456400.0
2018-03-08	AAON	Stock	24.3333	24.4667	24.02	24.2333	193200.0
2018-03-08	AAP	Stock	117.33	117.33	114.54	115.75	672200.0
2018-03-08	AAT	Stock	32.41	32.43	32.16	32.36	323800.0
2018-03-08	AAU-DELISTED	Stock	0.88	0.8947	0.845	0.8678	220792.0
2018-03-08	AAUAF-DELISTED	Stock	0.88	0.8947	0.845	0.869	223027.0
2018-03-08	AAV-DELISTED	Stock	2.8	2.875	2.8	2.8	163714.0
2018-03-08	AAWW-DELISTED	Stock	61.0	61.25	59.7	60.55	173037.0
2018-03-08	AAXJ	Stock	77.88	78.03	77.5	77.83	490645.0
2018-03-08	AAXN-DELISTED	Stock	39.72	40.1	39.39	39.79	661386.0
2018-03-08	AB	Stock	27.15	27.2	26.75	27.1	297900.0
2018-03-08	ABAC-DELISTED	Stock	2.5	2.5	2.4501	2.4866	744.0
2018-03-08	ABAX-DELISTED	Stock	71.54	72.44	70.68	71.07	62860.0
2018-03-08	ABB-DELISTED	Stock	24.21	24.38	24.15	24.36	1383290.0
2018-03-08	ABBNY-DELISTED	Stock	24.21	24.38	24.15	24.36	1811427.0
2018-03-08	ABBV	Stock	115.0	117.75	114.35	117.01	6179400.0
2018-03-08	ABC-DELISTED	Stock	96.26	98.03	95.21	96.26	883975.0
2018-03-08	ABCB	Stock	57.35	57.6	56.15	56.4	179300.0
2018-03-08	ABCD-DELISTED	Stock	8.4	9.04	8.4	8.695	252576.0
2018-03-08	ABDC-DELISTED	Stock	7.7	7.74	7.59	7.67	11418.0
2018-03-08	ABE-DELISTED	Stock	15.14	15.14	15.05	15.09	29564.0
2018-03-08	ABEO	Stock	398.75	398.75	366.25	377.5	38052.0
2018-03-08	ABEOW-DELISTED	Stock	10.33	10.35	9.8801	9.8801	1635.0
2018-03-08	ABEV	Stock	7.07	7.16	7.02	7.1	31290400.0
2018-03-08	ABG	Stock	68.2	68.35	67.15	67.6	127500.0
2018-03-08	ABIL-DELISTED	Stock	0.41	0.41	0.3829	0.3996	45045.0
2018-03-08	ABLX-DELISTED	Stock	54.41	54.43	53.84	54.13	26989.0
2018-03-08	ABM	Stock	36.46	36.99	36.34	36.94	420600.0
2018-03-08	ABMD-DELISTED	Stock	286.99	290.52	286.1	288.52	284990.0
2018-03-08	ABR	Stock	8.5	8.66	8.5	8.64	703000.0

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

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