PREVIEW / stock_daily / 2013-05-03

all stock daily files

  file:    by_date/stock_daily/2013/2013-05-03.parquet
  size:    210 KB
  rows:    6,331
  symbols: 3,523

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-05-03	AAPL	Stock	16.1182	16.1868	16.0411	16.0707	361300800.0
2013-05-03	MSFT	Stock	33.23	33.52	33.08	33.49	46784600.0
2013-05-03	NVDA	Stock	0.3475	0.3493	0.3455	0.3468	293864000.0
2013-05-03	AMZN	Stock	12.807	12.9625	12.735	12.9025	70280000.0
2013-05-03	META	Stock	29.04	29.07	28.15	28.31	58506400.0
2013-05-03	TSLA	Stock	3.7647	3.7647	3.6333	3.6367	50680500.0
2013-05-03	TLT	Stock	122.16	122.19	120.83	120.93	11283678.0
2013-05-03	ES	Stock	45.47	45.66	45.02	45.16	1430300.0
2013-05-03	CL	Stock	60.635	60.78	60.05	60.575	2120800.0
2013-05-03	A	Stock	29.9928	30.4363	29.7139	29.721	6626660.0
2013-05-03	AABA-DELISTED	Stock	25.13	25.25	24.99	25.07	10216416.0
2013-05-03	AACC-DELISTED	Stock	6.52	6.52	6.47	6.51	205221.0
2013-05-03	AACG	Stock	3.99	4.0	3.99	4.0	1100.0
2013-05-03	AAIC-DELISTED	Stock	27.08	27.25	26.7	26.88	229026.0
2013-05-03	AAMC-DELISTED	Stock	57.3529	60.2647	57.3529	59.7059	13665.0
2013-05-03	AAME	Stock	3.43	3.57	3.43	3.55	1400.0
2013-05-03	AAMRQ-DELISTED	Stock	4.33	4.43	4.33	4.33	3935011.0
2013-05-03	AAON	Stock	8.2637	8.563	8.2637	8.4415	147825.0
2013-05-03	AAP	Stock	85.02	85.74	84.14	84.56	694600.0
2013-05-03	AAT	Stock	35.72	36.04	35.34	35.48	125300.0
2013-05-03	AAU-DELISTED	Stock	1.6	1.635	1.5555	1.61	95087.0
2013-05-03	AAUAF-DELISTED	Stock	1.61	1.65	1.57	1.61	94854.0
2013-05-03	AAV-DELISTED	Stock	3.75	3.87	3.72	3.84	355075.0
2013-05-03	AAWW-DELISTED	Stock	39.89	43.03	39.89	41.66	427192.0
2013-05-03	AAXJ	Stock	60.25	60.69	60.19	60.43	427966.0
2013-05-03	AAXN-DELISTED	Stock	8.84	8.98	8.69	8.78	522020.0
2013-05-03	AB	Stock	24.78	24.83	24.22	24.41	385700.0
2013-05-03	ABAC-DELISTED	Stock	0.71	0.7124	0.68	0.699	8850.0
2013-05-03	ABAX-DELISTED	Stock	43.58	44.44	42.81	42.95	174790.0
2013-05-03	ABB-DELISTED	Stock	22.65	22.88	22.64	22.67	1084528.0
2013-05-03	ABBNY-DELISTED	Stock	22.65	22.88	22.64	22.66	1114196.0
2013-05-03	ABBV	Stock	44.31	44.77	43.83	44.68	4641200.0
2013-05-03	ABC-DELISTED	Stock	55.01	55.08	54.42	54.56	1839591.0
2013-05-03	ABCB	Stock	14.3	15.04	14.3	14.95	171000.0
2013-05-03	ABCD-DELISTED	Stock	0.951	0.951	0.95	0.95	24225.0
2013-05-03	ABCO-DELISTED	Stock	50.04	50.04	47.98	48.11	356462.0
2013-05-03	ABCW-DELISTED	Stock	0.65	0.65	0.621	0.649	9100.0
2013-05-03	ABE-DELISTED	Stock	21.49	21.679	21.4	21.64	3095.0
2013-05-03	ABEO	Stock	600.0	600.0	537.5	575.0	33.0
2013-05-03	ABFS-DELISTED	Stock	9.99	10.97	9.99	10.54	498405.0
2013-05-03	ABG	Stock	41.01	41.61	40.72	40.78	246400.0
2013-05-03	ABM	Stock	22.41	22.94	22.27	22.64	482100.0
2013-05-03	ABMD-DELISTED	Stock	19.95	20.1	19.685	19.72	534248.0
2013-05-03	ABR	Stock	7.69	7.74	7.25	7.42	270400.0
2013-05-03	ABR.A-DELISTED	Stock	26.04	26.15	26.0	26.14	8945.0
2013-05-03	ABT	Stock	37.25	37.25	36.61	36.8	5363500.0
2013-05-03	ABTL-DELISTED	Stock	4.49	4.65	4.22	4.27	24718.0
2013-05-03	ABUS	Stock	4.66	4.77	4.65	4.77	19000.0
2013-05-03	ABV-DELISTED	Stock	40.64	41.64	40.5	41.541	3682766.0
2013-05-03	ABX-DELISTED	Stock	19.79	20.1	19.63	20.01	18777647.0

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

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