PREVIEW / stock_daily / 2013-08-01

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-01.parquet
  size:    214 KB
  rows:    6,394
  symbols: 3,549

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-08-01	AAPL	Stock	16.2768	16.3143	16.1879	16.31	206250800.0
2013-08-01	MSFT	Stock	32.06	32.09	31.6	31.67	42557900.0
2013-08-01	NVDA	Stock	0.3622	0.3668	0.358	0.366	277648000.0
2013-08-01	AMZN	Stock	15.154	15.3105	14.945	15.2785	59434000.0
2013-08-01	META	Stock	37.3	38.29	36.92	37.49	106066500.0
2013-08-01	TSLA	Stock	9.0	9.1013	8.842	9.0367	79854000.0
2013-08-01	TLT	Stock	106.49	106.49	105.0	105.3601	13568578.0
2013-08-01	ES	Stock	44.6	45.13	44.5	45.05	1430400.0
2013-08-01	CL	Stock	60.27	60.82	60.24	60.56	2799300.0
2013-08-01	A	Stock	32.5536	33.0472	32.4177	32.9328	3827025.0
2013-08-01	AABA-DELISTED	Stock	28.35	28.45	27.91	27.96	12986819.0
2013-08-01	AACG	Stock	5.2	5.2	5.0	5.0	11500.0
2013-08-01	AAIC-DELISTED	Stock	25.45	25.6	25.0	25.06	154824.0
2013-08-01	AAMC-DELISTED	Stock	101.4706	104.4265	101.4706	104.1912	157658.0
2013-08-01	AAME	Stock	3.87	3.9	3.87	3.89	2900.0
2013-08-01	AAMRQ-DELISTED	Stock	6.105	6.2	5.95	6.04	11624739.0
2013-08-01	AAON	Stock	9.6533	10.0667	9.5733	10.0044	530550.0
2013-08-01	AAP	Stock	83.17	83.72	82.47	83.43	912800.0
2013-08-01	AAT	Stock	32.64	32.95	32.35	32.57	163300.0
2013-08-01	AAU-DELISTED	Stock	1.75	1.77	1.71	1.75	68951.0
2013-08-01	AAUAF-DELISTED	Stock	1.75	1.77	1.71	1.75	69151.0
2013-08-01	AAV-DELISTED	Stock	3.65	3.76	3.65	3.72	311427.0
2013-08-01	AAWW-DELISTED	Stock	44.55	45.23	43.42	43.92	385976.0
2013-08-01	AAXJ	Stock	56.49	56.89	56.42	56.78	1754583.0
2013-08-01	AAXN-DELISTED	Stock	8.98	9.052	8.89	8.9	337069.0
2013-08-01	AB	Stock	22.72	22.95	22.26	22.85	215700.0
2013-08-01	ABAC-DELISTED	Stock	0.6511	0.6511	0.62	0.6301	8550.0
2013-08-01	ABAX-DELISTED	Stock	41.96	42.18	40.72	40.96	232172.0
2013-08-01	ABB-DELISTED	Stock	22.15	22.23	22.07	22.14	1212200.0
2013-08-01	ABBNY-DELISTED	Stock	22.15	22.23	22.07	22.13	1241933.0
2013-08-01	ABBV	Stock	45.14	45.9	45.04	45.25	3652400.0
2013-08-01	ABC-DELISTED	Stock	58.39	59.115	58.37	58.81	1728224.0
2013-08-01	ABCB	Stock	19.55	19.58	18.13	19.5	73600.0
2013-08-01	ABCD-DELISTED	Stock	1.36	1.4001	1.36	1.4	28074.0
2013-08-01	ABCO-DELISTED	Stock	58.5	59.11	57.02	58.84	236958.0
2013-08-01	ABCW-DELISTED	Stock	0.4	0.43	0.37	0.43	53251.0
2013-08-01	ABE-DELISTED	Stock	19.87	19.99	19.43	19.9	6510.0
2013-08-01	ABEO	Stock	500.0	550.0	437.5	537.5	25.0
2013-08-01	ABFS-DELISTED	Stock	21.95	22.91	21.885	22.77	346826.0
2013-08-01	ABG	Stock	49.19	50.99	49.13	50.87	389800.0
2013-08-01	ABM	Stock	26.05	26.2	25.96	26.14	109500.0
2013-08-01	ABMD-DELISTED	Stock	25.22	25.22	22.9312	24.16	1345281.0
2013-08-01	ABR	Stock	7.6	7.63	7.4	7.51	138100.0
2013-08-01	ABR.A-DELISTED	Stock	25.36	25.3601	25.16	25.3499	2550.0
2013-08-01	ABR.B-DELISTED	Stock	24.2401	24.28	24.2399	24.28	5775.0
2013-08-01	ABT	Stock	36.89	37.07	36.68	36.84	7479900.0
2013-08-01	ABTL-DELISTED	Stock	5.45	5.7	5.35	5.61	67012.0
2013-08-01	ABUS	Stock	5.5	5.68	5.36	5.68	203400.0
2013-08-01	ABV-DELISTED	Stock	38.05	39.0	38.025	38.48	6422568.0
2013-08-01	ABX-DELISTED	Stock	17.34	17.42	16.79	16.81	18643726.0

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

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