PREVIEW / stock_daily / 2018-07-18

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-18.parquet
  size:    218 KB
  rows:    6,517
  symbols: 2,786

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-07-18	AAPL	Stock	47.945	47.95	47.4825	47.6	65573600.0
2018-07-18	MSFT	Stock	105.94	106.05	104.72	105.12	29493900.0
2018-07-18	NVDA	Stock	6.3348	6.3488	6.241	6.2925	277640000.0
2018-07-18	AMZN	Stock	92.4	92.944	91.5635	92.146	97238000.0
2018-07-18	GOOGL	Stock	60.4265	61.0795	60.228	60.6455	38947940.0
2018-07-18	META	Stock	209.82	210.99	208.44	209.36	15334900.0
2018-07-18	TSLA	Stock	21.6667	21.7	21.0833	21.59	84363000.0
2018-07-18	TLT	Stock	122.02	122.04	121.39	121.49	6329961.0
2018-07-18	ES	Stock	58.96	58.98	58.42	58.52	1478100.0
2018-07-18	CL	Stock	65.11	65.53	64.36	64.81	3713500.0
2018-07-18	A	Stock	63.03	63.23	62.75	62.99	1202300.0
2018-07-18	AA	Stock	47.98	48.75	47.32	47.96	3937700.0
2018-07-18	AABA-DELISTED	Stock	75.44	75.57	74.4711	74.6727	3112162.0
2018-07-18	AAC-DELISTED	Stock	9.62	9.83	9.55	9.58	99109.0
2018-07-18	AACG	Stock	4.63	4.65	4.63	4.65	300.0
2018-07-18	AAIC-DELISTED	Stock	10.15	10.29	10.15	10.26	335711.0
2018-07-18	AAL	Stock	38.0	39.2	38.0	38.37	10297400.0
2018-07-18	AAM.A-DELISTED	Stock	25.59	25.59	25.44	25.5878	23734.0
2018-07-18	AAM.B-DELISTED	Stock	24.96	25.03	24.84	25.03	44086.0
2018-07-18	AAMC-DELISTED	Stock	18.7794	18.7794	18.7794	18.7794	510.0
2018-07-18	AAME	Stock	2.55	2.7	2.45	2.65	8300.0
2018-07-18	AAMI	Stock	13.82	14.04	13.82	13.99	928400.0
2018-07-18	AAOI	Stock	46.99	47.09	42.88	43.0	3865300.0
2018-07-18	AAON	Stock	23.8	24.2667	23.7	24.2333	156000.0
2018-07-18	AAP	Stock	140.19	140.84	139.09	139.97	685800.0
2018-07-18	AAT	Stock	37.4	37.65	36.97	37.3	187300.0
2018-07-18	AAU-DELISTED	Stock	0.6923	0.6964	0.68	0.6853	135837.0
2018-07-18	AAUAF-DELISTED	Stock	0.6923	0.6964	0.68	0.6853	147193.0
2018-07-18	AAV-DELISTED	Stock	3.15	3.2	3.05	3.2	97804.0
2018-07-18	AAWW-DELISTED	Stock	69.65	70.6	69.5	70.5	149543.0
2018-07-18	AAXJ	Stock	71.46	71.87	71.32	71.84	317111.0
2018-07-18	AAXN-DELISTED	Stock	70.9	72.06	69.31	71.55	568859.0
2018-07-18	AB	Stock	29.45	30.1	29.45	29.9	188800.0
2018-07-18	ABAC-DELISTED	Stock	2.31	2.37	2.1507	2.33	11526.0
2018-07-18	ABAX-DELISTED	Stock	83.25	83.33	83.22	83.29	53405.0
2018-07-18	ABB-DELISTED	Stock	21.94	22.065	21.91	22.0	1785370.0
2018-07-18	ABBNY-DELISTED	Stock	21.94	22.065	21.91	22.0	1836596.0
2018-07-18	ABBV	Stock	95.27	95.43	94.33	94.4	5521900.0
2018-07-18	ABC-DELISTED	Stock	86.85	87.54	86.08	86.34	675333.0
2018-07-18	ABCB	Stock	50.95	51.7	50.75	51.6	653000.0
2018-07-18	ABCD-DELISTED	Stock	11.85	11.98	11.57	11.89	89844.0
2018-07-18	ABDC-DELISTED	Stock	6.3	6.3	6.18	6.27	52918.0
2018-07-18	ABEO	Stock	355.0	360.0	348.75	348.75	15288.0
2018-07-18	ABEOW-DELISTED	Stock	9.5	9.5	9.15	9.406	723.0
2018-07-18	ABEV	Stock	4.96	4.98	4.84	4.86	38216000.0
2018-07-18	ABG	Stock	67.0	69.85	66.5	69.8	304800.0
2018-07-18	ABIL-DELISTED	Stock	5.28	5.739	5.09	5.37	128113.0
2018-07-18	ABM	Stock	29.29	29.69	29.09	29.63	399000.0
2018-07-18	ABMD-DELISTED	Stock	430.19	432.695	426.77	431.61	504423.0
2018-07-18	ABR	Stock	11.6	11.62	11.18	11.22	3755600.0

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

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