PREVIEW / stock_daily / 2013-03-18

all stock daily files

  file:    by_date/stock_daily/2013/2013-03-18.parquet
  size:    207 KB
  rows:    6,298
  symbols: 3,505

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-03-18	AAPL	Stock	15.7661	16.3379	15.7571	16.2757	606197200.0
2013-03-18	MSFT	Stock	27.88	28.28	27.81	28.1	44809400.0
2013-03-18	NVDA	Stock	0.314	0.3168	0.3115	0.3138	298312000.0
2013-03-18	AMZN	Stock	12.965	13.0745	12.856	12.8945	54404000.0
2013-03-18	META	Stock	26.37	26.79	25.78	26.49	26653700.0
2013-03-18	TSLA	Stock	2.3533	2.404	2.328	2.3433	19741500.0
2013-03-18	TLT	Stock	116.83	116.88	116.15	116.64	9152175.0
2013-03-18	ES	Stock	42.43	42.61	42.26	42.39	783900.0
2013-03-18	CL	Stock	55.82	56.225	55.66	56.13	3896800.0
2013-03-18	A	Stock	30.372	30.5436	30.1717	30.4363	2582945.0
2013-03-18	AABA-DELISTED	Stock	21.9	22.17	21.87	22.01	14774927.0
2013-03-18	AACC-DELISTED	Stock	6.49	6.52	6.48	6.49	402158.0
2013-03-18	AACG	Stock	3.98	4.03	3.98	4.03	700.0
2013-03-18	AAIC-DELISTED	Stock	25.95	26.02	25.59	25.81	371315.0
2013-03-18	AAMC-DELISTED	Stock	41.1765	42.0588	40.9559	41.5441	20046.0
2013-03-18	AAME	Stock	3.36	3.36	3.3	3.33	2200.0
2013-03-18	AAMRQ-DELISTED	Stock	3.75	3.92	3.43	3.85	11654499.0
2013-03-18	AAON	Stock	7.7452	7.8281	7.7422	7.7837	397238.0
2013-03-18	AAP	Stock	79.09	80.76	79.01	80.7	1219200.0
2013-03-18	AAT	Stock	31.95	32.31	31.89	32.31	158100.0
2013-03-18	AAU-DELISTED	Stock	2.13	2.2	2.09	2.1	117760.0
2013-03-18	AAUAF-DELISTED	Stock	2.15	2.2	2.1	2.1	116944.0
2013-03-18	AAV-DELISTED	Stock	3.48	3.48	3.4	3.43	268650.0
2013-03-18	AAWW-DELISTED	Stock	44.06	44.69	44.06	44.41	135660.0
2013-03-18	AAXJ	Stock	58.46	58.46	58.1	58.17	838983.0
2013-03-18	AAXN-DELISTED	Stock	7.7	7.89	7.67	7.8	475582.0
2013-03-18	AB	Stock	21.87	21.97	21.5	21.66	301200.0
2013-03-18	ABAC-DELISTED	Stock	0.709	0.76	0.7	0.7	31403.0
2013-03-18	ABAX-DELISTED	Stock	45.53	46.62	45.11	46.08	116571.0
2013-03-18	ABB-DELISTED	Stock	22.69	22.93	22.6	22.67	1583555.0
2013-03-18	ABBNY-DELISTED	Stock	22.69	22.93	22.6	22.66	1609966.0
2013-03-18	ABBV	Stock	38.05	38.49	37.99	38.16	5178700.0
2013-03-18	ABC-DELISTED	Stock	48.32	48.67	48.16	48.29	2523552.0
2013-03-18	ABCB	Stock	14.33	14.49	14.26	14.39	23000.0
2013-03-18	ABCD-DELISTED	Stock	1.05	1.1	1.05	1.1	11488.0
2013-03-18	ABCO-DELISTED	Stock	49.4	49.52	48.82	49.31	328579.0
2013-03-18	ABCW-DELISTED	Stock	0.55	0.62	0.55	0.61	12811.0
2013-03-18	ABE-DELISTED	Stock	21.15	21.15	20.16	21.02	8162.0
2013-03-18	ABEO	Stock	750.0	750.0	687.5	750.0	6.0
2013-03-18	ABFS-DELISTED	Stock	12.2	12.699	12.02	12.615	174846.0
2013-03-18	ABG	Stock	37.46	37.6	36.56	37.19	550700.0
2013-03-18	ABM	Stock	21.85	22.12	21.85	22.01	229500.0
2013-03-18	ABMD-DELISTED	Stock	17.38	17.59	17.13	17.57	322125.0
2013-03-18	ABR	Stock	8.19	8.24	8.05	8.22	185100.0
2013-03-18	ABR.A-DELISTED	Stock	25.48	25.5	25.3699	25.49	12874.0
2013-03-18	ABT	Stock	33.94	34.01	33.44	33.46	8895900.0
2013-03-18	ABTL-DELISTED	Stock	4.14	4.21	4.14	4.21	19300.0
2013-03-18	ABUS	Stock	4.18	4.48	4.18	4.48	11500.0
2013-03-18	ABV-DELISTED	Stock	42.6	43.33	42.41	43.03	1778584.0
2013-03-18	ABX-DELISTED	Stock	29.07	29.34	28.82	28.85	6899457.0

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

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