PREVIEW / stock_daily / 2014-10-27

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-27.parquet
  size:    226 KB
  rows:    6,607
  symbols: 3,548

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
2014-10-27	AAPL	Stock	26.2125	26.37	26.175	26.2775	136750800.0
2014-10-27	MSFT	Stock	45.71	46.1	45.71	45.91	30371300.0
2014-10-27	NVDA	Stock	0.4618	0.464	0.4568	0.4622	145092000.0
2014-10-27	AMZN	Stock	14.285	14.521	14.251	14.4985	119012000.0
2014-10-27	GOOGL	Stock	27.388	27.7	27.36	27.494	31968180.0
2014-10-27	META	Stock	80.74	80.8	79.76	80.28	30169000.0
2014-10-27	TSLA	Stock	15.6167	15.6407	14.6873	14.778	143299500.0
2014-10-27	TLT	Stock	119.89	120.265	119.66	119.94	3392161.0
2014-10-27	ES	Stock	48.56	48.77	48.3	48.45	1590000.0
2014-10-27	CL	Stock	65.33	66.32	65.26	66.11	3265300.0
2014-10-27	A	Stock	38.5837	38.7053	38.3405	38.6195	1545209.0
2014-10-27	AA.B-DELISTED	Stock	51.49	51.49	50.9799	51.29	217403.0
2014-10-27	AABA-DELISTED	Stock	43.25	44.8	43.25	44.7	34864444.0
2014-10-27	AAC-DELISTED	Stock	22.0	22.6498	21.8999	22.14	195807.0
2014-10-27	AACG	Stock	4.27	4.27	4.18	4.26	3900.0
2014-10-27	AAIC-DELISTED	Stock	27.07	27.1556	26.635	27.06	309843.0
2014-10-27	AAL	Stock	39.6	40.4	39.29	39.91	13353100.0
2014-10-27	AAMC-DELISTED	Stock	161.7647	163.2353	159.7059	161.7647	59840.0
2014-10-27	AAME	Stock	3.95	3.95	3.83	3.83	1300.0
2014-10-27	AAMI	Stock	14.75	14.8	14.51	14.76	64400.0
2014-10-27	AAOI	Stock	15.2	15.55	14.77	15.06	340400.0
2014-10-27	AAON	Stock	12.08	12.2467	11.84	12.18	113700.0
2014-10-27	AAP	Stock	142.16	144.52	141.86	144.46	464800.0
2014-10-27	AAT	Stock	36.68	36.95	36.32	36.95	102700.0
2014-10-27	AAU-DELISTED	Stock	1.1989	1.2534	1.1569	1.22	170297.0
2014-10-27	AAUAF-DELISTED	Stock	1.14	1.22	1.1	1.22	180450.0
2014-10-27	AAV-DELISTED	Stock	4.16	4.2	4.04	4.185	164913.0
2014-10-27	AAVL-DELISTED	Stock	32.9299	33.85	32.75	33.64	29518.0
2014-10-27	AAWW-DELISTED	Stock	34.6099	36.13	34.25	35.51	213400.0
2014-10-27	AAXJ	Stock	60.93	61.16	60.85	61.13	548291.0
2014-10-27	AAXN-DELISTED	Stock	15.37	15.69	15.222	15.635	1174089.0
2014-10-27	AB	Stock	26.07	26.17	25.76	25.82	111000.0
2014-10-27	ABAC-DELISTED	Stock	2.2799	2.29	2.22	2.25	58878.0
2014-10-27	ABAX-DELISTED	Stock	49.0	49.3699	48.34	48.93	272807.0
2014-10-27	ABB-DELISTED	Stock	21.2399	21.35	21.1499	21.25	866964.0
2014-10-27	ABBNY-DELISTED	Stock	21.24	21.35	21.15	21.25	945114.0
2014-10-27	ABBV	Stock	60.35	60.98	60.21	60.49	10010900.0
2014-10-27	ABC-DELISTED	Stock	78.3401	79.99	78.2901	79.45	2989463.0
2014-10-27	ABCB	Stock	23.65	23.95	23.39	23.95	38300.0
2014-10-27	ABCD-DELISTED	Stock	1.48	1.48	1.48	1.48	653.0
2014-10-27	ABCO-DELISTED	Stock	50.57	51.97	50.01	51.85	165300.0
2014-10-27	ABCW-DELISTED	Stock	31.0	31.0	30.5	30.982	3650.0
2014-10-27	ABDC-DELISTED	Stock	12.65	12.79	12.38	12.7	16351.0
2014-10-27	ABE-DELISTED	Stock	13.78	13.78	13.7	13.73	4152.0
2014-10-27	ABEO	Stock	222.5	222.5	162.5	212.5	40.0
2014-10-27	ABEV	Stock	6.06	6.23	6.06	6.21	32874900.0
2014-10-27	ABG	Stock	66.55	66.9	66.03	66.3	278900.0
2014-10-27	ABGB-DELISTED	Stock	20.05	20.3099	19.5599	20.18	21280.0
2014-10-27	ABM	Stock	26.38	26.59	26.19	26.57	81500.0
2014-10-27	ABMD-DELISTED	Stock	24.1	24.6799	23.9759	24.57	255622.0

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

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