PREVIEW / stock_daily / 2011-12-20

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-20.parquet
  size:    198 KB
  rows:    6,232
  symbols: 3,604

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
2011-12-20	AAPL	Stock	13.8486	14.1464	13.8307	14.1411	337215200.0
2011-12-20	MSFT	Stock	25.86	26.1	25.81	26.03	60767600.0
2011-12-20	NVDA	Stock	0.3365	0.3488	0.3365	0.3475	445208000.0
2011-12-20	AMZN	Stock	9.1345	9.1585	9.027	9.126	92002000.0
2011-12-20	TSLA	Stock	1.87	1.8967	1.848	1.86	12649500.0
2011-12-20	TLT	Stock	122.66	122.67	120.61	120.78	13946803.0
2011-12-20	ES	Stock	34.92	35.0	34.5	34.81	1744400.0
2011-12-20	CL	Stock	45.24	45.8	45.165	45.775	3367000.0
2011-12-20	A	Stock	24.3133	24.8784	24.2847	24.7353	5132897.0
2011-12-20	AABA-DELISTED	Stock	14.7	15.185	14.68	15.1	14786138.0
2011-12-20	AACC-DELISTED	Stock	3.64	3.91	3.45	3.72	286060.0
2011-12-20	AACG	Stock	8.01	9.01	8.0	9.0	6700.0
2011-12-20	AAIC-DELISTED	Stock	21.55	21.96	21.19	21.88	81616.0
2011-12-20	AAME	Stock	2.0	2.01	1.87	2.0	6700.0
2011-12-20	AAON	Stock	6.2281	6.4207	6.1274	6.3852	352688.0
2011-12-20	AAP	Stock	68.04	69.32	67.92	68.99	813700.0
2011-12-20	AAT	Stock	20.88	21.23	20.63	20.97	785700.0
2011-12-20	AATI-DELISTED	Stock	5.76	5.77	5.75	5.77	490223.0
2011-12-20	AAU-DELISTED	Stock	2.11	2.275	2.1	2.14	128003.0
2011-12-20	AAUAF-DELISTED	Stock	2.1	2.28	2.1	2.15	129311.0
2011-12-20	AAV-DELISTED	Stock	3.95	4.08	3.92	3.94	514837.0
2011-12-20	AAWW-DELISTED	Stock	37.24	38.38	36.9834	37.96	466152.0
2011-12-20	AAXJ	Stock	49.07	49.7855	49.03	49.69	310859.0
2011-12-20	AAXN-DELISTED	Stock	5.65	5.8	5.61	5.69	508057.0
2011-12-20	AB	Stock	13.19	13.58	13.19	13.54	613800.0
2011-12-20	ABAC-DELISTED	Stock	1.3	1.34	1.25	1.26	8600.0
2011-12-20	ABAX-DELISTED	Stock	27.91	28.3	27.66	27.9	158643.0
2011-12-20	ABB-DELISTED	Stock	18.17	18.38	18.14	18.37	2302891.0
2011-12-20	ABBNY-DELISTED	Stock	18.17	18.38	18.14	18.37	2302541.0
2011-12-20	ABC-DELISTED	Stock	36.86	37.29	36.74	37.1	2480514.0
2011-12-20	ABCB	Stock	10.18	10.43	10.17	10.2	64900.0
2011-12-20	ABCD-DELISTED	Stock	2.98	3.26	2.89	3.17	58912.0
2011-12-20	ABCO-DELISTED	Stock	36.0	36.42	35.44	35.82	466786.0
2011-12-20	ABCW-DELISTED	Stock	0.2309	0.2711	0.2219	0.2711	192410.0
2011-12-20	ABD-DELISTED	Stock	9.935	10.005	9.825	9.935	410270.0
2011-12-20	ABE-DELISTED	Stock	17.05	17.25	17.05	17.16	16800.0
2011-12-20	ABEO	Stock	1700.0	1750.0	1637.5	1737.5	13.0
2011-12-20	ABFS-DELISTED	Stock	17.86	18.78	17.59	18.75	380482.0
2011-12-20	ABG	Stock	19.51	19.93	19.4	19.82	263800.0
2011-12-20	ABH-DELISTED	Stock	14.72	15.03	14.55	14.99	391556.0
2011-12-20	ABM	Stock	20.47	21.04	20.22	20.81	281200.0
2011-12-20	ABMD-DELISTED	Stock	18.73	18.93	18.07	18.19	476013.0
2011-12-20	ABR	Stock	3.41	3.48	3.31	3.41	32100.0
2011-12-20	ABT	Stock	26.2403	26.3506	26.2067	26.3218	15898916.0
2011-12-20	ABTL-DELISTED	Stock	3.9439	4.2133	3.7902	4.2	28338.0
2011-12-20	ABUS	Stock	1.51	1.6	1.51	1.52	13800.0
2011-12-20	ABV-DELISTED	Stock	36.4	36.6525	36.205	36.26	2683761.0
2011-12-20	ABVA-DELISTED	Stock	3.49	3.55	3.4	3.516	12001.0
2011-12-20	ABVT-DELISTED	Stock	65.0	65.59	65.0	65.35	186366.0
2011-12-20	ABX-DELISTED	Stock	45.71	46.48	45.55	46.09	7525414.0

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

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