PREVIEW / stock_daily / 2018-03-19

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-19.parquet
  size:    216 KB
  rows:    6,496
  symbols: 2,853

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-19	AAPL	Stock	44.33	44.3675	43.415	43.825	133787200.0
2018-03-19	MSFT	Stock	93.74	93.9	92.11	92.89	33344100.0
2018-03-19	NVDA	Stock	6.2045	6.2338	5.925	6.025	713772000.0
2018-03-19	AMZN	Stock	77.7265	78.083	76.2675	77.2465	131616000.0
2018-03-19	GOOGL	Stock	55.888	55.9685	54.446	55.0035	63655920.0
2018-03-19	META	Stock	177.01	177.17	170.06	172.56	88140100.0
2018-03-19	TSLA	Stock	21.1	21.3833	20.6447	20.904	112264500.0
2018-03-19	TLT	Stock	119.21	119.97	119.2	119.43	8491173.0
2018-03-19	ES	Stock	58.33	58.37	57.7	58.04	2167100.0
2018-03-19	CL	Stock	69.97	71.3	69.78	70.06	3776900.0
2018-03-19	A	Stock	69.79	70.31	69.06	69.34	2639400.0
2018-03-19	AA	Stock	47.03	47.68	45.76	46.36	2509100.0
2018-03-19	AABA-DELISTED	Stock	79.29	79.48	77.31	77.84	4015083.0
2018-03-19	AAC-DELISTED	Stock	12.92	12.96	11.76	12.35	233349.0
2018-03-19	AACG	Stock	5.29	5.29	5.26	5.28	800.0
2018-03-19	AAIC-DELISTED	Stock	11.79	11.88	11.53	11.69	680895.0
2018-03-19	AAL	Stock	55.33	55.69	54.19	54.62	3834300.0
2018-03-19	AAM.A-DELISTED	Stock	25.15	25.19	25.06	25.08	30006.0
2018-03-19	AAMC-DELISTED	Stock	17.9559	17.9853	17.9412	17.9559	4036.0
2018-03-19	AAME	Stock	3.2	3.25	3.15	3.25	3000.0
2018-03-19	AAMI	Stock	15.73	15.75	15.42	15.65	622200.0
2018-03-19	AAOI	Stock	26.79	26.88	25.8	26.22	1265100.0
2018-03-19	AAON	Stock	26.0	26.2	25.7667	26.0333	455250.0
2018-03-19	AAP	Stock	116.79	117.56	114.7	115.87	813000.0
2018-03-19	AAT	Stock	33.23	33.26	32.87	33.21	287300.0
2018-03-19	AAU-DELISTED	Stock	0.85	0.85	0.81	0.8252	198804.0
2018-03-19	AAUAF-DELISTED	Stock	0.85	0.85	0.81	0.8252	202049.0
2018-03-19	AAV-DELISTED	Stock	2.95	2.95	2.75	2.8	288899.0
2018-03-19	AAWW-DELISTED	Stock	64.05	64.35	62.7	63.65	161752.0
2018-03-19	AAXJ	Stock	79.0	79.12	78.18	78.62	269232.0
2018-03-19	AAXN-DELISTED	Stock	37.81	37.95	37.11	37.4	688490.0
2018-03-19	AB	Stock	26.6	26.7	26.1	26.55	277000.0
2018-03-19	ABAC-DELISTED	Stock	2.27	2.44	2.27	2.44	3056.0
2018-03-19	ABAX-DELISTED	Stock	74.81	74.81	72.27	73.16	134492.0
2018-03-19	ABB-DELISTED	Stock	24.11	24.11	23.78	23.96	1230173.0
2018-03-19	ABBNY-DELISTED	Stock	24.11	24.11	23.78	23.96	1302997.0
2018-03-19	ABBV	Stock	113.74	114.98	110.44	112.03	8598900.0
2018-03-19	ABC-DELISTED	Stock	96.34	96.34	92.82	92.99	957803.0
2018-03-19	ABCB	Stock	56.2	56.75	55.55	56.6	318300.0
2018-03-19	ABCD-DELISTED	Stock	10.19	10.68	9.5551	10.17	384992.0
2018-03-19	ABDC-DELISTED	Stock	6.24	6.34	6.1	6.11	104087.0
2018-03-19	ABE-DELISTED	Stock	15.25	15.25	15.0411	15.08	3854.0
2018-03-19	ABEO	Stock	373.75	387.0	342.5	349.5	47420.0
2018-03-19	ABEOW-DELISTED	Stock	10.8	10.8	9.162	9.162	2600.0
2018-03-19	ABEV	Stock	7.07	7.19	7.06	7.17	14332900.0
2018-03-19	ABG	Stock	68.85	69.15	67.4	68.4	214600.0
2018-03-19	ABIL-DELISTED	Stock	0.39	0.42	0.385	0.4028	86978.0
2018-03-19	ABLX-DELISTED	Stock	54.0	54.155	53.89	54.14	27642.0
2018-03-19	ABM	Stock	34.94	35.04	33.95	34.46	818500.0
2018-03-19	ABMD-DELISTED	Stock	291.27	294.57	285.03	287.83	377256.0

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

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