PREVIEW / stock_daily / 2017-12-27

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-27.parquet
  size:    216 KB
  rows:    6,500
  symbols: 2,889

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-12-27	AAPL	Stock	42.525	42.695	42.4275	42.65	85992800.0
2017-12-27	MSFT	Stock	85.65	85.98	85.22	85.71	14678000.0
2017-12-27	NVDA	Stock	4.9225	4.9992	4.9078	4.9292	329488000.0
2017-12-27	AMZN	Stock	58.9955	59.3645	58.7805	59.113	37344000.0
2017-12-27	GOOGL	Stock	53.33	53.4135	52.919	53.01	22324060.0
2017-12-27	META	Stock	176.55	178.44	176.26	177.62	9496100.0
2017-12-27	TSLA	Stock	21.0667	21.1787	20.7167	20.776	70681500.0
2017-12-27	TLT	Stock	125.71	126.9805	125.7	126.77	9059659.0
2017-12-27	ES	Stock	62.32	62.69	62.14	62.53	1139000.0
2017-12-27	CL	Stock	75.58	75.7	75.26	75.37	1227600.0
2017-12-27	A	Stock	67.21	67.46	67.15	67.3	1038600.0
2017-12-27	AA	Stock	50.55	51.93	50.2	51.84	2977800.0
2017-12-27	AAAP-DELISTED	Stock	81.6	81.63	81.59	81.615	449691.0
2017-12-27	AABA-DELISTED	Stock	69.77	70.49	69.69	70.065	5496916.0
2017-12-27	AAC-DELISTED	Stock	9.02	9.16	8.67	9.04	137477.0
2017-12-27	AACG	Stock	5.08	5.24	5.08	5.12	3300.0
2017-12-27	AAIC-DELISTED	Stock	12.55	12.55	12.32	12.49	846243.0
2017-12-27	AAL	Stock	52.8	52.88	52.06	52.4	2831400.0
2017-12-27	AAM.A-DELISTED	Stock	26.3	26.33	26.2272	26.29	6257.0
2017-12-27	AAMC-DELISTED	Stock	21.7647	21.7647	21.7647	21.7647	15490.0
2017-12-27	AAME	Stock	3.55	3.55	3.35	3.35	3400.0
2017-12-27	AAMI	Stock	16.86	16.91	16.74	16.78	192200.0
2017-12-27	AAOI	Stock	38.65	39.75	38.41	38.66	902800.0
2017-12-27	AAON	Stock	24.4333	24.5333	24.3	24.3333	179100.0
2017-12-27	AAP	Stock	101.72	101.72	99.4	99.77	988500.0
2017-12-27	AAT	Stock	38.01	38.15	37.82	37.91	126400.0
2017-12-27	AAU-DELISTED	Stock	1.02	1.05	1.011	1.04	132889.0
2017-12-27	AAUAF-DELISTED	Stock	1.02	1.05	1.011	1.04	144457.0
2017-12-27	AAV-DELISTED	Stock	4.15	4.245	4.075	4.15	199672.0
2017-12-27	AAWW-DELISTED	Stock	59.95	60.1	59.05	59.3	68984.0
2017-12-27	AAXJ	Stock	75.39	75.52	75.23	75.37	519677.0
2017-12-27	AAXN-DELISTED	Stock	26.55	26.74	26.42	26.69	168505.0
2017-12-27	AB	Stock	25.45	25.45	25.18	25.3	177200.0
2017-12-27	ABAC-DELISTED	Stock	3.01	3.13	2.9517	3.07	7303.0
2017-12-27	ABAX-DELISTED	Stock	49.64	49.724	48.8	49.04	115020.0
2017-12-27	ABB-DELISTED	Stock	26.65	26.76	26.58	26.74	750115.0
2017-12-27	ABBNY-DELISTED	Stock	26.65	26.76	26.58	26.74	899939.0
2017-12-27	ABBV	Stock	97.73	98.23	97.44	98.09	1927300.0
2017-12-27	ABC-DELISTED	Stock	93.18	93.2	92.001	92.6	615008.0
2017-12-27	ABCB	Stock	48.6	48.85	48.1	48.45	148800.0
2017-12-27	ABCD-DELISTED	Stock	5.65	5.6799	5.6	5.62	32873.0
2017-12-27	ABDC-DELISTED	Stock	9.0	9.01	8.7001	8.78	183943.0
2017-12-27	ABE-DELISTED	Stock	14.545	14.6311	14.4705	14.63	4029.0
2017-12-27	ABEO	Stock	401.25	405.0	393.75	402.5	17744.0
2017-12-27	ABEV	Stock	6.41	6.45	6.36	6.37	11149900.0
2017-12-27	ABG	Stock	64.3	64.85	64.15	64.65	497900.0
2017-12-27	ABIL-DELISTED	Stock	0.41	0.4725	0.401	0.4496	68400.0
2017-12-27	ABLX-DELISTED	Stock	24.19	24.27	24.0	24.22	220437.0
2017-12-27	ABM	Stock	38.19	38.5	38.04	38.21	534600.0
2017-12-27	ABMD-DELISTED	Stock	189.96	191.62	188.5501	190.41	192796.0

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

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