PREVIEW / stock_daily / 2015-07-09

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-09.parquet
  size:    222 KB
  rows:    6,635
  symbols: 3,468

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-09	AAPL	Stock	30.9625	31.015	29.805	30.0175	314380000.0
2015-07-09	MSFT	Stock	44.75	45.22	44.5	44.52	32424700.0
2015-07-09	NVDA	Stock	0.499	0.5013	0.4822	0.4852	357588000.0
2015-07-09	AMZN	Stock	21.745	21.936	21.7075	21.7195	45428000.0
2015-07-09	GOOGL	Stock	27.4325	27.444	27.231	27.2325	29766480.0
2015-07-09	META	Stock	86.73	87.6	85.65	85.88	23307400.0
2015-07-09	TSLA	Stock	17.272	17.53	17.1193	17.1947	50011500.0
2015-07-09	TLT	Stock	118.7	119.12	117.8456	117.92	11108879.0
2015-07-09	ES	Stock	47.25	47.35	46.24	46.73	2986100.0
2015-07-09	CL	Stock	67.15	67.18	66.15	66.17	3004700.0
2015-07-09	A	Stock	39.27	39.33	38.91	38.92	2237900.0
2015-07-09	AA.B-DELISTED	Stock	39.34	39.98	39.0	39.06	96197.0
2015-07-09	AABA-DELISTED	Stock	38.23	38.68	37.52	37.61	16068534.0
2015-07-09	AAC-DELISTED	Stock	42.15	44.23	41.57	43.59	166719.0
2015-07-09	AACG	Stock	4.68	5.0	4.4	4.57	86800.0
2015-07-09	AAIC-DELISTED	Stock	20.0	20.11	19.805	19.85	286628.0
2015-07-09	AAL	Stock	39.84	40.28	39.66	39.67	8490900.0
2015-07-09	AAMC-DELISTED	Stock	39.1029	39.4559	37.9412	38.5324	30950.0
2015-07-09	AAME	Stock	3.66	3.7	3.65	3.65	2300.0
2015-07-09	AAMI	Stock	17.26	17.46	17.11	17.37	276300.0
2015-07-09	AAOI	Stock	16.28	16.56	15.54	16.19	193900.0
2015-07-09	AAON	Stock	14.98	15.08	14.7933	14.8267	170250.0
2015-07-09	AAP	Stock	161.29	162.66	160.69	162.07	1908300.0
2015-07-09	AAT	Stock	40.59	40.88	40.22	40.4	146200.0
2015-07-09	AAU-DELISTED	Stock	0.79	0.79	0.77	0.77	86454.0
2015-07-09	AAUAF-DELISTED	Stock	0.79	0.79	0.77	0.77	87017.0
2015-07-09	AAV-DELISTED	Stock	6.3	6.34	6.14	6.19	72685.0
2015-07-09	AAVL-DELISTED	Stock	15.72	15.9	15.32	15.6	224837.0
2015-07-09	AAWW-DELISTED	Stock	53.18	53.55	51.684	52.21	358772.0
2015-07-09	AAXJ	Stock	60.06	60.25	59.585	59.6	1750092.0
2015-07-09	AAXN-DELISTED	Stock	32.1	32.73	31.9	32.4	1549707.0
2015-07-09	AB	Stock	28.99	29.08	28.6	28.72	99700.0
2015-07-09	ABAC-DELISTED	Stock	1.07	1.19	1.06	1.08	100676.0
2015-07-09	ABAX-DELISTED	Stock	50.43	51.0	50.1	50.5	91212.0
2015-07-09	ABB-DELISTED	Stock	20.24	20.3	20.0	20.0	2449157.0
2015-07-09	ABBNY-DELISTED	Stock	20.24	20.3	20.0	20.01	2598382.0
2015-07-09	ABBV	Stock	68.48	68.92	67.8	67.97	6516800.0
2015-07-09	ABC-DELISTED	Stock	108.97	109.15	108.08	108.86	1543367.0
2015-07-09	ABCB	Stock	25.68	25.79	25.4	25.7	149000.0
2015-07-09	ABCD-DELISTED	Stock	4.77	4.89	4.68	4.73	214826.0
2015-07-09	ABCO-DELISTED	Stock	55.01	57.18	54.97	57.17	391221.0
2015-07-09	ABCW-DELISTED	Stock	41.4	41.4	39.78	40.16	16969.0
2015-07-09	ABDC-DELISTED	Stock	12.6048	12.84	12.35	12.8	27689.0
2015-07-09	ABE-DELISTED	Stock	12.47	13.0	12.47	12.97	14273.0
2015-07-09	ABEO	Stock	120.25	127.75	119.0	126.75	13624.0
2015-07-09	ABEOW-DELISTED	Stock	1.6	1.94	1.55	1.7	16477.0
2015-07-09	ABEV	Stock	5.97	6.05	5.94	5.94	5952600.0
2015-07-09	ABG	Stock	90.38	90.72	89.15	90.03	220800.0
2015-07-09	ABGB-DELISTED	Stock	15.12	15.17	14.76	14.9	18741.0
2015-07-09	ABIL-DELISTED	Stock	10.0	10.0	10.0	10.0	200.0

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

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