PREVIEW / stock_daily / 2018-10-11

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-11.parquet
  size:    222 KB
  rows:    6,559
  symbols: 2,741

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-10-11	AAPL	Stock	53.63	54.875	53.08	53.6125	212497600.0
2018-10-11	MSFT	Stock	105.35	108.93	104.2	105.91	63904300.0
2018-10-11	NVDA	Stock	6.0542	6.189	5.8565	5.8783	725436000.0
2018-10-11	AMZN	Stock	86.2	87.77	84.255	85.968	278718000.0
2018-10-11	GOOGL	Stock	53.952	55.8028	53.7945	54.537	67695500.0
2018-10-11	META	Stock	150.13	154.81	149.16	153.35	35338900.0
2018-10-11	TSLA	Stock	17.1687	17.4833	16.602	16.8153	122515500.0
2018-10-11	TLT	Stock	114.0	115.15	113.79	114.87	16087021.0
2018-10-11	ES	Stock	63.39	63.54	61.51	61.68	2396200.0
2018-10-11	CL	Stock	63.87	64.14	62.12	62.35	7242600.0
2018-10-11	A	Stock	66.64	66.97	64.62	64.89	3624200.0
2018-10-11	AA	Stock	35.8	36.22	35.13	35.67	3505400.0
2018-10-11	AABA-DELISTED	Stock	57.61	60.115	57.61	59.91	8487585.0
2018-10-11	AAC-DELISTED	Stock	6.98	7.1299	6.86	6.9	77768.0
2018-10-11	AACG	Stock	1.02	1.09	1.0	1.06	74700.0
2018-10-11	AAIC-DELISTED	Stock	8.69	8.76	8.45	8.46	537978.0
2018-10-11	AAL	Stock	32.3	32.75	30.75	31.27	17115800.0
2018-10-11	AAM.A-DELISTED	Stock	24.32	24.32	24.13	24.21	15171.0
2018-10-11	AAM.B-DELISTED	Stock	24.06	24.18	24.01	24.06	16569.0
2018-10-11	AAMC-DELISTED	Stock	14.7529	14.9294	14.7529	14.9294	4757.0
2018-10-11	AAME	Stock	2.66	2.79	2.66	2.77	2300.0
2018-10-11	AAMI	Stock	12.52	12.64	12.12	12.14	810400.0
2018-10-11	AAOI	Stock	20.759	23.18	20.759	22.02	1687500.0
2018-10-11	AAON	Stock	21.8867	22.4467	21.2	21.2267	313950.0
2018-10-11	AAP	Stock	162.87	165.53	160.6	161.04	1345400.0
2018-10-11	AAT	Stock	36.93	36.93	35.88	35.9	255900.0
2018-10-11	AAU-DELISTED	Stock	0.54	0.58	0.53	0.54	522012.0
2018-10-11	AAUAF-DELISTED	Stock	0.54	0.58	0.53	0.54	525241.0
2018-10-11	AAWW-DELISTED	Stock	54.04	54.1	52.03	52.08	297858.0
2018-10-11	AAXJ	Stock	63.42	64.07	62.67	63.26	2910260.0
2018-10-11	AAXN-DELISTED	Stock	57.02	58.8	56.08	56.19	689001.0
2018-10-11	AB	Stock	29.19	29.44	28.1	28.26	673000.0
2018-10-11	ABAC-DELISTED	Stock	1.92	1.9689	1.7	1.75	17573.0
2018-10-11	ABB-DELISTED	Stock	21.5	21.565	21.055	21.13	2082561.0
2018-10-11	ABBNY-DELISTED	Stock	21.51	21.565	21.055	21.14	2184079.0
2018-10-11	ABBV	Stock	93.0	93.38	89.61	90.7	9994400.0
2018-10-11	ABC-DELISTED	Stock	90.53	90.79	86.87	87.31	1328117.0
2018-10-11	ABCB	Stock	44.6	45.05	44.0	44.0	418500.0
2018-10-11	ABCD-DELISTED	Stock	11.74	11.88	11.58	11.74	92346.0
2018-10-11	ABDC-DELISTED	Stock	6.0	6.02	5.95	5.99	78928.0
2018-10-11	ABEO	Stock	249.5	259.0	245.0	251.0	32236.0
2018-10-11	ABEOW-DELISTED	Stock	5.45	5.45	5.424	5.424	300.0
2018-10-11	ABEV	Stock	4.55	4.61	4.45	4.46	26896200.0
2018-10-11	ABG	Stock	61.9	62.51	60.12	60.19	293400.0
2018-10-11	ABIL-DELISTED	Stock	3.16	3.208	3.02	3.0719	39163.0
2018-10-11	ABM	Stock	32.16	32.3	31.09	31.21	633700.0
2018-10-11	ABMD-DELISTED	Stock	372.0	383.88	363.6327	367.91	585755.0
2018-10-11	ABR	Stock	11.6	11.71	11.5	11.54	818900.0
2018-10-11	ABR.A-DELISTED	Stock	25.61	25.67	25.5331	25.65	790.0
2018-10-11	ABR.B-DELISTED	Stock	25.34	25.4499	25.34	25.4499	1905.0

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

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