PREVIEW / stock_daily / 2013-04-23

all stock daily files

  file:    by_date/stock_daily/2013/2013-04-23.parquet
  size:    207 KB
  rows:    6,278
  symbols: 3,488

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-04-23	AAPL	Stock	14.4282	14.585	14.2432	14.5046	664238400.0
2013-04-23	MSFT	Stock	30.7	30.9	30.38	30.6	59126900.0
2013-04-23	NVDA	Stock	0.3175	0.3263	0.317	0.323	376948000.0
2013-04-23	AMZN	Stock	13.225	13.4935	13.225	13.445	45412000.0
2013-04-23	META	Stock	26.22	26.33	25.77	25.98	25191500.0
2013-04-23	TSLA	Stock	3.4	3.528	3.3773	3.4007	56007000.0
2013-04-23	TLT	Stock	123.26	123.79	122.38	122.49	8043281.0
2013-04-23	ES	Stock	44.68	44.8	44.3	44.8	1506200.0
2013-04-23	CL	Stock	60.28	60.72	59.83	60.715	3784800.0
2013-04-23	A	Stock	30.1931	30.6438	30.1359	30.4793	4924455.0
2013-04-23	AABA-DELISTED	Stock	23.96	24.45	23.96	24.37	15392064.0
2013-04-23	AACC-DELISTED	Stock	6.48	6.51	6.48	6.5	93350.0
2013-04-23	AACG	Stock	3.97	3.97	3.97	3.97	300.0
2013-04-23	AAIC-DELISTED	Stock	25.67	26.06	25.53	26.05	240310.0
2013-04-23	AAMC-DELISTED	Stock	40.8824	43.6765	40.8824	42.9412	17201.0
2013-04-23	AAME	Stock	3.41	3.43	3.4	3.4	6000.0
2013-04-23	AAMRQ-DELISTED	Stock	3.63	3.94	3.61	3.89	11241504.0
2013-04-23	AAON	Stock	8.1244	8.3881	8.1126	8.3348	130950.0
2013-04-23	AAP	Stock	79.55	81.23	79.53	80.55	654600.0
2013-04-23	AAT	Stock	32.96	33.16	32.63	33.03	86700.0
2013-04-23	AAU-DELISTED	Stock	1.62	1.65	1.51	1.56	93112.0
2013-04-23	AAUAF-DELISTED	Stock	1.62	1.65	1.51	1.55	93235.0
2013-04-23	AAV-DELISTED	Stock	3.64	3.73	3.62	3.7	157886.0
2013-04-23	AAWW-DELISTED	Stock	38.56	38.62	37.99	38.59	217363.0
2013-04-23	AAXJ	Stock	58.37	58.692	58.26	58.55	352573.0
2013-04-23	AAXN-DELISTED	Stock	8.02	8.15	8.01	8.14	309253.0
2013-04-23	AB	Stock	22.73	23.0	22.58	22.93	192700.0
2013-04-23	ABAC-DELISTED	Stock	0.7	0.73	0.7	0.729	12330.0
2013-04-23	ABAX-DELISTED	Stock	44.5	44.98	43.99	44.68	150037.0
2013-04-23	ABB-DELISTED	Stock	21.61	21.9	21.57	21.73	1925011.0
2013-04-23	ABBNY-DELISTED	Stock	21.61	21.9	21.57	21.72	2180938.0
2013-04-23	ABBV	Stock	44.61	46.32	44.4	45.14	9378100.0
2013-04-23	ABC-DELISTED	Stock	56.39	56.91	55.94	56.28	2071664.0
2013-04-23	ABCB	Stock	13.55	14.0	13.52	14.0	26700.0
2013-04-23	ABCD-DELISTED	Stock	0.96	0.96	0.95	0.95	4100.0
2013-04-23	ABCO-DELISTED	Stock	47.35	48.03	46.62	47.15	224938.0
2013-04-23	ABCW-DELISTED	Stock	0.63	0.67	0.62	0.631	32070.0
2013-04-23	ABE-DELISTED	Stock	21.309	21.309	20.74	20.74	10460.0
2013-04-23	ABEO	Stock	500.0	500.0	450.0	487.5	20.0
2013-04-23	ABFS-DELISTED	Stock	11.06	11.75	11.03	11.675	361578.0
2013-04-23	ABG	Stock	35.11	35.59	34.77	35.55	237200.0
2013-04-23	ABM	Stock	20.77	20.97	20.63	20.9	163300.0
2013-04-23	ABMD-DELISTED	Stock	17.88	18.04	17.71	17.96	163424.0
2013-04-23	ABR	Stock	7.27	7.41	7.23	7.39	170800.0
2013-04-23	ABR.A-DELISTED	Stock	25.99	25.99	25.84	25.9	9573.0
2013-04-23	ABT	Stock	37.11	37.34	36.86	37.21	5291200.0
2013-04-23	ABTL-DELISTED	Stock	4.1048	4.17	4.07	4.17	34146.0
2013-04-23	ABUS	Stock	4.78	4.86	4.66	4.84	102800.0
2013-04-23	ABV-DELISTED	Stock	39.42	40.22	39.33	39.99	2509400.0
2013-04-23	ABX-DELISTED	Stock	17.83	18.03	17.53	17.59	21043554.0

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

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