PREVIEW / stock_daily / 2015-09-14

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-14.parquet
  size:    219 KB
  rows:    6,619
  symbols: 3,428

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-09-14	AAPL	Stock	29.145	29.2225	28.715	28.8275	233453600.0
2015-09-14	MSFT	Stock	43.43	43.44	42.86	43.04	23656000.0
2015-09-14	NVDA	Stock	0.569	0.5708	0.5642	0.5672	192460000.0
2015-09-14	AMZN	Stock	26.472	26.6225	25.929	26.069	62604000.0
2015-09-14	GOOGL	Stock	32.7815	32.796	32.4751	32.6235	29952540.0
2015-09-14	META	Stock	92.31	92.62	91.6	92.31	20127900.0
2015-09-14	TSLA	Stock	16.74	16.95	16.6447	16.8793	43363500.0
2015-09-14	TLT	Stock	121.95	122.145	121.28	121.58	4221733.0
2015-09-14	ES	Stock	46.08	46.47	45.97	46.25	1129300.0
2015-09-14	CL	Stock	61.83	62.14	61.55	62.11	3704100.0
2015-09-14	A	Stock	35.92	36.09	35.32	35.55	2223300.0
2015-09-14	AA.B-DELISTED	Stock	34.52	34.6	34.01	34.01	21838.0
2015-09-14	AABA-DELISTED	Stock	30.68	30.92	30.0	30.33	21345126.0
2015-09-14	AAC-DELISTED	Stock	22.46	24.62	22.214	23.19	401446.0
2015-09-14	AACG	Stock	2.36	2.36	2.25	2.27	7400.0
2015-09-14	AAIC-DELISTED	Stock	15.97	15.9799	15.76	15.86	160927.0
2015-09-14	AAL	Stock	42.17	42.5	41.84	42.29	7362500.0
2015-09-14	AAMC-DELISTED	Stock	8.3971	8.3971	7.2941	7.6559	60959.0
2015-09-14	AAME	Stock	3.47	3.59	3.47	3.5	6800.0
2015-09-14	AAMI	Stock	16.33	16.33	16.01	16.22	141300.0
2015-09-14	AAOI	Stock	20.04	20.2	18.64	18.86	664900.0
2015-09-14	AAON	Stock	13.4267	13.46	13.1267	13.2867	196650.0
2015-09-14	AAP	Stock	175.1	176.04	173.48	175.0	556400.0
2015-09-14	AAT	Stock	38.68	39.0	38.61	38.83	80700.0
2015-09-14	AAU-DELISTED	Stock	0.5105	0.5301	0.4883	0.49	96720.0
2015-09-14	AAUAF-DELISTED	Stock	0.5105	0.5301	0.4883	0.49	97081.0
2015-09-14	AAV-DELISTED	Stock	5.2	5.43	5.14	5.32	81017.0
2015-09-14	AAVL-DELISTED	Stock	10.69	10.69	10.24	10.59	255779.0
2015-09-14	AAWW-DELISTED	Stock	39.44	39.556	38.39	38.68	182044.0
2015-09-14	AAXJ	Stock	53.43	53.47	53.155	53.37	474846.0
2015-09-14	AAXN-DELISTED	Stock	23.68	24.03	23.633	23.87	645059.0
2015-09-14	AB	Stock	26.29	26.97	26.2	26.84	186700.0
2015-09-14	ABAC-DELISTED	Stock	0.726	0.7315	0.68	0.7	108174.0
2015-09-14	ABAX-DELISTED	Stock	48.83	48.83	48.36	48.53	69128.0
2015-09-14	ABB-DELISTED	Stock	18.6	18.6	18.41	18.51	2204047.0
2015-09-14	ABBNY-DELISTED	Stock	18.6	18.6	18.41	18.51	2276181.0
2015-09-14	ABBV	Stock	59.43	59.62	57.54	58.94	9095600.0
2015-09-14	ABC-DELISTED	Stock	104.82	105.48	103.79	104.61	1440378.0
2015-09-14	ABCB	Stock	27.89	28.24	27.79	28.18	328200.0
2015-09-14	ABCD-DELISTED	Stock	5.01	5.01	4.88	4.91	30860.0
2015-09-14	ABCO-DELISTED	Stock	48.72	48.89	48.0	48.15	109150.0
2015-09-14	ABCW-DELISTED	Stock	41.5	41.5	40.5	40.89	58353.0
2015-09-14	ABDC-DELISTED	Stock	12.78	12.78	12.63	12.71	77144.0
2015-09-14	ABE-DELISTED	Stock	10.95	11.07	10.95	11.0585	3740.0
2015-09-14	ABEO	Stock	134.75	137.5	127.5	129.0	6144.0
2015-09-14	ABEOW-DELISTED	Stock	2.02	2.1693	2.01	2.1693	1590.0
2015-09-14	ABEV	Stock	4.88	4.91	4.83	4.9	32802400.0
2015-09-14	ABG	Stock	81.83	82.11	80.32	81.22	150200.0
2015-09-14	ABGB-DELISTED	Stock	5.76	5.82	5.665	5.6701	43370.0
2015-09-14	ABIL-DELISTED	Stock	10.04	10.04	10.04	10.04	100.0

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

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