PREVIEW / stock_daily / 2017-06-01

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-01.parquet
  size:    215 KB
  rows:    6,482
  symbols: 3,018

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
2017-06-01	AAPL	Stock	38.2925	38.3325	38.055	38.295	65616400.0
2017-06-01	MSFT	Stock	70.24	70.61	69.45	70.1	21603600.0
2017-06-01	NVDA	Stock	3.6248	3.6258	3.563	3.609	503340000.0
2017-06-01	AMZN	Stock	49.9295	49.9495	49.5685	49.7975	49096000.0
2017-06-01	GOOGL	Stock	49.548	49.657	49.0645	49.4145	26127680.0
2017-06-01	META	Stock	151.75	152.29	150.3	151.53	14530600.0
2017-06-01	TSLA	Stock	22.9333	22.992	22.486	22.6913	114120000.0
2017-06-01	TLT	Stock	123.7	124.19	123.66	124.15	9037271.0
2017-06-01	ES	Stock	62.1	62.35	61.81	62.35	1278600.0
2017-06-01	CL	Stock	76.5	76.69	76.05	76.69	2638400.0
2017-06-01	A	Stock	60.01	60.77	59.81	60.73	2100400.0
2017-06-01	AA	Stock	32.84	33.45	32.45	32.94	2372200.0
2017-06-01	AAAP-DELISTED	Stock	37.63	38.25	37.08	37.47	158078.0
2017-06-01	AABA-DELISTED	Stock	50.49	50.7	50.07	50.65	7233483.0
2017-06-01	AAC-DELISTED	Stock	6.24	6.67	6.07	6.46	191676.0
2017-06-01	AACG	Stock	3.62	3.71	3.61	3.67	5300.0
2017-06-01	AAIC-DELISTED	Stock	14.37	14.44	14.23	14.4	426329.0
2017-06-01	AAL	Stock	48.5	49.36	48.3	49.05	4421400.0
2017-06-01	AAM.A-DELISTED	Stock	25.49	25.64	25.49	25.57	77310.0
2017-06-01	AAMC-DELISTED	Stock	27.0588	27.6148	26.9853	26.9853	10122.0
2017-06-01	AAME	Stock	3.8	3.8	3.65	3.65	4700.0
2017-06-01	AAMI	Stock	14.01	14.15	13.93	14.14	678500.0
2017-06-01	AAOI	Stock	70.05	71.36	69.44	70.01	1857300.0
2017-06-01	AAON	Stock	24.1667	24.5333	24.0333	24.5	144750.0
2017-06-01	AAP	Stock	134.1	137.1	133.75	137.1	1313300.0
2017-06-01	AAT	Stock	38.99	39.67	38.87	39.65	254100.0
2017-06-01	AAU-DELISTED	Stock	1.29	1.34	1.29	1.33	140659.0
2017-06-01	AAUAF-DELISTED	Stock	1.29	1.34	1.29	1.33	141588.0
2017-06-01	AAV-DELISTED	Stock	6.25	6.3885	6.25	6.35	31501.0
2017-06-01	AAWW-DELISTED	Stock	48.75	50.45	48.65	50.45	219881.0
2017-06-01	AAXJ	Stock	67.05	67.39	66.94	67.38	1127376.0
2017-06-01	AAXN-DELISTED	Stock	24.1	24.5	23.9953	24.46	652012.0
2017-06-01	AB	Stock	22.55	23.1	22.45	23.0	949200.0
2017-06-01	ABAC-DELISTED	Stock	2.0189	2.0189	1.8391	1.96	16021.0
2017-06-01	ABAX-DELISTED	Stock	48.48	49.85	48.48	49.37	102798.0
2017-06-01	ABB-DELISTED	Stock	25.14	25.25	25.12	25.23	1039375.0
2017-06-01	ABBNY-DELISTED	Stock	25.14	25.25	25.12	25.23	1076177.0
2017-06-01	ABBV	Stock	66.26	66.72	66.12	66.71	4554700.0
2017-06-01	ABC-DELISTED	Stock	91.71	93.3	91.44	93.13	1139335.0
2017-06-01	ABCB	Stock	43.7	44.1	43.0	44.05	142600.0
2017-06-01	ABCD-DELISTED	Stock	4.95	5.02	4.84	5.0	15478.0
2017-06-01	ABCO-DELISTED	Stock	51.8	52.5	51.35	52.35	527123.0
2017-06-01	ABDC-DELISTED	Stock	13.2	13.34	13.15	13.27	52893.0
2017-06-01	ABE-DELISTED	Stock	13.7	13.84	13.68	13.84	23750.0
2017-06-01	ABEO	Stock	131.25	141.25	128.75	137.5	9644.0
2017-06-01	ABEOW-DELISTED	Stock	3.0	3.014	2.804	2.804	385.0
2017-06-01	ABEV	Stock	5.77	5.77	5.66	5.66	68462700.0
2017-06-01	ABG	Stock	56.2	58.55	55.85	57.6	325200.0
2017-06-01	ABIL-DELISTED	Stock	0.5931	0.63	0.57	0.5902	29546.0
2017-06-01	ABM	Stock	43.13	43.84	42.82	43.83	251300.0

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

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