PREVIEW / stock_daily / 2012-10-24

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-24.parquet
  size:    199 KB
  rows:    6,167
  symbols: 3,484

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
2012-10-24	AAPL	Stock	22.1943	22.3768	21.8086	22.0296	558527200.0
2012-10-24	MSFT	Stock	28.16	28.2	27.87	27.9	53320400.0
2012-10-24	NVDA	Stock	0.3103	0.3115	0.3012	0.3042	332916000.0
2012-10-24	AMZN	Stock	11.794	11.797	11.3975	11.4245	73574000.0
2012-10-24	META	Stock	24.13	24.25	22.85	23.23	228949900.0
2012-10-24	TSLA	Stock	1.9013	1.9013	1.8167	1.828	15246000.0
2012-10-24	TLT	Stock	121.86	122.2883	121.48	121.48	6824490.0
2012-10-24	ES	Stock	39.15	39.19	38.8	38.83	716400.0
2012-10-24	CL	Stock	53.51	53.755	53.085	53.28	2859200.0
2012-10-24	A	Stock	25.4936	25.7296	25.3505	25.6438	5719498.0
2012-10-24	AABA-DELISTED	Stock	16.78	16.8	16.48	16.56	24486459.0
2012-10-24	AACC-DELISTED	Stock	7.2	7.2483	7.0	7.15	4449.0
2012-10-24	AACG	Stock	5.14	5.14	5.14	5.14	100.0
2012-10-24	AAIC-DELISTED	Stock	21.68	21.9	21.42	21.63	129148.0
2012-10-24	AAME	Stock	2.89	2.89	2.89	2.89	500.0
2012-10-24	AAMRQ-DELISTED	Stock	0.366	0.372	0.363	0.368	314977.0
2012-10-24	AAON	Stock	6.0533	6.0741	5.9081	5.9911	77625.0
2012-10-24	AAP	Stock	67.49	67.62	66.04	66.85	835800.0
2012-10-24	AAT	Stock	27.59	27.64	27.36	27.47	71600.0
2012-10-24	AAU-DELISTED	Stock	2.59	2.64	2.57	2.6	73748.0
2012-10-24	AAUAF-DELISTED	Stock	2.56	2.61	2.54	2.6	74904.0
2012-10-24	AAV-DELISTED	Stock	3.6	3.6798	3.49	3.5	258932.0
2012-10-24	AAWW-DELISTED	Stock	52.63	53.2129	52.06	52.7	84176.0
2012-10-24	AAXJ	Stock	56.68	56.68	56.2	56.33	521116.0
2012-10-24	AAXN-DELISTED	Stock	6.52	6.65	6.46	6.51	496002.0
2012-10-24	AB	Stock	15.79	15.98	15.57	15.57	235600.0
2012-10-24	ABAC-DELISTED	Stock	1.36	1.37	1.33	1.37	11050.0
2012-10-24	ABAX-DELISTED	Stock	36.57	36.57	33.28	34.35	394744.0
2012-10-24	ABB-DELISTED	Stock	18.91	18.92	18.74	18.77	1427716.0
2012-10-24	ABBNY-DELISTED	Stock	18.91	18.92	18.74	18.77	1558271.0
2012-10-24	ABC-DELISTED	Stock	39.97	40.16	39.63	39.66	1640747.0
2012-10-24	ABCB	Stock	11.94	11.94	11.15	11.27	130700.0
2012-10-24	ABCD-DELISTED	Stock	0.94	1.0	0.94	0.94	6718.0
2012-10-24	ABCO-DELISTED	Stock	46.37	46.86	46.0	46.35	44860.0
2012-10-24	ABCW-DELISTED	Stock	0.37	0.375	0.36	0.37	29532.0
2012-10-24	ABE-DELISTED	Stock	20.57	20.64	20.54	20.63	3800.0
2012-10-24	ABEO	Stock	437.5	437.5	325.0	325.0	2.0
2012-10-24	ABFS-DELISTED	Stock	7.81	7.9	7.67	7.75	159908.0
2012-10-24	ABG	Stock	31.02	31.64	30.79	31.24	291200.0
2012-10-24	ABM	Stock	18.32	18.32	17.99	18.08	376700.0
2012-10-24	ABMD-DELISTED	Stock	18.8	19.01	18.54	18.7	313133.0
2012-10-24	ABR	Stock	5.46	5.5	5.4	5.46	92600.0
2012-10-24	ABT	Stock	31.4221	31.7148	31.1294	31.4557	15727803.0
2012-10-24	ABTL-DELISTED	Stock	3.9	3.98	3.9	3.98	4100.0
2012-10-24	ABUS	Stock	3.95	3.95	3.81	3.95	14900.0
2012-10-24	ABV-DELISTED	Stock	40.94	41.07	40.36	40.41	1878553.0
2012-10-24	ABVA-DELISTED	Stock	4.46	4.46	4.46	4.46	184.0
2012-10-24	ABX-DELISTED	Stock	39.24	39.27	38.32	38.49	7303083.0
2012-10-24	ACAD	Stock	2.31	2.32	2.15	2.18	1157400.0
2012-10-24	ACAS-DELISTED	Stock	11.79	11.85	11.67	11.78	1820353.0

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

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