PREVIEW / stock_daily / 2018-03-27

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-27.parquet
  size:    217 KB
  rows:    6,485
  symbols: 2,840

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-27	AAPL	Stock	43.42	43.7875	41.73	42.085	163690400.0
2018-03-27	MSFT	Stock	94.94	95.14	88.51	89.47	56569000.0
2018-03-27	NVDA	Stock	6.1938	6.25	5.4962	5.638	1409000000.0
2018-03-27	AMZN	Stock	78.62	78.7985	74.116	74.8525	139992000.0
2018-03-27	GOOGL	Stock	53.195	53.227	49.881	50.347	60816180.0
2018-03-27	META	Stock	156.31	162.85	150.75	152.22	79117000.0
2018-03-27	TSLA	Stock	20.2667	20.2847	18.4787	18.612	208080000.0
2018-03-27	TLT	Stock	119.83	121.12	119.81	120.99	9168508.0
2018-03-27	ES	Stock	57.66	59.35	57.45	58.59	2811300.0
2018-03-27	CL	Stock	68.19	69.85	68.19	69.28	3760200.0
2018-03-27	A	Stock	68.48	68.63	66.54	67.0	2104500.0
2018-03-27	AA	Stock	46.25	46.49	44.635	44.9	4204800.0
2018-03-27	AABA-DELISTED	Stock	76.62	76.62	72.45	73.04	7475119.0
2018-03-27	AAC-DELISTED	Stock	12.3	12.3	11.56	11.61	75831.0
2018-03-27	AAIC-DELISTED	Stock	11.66	11.795	11.56	11.73	944074.0
2018-03-27	AAL	Stock	52.3	52.35	50.55	50.9	2940700.0
2018-03-27	AAM.A-DELISTED	Stock	24.84	25.048	24.84	25.0	46724.0
2018-03-27	AAM.B-DELISTED	Stock	24.74	24.88	24.74	24.82	199452.0
2018-03-27	AAMC-DELISTED	Stock	17.5441	20.4853	17.5097	19.1912	24256.0
2018-03-27	AAMI	Stock	15.85	15.93	15.64	15.68	717800.0
2018-03-27	AAOI	Stock	24.54	25.239	24.15	24.6	756500.0
2018-03-27	AAON	Stock	25.3333	25.5333	25.0667	25.3333	292800.0
2018-03-27	AAP	Stock	114.58	117.45	113.29	115.01	1402700.0
2018-03-27	AAT	Stock	32.74	33.2	31.98	32.75	617200.0
2018-03-27	AAU-DELISTED	Stock	0.87	0.87	0.82	0.825	88797.0
2018-03-27	AAUAF-DELISTED	Stock	0.87	0.87	0.82	0.825	102710.0
2018-03-27	AAV-DELISTED	Stock	3.2	3.2	2.95	3.0	227471.0
2018-03-27	AAWW-DELISTED	Stock	60.35	60.35	58.75	59.1	210399.0
2018-03-27	AAXJ	Stock	77.75	77.96	76.3	76.56	3152732.0
2018-03-27	AAXN-DELISTED	Stock	38.67	39.31	38.32	38.64	470020.0
2018-03-27	AB	Stock	26.6	26.65	26.05	26.2	306300.0
2018-03-27	ABAC-DELISTED	Stock	2.48	2.48	2.2709	2.329	13197.0
2018-03-27	ABAX-DELISTED	Stock	74.45	74.45	69.47	69.81	219413.0
2018-03-27	ABB-DELISTED	Stock	23.64	23.74	23.17	23.26	2604381.0
2018-03-27	ABBNY-DELISTED	Stock	23.64	23.74	23.17	23.25	2793357.0
2018-03-27	ABBV	Stock	95.5	95.72	91.12	92.01	10821300.0
2018-03-27	ABC-DELISTED	Stock	84.93	85.205	83.38	84.01	1240849.0
2018-03-27	ABCB	Stock	54.0	54.0	52.2	52.5	175500.0
2018-03-27	ABCD-DELISTED	Stock	10.53	10.79	9.76	9.87	353574.0
2018-03-27	ABDC-DELISTED	Stock	7.2	7.28	7.03	7.14	106024.0
2018-03-27	ABE-DELISTED	Stock	14.81	14.8329	14.59	14.59	8196.0
2018-03-27	ABEO	Stock	376.25	381.25	345.0	350.0	43152.0
2018-03-27	ABEV	Stock	7.14	7.2	7.07	7.08	15103700.0
2018-03-27	ABG	Stock	65.7	66.3	64.4	64.7	137000.0
2018-03-27	ABIL-DELISTED	Stock	4.2	4.24	3.5	3.87	56070.0
2018-03-27	ABLX-DELISTED	Stock	54.38	54.49	54.3	54.41	27997.0
2018-03-27	ABM	Stock	33.37	33.65	32.63	32.77	699000.0
2018-03-27	ABMD-DELISTED	Stock	296.0	299.88	283.64	286.43	366859.0
2018-03-27	ABR	Stock	8.77	8.8	8.71	8.74	376000.0
2018-03-27	ABR.A-DELISTED	Stock	25.358	25.358	25.3	25.3	1600.0

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

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