PREVIEW / stock_daily / 2018-04-25

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-25.parquet
  size:    215 KB
  rows:    6,470
  symbols: 2,820

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-25	AAPL	Stock	40.655	41.355	40.6025	40.9125	113528400.0
2018-04-25	MSFT	Stock	93.3	93.3	90.28	92.31	33729300.0
2018-04-25	NVDA	Stock	5.5	5.5395	5.2575	5.4165	588492000.0
2018-04-25	AMZN	Stock	72.9	73.4995	70.751	73.0085	131746000.0
2018-04-25	GOOGL	Stock	51.4875	51.8035	50.8505	51.1495	57860940.0
2018-04-25	META	Stock	160.14	161.06	156.19	159.69	41083600.0
2018-04-25	TSLA	Stock	18.9	19.0107	18.4833	18.7127	60204000.0
2018-04-25	TLT	Stock	117.41	117.65	116.94	117.16	6603780.0
2018-04-25	ES	Stock	59.23	59.6	58.75	59.37	1718700.0
2018-04-25	CL	Stock	66.4	67.06	66.24	66.41	4209700.0
2018-04-25	A	Stock	66.69	67.08	64.91	65.8	4451600.0
2018-04-25	AA	Stock	50.59	52.43	49.97	51.95	4760700.0
2018-04-25	AABA-DELISTED	Stock	68.85	68.85	67.09	68.26	3504495.0
2018-04-25	AAC-DELISTED	Stock	10.82	11.2	10.75	11.01	76073.0
2018-04-25	AACG	Stock	5.18	5.18	5.18	5.18	100.0
2018-04-25	AAIC-DELISTED	Stock	11.15	11.165	11.075	11.15	343134.0
2018-04-25	AAL	Stock	45.67	45.93	43.89	45.25	7847600.0
2018-04-25	AAM.A-DELISTED	Stock	24.2	24.25	23.9842	24.2	38409.0
2018-04-25	AAM.B-DELISTED	Stock	24.16	24.16	23.87	24.15	84124.0
2018-04-25	AAMC-DELISTED	Stock	16.4853	17.9412	16.2647	17.9412	19968.0
2018-04-25	AAME	Stock	3.11	3.25	3.11	3.18	1000.0
2018-04-25	AAMI	Stock	14.85	15.06	14.72	14.91	279900.0
2018-04-25	AAOI	Stock	32.8	33.13	31.67	32.62	815700.0
2018-04-25	AAON	Stock	23.4667	23.8667	23.4	23.8333	255600.0
2018-04-25	AAP	Stock	106.82	109.31	106.44	107.82	1031300.0
2018-04-25	AAT	Stock	32.73	32.88	32.31	32.77	160800.0
2018-04-25	AAU-DELISTED	Stock	0.84	0.84	0.8037	0.8192	100772.0
2018-04-25	AAUAF-DELISTED	Stock	0.84	0.84	0.8037	0.82	109112.0
2018-04-25	AAV-DELISTED	Stock	3.2	3.35	3.2	3.25	140363.0
2018-04-25	AAWW-DELISTED	Stock	63.3	63.9	62.7	63.8	106310.0
2018-04-25	AAXJ	Stock	75.21	75.29	74.68	75.1	389891.0
2018-04-25	AAXN-DELISTED	Stock	42.64	43.07	42.1124	43.0	511879.0
2018-04-25	AB	Stock	26.3	26.65	25.95	26.1	334300.0
2018-04-25	ABAC-DELISTED	Stock	2.35	2.35	2.35	2.35	100.0
2018-04-25	ABAX-DELISTED	Stock	72.22	72.22	69.665	70.81	116769.0
2018-04-25	ABB-DELISTED	Stock	23.33	23.41	23.165	23.32	3453100.0
2018-04-25	ABBNY-DELISTED	Stock	23.33	23.41	23.165	23.33	11426141.0
2018-04-25	ABBV	Stock	90.96	92.28	90.52	91.87	5487800.0
2018-04-25	ABC-DELISTED	Stock	89.92	91.46	89.3	91.43	616270.0
2018-04-25	ABCB	Stock	52.5	53.1	52.05	52.65	233600.0
2018-04-25	ABCD-DELISTED	Stock	10.07	10.76	10.0601	10.46	294207.0
2018-04-25	ABDC-DELISTED	Stock	6.5	6.56	5.9	6.0	255949.0
2018-04-25	ABE-DELISTED	Stock	14.7	14.7001	14.63	14.66	3160.0
2018-04-25	ABEO	Stock	463.75	469.0	426.25	432.5	51168.0
2018-04-25	ABEOW-DELISTED	Stock	12.75	12.75	12.53	12.53	1000.0
2018-04-25	ABEV	Stock	6.61	6.63	6.54	6.61	17835100.0
2018-04-25	ABG	Stock	70.35	71.35	69.95	70.4	245300.0
2018-04-25	ABIL-DELISTED	Stock	2.68	2.96	2.5336	2.8895	51145.0
2018-04-25	ABLX-DELISTED	Stock	54.46	54.58	54.4	54.44	25892.0
2018-04-25	ABM	Stock	31.93	32.17	31.71	32.07	495100.0

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

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