PREVIEW / stock_daily / 2018-07-06

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-06.parquet
  size:    217 KB
  rows:    6,494
  symbols: 2,764

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-06	AAPL	Stock	46.355	47.1075	46.3	46.9925	69940800.0
2018-07-06	MSFT	Stock	99.89	101.43	99.67	101.16	19234600.0
2018-07-06	NVDA	Stock	6.0435	6.1918	6.022	6.1833	296352000.0
2018-07-06	AMZN	Stock	84.8	85.7635	84.5835	85.5315	53006000.0
2018-07-06	GOOGL	Stock	57.0885	57.81	56.862	57.754	21819340.0
2018-07-06	META	Stock	198.45	203.64	197.7	203.23	19740100.0
2018-07-06	TSLA	Stock	20.33	20.8047	20.1333	20.5933	132982500.0
2018-07-06	TLT	Stock	122.75	122.92	122.48	122.75	4679906.0
2018-07-06	ES	Stock	59.76	60.44	59.72	60.31	1555600.0
2018-07-06	CL	Stock	65.98	66.25	65.62	65.78	3310800.0
2018-07-06	A	Stock	61.92	62.4	61.65	62.29	2269700.0
2018-07-06	AA	Stock	46.49	47.245	46.02	47.14	2184800.0
2018-07-06	AABA-DELISTED	Stock	73.31	75.55	72.869	75.41	9653301.0
2018-07-06	AAC-DELISTED	Stock	9.81	9.81	9.36	9.48	90053.0
2018-07-06	AACG	Stock	4.35	4.4	4.06	4.08	5600.0
2018-07-06	AAIC-DELISTED	Stock	10.37	10.55	10.37	10.46	619720.0
2018-07-06	AAL	Stock	38.19	38.39	37.76	38.09	3695000.0
2018-07-06	AAM.A-DELISTED	Stock	25.72	25.93	25.67	25.86	26537.0
2018-07-06	AAM.B-DELISTED	Stock	25.05	25.2	25.0105	25.07	101975.0
2018-07-06	AAMC-DELISTED	Stock	19.6176	19.6324	19.6103	19.6324	3216.0
2018-07-06	AAME	Stock	2.6	2.66	2.45	2.45	6800.0
2018-07-06	AAMI	Stock	14.59	14.62	14.45	14.51	321100.0
2018-07-06	AAOI	Stock	45.58	46.51	45.21	46.02	727500.0
2018-07-06	AAON	Stock	23.5333	23.7667	23.4	23.5333	248400.0
2018-07-06	AAP	Stock	137.22	138.0	136.02	137.17	889500.0
2018-07-06	AAT	Stock	38.98	39.25	38.81	38.94	211500.0
2018-07-06	AAU-DELISTED	Stock	0.71	0.726	0.71	0.726	71107.0
2018-07-06	AAUAF-DELISTED	Stock	0.71	0.726	0.71	0.726	73052.0
2018-07-06	AAV-DELISTED	Stock	3.1	3.175	3.1	3.125	26895.0
2018-07-06	AAWW-DELISTED	Stock	71.8	71.8	70.75	71.45	74046.0
2018-07-06	AAXJ	Stock	70.4	71.4	70.39	71.1	640367.0
2018-07-06	AAXN-DELISTED	Stock	64.82	66.03	64.04	65.95	417227.0
2018-07-06	AB	Stock	28.9	29.2	28.65	29.1	192600.0
2018-07-06	ABAC-DELISTED	Stock	2.57	2.7862	2.57	2.69	2451.0
2018-07-06	ABAX-DELISTED	Stock	83.16	83.35	82.99	83.23	298097.0
2018-07-06	ABB-DELISTED	Stock	21.25	21.665	21.23	21.555	2349727.0
2018-07-06	ABBNY-DELISTED	Stock	21.25	21.665	21.23	21.55	2430678.0
2018-07-06	ABBV	Stock	95.2	97.07	94.96	96.92	5867400.0
2018-07-06	ABC-DELISTED	Stock	87.61	88.14	86.83	87.98	840108.0
2018-07-06	ABCB	Stock	53.15	53.5	52.5	53.3	280900.0
2018-07-06	ABCD-DELISTED	Stock	12.02	12.29	11.97	12.04	94780.0
2018-07-06	ABDC-DELISTED	Stock	6.5	6.56	6.47	6.51	33189.0
2018-07-06	ABEO	Stock	403.75	411.25	393.75	398.75	26408.0
2018-07-06	ABEV	Stock	4.63	4.71	4.6	4.65	29409200.0
2018-07-06	ABG	Stock	70.5	70.75	69.9	70.45	181500.0
2018-07-06	ABIL-DELISTED	Stock	7.92	9.23	7.02	7.5	448020.0
2018-07-06	ABM	Stock	30.02	30.31	29.86	30.07	553700.0
2018-07-06	ABMD-DELISTED	Stock	400.72	409.51	399.0	405.99	487862.0
2018-07-06	ABR	Stock	10.68	10.93	10.68	10.85	2900800.0
2018-07-06	ABR.A-DELISTED	Stock	25.9196	25.9196	25.9196	25.9196	1000.0

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

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