PREVIEW / stock_daily / 2018-04-19

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-19.parquet
  size:    216 KB
  rows:    6,455
  symbols: 2,818

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-04-19	AAPL	Stock	43.44	43.8475	43.165	43.2	139235200.0
2018-04-19	MSFT	Stock	96.44	97.07	95.34	96.11	23552500.0
2018-04-19	NVDA	Stock	5.7938	5.8275	5.67	5.726	471996000.0
2018-04-19	AMZN	Stock	77.161	78.426	76.953	77.8455	130474000.0
2018-04-19	GOOGL	Stock	53.451	54.8755	53.451	54.4725	39884940.0
2018-04-19	META	Stock	166.2	168.33	165.2	168.1	22235000.0
2018-04-19	TSLA	Stock	19.4053	20.0673	19.2367	20.0053	91359000.0
2018-04-19	TLT	Stock	119.42	119.53	118.81	119.32	9875870.0
2018-04-19	ES	Stock	59.79	59.99	59.27	59.86	1107100.0
2018-04-19	CL	Stock	70.96	70.98	69.44	69.77	5536900.0
2018-04-19	A	Stock	69.48	69.59	67.36	67.97	2435100.0
2018-04-19	AA	Stock	60.54	62.35	59.56	60.23	11779200.0
2018-04-19	AABA-DELISTED	Stock	72.3	72.6	71.49	72.0	7297269.0
2018-04-19	AAC-DELISTED	Stock	11.39	11.43	11.15	11.37	55428.0
2018-04-19	AACG	Stock	5.46	5.46	5.23	5.45	11000.0
2018-04-19	AAIC-DELISTED	Stock	11.27	11.29	11.14	11.18	286673.0
2018-04-19	AAL	Stock	47.53	47.77	46.41	46.88	5759300.0
2018-04-19	AAM.A-DELISTED	Stock	24.5	24.5	24.2	24.4	78799.0
2018-04-19	AAM.B-DELISTED	Stock	24.45	24.455	24.155	24.3	309114.0
2018-04-19	AAME	Stock	3.15	3.15	3.15	3.15	400.0
2018-04-19	AAMI	Stock	15.04	15.18	14.98	15.04	217900.0
2018-04-19	AAOI	Stock	28.31	31.72	28.116	31.64	1787200.0
2018-04-19	AAON	Stock	24.0667	24.2	23.7333	23.9333	183000.0
2018-04-19	AAP	Stock	107.55	108.21	103.49	105.18	1516400.0
2018-04-19	AAT	Stock	33.85	33.91	33.06	33.27	158800.0
2018-04-19	AAU-DELISTED	Stock	0.8548	0.8548	0.825	0.8308	97823.0
2018-04-19	AAUAF-DELISTED	Stock	0.8548	0.8548	0.825	0.8308	104673.0
2018-04-19	AAV-DELISTED	Stock	3.3	3.425	3.2	3.225	698156.0
2018-04-19	AAWW-DELISTED	Stock	63.75	64.65	62.75	63.7	232421.0
2018-04-19	AAXJ	Stock	77.66	77.675	76.92	77.15	1437322.0
2018-04-19	AAXN-DELISTED	Stock	42.7	43.43	42.15	42.99	807045.0
2018-04-19	AB	Stock	26.5	26.65	26.2	26.4	220700.0
2018-04-19	ABAC-DELISTED	Stock	2.5044	2.54	2.5044	2.54	300.0
2018-04-19	ABAX-DELISTED	Stock	73.42	73.99	72.35	73.28	54897.0
2018-04-19	ABB-DELISTED	Stock	24.48	24.55	24.17	24.27	2706604.0
2018-04-19	ABBNY-DELISTED	Stock	24.48	24.55	24.17	24.27	2946831.0
2018-04-19	ABBV	Stock	94.43	94.53	91.4	93.01	4972900.0
2018-04-19	ABC-DELISTED	Stock	92.59	92.59	90.28	91.69	911028.0
2018-04-19	ABCB	Stock	51.7	52.85	51.7	52.7	195800.0
2018-04-19	ABCD-DELISTED	Stock	13.55	13.77	13.25	13.57	770336.0
2018-04-19	ABDC-DELISTED	Stock	6.71	6.74	6.63	6.73	48942.0
2018-04-19	ABE-DELISTED	Stock	15.06	15.0601	15.0	15.0	3400.0
2018-04-19	ABEO	Stock	498.75	520.0	496.25	501.25	47340.0
2018-04-19	ABEV	Stock	6.8	6.89	6.77	6.89	24137100.0
2018-04-19	ABG	Stock	68.5	69.35	67.35	67.5	147800.0
2018-04-19	ABIL-DELISTED	Stock	3.02	3.02	2.9211	2.98	7478.0
2018-04-19	ABLX-DELISTED	Stock	55.15	55.15	54.83	54.87	11536.0
2018-04-19	ABM	Stock	32.43	32.52	32.01	32.23	343100.0
2018-04-19	ABMD-DELISTED	Stock	305.74	307.05	303.5141	306.47	261490.0
2018-04-19	ABR	Stock	8.65	8.67	8.6	8.61	263400.0

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

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