PREVIEW / stock_daily / 2015-05-18

all stock daily files

  file:    by_date/stock_daily/2015/2015-05-18.parquet
  size:    224 KB
  rows:    6,665
  symbols: 3,507

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-05-18	AAPL	Stock	32.095	32.68	32.09	32.5475	203531600.0
2015-05-18	MSFT	Stock	47.98	48.22	47.61	48.01	24136500.0
2015-05-18	NVDA	Stock	0.5312	0.535	0.5287	0.5318	324972000.0
2015-05-18	AMZN	Stock	21.3	21.3635	21.073	21.262	47804000.0
2015-05-18	GOOGL	Stock	27.191	27.417	27.1125	27.3335	26705120.0
2015-05-18	META	Stock	80.33	81.38	80.23	80.88	21613700.0
2015-05-18	TSLA	Stock	16.4667	16.66	16.4	16.5833	50298000.0
2015-05-18	TLT	Stock	120.32	120.43	119.4732	119.55	10208341.0
2015-05-18	ES	Stock	49.03	49.56	48.9	49.44	1186300.0
2015-05-18	CL	Stock	68.49	68.82	68.4	68.61	3359800.0
2015-05-18	A	Stock	42.05	42.7	41.98	42.63	1966100.0
2015-05-18	AA.B-DELISTED	Stock	46.21	46.21	45.46	45.7057	30506.0
2015-05-18	AABA-DELISTED	Stock	44.59	44.59	44.04	44.35	8552314.0
2015-05-18	AAC-DELISTED	Stock	37.12	39.0499	36.7122	37.57	755437.0
2015-05-18	AACG	Stock	4.35	4.75	4.35	4.75	1900.0
2015-05-18	AAIC-DELISTED	Stock	21.2	21.4	21.15	21.28	190604.0
2015-05-18	AAL	Stock	48.56	49.17	48.38	49.0	6152300.0
2015-05-18	AAMC-DELISTED	Stock	51.6794	52.0588	51.1735	51.1735	7548.0
2015-05-18	AAME	Stock	3.55	3.71	3.51	3.69	4900.0
2015-05-18	AAMI	Stock	19.24	19.86	19.2	19.74	82000.0
2015-05-18	AAOI	Stock	14.48	14.95	14.46	14.8	166300.0
2015-05-18	AAON	Stock	15.3467	15.7733	15.28	15.7733	168300.0
2015-05-18	AAP	Stock	150.99	153.13	150.85	151.88	2099300.0
2015-05-18	AAT	Stock	40.34	40.86	40.15	40.75	91100.0
2015-05-18	AAU-DELISTED	Stock	0.85	0.95	0.85	0.93	260161.0
2015-05-18	AAUAF-DELISTED	Stock	0.85	0.95	0.85	0.93	265018.0
2015-05-18	AAV-DELISTED	Stock	6.11	6.15	5.8	5.8	253425.0
2015-05-18	AAVL-DELISTED	Stock	35.14	36.8	34.77	36.67	327502.0
2015-05-18	AAWW-DELISTED	Stock	57.17	59.13	57.04	58.76	425542.0
2015-05-18	AAXJ	Stock	67.67	67.67	67.42	67.43	1388529.0
2015-05-18	AAXN-DELISTED	Stock	31.83	32.49	30.3801	32.43	4052220.0
2015-05-18	AB	Stock	30.8	31.59	30.79	31.19	358000.0
2015-05-18	ABAC-DELISTED	Stock	1.67	1.71	1.6372	1.69	15614.0
2015-05-18	ABAX-DELISTED	Stock	52.54	53.79	52.51	53.23	70891.0
2015-05-18	ABB-DELISTED	Stock	22.28	22.29	22.09	22.15	1300605.0
2015-05-18	ABBNY-DELISTED	Stock	22.28	22.29	22.09	22.15	1587701.0
2015-05-18	ABBV	Stock	65.79	65.91	65.14	65.61	7858100.0
2015-05-18	ABC-DELISTED	Stock	113.36	113.62	112.56	113.31	2511081.0
2015-05-18	ABCB	Stock	24.95	25.59	24.95	25.42	59800.0
2015-05-18	ABCD-DELISTED	Stock	3.37	3.81	3.37	3.72	269537.0
2015-05-18	ABCO-DELISTED	Stock	47.95	48.71	47.53	48.63	287079.0
2015-05-18	ABCW-DELISTED	Stock	37.47	37.49	37.31	37.48	2959.0
2015-05-18	ABDC-DELISTED	Stock	13.82	14.0	13.82	14.0	61932.0
2015-05-18	ABE-DELISTED	Stock	13.3999	13.3999	13.24	13.32	3399.0
2015-05-18	ABEO	Stock	211.25	236.0	201.25	231.75	226424.0
2015-05-18	ABEOW-DELISTED	Stock	3.9	4.4	3.16	4.21	214380.0
2015-05-18	ABEV	Stock	6.5	6.5	6.36	6.38	10718100.0
2015-05-18	ABG	Stock	84.75	87.03	84.64	86.85	197600.0
2015-05-18	ABGB-DELISTED	Stock	17.32	17.49	17.22	17.3	10590.0
2015-05-18	ABIL-DELISTED	Stock	9.89	9.91	9.89	9.9	1216.0

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

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