PREVIEW / stock_daily / 2018-07-26

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-26.parquet
  size:    219 KB
  rows:    6,540
  symbols: 2,793

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-26	AAPL	Stock	48.6525	48.99	48.4025	48.5525	76304000.0
2018-07-26	MSFT	Stock	110.74	111.0	109.5	109.62	31372100.0
2018-07-26	NVDA	Stock	6.2765	6.4082	6.2595	6.371	325124000.0
2018-07-26	AMZN	Stock	91.95	92.234	90.225	90.4	198488000.0
2018-07-26	GOOGL	Stock	63.359	64.37	63.15	64.275	54686040.0
2018-07-26	META	Stock	174.89	180.13	173.75	176.26	169803700.0
2018-07-26	TSLA	Stock	20.3233	20.7133	20.2427	20.4433	69457500.0
2018-07-26	TLT	Stock	119.71	119.88	119.16	119.26	6821057.0
2018-07-26	ES	Stock	59.7	60.54	59.7	60.36	2278000.0
2018-07-26	CL	Stock	66.02	67.92	66.02	66.94	5836700.0
2018-07-26	A	Stock	66.0	66.83	65.82	66.75	2583500.0
2018-07-26	AA	Stock	42.7	43.46	42.05	42.82	3023700.0
2018-07-26	AABA-DELISTED	Stock	76.15	76.79	75.53	76.16	5484966.0
2018-07-26	AAC-DELISTED	Stock	10.01	10.36	9.82	10.3	91128.0
2018-07-26	AACG	Stock	4.4	4.4	4.3	4.38	9400.0
2018-07-26	AAIC-DELISTED	Stock	10.33	10.4666	10.3	10.39	456097.0
2018-07-26	AAL	Stock	37.85	40.45	37.6	40.02	12832300.0
2018-07-26	AAM.A-DELISTED	Stock	25.41	25.442	25.34	25.37	34911.0
2018-07-26	AAM.B-DELISTED	Stock	25.07	25.07	24.99	25.0269	37762.0
2018-07-26	AAMC-DELISTED	Stock	19.6765	19.6765	18.5809	19.2794	4141.0
2018-07-26	AAME	Stock	2.35	2.4	2.35	2.4	2800.0
2018-07-26	AAMI	Stock	14.08	14.24	14.03	14.08	244900.0
2018-07-26	AAOI	Stock	38.13	40.08	38.1	39.72	765400.0
2018-07-26	AAON	Stock	24.2	24.8	24.1	24.3333	260400.0
2018-07-26	AAP	Stock	141.0	143.81	140.32	141.78	775700.0
2018-07-26	AAT	Stock	37.5	38.02	37.5	37.68	300200.0
2018-07-26	AAU-DELISTED	Stock	0.68	0.69	0.65	0.6633	209712.0
2018-07-26	AAUAF-DELISTED	Stock	0.68	0.69	0.65	0.6633	212224.0
2018-07-26	AAV-DELISTED	Stock	3.5	3.6	3.5	3.55	99301.0
2018-07-26	AAWW-DELISTED	Stock	68.05	68.9	67.6	67.7	173350.0
2018-07-26	AAXJ	Stock	72.84	73.04	72.71	72.88	1164239.0
2018-07-26	AAXN-DELISTED	Stock	72.22	72.99	70.94	72.46	501301.0
2018-07-26	AB	Stock	30.5	30.8	30.2	30.4	324700.0
2018-07-26	ABAC-DELISTED	Stock	2.23	2.23	2.1001	2.14	5151.0
2018-07-26	ABAX-DELISTED	Stock	83.19	83.24	83.1	83.19	44463.0
2018-07-26	ABB-DELISTED	Stock	22.83	22.895	22.77	22.83	2142785.0
2018-07-26	ABBNY-DELISTED	Stock	22.84	22.895	22.77	22.84	2321796.0
2018-07-26	ABBV	Stock	93.95	94.56	92.54	93.94	6812400.0
2018-07-26	ABC-DELISTED	Stock	84.83	85.25	82.98	83.24	1434244.0
2018-07-26	ABCB	Stock	49.95	51.0	49.95	50.85	308600.0
2018-07-26	ABCD-DELISTED	Stock	12.94	12.98	12.4	12.76	183846.0
2018-07-26	ABDC-DELISTED	Stock	6.25	6.27	6.19	6.25	27787.0
2018-07-26	ABEO	Stock	318.75	332.25	316.25	325.0	30772.0
2018-07-26	ABEV	Stock	5.29	5.32	5.19	5.31	56179200.0
2018-07-26	ABG	Stock	68.95	70.3	67.2	68.2	943800.0
2018-07-26	ABIL-DELISTED	Stock	4.4	4.4	3.7	3.8674	77849.0
2018-07-26	ABM	Stock	30.49	31.11	30.32	30.8	781600.0
2018-07-26	ABMD-DELISTED	Stock	414.87	415.0	360.2201	384.1	1434256.0
2018-07-26	ABR	Stock	11.18	11.2	11.11	11.18	634700.0
2018-07-26	ABR.A-DELISTED	Stock	26.05	26.061	26.05	26.05	1190.0

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

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