PREVIEW / stock_daily / 2013-09-03

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-03.parquet
  size:    212 KB
  rows:    6,376
  symbols: 3,535

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-03	AAPL	Stock	17.6107	17.8786	17.4054	17.4493	331928800.0
2013-09-03	MSFT	Stock	31.75	32.07	31.29	31.88	154507000.0
2013-09-03	NVDA	Stock	0.3698	0.3743	0.3668	0.369	284680000.0
2013-09-03	AMZN	Stock	14.2365	14.5695	14.2085	14.44	57952000.0
2013-09-03	META	Stock	41.84	42.16	41.51	41.87	48774900.0
2013-09-03	TSLA	Stock	11.56	11.58	11.0933	11.2627	180916500.0
2013-09-03	TLT	Stock	104.59	104.67	103.51	104.22	12084368.0
2013-09-03	ES	Stock	41.23	41.38	40.3	40.34	1643200.0
2013-09-03	CL	Stock	58.35	58.39	57.38	57.45	3376100.0
2013-09-03	A	Stock	33.6481	33.9843	33.3476	33.5694	2188709.0
2013-09-03	AABA-DELISTED	Stock	27.46	27.87	27.37	27.79	14496838.0
2013-09-03	AACG	Stock	4.55	4.96	4.33	4.5	5200.0
2013-09-03	AAIC-DELISTED	Stock	23.36	23.78	23.02	23.17	154271.0
2013-09-03	AAMC-DELISTED	Stock	94.2647	94.4118	94.2647	94.4118	2006.0
2013-09-03	AAME	Stock	3.87	3.94	3.87	3.94	600.0
2013-09-03	AAMRQ-DELISTED	Stock	3.695	3.72	3.39	3.54	7784484.0
2013-09-03	AAON	Stock	10.6	10.9467	10.6	10.7822	329400.0
2013-09-03	AAP	Stock	81.35	81.35	79.41	79.78	904200.0
2013-09-03	AAT	Stock	29.89	29.89	29.01	29.25	110500.0
2013-09-03	AAU-DELISTED	Stock	1.78	1.869	1.73	1.74	69693.0
2013-09-03	AAUAF-DELISTED	Stock	1.78	1.869	1.73	1.74	71093.0
2013-09-03	AAV-DELISTED	Stock	3.64	3.69	3.55	3.57	103448.0
2013-09-03	AAWW-DELISTED	Stock	46.64	47.35	46.5	47.08	130089.0
2013-09-03	AAXJ	Stock	55.58	55.72	55.14	55.21	1022644.0
2013-09-03	AAXN-DELISTED	Stock	11.92	11.99	11.7	11.97	1105940.0
2013-09-03	AB	Stock	19.65	19.89	19.5	19.6	166600.0
2013-09-03	ABAC-DELISTED	Stock	0.7801	0.8622	0.7701	0.7921	44900.0
2013-09-03	ABAX-DELISTED	Stock	39.51	40.0	38.97	39.14	112100.0
2013-09-03	ABB-DELISTED	Stock	21.6	21.68	21.5	21.59	1270933.0
2013-09-03	ABBNY-DELISTED	Stock	21.6	21.68	21.5	21.58	1307654.0
2013-09-03	ABBV	Stock	43.0	43.28	42.31	42.59	2925600.0
2013-09-03	ABC-DELISTED	Stock	57.46	57.88	57.21	57.39	1033303.0
2013-09-03	ABCB	Stock	19.5	19.74	19.05	19.26	54400.0
2013-09-03	ABCD-DELISTED	Stock	1.67	1.7499	1.64	1.65	15661.0
2013-09-03	ABCO-DELISTED	Stock	55.36	56.27	54.55	56.18	140266.0
2013-09-03	ABE-DELISTED	Stock	18.26	18.44	17.9445	18.36	11948.0
2013-09-03	ABEO	Stock	425.0	450.0	425.0	450.0	24.0
2013-09-03	ABFS-DELISTED	Stock	25.29	25.75	24.71	24.76	717249.0
2013-09-03	ABG	Stock	49.88	50.42	48.66	49.09	183300.0
2013-09-03	ABM	Stock	24.48	24.77	24.14	24.59	180500.0
2013-09-03	ABMD-DELISTED	Stock	23.8	24.07	23.55	24.0	274354.0
2013-09-03	ABR	Stock	7.04	7.06	6.84	6.99	71100.0
2013-09-03	ABR.A-DELISTED	Stock	24.538	24.6899	24.538	24.6899	300.0
2013-09-03	ABR.B-DELISTED	Stock	23.78	24.13	23.78	24.0	3000.0
2013-09-03	ABT	Stock	33.68	33.78	32.7	32.93	14068300.0
2013-09-03	ABTL-DELISTED	Stock	5.915	6.059	5.85	6.04	22718.0
2013-09-03	ABUS	Stock	5.48	5.51	5.33	5.39	30500.0
2013-09-03	ABV-DELISTED	Stock	35.03	35.2	34.16	34.57	2517905.0
2013-09-03	ABX-DELISTED	Stock	19.44	19.73	19.37	19.51	13494470.0
2013-09-03	ACAD	Stock	20.3	20.57	20.1	20.53	886800.0

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

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