PREVIEW / stock_daily / 2011-03-04

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-04.parquet
  size:    197 KB
  rows:    6,074
  symbols: 3,548

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-03-04	AAPL	Stock	12.8596	12.8675	12.7768	12.8571	453266800.0
2011-03-04	MSFT	Stock	26.22	26.24	25.8	25.95	70437200.0
2011-03-04	NVDA	Stock	0.5222	0.5275	0.5133	0.519	959760000.0
2011-03-04	AMZN	Stock	8.631	8.6375	8.4755	8.5835	98486000.0
2011-03-04	TSLA	Stock	1.632	1.666	1.5853	1.6633	23701500.0
2011-03-04	TLT	Stock	90.1	90.85	90.0	90.81	9319657.0
2011-03-04	ES	Stock	34.13	34.25	33.49	33.83	2162800.0
2011-03-04	CL	Stock	39.025	39.095	38.625	38.75	6091800.0
2011-03-04	A	Stock	31.0086	33.4835	31.0086	33.4406	18664139.0
2011-03-04	AABA-DELISTED	Stock	16.78	17.2	16.72	17.09	19864565.0
2011-03-04	AACC-DELISTED	Stock	5.84	5.88	5.65	5.71	7608.0
2011-03-04	AACG	Stock	7.59	8.09	7.5	7.61	74100.0
2011-03-04	AAI-DELISTED	Stock	7.32	7.32	7.28	7.28	1353934.0
2011-03-04	AAIC-DELISTED	Stock	27.68	27.69	26.85	26.85	35728.0
2011-03-04	AAON	Stock	5.9951	6.0523	5.9496	5.9931	299700.0
2011-03-04	AAP	Stock	64.35	64.44	63.47	63.79	746500.0
2011-03-04	AAT	Stock	21.5	21.6	21.21	21.27	115700.0
2011-03-04	AATI-DELISTED	Stock	4.21	4.26	4.17	4.22	69426.0
2011-03-04	AAU-DELISTED	Stock	4.1	4.21	4.03	4.08	314429.0
2011-03-04	AAUAF-DELISTED	Stock	4.1	4.21	4.03	4.07	315169.0
2011-03-04	AAV-DELISTED	Stock	8.22	8.3	8.05	8.13	527006.0
2011-03-04	AAWW-DELISTED	Stock	69.74	69.74	67.28	67.99	159977.0
2011-03-04	AAXJ	Stock	61.82	61.89	61.24	61.69	349708.0
2011-03-04	AAXN-DELISTED	Stock	4.07	4.1	4.0	4.05	398000.0
2011-03-04	AB	Stock	23.37	23.51	22.95	23.49	687200.0
2011-03-04	ABAC-DELISTED	Stock	4.88	4.93	4.83	4.891	27060.0
2011-03-04	ABAX-DELISTED	Stock	27.66	27.7	27.31	27.69	68562.0
2011-03-04	ABB-DELISTED	Stock	24.67	24.7	24.22	24.43	2031532.0
2011-03-04	ABBC-DELISTED	Stock	12.53	12.59	12.26	12.44	65700.0
2011-03-04	ABBNY-DELISTED	Stock	24.67	24.7	24.22	24.45	2081832.0
2011-03-04	ABC-DELISTED	Stock	37.67	37.72	37.2	37.66	2058561.0
2011-03-04	ABCB	Stock	10.01	10.01	9.85	9.91	27300.0
2011-03-04	ABCD-DELISTED	Stock	3.6699	3.6699	3.47	3.49	21868.0
2011-03-04	ABCO-DELISTED	Stock	25.27	25.37	25.01	25.3	124807.0
2011-03-04	ABCW-DELISTED	Stock	1.08	1.08	1.05	1.06	57070.0
2011-03-04	ABD-DELISTED	Stock	8.86	8.98	8.738	8.9	164020.0
2011-03-04	ABE-DELISTED	Stock	17.94	18.04	17.8912	17.94	12515.0
2011-03-04	ABEO	Stock	2625.0	2675.0	2562.5	2625.0	14.0
2011-03-04	ABFS-DELISTED	Stock	24.46	24.46	23.8001	23.93	141579.0
2011-03-04	ABG	Stock	19.15	19.21	18.89	19.11	205900.0
2011-03-04	ABH-DELISTED	Stock	28.25	28.57	27.61	28.35	404376.0
2011-03-04	ABM	Stock	26.55	26.58	26.07	26.54	210300.0
2011-03-04	ABMD-DELISTED	Stock	13.64	13.64	13.27	13.45	152754.0
2011-03-04	ABR	Stock	6.85	6.85	6.01	6.52	230300.0
2011-03-04	ABT	Stock	23.1599	23.4862	23.1551	23.3615	23068153.0
2011-03-04	ABTL-DELISTED	Stock	5.8	5.85	5.65	5.65	53088.0
2011-03-04	ABUS	Stock	4.88	4.9	4.67	4.84	17000.0
2011-03-04	ABV-DELISTED	Stock	28.41	28.41	27.66	28.06	1898815.0
2011-03-04	ABVA-DELISTED	Stock	4.9	4.9	4.8	4.8	300.0
2011-03-04	ABVT-DELISTED	Stock	64.01	64.28	63.0	63.43	97499.0

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

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