PREVIEW / stock_daily / 2013-09-18

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-18.parquet
  size:    212 KB
  rows:    6,364
  symbols: 3,512

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
2013-09-18	AAPL	Stock	16.5421	16.6554	16.4521	16.5957	456862000.0
2013-09-18	MSFT	Stock	32.99	33.4	32.83	33.32	64099900.0
2013-09-18	NVDA	Stock	0.3968	0.401	0.3948	0.4	268168000.0
2013-09-18	AMZN	Stock	15.203	15.637	15.1455	15.6015	58928000.0
2013-09-18	META	Stock	44.84	45.47	44.4	45.23	79317000.0
2013-09-18	TSLA	Stock	11.138	11.1633	10.9467	11.0813	81595500.0
2013-09-18	TLT	Stock	103.63	105.55	102.98	104.99	19749126.0
2013-09-18	ES	Stock	40.51	42.01	40.34	41.89	1736000.0
2013-09-18	CL	Stock	60.06	61.19	59.8	61.19	3832500.0
2013-09-18	A	Stock	34.8856	35.3004	34.5422	35.279	2857792.0
2013-09-18	AABA-DELISTED	Stock	30.01	30.46	29.85	30.43	15186329.0
2013-09-18	AACG	Stock	4.79	4.79	4.4	4.5	7900.0
2013-09-18	AAIC-DELISTED	Stock	25.47	26.0	25.3114	25.91	170073.0
2013-09-18	AAMC-DELISTED	Stock	105.8824	105.8824	104.8382	104.8382	8830.0
2013-09-18	AAME	Stock	4.01	4.03	3.83	4.03	16800.0
2013-09-18	AAMRQ-DELISTED	Stock	3.775	3.85	3.64	3.84	4934485.0
2013-09-18	AAON	Stock	11.2178	11.5378	11.1111	11.4	186525.0
2013-09-18	AAP	Stock	80.05	80.42	79.09	80.36	505000.0
2013-09-18	AAT	Stock	30.4	31.35	30.13	31.33	88200.0
2013-09-18	AAU-DELISTED	Stock	1.42	1.59	1.4	1.51	401028.0
2013-09-18	AAUAF-DELISTED	Stock	1.42	1.59	1.4	1.53	403928.0
2013-09-18	AAV-DELISTED	Stock	3.79	3.88	3.69	3.83	92470.0
2013-09-18	AAWW-DELISTED	Stock	46.45	47.19	46.26	46.98	173437.0
2013-09-18	AAXJ	Stock	59.03	61.4	58.835	61.19	3838675.0
2013-09-18	AAXN-DELISTED	Stock	13.5	14.2	13.36	14.085	2685405.0
2013-09-18	AB	Stock	20.73	21.54	20.51	21.52	593000.0
2013-09-18	ABAC-DELISTED	Stock	0.7968	0.838	0.7968	0.81	14400.0
2013-09-18	ABAX-DELISTED	Stock	40.57	40.98	40.0	40.675	135078.0
2013-09-18	ABB-DELISTED	Stock	23.3	23.94	23.28	23.92	1445925.0
2013-09-18	ABBNY-DELISTED	Stock	23.3	23.94	23.28	23.93	1464820.0
2013-09-18	ABBV	Stock	47.19	48.42	46.88	47.92	6689400.0
2013-09-18	ABC-DELISTED	Stock	61.63	61.71	60.815	61.5	1122127.0
2013-09-18	ABCB	Stock	19.21	19.25	18.96	19.1	29700.0
2013-09-18	ABCD-DELISTED	Stock	1.5045	1.65	1.49	1.49	2738.0
2013-09-18	ABCO-DELISTED	Stock	58.45	59.29	57.98	59.28	105536.0
2013-09-18	ABE-DELISTED	Stock	19.55	19.95	19.55	19.95	8317.0
2013-09-18	ABEO	Stock	412.5	500.0	412.5	500.0	5.0
2013-09-18	ABFS-DELISTED	Stock	25.36	26.63	25.185	25.68	301683.0
2013-09-18	ABG	Stock	53.38	53.57	52.41	53.49	230400.0
2013-09-18	ABM	Stock	25.91	26.13	25.81	26.03	230100.0
2013-09-18	ABMD-DELISTED	Stock	23.56	23.67	22.92	23.18	288802.0
2013-09-18	ABR	Stock	7.2	7.4	7.16	7.4	77500.0
2013-09-18	ABR.A-DELISTED	Stock	24.69	24.69	24.6195	24.65	2300.0
2013-09-18	ABR.B-DELISTED	Stock	23.7	23.72	23.7	23.716	730.0
2013-09-18	ABT	Stock	35.0	35.67	34.89	35.65	6753100.0
2013-09-18	ABTL-DELISTED	Stock	7.6	7.6	7.42	7.6	41164.0
2013-09-18	ABUS	Stock	6.17	6.48	6.09	6.38	138900.0
2013-09-18	ABV-DELISTED	Stock	37.54	39.12	37.13	38.9	2653870.0
2013-09-18	ABX-DELISTED	Stock	18.11	20.39	18.07	20.13	32416374.0
2013-09-18	ACAD	Stock	23.76	24.1	23.4	23.72	1330500.0

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

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