PREVIEW / stock_daily / 2011-06-03

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-03.parquet
  size:    198 KB
  rows:    6,131
  symbols: 3,574

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-06-03	AAPL	Stock	12.2564	12.3332	12.2146	12.2657	313250000.0
2011-06-03	MSFT	Stock	24.05	24.14	23.84	23.91	60697700.0
2011-06-03	NVDA	Stock	0.4708	0.475	0.4593	0.4615	549300000.0
2011-06-03	AMZN	Stock	9.5615	9.6605	9.381	9.416	99490000.0
2011-06-03	TSLA	Stock	1.9967	2.1	1.9667	2.0087	93138000.0
2011-06-03	TLT	Stock	96.58	96.6	95.57	96.33	10644188.0
2011-06-03	ES	Stock	34.49	34.52	34.09	34.26	2222400.0
2011-06-03	CL	Stock	42.32	42.5	41.96	42.055	5099200.0
2011-06-03	A	Stock	33.8984	34.299	33.4979	33.927	4042037.0
2011-06-03	AABA-DELISTED	Stock	15.83	16.0	15.63	15.68	22079690.0
2011-06-03	AACC-DELISTED	Stock	3.69	3.94	3.62	3.64	28510.0
2011-06-03	AACG	Stock	12.74	12.74	11.9	12.22	51600.0
2011-06-03	AAIC-DELISTED	Stock	27.0	27.5	26.85	27.28	54440.0
2011-06-03	AAME	Stock	2.04	2.04	2.04	2.04	100.0
2011-06-03	AAON	Stock	6.2558	6.3309	6.2499	6.2617	232875.0
2011-06-03	AAP	Stock	59.87	60.47	59.04	59.77	1078600.0
2011-06-03	AAT	Stock	21.64	21.94	21.64	21.83	136200.0
2011-06-03	AATI-DELISTED	Stock	6.03	6.04	6.03	6.04	1094923.0
2011-06-03	AAU-DELISTED	Stock	3.44	3.54	3.34	3.41	315805.0
2011-06-03	AAUAF-DELISTED	Stock	3.44	3.54	3.34	3.41	316405.0
2011-06-03	AAV-DELISTED	Stock	8.16	8.5	8.1	8.47	345289.0
2011-06-03	AAWW-DELISTED	Stock	60.07	60.39	59.06	59.3	203987.0
2011-06-03	AAXJ	Stock	62.58	63.23	62.43	62.74	204543.0
2011-06-03	AAXN-DELISTED	Stock	4.4	4.49	4.4	4.43	287417.0
2011-06-03	AB	Stock	19.79	19.98	19.65	19.68	590600.0
2011-06-03	ABAC-DELISTED	Stock	2.73	2.7599	2.58	2.58	11866.0
2011-06-03	ABAX-DELISTED	Stock	29.26	29.49	28.62	28.92	164180.0
2011-06-03	ABB-DELISTED	Stock	26.46	26.71	26.41	26.5	3526059.0
2011-06-03	ABBC-DELISTED	Stock	10.68	10.85	10.41	10.6	89224.0
2011-06-03	ABBNY-DELISTED	Stock	26.46	26.71	26.41	26.49	3524635.0
2011-06-03	ABC-DELISTED	Stock	40.25	40.5	40.15	40.36	1847826.0
2011-06-03	ABCB	Stock	8.69	8.8	8.54	8.65	60000.0
2011-06-03	ABCD-DELISTED	Stock	3.15	3.27	2.92	2.92	42297.0
2011-06-03	ABCO-DELISTED	Stock	25.33	25.43	24.27	25.13	87158.0
2011-06-03	ABCW-DELISTED	Stock	0.77	0.77	0.74	0.75	28840.0
2011-06-03	ABD-DELISTED	Stock	7.86	7.97	7.65	7.83	370200.0
2011-06-03	ABE-DELISTED	Stock	18.66	18.83	18.63	18.78	7295.0
2011-06-03	ABEO	Stock	2625.0	2812.5	2625.0	2800.0	7.0
2011-06-03	ABFS-DELISTED	Stock	22.72	22.93	21.83	21.99	732753.0
2011-06-03	ABG	Stock	15.7	16.08	15.5	15.67	348900.0
2011-06-03	ABH-DELISTED	Stock	23.45	24.0	23.3901	23.69	220285.0
2011-06-03	ABM	Stock	22.25	22.44	22.11	22.15	217600.0
2011-06-03	ABMD-DELISTED	Stock	17.55	17.55	17.15	17.3	268252.0
2011-06-03	ABR	Stock	4.82	5.03	4.82	5.03	22100.0
2011-06-03	ABT	Stock	24.4314	24.6089	24.2875	24.5082	13345352.0
2011-06-03	ABTL-DELISTED	Stock	5.6487	6.0017	5.5983	5.8	19462.0
2011-06-03	ABUS	Stock	3.21	3.21	2.92	3.07	16900.0
2011-06-03	ABV-DELISTED	Stock	31.0	32.03	30.93	31.85	1902847.0
2011-06-03	ABVA-DELISTED	Stock	5.15	5.15	4.75	4.79	9560.0
2011-06-03	ABVT-DELISTED	Stock	74.99	76.23	73.55	74.45	321343.0

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

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