PREVIEW / stock_daily / 2011-08-01

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-01.parquet
  size:    197 KB
  rows:    6,091
  symbols: 3,529

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-08-01	AAPL	Stock	14.2064	14.2679	14.0132	14.1696	612836000.0
2011-08-01	MSFT	Stock	27.51	27.69	26.75	27.27	61838400.0
2011-08-01	NVDA	Stock	0.3538	0.3652	0.3508	0.3642	1019620000.0
2011-08-01	AMZN	Stock	11.25	11.3725	10.883	11.066	115786000.0
2011-08-01	TSLA	Stock	1.9113	1.932	1.8807	1.918	17473500.0
2011-08-01	TLT	Stock	97.39	98.94	97.35	98.58	14348408.0
2011-08-01	ES	Stock	34.35	34.37	34.01	34.26	1501200.0
2011-08-01	CL	Stock	42.485	42.525	41.485	42.01	4906200.0
2011-08-01	A	Stock	30.4864	30.6009	28.9557	29.1774	7920509.0
2011-08-01	AABA-DELISTED	Stock	13.26	13.34	12.95	13.1	25964292.0
2011-08-01	AACC-DELISTED	Stock	5.04	5.16	4.645	4.8	47839.0
2011-08-01	AACG	Stock	9.59	10.27	9.59	9.91	7500.0
2011-08-01	AAIC-DELISTED	Stock	28.58	28.68	28.1	28.35	105367.0
2011-08-01	AAME	Stock	2.02	2.02	2.02	2.02	100.0
2011-08-01	AAON	Stock	6.7881	6.8148	6.6281	6.7644	182250.0
2011-08-01	AAP	Stock	55.44	55.44	53.91	54.2	710000.0
2011-08-01	AAT	Stock	22.17	22.19	21.72	21.97	161300.0
2011-08-01	AATI-DELISTED	Stock	6.08	6.09	6.04	6.05	575421.0
2011-08-01	AAU-DELISTED	Stock	3.25	3.42	3.2	3.29	241296.0
2011-08-01	AAUAF-DELISTED	Stock	3.25	3.42	3.2	3.29	241996.0
2011-08-01	AAV-DELISTED	Stock	7.1	7.2	6.99	7.17	273942.0
2011-08-01	AAWW-DELISTED	Stock	52.96	52.96	49.86	50.55	552129.0
2011-08-01	AAXJ	Stock	63.15	63.15	62.01	62.66	396546.0
2011-08-01	AAXN-DELISTED	Stock	4.16	4.28	4.13	4.28	818904.0
2011-08-01	AB	Stock	17.16	17.27	16.51	16.72	379800.0
2011-08-01	ABAC-DELISTED	Stock	2.67	2.68	2.57	2.61	8720.0
2011-08-01	ABAX-DELISTED	Stock	24.05	24.13	21.95	22.69	565219.0
2011-08-01	ABB-DELISTED	Stock	24.22	24.3	23.43	23.76	3468403.0
2011-08-01	ABBC-DELISTED	Stock	10.03	10.03	9.81	9.96	60342.0
2011-08-01	ABBNY-DELISTED	Stock	24.22	24.3	23.43	23.74	3914803.0
2011-08-01	ABC-DELISTED	Stock	38.35	39.31	36.88	37.73	6409808.0
2011-08-01	ABCB	Stock	10.17	10.28	9.9	10.25	108300.0
2011-08-01	ABCD-DELISTED	Stock	3.18	3.24	3.15	3.18	48160.0
2011-08-01	ABCO-DELISTED	Stock	27.11	27.33	26.12	26.33	114220.0
2011-08-01	ABCW-DELISTED	Stock	0.7	0.7001	0.65	0.65	92850.0
2011-08-01	ABD-DELISTED	Stock	8.69	8.84	8.109	8.27	585550.0
2011-08-01	ABE-DELISTED	Stock	19.07	19.21	19.05	19.1	44994.0
2011-08-01	ABEO	Stock	2812.5	2950.0	2625.0	2875.0	22.0
2011-08-01	ABFS-DELISTED	Stock	24.2	24.57	23.79	24.07	452311.0
2011-08-01	ABG	Stock	22.0	22.0	21.26	21.66	459100.0
2011-08-01	ABH-DELISTED	Stock	18.54	18.59	17.31	17.85	1071242.0
2011-08-01	ABM	Stock	22.68	22.78	22.04	22.23	240800.0
2011-08-01	ABMD-DELISTED	Stock	16.78	16.78	15.78	15.85	202036.0
2011-08-01	ABR	Stock	4.31	4.4	4.19	4.28	75800.0
2011-08-01	ABT	Stock	24.7673	24.7673	24.062	24.2155	19402251.0
2011-08-01	ABTL-DELISTED	Stock	5.2026	5.2531	4.8995	4.95	41256.0
2011-08-01	ABUS	Stock	2.4	2.41	2.4	2.41	600.0
2011-08-01	ABV-DELISTED	Stock	30.49	30.57	29.79	29.98	4025763.0
2011-08-01	ABVA-DELISTED	Stock	5.0	5.15	5.0	5.15	7195.0
2011-08-01	ABVT-DELISTED	Stock	61.55	61.96	59.84	60.38	180313.0

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

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