PREVIEW / stock_daily / 2019-07-01

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-01.parquet
  size:    220 KB
  rows:    6,582
  symbols: 2,564

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
2019-07-01	AAPL	Stock	50.7925	51.1225	50.1625	50.3875	109012000.0
2019-07-01	MSFT	Stock	136.63	136.7	134.97	135.68	22613500.0
2019-07-01	NVDA	Stock	4.3142	4.3488	4.1165	4.1542	709756000.0
2019-07-01	AMZN	Stock	96.149	96.491	95.733	96.1095	63842000.0
2019-07-01	GOOGL	Stock	55.052	55.4295	54.7665	55.0	29288980.0
2019-07-01	META	Stock	195.21	195.28	191.93	193.0	14181800.0
2019-07-01	TSLA	Stock	15.3473	15.54	15.0853	15.1447	123201000.0
2019-07-01	TLT	Stock	132.57	132.75	131.591	132.24	14141551.0
2019-07-01	ES	Stock	75.76	75.77	74.77	75.66	1683700.0
2019-07-01	CL	Stock	71.96	72.26	71.59	72.08	3161800.0
2019-07-01	A	Stock	75.6	75.89	74.92	75.78	2753200.0
2019-07-01	AA	Stock	23.67	23.85	22.78	22.92	3419900.0
2019-07-01	AABA-DELISTED	Stock	70.9	71.52	70.325	70.55	8663016.0
2019-07-01	AAC-DELISTED	Stock	0.86	0.91	0.86	0.8823	111240.0
2019-07-01	AACG	Stock	2.55	2.67	2.44	2.64	235200.0
2019-07-01	AAIC-DELISTED	Stock	6.96	6.99	6.8087	6.83	633775.0
2019-07-01	AAIC.C-DELISTED	Stock	21.95	21.95	21.7	21.75	5846.0
2019-07-01	AAL	Stock	33.14	33.66	32.53	32.88	8985600.0
2019-07-01	AAM.A-DELISTED	Stock	25.67	25.75	25.67	25.73	13639.0
2019-07-01	AAM.B-DELISTED	Stock	25.82	25.94	25.7797	25.94	8524.0
2019-07-01	AAMC-DELISTED	Stock	3.5529	4.0588	3.3971	3.5324	14474.0
2019-07-01	AAME	Stock	2.43	2.43	2.4	2.4	500.0
2019-07-01	AAMI	Stock	11.59	11.823	11.59	11.69	398900.0
2019-07-01	AAOI	Stock	10.7	10.89	10.01	10.18	881700.0
2019-07-01	AAON	Stock	33.7133	33.9933	32.3733	33.1533	268200.0
2019-07-01	AAP	Stock	155.71	158.45	155.57	156.59	1151500.0
2019-07-01	AAT	Stock	47.36	47.37	46.31	46.88	620200.0
2019-07-01	AAU-DELISTED	Stock	0.59	0.6411	0.58	0.5977	236847.0
2019-07-01	AAUAF-DELISTED	Stock	0.59	0.6411	0.58	0.5977	250292.0
2019-07-01	AAWW-DELISTED	Stock	45.27	45.985	43.81	44.03	275843.0
2019-07-01	AAXJ	Stock	71.05	71.225	70.48	70.74	830156.0
2019-07-01	AAXN-DELISTED	Stock	65.22	65.9	63.4	64.55	1086037.0
2019-07-01	AB	Stock	30.0	30.15	29.76	29.9	250200.0
2019-07-01	ABB-DELISTED	Stock	20.24	20.27	20.125	20.21	2201178.0
2019-07-01	ABBNY-DELISTED	Stock	20.24	20.27	20.125	20.21	6480559.0
2019-07-01	ABBV	Stock	73.5	73.85	72.28	73.4	18010900.0
2019-07-01	ABC-DELISTED	Stock	85.78	85.91	84.65	85.54	937617.0
2019-07-01	ABCB	Stock	39.1	40.03	37.95	39.8	2584100.0
2019-07-01	ABDC-DELISTED	Stock	8.39	8.5299	8.28	8.28	18083.0
2019-07-01	ABEO	Stock	122.5	123.25	117.75	119.25	35916.0
2019-07-01	ABEOW-DELISTED	Stock	1.0	1.0	0.97	0.97	5531.0
2019-07-01	ABEV	Stock	4.74	4.74	4.6	4.63	28570900.0
2019-07-01	ABG	Stock	85.69	87.16	83.26	84.15	154200.0
2019-07-01	ABIL-DELISTED	Stock	0.93	0.9398	0.91	0.9222	31072.0
2019-07-01	ABM	Stock	40.47	40.56	39.94	40.33	370700.0
2019-07-01	ABMD-DELISTED	Stock	263.09	275.0	262.7443	265.13	559492.0
2019-07-01	ABR	Stock	12.26	12.3	12.11	12.2	1419300.0
2019-07-01	ABR.A-DELISTED	Stock	26.28	26.28	26.0919	26.1101	1500.0
2019-07-01	ABR.B-DELISTED	Stock	25.65	25.75	25.65	25.74	3100.0
2019-07-01	ABR.C-DELISTED	Stock	25.8897	26.05	25.8897	26.0187	1950.0

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

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