PREVIEW / stock_daily / 2012-11-29

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-29.parquet
  size:    200 KB
  rows:    6,188
  symbols: 3,506

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-11-29	AAPL	Stock	21.0793	21.2232	20.9018	21.0486	514698800.0
2012-11-29	MSFT	Stock	27.11	27.36	26.86	26.95	69551400.0
2012-11-29	NVDA	Stock	0.307	0.3085	0.3	0.301	488688000.0
2012-11-29	AMZN	Stock	12.4025	12.624	12.375	12.5635	106210000.0
2012-11-29	META	Stock	26.5	27.52	26.16	27.32	88759700.0
2012-11-29	TSLA	Stock	2.2293	2.2667	2.1913	2.246	16551000.0
2012-11-29	TLT	Stock	124.86	125.44	124.66	125.13	2760924.0
2012-11-29	ES	Stock	38.16	38.27	37.81	38.16	1555200.0
2012-11-29	CL	Stock	53.97	54.165	53.7	54.005	1873000.0
2012-11-29	A	Stock	27.2461	27.5966	27.1888	27.4249	5551178.0
2012-11-29	AABA-DELISTED	Stock	18.95	19.03	18.85	18.862	26464993.0
2012-11-29	AACC-DELISTED	Stock	4.89	5.81	4.89	5.33	37389.0
2012-11-29	AACG	Stock	4.23	4.28	4.13	4.18	7600.0
2012-11-29	AAIC-DELISTED	Stock	21.15	21.5464	21.13	21.37	121777.0
2012-11-29	AAMRQ-DELISTED	Stock	0.4505	0.459	0.4411	0.459	2175547.0
2012-11-29	AAON	Stock	6.3052	6.4563	6.2963	6.3407	724950.0
2012-11-29	AAP	Stock	71.45	74.05	71.36	73.93	3211200.0
2012-11-29	AAT	Stock	27.95	27.95	27.27	27.34	251300.0
2012-11-29	AAU-DELISTED	Stock	2.8	2.86	2.7	2.73	118116.0
2012-11-29	AAUAF-DELISTED	Stock	2.8	2.86	2.7	2.75	118416.0
2012-11-29	AAV-DELISTED	Stock	3.28	3.4	3.27	3.34	220843.0
2012-11-29	AAWW-DELISTED	Stock	43.23	43.72	43.19	43.4	170407.0
2012-11-29	AAXJ	Stock	57.79	58.14	57.76	58.05	164381.0
2012-11-29	AAXN-DELISTED	Stock	8.63	8.67	8.15	8.27	1701169.0
2012-11-29	AB	Stock	18.03	18.1	17.87	17.94	262800.0
2012-11-29	ABAC-DELISTED	Stock	0.92	0.92	0.8	0.8101	14400.0
2012-11-29	ABAX-DELISTED	Stock	37.0	38.44	36.955	37.77	117967.0
2012-11-29	ABB-DELISTED	Stock	19.39	19.47	19.24	19.38	1804254.0
2012-11-29	ABBNY-DELISTED	Stock	19.39	19.47	19.24	19.39	1874543.0
2012-11-29	ABC-DELISTED	Stock	41.49	41.78	41.34	41.53	2516684.0
2012-11-29	ABCB	Stock	11.11	11.41	11.06	11.38	20000.0
2012-11-29	ABCD-DELISTED	Stock	1.01	1.01	0.92	0.93	16808.0
2012-11-29	ABCO-DELISTED	Stock	44.07	45.24	43.96	44.96	149784.0
2012-11-29	ABCW-DELISTED	Stock	0.38	0.42	0.38	0.381	6336.0
2012-11-29	ABE-DELISTED	Stock	20.15	20.4401	20.15	20.44	31854.0
2012-11-29	ABEO	Stock	437.5	437.5	375.0	387.5	80.0
2012-11-29	ABFS-DELISTED	Stock	8.5	8.65	8.42	8.55	226182.0
2012-11-29	ABG	Stock	30.0	30.25	29.82	30.16	363900.0
2012-11-29	ABM	Stock	19.18	19.38	18.97	19.06	285600.0
2012-11-29	ABMD-DELISTED	Stock	14.32	14.54	13.925	13.93	420969.0
2012-11-29	ABR	Stock	5.22	5.25	5.16	5.2	125200.0
2012-11-29	ABT	Stock	31.115	31.2878	30.9807	31.2254	10914548.0
2012-11-29	ABTL-DELISTED	Stock	3.8	3.84	3.76	3.8	10430.0
2012-11-29	ABUS	Stock	5.25	5.25	5.04	5.09	43000.0
2012-11-29	ABV-DELISTED	Stock	40.6	40.98	40.33	40.75	2044876.0
2012-11-29	ABVA-DELISTED	Stock	4.74	4.7736	4.66	4.75	29019.0
2012-11-29	ABX-DELISTED	Stock	35.13	35.27	34.6	34.89	5445290.0
2012-11-29	ACAD	Stock	5.15	5.5	5.0	5.37	6533500.0
2012-11-29	ACAS-DELISTED	Stock	11.91	11.955	11.825	11.94	1639269.0
2012-11-29	ACAT-DELISTED	Stock	37.57	38.36	37.45	37.78	81742.0

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

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