PREVIEW / stock_daily / 2013-11-04

all stock daily files

  file:    by_date/stock_daily/2013/2013-11-04.parquet
  size:    214 KB
  rows:    6,423
  symbols: 3,538

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-11-04	AAPL	Stock	18.6107	18.815	18.5289	18.8125	244627600.0
2013-11-04	MSFT	Stock	35.59	35.98	35.55	35.94	28060700.0
2013-11-04	NVDA	Stock	0.3828	0.3828	0.3698	0.3705	410264000.0
2013-11-04	AMZN	Stock	18.006	18.05	17.72	17.937	38768000.0
2013-11-04	META	Stock	49.37	49.75	48.02	48.22	80371000.0
2013-11-04	TSLA	Stock	11.0	11.6927	10.948	11.68	196806000.0
2013-11-04	TLT	Stock	106.47	106.67	106.22	106.29	4733187.0
2013-11-04	ES	Stock	42.58	42.75	42.29	42.67	876300.0
2013-11-04	CL	Stock	65.56	65.8	65.21	65.73	2657200.0
2013-11-04	A	Stock	36.7597	36.8097	36.4449	36.6309	1971040.0
2013-11-04	AABA-DELISTED	Stock	33.17	33.64	33.01	33.19	14223560.0
2013-11-04	AACG	Stock	4.11	4.24	4.11	4.14	11900.0
2013-11-04	AAIC-DELISTED	Stock	24.59	24.769	24.3501	24.69	125416.0
2013-11-04	AAMC-DELISTED	Stock	187.6471	191.1765	185.2941	188.2353	52020.0
2013-11-04	AAME	Stock	4.04	4.05	4.01	4.05	5400.0
2013-11-04	AAMRQ-DELISTED	Stock	8.005	10.05	8.0	9.84	40423773.0
2013-11-04	AAOI	Stock	12.85	13.0	12.85	13.0	67700.0
2013-11-04	AAON	Stock	12.1244	12.2133	12.0356	12.1422	216675.0
2013-11-04	AAP	Stock	99.86	100.27	99.32	99.38	675900.0
2013-11-04	AAT	Stock	33.35	33.73	33.05	33.62	301800.0
2013-11-04	AAU-DELISTED	Stock	1.3	1.33	1.3	1.3	63397.0
2013-11-04	AAUAF-DELISTED	Stock	1.3	1.33	1.3	1.3	63497.0
2013-11-04	AAV-DELISTED	Stock	4.01	4.04	3.88	3.89	410659.0
2013-11-04	AAWW-DELISTED	Stock	38.65	39.48	38.65	38.93	479905.0
2013-11-04	AAXJ	Stock	60.55	60.55	60.3	60.48	260325.0
2013-11-04	AAXN-DELISTED	Stock	16.87	17.82	16.87	17.31	1613029.0
2013-11-04	AB	Stock	22.71	22.75	22.26	22.53	217600.0
2013-11-04	ABAC-DELISTED	Stock	1.5	1.64	1.5	1.57	19148.0
2013-11-04	ABAX-DELISTED	Stock	36.01	36.91	35.885	36.2	204277.0
2013-11-04	ABB-DELISTED	Stock	25.14	25.34	25.13	25.33	853765.0
2013-11-04	ABBNY-DELISTED	Stock	25.14	25.34	25.11	25.31	863977.0
2013-11-04	ABBV	Stock	49.19	49.19	48.0	48.76	4095600.0
2013-11-04	ABC-DELISTED	Stock	66.5	67.1	66.25	67.08	2667650.0
2013-11-04	ABCB	Stock	17.99	18.09	17.78	17.84	72300.0
2013-11-04	ABCD-DELISTED	Stock	1.34	1.38	1.32	1.32	4513.0
2013-11-04	ABCO-DELISTED	Stock	68.81	70.11	68.45	69.41	404787.0
2013-11-04	ABE-DELISTED	Stock	20.01	20.21	20.01	20.19	25696.0
2013-11-04	ABEO	Stock	387.5	425.0	387.5	412.5	23.0
2013-11-04	ABFS-DELISTED	Stock	27.43	28.42	27.3725	28.25	516208.0
2013-11-04	ABG	Stock	48.85	50.02	48.34	49.82	302800.0
2013-11-04	ABGB-DELISTED	Stock	12.0	12.09	11.922	12.03	7987.0
2013-11-04	ABM	Stock	27.86	28.04	27.59	27.74	301700.0
2013-11-04	ABMD-DELISTED	Stock	24.37	25.0	23.56	24.85	638284.0
2013-11-04	ABR	Stock	6.65	6.74	6.57	6.6	116500.0
2013-11-04	ABR.A-DELISTED	Stock	25.3	25.3	25.05	25.051	4700.0
2013-11-04	ABR.B-DELISTED	Stock	23.35	23.51	23.35	23.5	1000.0
2013-11-04	ABT	Stock	36.98	37.02	36.69	36.98	5645300.0
2013-11-04	ABTL-DELISTED	Stock	7.6	8.584	7.49	8.55	156123.0
2013-11-04	ABUS	Stock	8.92	9.06	8.76	8.97	162800.0
2013-11-04	ABV-DELISTED	Stock	37.14	37.27	36.87	37.06	1375586.0

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

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