PREVIEW / stock_daily / 2018-06-27

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-27.parquet
  size:    218 KB
  rows:    6,502
  symbols: 2,784

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-06-27	AAPL	Stock	46.3075	46.82	46.0075	46.04	101141200.0
2018-06-27	MSFT	Stock	99.58	100.02	97.4	97.54	31298400.0
2018-06-27	NVDA	Stock	6.0938	6.1608	5.8875	5.893	453892000.0
2018-06-27	AMZN	Stock	85.4055	85.5975	83.0	83.0255	97444000.0
2018-06-27	GOOGL	Stock	56.8	57.3105	55.835	55.847	34537320.0
2018-06-27	META	Stock	199.18	200.75	195.8	195.84	18734400.0
2018-06-27	TSLA	Stock	23.0	23.386	22.6333	22.9667	125005500.0
2018-06-27	TLT	Stock	121.75	122.18	121.55	122.11	8173837.0
2018-06-27	ES	Stock	57.85	58.13	57.26	57.99	1556300.0
2018-06-27	CL	Stock	65.15	65.67	64.64	64.71	4228800.0
2018-06-27	A	Stock	62.26	63.0	61.1	61.14	2025800.0
2018-06-27	AA	Stock	45.68	47.05	45.47	45.74	2468600.0
2018-06-27	AABA-DELISTED	Stock	76.04	76.22	73.11	73.14	10796593.0
2018-06-27	AAC-DELISTED	Stock	9.86	9.94	9.19	9.26	199668.0
2018-06-27	AACG	Stock	5.15	5.18	4.97	5.12	3700.0
2018-06-27	AAIC-DELISTED	Stock	10.95	10.96	10.615	10.66	832501.0
2018-06-27	AAL	Stock	39.09	39.18	38.25	38.26	7391600.0
2018-06-27	AAM.A-DELISTED	Stock	25.2764	25.3074	25.16	25.26	30104.0
2018-06-27	AAM.B-DELISTED	Stock	24.71	24.79	24.6466	24.79	66891.0
2018-06-27	AAMC-DELISTED	Stock	20.4707	20.5	19.8529	20.3529	24565.0
2018-06-27	AAME	Stock	2.63	2.7	2.5	2.5	5400.0
2018-06-27	AAMI	Stock	14.58	14.63	14.425	14.48	551400.0
2018-06-27	AAOI	Stock	42.71	44.75	41.08	41.26	1054600.0
2018-06-27	AAON	Stock	22.1	22.3	21.9	22.0	231000.0
2018-06-27	AAP	Stock	137.12	137.69	134.01	134.38	1124400.0
2018-06-27	AAT	Stock	38.49	38.52	38.24	38.25	163300.0
2018-06-27	AAU-DELISTED	Stock	0.73	0.7464	0.7201	0.7279	50111.0
2018-06-27	AAUAF-DELISTED	Stock	0.73	0.7464	0.7201	0.7279	51858.0
2018-06-27	AAV-DELISTED	Stock	3.15	3.3	3.15	3.225	275623.0
2018-06-27	AAWW-DELISTED	Stock	70.15	71.1	68.95	69.0	136103.0
2018-06-27	AAXJ	Stock	71.67	71.67	70.29	70.39	1031068.0
2018-06-27	AAXN-DELISTED	Stock	63.17	63.97	62.0	62.01	561619.0
2018-06-27	AB	Stock	28.5	28.75	28.3	28.4	318000.0
2018-06-27	ABAC-DELISTED	Stock	2.5125	3.35	2.35	2.7599	656865.0
2018-06-27	ABAX-DELISTED	Stock	83.13	83.18	83.0	83.005	139812.0
2018-06-27	ABB-DELISTED	Stock	21.76	21.9	21.455	21.485	2272332.0
2018-06-27	ABBNY-DELISTED	Stock	21.76	21.9	21.455	21.48	2353070.0
2018-06-27	ABBV	Stock	92.36	93.27	91.47	91.51	5833000.0
2018-06-27	ABC-DELISTED	Stock	90.48	91.53	89.52	89.83	661205.0
2018-06-27	ABCB	Stock	55.15	55.3	54.05	54.05	127400.0
2018-06-27	ABCD-DELISTED	Stock	10.85	10.93	10.65	10.7	167620.0
2018-06-27	ABDC-DELISTED	Stock	6.6	6.6	6.51	6.52	47849.0
2018-06-27	ABEO	Stock	412.5	431.25	392.5	393.75	29940.0
2018-06-27	ABEV	Stock	4.7	4.77	4.61	4.63	55988500.0
2018-06-27	ABG	Stock	72.45	72.45	70.8	70.8	144000.0
2018-06-27	ABIL-DELISTED	Stock	10.49	11.44	7.61	8.23	1331903.0
2018-06-27	ABM	Stock	30.18	30.35	29.67	29.67	465100.0
2018-06-27	ABMD-DELISTED	Stock	429.2	432.618	409.58	410.55	448557.0
2018-06-27	ABR	Stock	10.15	10.16	10.04	10.07	745200.0
2018-06-27	ABR.A-DELISTED	Stock	25.98	25.98	25.9	25.9	600.0

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

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