PREVIEW / stock_daily / 2015-08-07

all stock daily files

  file:    by_date/stock_daily/2015/2015-08-07.parquet
  size:    221 KB
  rows:    6,632
  symbols: 3,459

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-08-07	AAPL	Stock	28.645	29.0625	28.625	28.88	154681600.0
2015-08-07	MSFT	Stock	46.39	46.78	46.26	46.74	19163000.0
2015-08-07	NVDA	Stock	0.5615	0.5843	0.547	0.5745	1405248000.0
2015-08-07	AMZN	Stock	26.458	26.473	25.9105	26.131	79384000.0
2015-08-07	GOOGL	Stock	33.389	33.4397	32.9435	33.2195	27543040.0
2015-08-07	META	Stock	95.38	95.4	93.61	94.3	23199100.0
2015-08-07	TSLA	Stock	16.2387	16.2487	15.8927	16.1673	76101000.0
2015-08-07	TLT	Stock	123.3	124.4993	123.24	124.34	8316980.0
2015-08-07	ES	Stock	49.26	49.97	49.03	49.8	2142900.0
2015-08-07	CL	Stock	68.63	68.7	68.3	68.49	2286500.0
2015-08-07	A	Stock	40.14	40.21	39.63	39.99	1513100.0
2015-08-07	AA.B-DELISTED	Stock	36.12	36.3899	34.63	34.82	68683.0
2015-08-07	AABA-DELISTED	Stock	36.52	36.76	36.15	36.69	10329432.0
2015-08-07	AAC-DELISTED	Stock	20.04	20.17	16.59	17.8263	815959.0
2015-08-07	AACG	Stock	3.5	3.5	3.41	3.42	10900.0
2015-08-07	AAIC-DELISTED	Stock	18.41	18.54	18.041	18.12	208099.0
2015-08-07	AAL	Stock	42.21	42.48	41.4	41.49	5588600.0
2015-08-07	AAMC-DELISTED	Stock	39.0441	39.0765	37.6471	39.0765	4359.0
2015-08-07	AAME	Stock	3.68	3.71	3.68	3.71	1500.0
2015-08-07	AAMI	Stock	17.64	18.0	17.52	17.65	157200.0
2015-08-07	AAOI	Stock	20.71	21.87	20.41	21.85	582000.0
2015-08-07	AAON	Stock	15.0733	15.4267	14.98	15.1333	222900.0
2015-08-07	AAP	Stock	172.76	174.03	171.54	173.75	534500.0
2015-08-07	AAT	Stock	40.01	40.66	39.93	40.63	379400.0
2015-08-07	AAU-DELISTED	Stock	0.7299	0.77	0.7199	0.77	139495.0
2015-08-07	AAUAF-DELISTED	Stock	0.7299	0.77	0.7199	0.77	142167.0
2015-08-07	AAV-DELISTED	Stock	5.69	5.69	5.4	5.44	328397.0
2015-08-07	AAVL-DELISTED	Stock	14.19	14.29	13.79	13.99	263433.0
2015-08-07	AAWW-DELISTED	Stock	46.46	46.46	44.68	44.96	599479.0
2015-08-07	AAXJ	Stock	58.31	58.45	58.15	58.27	690307.0
2015-08-07	AAXN-DELISTED	Stock	24.2	24.28	23.03	24.04	1622369.0
2015-08-07	AB	Stock	27.59	28.25	27.5	28.06	233100.0
2015-08-07	ABAC-DELISTED	Stock	1.02	1.02	0.851	0.9999	19415.0
2015-08-07	ABAX-DELISTED	Stock	48.49	48.78	47.51	48.72	191003.0
2015-08-07	ABB-DELISTED	Stock	20.42	20.58	20.39	20.51	1405382.0
2015-08-07	ABBNY-DELISTED	Stock	20.42	20.58	20.39	20.5	1460303.0
2015-08-07	ABBV	Stock	69.08	69.3	67.77	68.62	6214500.0
2015-08-07	ABC-DELISTED	Stock	104.51	104.65	102.88	104.41	2269600.0
2015-08-07	ABCB	Stock	28.0	28.14	27.65	27.94	139200.0
2015-08-07	ABCD-DELISTED	Stock	4.66	4.66	4.35	4.35	70691.0
2015-08-07	ABCO-DELISTED	Stock	47.52	47.88	46.19	47.31	454486.0
2015-08-07	ABCW-DELISTED	Stock	39.33	39.92	38.82	39.8	21101.0
2015-08-07	ABDC-DELISTED	Stock	11.82	12.21	11.81	11.95	38229.0
2015-08-07	ABE-DELISTED	Stock	12.23	12.33	12.23	12.33	1943.0
2015-08-07	ABEO	Stock	145.0	145.0	137.25	139.25	7440.0
2015-08-07	ABEOW-DELISTED	Stock	2.08	2.1	2.07	2.07	2110.0
2015-08-07	ABEV	Stock	5.51	5.56	5.49	5.52	8782100.0
2015-08-07	ABG	Stock	85.04	85.74	83.5	83.62	278300.0
2015-08-07	ABGB-DELISTED	Stock	6.11	6.11	5.89	6.03	123794.0
2015-08-07	ABM	Stock	33.03	33.21	32.83	33.03	199300.0

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

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