PREVIEW / stock_daily / 2014-10-01

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-01.parquet
  size:    222 KB
  rows:    6,647
  symbols: 3,578

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-01	AAPL	Stock	25.1475	25.1725	24.675	24.795	205965200.0
2014-10-01	MSFT	Stock	46.27	46.53	45.85	45.9	38088400.0
2014-10-01	NVDA	Stock	0.462	0.4652	0.4555	0.4568	350976000.0
2014-10-01	AMZN	Stock	16.102	16.1085	15.7775	15.873	61782000.0
2014-10-01	GOOGL	Stock	29.34	29.436	28.901	28.9815	28993720.0
2014-10-01	META	Stock	78.78	78.82	75.9	76.55	55090000.0
2014-10-01	TSLA	Stock	16.1467	16.1773	15.71	16.016	89125500.0
2014-10-01	TLT	Stock	116.89	118.26	116.83	118.23	17194898.0
2014-10-01	ES	Stock	44.39	45.2	44.37	44.89	2801500.0
2014-10-01	CL	Stock	65.22	65.29	64.8	64.89	3385200.0
2014-10-01	A	Stock	40.6652	40.7225	40.186	40.2003	3468857.0
2014-10-01	AA.B-DELISTED	Stock	49.8499	49.96	48.77	49.1499	39177.0
2014-10-01	AABA-DELISTED	Stock	40.66	41.24	40.11	40.325	33988482.0
2014-10-01	AACG	Stock	4.5	4.5	4.3	4.34	8000.0
2014-10-01	AAIC-DELISTED	Stock	25.3	25.67	25.25	25.56	455935.0
2014-10-01	AAL	Stock	34.72	34.94	33.85	34.39	19443300.0
2014-10-01	AAMC-DELISTED	Stock	201.1044	205.8059	194.1176	198.8235	52105.0
2014-10-01	AAME	Stock	4.0	4.0	4.0	4.0	300.0
2014-10-01	AAOI	Stock	16.01	16.1	15.2	15.21	230700.0
2014-10-01	AAON	Stock	11.36	11.6667	11.2867	11.5133	370350.0
2014-10-01	AAP	Stock	129.89	131.44	129.08	130.52	1017000.0
2014-10-01	AAT	Stock	32.97	33.33	32.84	33.08	192800.0
2014-10-01	AAU-DELISTED	Stock	1.33	1.35	1.308	1.315	88180.0
2014-10-01	AAUAF-DELISTED	Stock	1.32	1.34	1.303	1.32	88985.0
2014-10-01	AAV-DELISTED	Stock	5.11	5.16	4.99	5.02	312817.0
2014-10-01	AAVL-DELISTED	Stock	34.0	34.9375	31.21	31.88	192792.0
2014-10-01	AAWW-DELISTED	Stock	33.04	33.04	31.51	31.53	397187.0
2014-10-01	AAXJ	Stock	61.09	61.1625	60.33	60.33	575104.0
2014-10-01	AAXN-DELISTED	Stock	15.34	15.34	14.3	14.58	2900914.0
2014-10-01	AB	Stock	26.0	26.43	25.01	25.55	334000.0
2014-10-01	ABAC-DELISTED	Stock	2.03	2.09	1.9101	2.0	16650.0
2014-10-01	ABAX-DELISTED	Stock	50.85	51.57	50.15	51.4	165805.0
2014-10-01	ABB-DELISTED	Stock	22.32	22.34	22.05	22.12	1561556.0
2014-10-01	ABBNY-DELISTED	Stock	22.32	22.34	22.05	22.12	1788035.0
2014-10-01	ABBV	Stock	57.93	57.94	56.96	57.23	8431900.0
2014-10-01	ABC-DELISTED	Stock	78.21	78.21	76.44	76.64	1329052.0
2014-10-01	ABCB	Stock	21.9	22.11	21.76	21.95	178900.0
2014-10-01	ABCD-DELISTED	Stock	1.55	1.57	1.55	1.57	14328.0
2014-10-01	ABCO-DELISTED	Stock	46.46	46.72	45.39	45.5	325189.0
2014-10-01	ABDC-DELISTED	Stock	13.2	13.3688	12.59	13.34	45907.0
2014-10-01	ABE-DELISTED	Stock	13.85	13.85	13.84	13.85	9932.0
2014-10-01	ABEO	Stock	337.5	337.5	337.5	337.5	25.0
2014-10-01	ABEV	Stock	6.49	6.52	6.22	6.3	29727400.0
2014-10-01	ABG	Stock	63.84	64.65	63.04	63.2	385100.0
2014-10-01	ABGB-DELISTED	Stock	25.95	25.97	25.46	25.53	41567.0
2014-10-01	ABM	Stock	25.74	25.82	25.16	25.18	377500.0
2014-10-01	ABMD-DELISTED	Stock	24.85	24.92	24.23	24.29	231697.0
2014-10-01	ABR	Stock	6.71	6.74	6.61	6.67	94100.0
2014-10-01	ABR.A-DELISTED	Stock	24.3801	24.431	24.24	24.27	11118.0
2014-10-01	ABR.B-DELISTED	Stock	24.15	24.15	24.12	24.15	4861.0

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

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