PREVIEW / stock_daily / 2018-03-28

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-28.parquet
  size:    216 KB
  rows:    6,470
  symbols: 2,839

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-28	AAPL	Stock	41.8125	42.505	41.2975	41.62	166674000.0
2018-03-28	MSFT	Stock	89.82	91.23	88.87	89.39	52501100.0
2018-03-28	NVDA	Stock	5.6032	5.7348	5.425	5.5338	945904000.0
2018-03-28	AMZN	Stock	72.35	72.795	69.3085	71.571	274106000.0
2018-03-28	GOOGL	Stock	50.0955	51.2495	49.2	50.259	77698860.0
2018-03-28	META	Stock	151.65	155.88	150.8	153.03	60029200.0
2018-03-28	TSLA	Stock	17.6387	17.912	16.8067	17.1853	315021000.0
2018-03-28	TLT	Stock	121.45	121.64	120.945	121.31	7412538.0
2018-03-28	ES	Stock	58.78	59.15	58.22	58.47	1925300.0
2018-03-28	CL	Stock	69.55	71.06	69.55	70.8	4174400.0
2018-03-28	A	Stock	67.22	67.38	65.81	66.4	2267800.0
2018-03-28	AA	Stock	44.51	44.92	43.686	44.42	1661700.0
2018-03-28	AABA-DELISTED	Stock	72.74	73.52	71.77	72.63	7146474.0
2018-03-28	AAC-DELISTED	Stock	11.5	11.5501	10.99	11.28	162540.0
2018-03-28	AACG	Stock	5.19	5.24	5.12	5.22	15800.0
2018-03-28	AAIC-DELISTED	Stock	11.18	11.19	10.87	10.96	1142656.0
2018-03-28	AAL	Stock	50.9	51.26	50.05	50.85	4177500.0
2018-03-28	AAM.A-DELISTED	Stock	24.97	25.0572	24.895	24.927	20008.0
2018-03-28	AAM.B-DELISTED	Stock	24.82	24.87	24.8	24.82	99824.0
2018-03-28	AAMC-DELISTED	Stock	19.2647	19.2647	19.2647	19.2647	867.0
2018-03-28	AAME	Stock	3.3	3.3	3.1	3.2	2300.0
2018-03-28	AAMI	Stock	15.64	15.82	15.47	15.52	762900.0
2018-03-28	AAOI	Stock	24.54	24.58	23.56	23.65	1210400.0
2018-03-28	AAON	Stock	25.3333	25.7667	25.2667	25.7333	314700.0
2018-03-28	AAP	Stock	115.28	119.42	114.08	115.98	1047500.0
2018-03-28	AAT	Stock	32.91	34.23	32.91	34.09	431500.0
2018-03-28	AAU-DELISTED	Stock	0.8198	0.83	0.8	0.8041	178207.0
2018-03-28	AAUAF-DELISTED	Stock	0.8198	0.83	0.8	0.8041	183571.0
2018-03-28	AAV-DELISTED	Stock	3.05	3.05	2.81	2.9	187100.0
2018-03-28	AAWW-DELISTED	Stock	59.15	59.5	58.35	59.25	116686.0
2018-03-28	AAXJ	Stock	76.44	76.5	75.62	76.16	567971.0
2018-03-28	AAXN-DELISTED	Stock	38.78	38.8	37.62	37.91	462834.0
2018-03-28	AB	Stock	26.25	26.4	25.81	26.35	340800.0
2018-03-28	ABAC-DELISTED	Stock	2.44	2.64	2.3101	2.36	79538.0
2018-03-28	ABAX-DELISTED	Stock	69.85	71.0	67.96	68.61	139071.0
2018-03-28	ABB-DELISTED	Stock	23.34	23.7	23.19	23.57	2895667.0
2018-03-28	ABBNY-DELISTED	Stock	23.34	23.7	23.19	23.56	3043649.0
2018-03-28	ABBV	Stock	92.19	96.85	91.58	94.27	11154200.0
2018-03-28	ABC-DELISTED	Stock	84.45	85.75	84.1268	85.12	1599071.0
2018-03-28	ABCB	Stock	52.45	52.95	51.78	52.45	259700.0
2018-03-28	ABCD-DELISTED	Stock	9.84	10.08	9.11	10.0199	201471.0
2018-03-28	ABDC-DELISTED	Stock	6.98	7.1	6.66	7.03	355453.0
2018-03-28	ABE-DELISTED	Stock	14.53	14.65	14.46	14.53	8417.0
2018-03-28	ABEO	Stock	345.0	352.5	323.5	341.25	49992.0
2018-03-28	ABEOW-DELISTED	Stock	8.3153	8.3153	8.3153	8.3153	150.0
2018-03-28	ABEV	Stock	7.1	7.13	7.03	7.11	21590600.0
2018-03-28	ABG	Stock	64.65	67.1	64.43	65.55	189000.0
2018-03-28	ABIL-DELISTED	Stock	3.75	3.895	3.24	3.39	49928.0
2018-03-28	ABLX-DELISTED	Stock	54.22	54.32	53.9	53.9	23255.0
2018-03-28	ABM	Stock	32.73	33.52	32.73	33.23	784000.0

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

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