PREVIEW / stock_daily / 2013-01-17

all stock daily files

  file:    by_date/stock_daily/2013/2013-01-17.parquet
  size:    204 KB
  rows:    6,211
  symbols: 3,490

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-01-17	AAPL	Stock	18.2254	18.2411	17.9296	17.9529	453678400.0
2013-01-17	MSFT	Stock	27.19	27.47	27.06	27.25	51685900.0
2013-01-17	NVDA	Stock	0.3032	0.3075	0.3025	0.3062	580736000.0
2013-01-17	AMZN	Stock	13.575	13.5985	13.4605	13.524	37692000.0
2013-01-17	META	Stock	30.08	30.42	30.03	30.14	40256700.0
2013-01-17	TSLA	Stock	2.2773	2.3233	2.2613	2.292	21550500.0
2013-01-17	TLT	Stock	119.33	119.55	118.75	119.12	7019198.0
2013-01-17	ES	Stock	38.79	38.86	38.6	38.7	3487600.0
2013-01-17	CL	Stock	54.175	54.645	54.09	54.47	1881200.0
2013-01-17	A	Stock	31.216	31.7811	31.1302	31.3805	6639382.0
2013-01-17	AABA-DELISTED	Stock	20.12	20.205	20.0	20.13	14201501.0
2013-01-17	AACC-DELISTED	Stock	4.62	4.88	4.6	4.79	36244.0
2013-01-17	AACG	Stock	5.65	5.65	5.52	5.55	3800.0
2013-01-17	AAIC-DELISTED	Stock	22.76	22.93	22.6	22.78	158763.0
2013-01-17	AAMC-DELISTED	Stock	30.8824	31.7647	29.1176	30.0324	112676.0
2013-01-17	AAME	Stock	3.28	3.29	3.25	3.29	1800.0
2013-01-17	AAMRQ-DELISTED	Stock	1.505	1.57	1.44	1.45	11453673.0
2013-01-17	AAON	Stock	6.5126	6.5956	6.5037	6.5867	105638.0
2013-01-17	AAP	Stock	73.15	74.23	73.1	73.42	449700.0
2013-01-17	AAT	Stock	28.69	29.03	28.64	28.68	137300.0
2013-01-17	AAU-DELISTED	Stock	3.23	3.2701	3.22	3.22	251566.0
2013-01-17	AAUAF-DELISTED	Stock	3.22	3.26	3.21	3.23	252745.0
2013-01-17	AAV-DELISTED	Stock	3.28	3.34	3.25	3.27	203212.0
2013-01-17	AAWW-DELISTED	Stock	43.56	45.58	43.36	45.33	342736.0
2013-01-17	AAXJ	Stock	60.89	61.3	60.83	61.06	1202679.0
2013-01-17	AAXN-DELISTED	Stock	9.3	9.56	9.15	9.42	845250.0
2013-01-17	AB	Stock	19.96	20.09	19.92	20.01	441500.0
2013-01-17	ABAC-DELISTED	Stock	0.9	0.9504	0.9	0.9504	4300.0
2013-01-17	ABAX-DELISTED	Stock	39.48	40.16	38.59	38.8	116617.0
2013-01-17	ABB-DELISTED	Stock	21.31	21.37	21.05	21.134	2873419.0
2013-01-17	ABBNY-DELISTED	Stock	21.31	21.37	21.05	21.14	2914497.0
2013-01-17	ABBV	Stock	35.75	36.7	35.75	36.42	14424800.0
2013-01-17	ABC-DELISTED	Stock	45.27	45.68	45.212	45.53	1366253.0
2013-01-17	ABCB	Stock	12.84	12.95	12.7	12.93	25900.0
2013-01-17	ABCD-DELISTED	Stock	1.2	1.25	1.2	1.21	15800.0
2013-01-17	ABCO-DELISTED	Stock	52.65	52.65	51.86	52.12	122046.0
2013-01-17	ABCW-DELISTED	Stock	0.59	0.76	0.59	0.72	175276.0
2013-01-17	ABE-DELISTED	Stock	21.74	22.04	21.74	21.92	4277.0
2013-01-17	ABFS-DELISTED	Stock	10.28	10.49	10.12	10.39	189812.0
2013-01-17	ABG	Stock	33.49	33.8	33.03	33.58	198700.0
2013-01-17	ABM	Stock	20.6	20.84	20.59	20.74	583600.0
2013-01-17	ABMD-DELISTED	Stock	12.56	12.99	12.54	12.85	488203.0
2013-01-17	ABR	Stock	7.01	7.35	7.01	7.17	450000.0
2013-01-17	ABT	Stock	32.85	32.97	32.67	32.78	20270400.0
2013-01-17	ABTL-DELISTED	Stock	3.95	4.0	3.95	3.991	23651.0
2013-01-17	ABUS	Stock	5.14	5.14	5.03	5.14	17400.0
2013-01-17	ABV-DELISTED	Stock	44.26	45.05	44.23	44.83	1357264.0
2013-01-17	ABX-DELISTED	Stock	33.96	34.36	33.51	34.05	8745206.0
2013-01-17	ACAD	Stock	5.48	5.48	5.25	5.38	1534100.0
2013-01-17	ACAS-DELISTED	Stock	13.25	13.3399	13.09	13.175	2855131.0

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

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