PREVIEW / stock_daily / 2015-07-15

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-15.parquet
  size:    224 KB
  rows:    6,674
  symbols: 3,484

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
2015-07-15	AAPL	Stock	31.43	31.7875	31.395	31.705	134596800.0
2015-07-15	MSFT	Stock	45.68	45.89	45.43	45.76	26629600.0
2015-07-15	NVDA	Stock	0.496	0.4992	0.4892	0.4938	265732000.0
2015-07-15	AMZN	Stock	23.152	23.235	23.01	23.0595	59748000.0
2015-07-15	GOOGL	Stock	29.187	29.4345	29.0105	29.198	41466600.0
2015-07-15	META	Stock	90.0	90.99	89.42	89.76	30886600.0
2015-07-15	TSLA	Stock	17.7827	17.8327	17.472	17.5427	30324000.0
2015-07-15	TLT	Stock	116.11	117.55	116.04	117.3	8720406.0
2015-07-15	ES	Stock	47.3	47.86	47.07	47.72	1946800.0
2015-07-15	CL	Stock	67.04	67.58	66.76	66.91	3360300.0
2015-07-15	A	Stock	40.42	40.52	40.02	40.13	2247700.0
2015-07-15	AA.B-DELISTED	Stock	39.16	39.16	38.49	38.51	119370.0
2015-07-15	AABA-DELISTED	Stock	38.51	38.8	38.15	38.37	8424548.0
2015-07-15	AAC-DELISTED	Stock	43.37	43.95	42.72	42.75	165896.0
2015-07-15	AACG	Stock	4.38	4.65	4.11	4.16	17300.0
2015-07-15	AAIC-DELISTED	Stock	20.22	20.295	19.98	20.07	218724.0
2015-07-15	AAL	Stock	41.39	42.22	40.39	41.54	17922800.0
2015-07-15	AAMC-DELISTED	Stock	43.5471	45.4235	41.9059	43.25	29611.0
2015-07-15	AAME	Stock	3.7	3.7	3.65	3.7	5100.0
2015-07-15	AAMI	Stock	17.6	17.775	17.6	17.7	112100.0
2015-07-15	AAOI	Stock	19.7	19.85	19.29	19.53	251800.0
2015-07-15	AAON	Stock	15.26	15.4333	14.9533	15.0133	125400.0
2015-07-15	AAP	Stock	167.21	169.13	166.46	168.47	644700.0
2015-07-15	AAT	Stock	40.91	41.16	40.27	40.83	97100.0
2015-07-15	AAU-DELISTED	Stock	0.7624	0.7808	0.75	0.7576	151124.0
2015-07-15	AAUAF-DELISTED	Stock	0.7618	0.7802	0.75	0.757	153915.0
2015-07-15	AAV-DELISTED	Stock	6.21	6.26	6.0	6.08	101785.0
2015-07-15	AAVL-DELISTED	Stock	16.94	17.01	16.4	16.46	552022.0
2015-07-15	AAWW-DELISTED	Stock	53.47	53.54	51.0	52.02	611920.0
2015-07-15	AAXJ	Stock	61.0	61.12	60.66	60.72	702532.0
2015-07-15	AAXN-DELISTED	Stock	32.64	33.06	32.06	32.955	1714372.0
2015-07-15	AB	Stock	28.2	28.25	27.19	27.63	1120000.0
2015-07-15	ABAC-DELISTED	Stock	1.054	1.17	1.01	1.05	15168.0
2015-07-15	ABAX-DELISTED	Stock	53.91	54.49	53.78	54.0	76431.0
2015-07-15	ABB-DELISTED	Stock	20.48	20.581	20.42	20.51	1347515.0
2015-07-15	ABBNY-DELISTED	Stock	20.48	20.581	20.42	20.52	1500165.0
2015-07-15	ABBV	Stock	69.81	70.04	69.31	69.75	16761400.0
2015-07-15	ABC-DELISTED	Stock	110.67	110.93	109.496	110.55	820666.0
2015-07-15	ABCB	Stock	25.97	26.24	25.6	26.07	112700.0
2015-07-15	ABCD-DELISTED	Stock	4.98	5.11	4.83	4.84	205851.0
2015-07-15	ABCO-DELISTED	Stock	58.11	58.9	57.64	58.65	753492.0
2015-07-15	ABCW-DELISTED	Stock	41.35	41.5	40.79	41.235	15987.0
2015-07-15	ABDC-DELISTED	Stock	12.73	12.99	12.53	12.54	24960.0
2015-07-15	ABE-DELISTED	Stock	13.02	13.06	13.02	13.04	5016.0
2015-07-15	ABEO	Stock	160.25	160.25	149.25	151.0	14008.0
2015-07-15	ABEOW-DELISTED	Stock	2.85	2.85	2.3501	2.4	12434.0
2015-07-15	ABEV	Stock	6.19	6.25	6.17	6.25	14244800.0
2015-07-15	ABG	Stock	93.58	93.92	92.95	93.5	187600.0
2015-07-15	ABGB-DELISTED	Stock	15.95	15.95	15.58	15.78	42266.0
2015-07-15	ABM	Stock	32.7	32.7	32.29	32.42	166900.0

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

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