PREVIEW / stock_daily / 2011-12-28

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-28.parquet
  size:    197 KB
  rows:    6,185
  symbols: 3,579

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-28	AAPL	Stock	14.5318	14.5804	14.3336	14.38	228662000.0
2011-12-28	MSFT	Stock	26.11	26.15	25.76	25.82	29822500.0
2011-12-28	NVDA	Stock	0.3515	0.3522	0.3425	0.3428	233960000.0
2011-12-28	AMZN	Stock	8.8195	8.8325	8.614	8.6945	73190000.0
2011-12-28	TSLA	Stock	1.9327	1.9493	1.8693	1.9007	8628000.0
2011-12-28	TLT	Stock	118.74	121.05	118.45	120.64	8302411.0
2011-12-28	ES	Stock	35.95	36.35	35.8	35.84	1476500.0
2011-12-28	CL	Stock	46.725	46.81	46.305	46.365	2821000.0
2011-12-28	A	Stock	25.2146	25.2861	24.3348	24.3991	2566588.0
2011-12-28	AABA-DELISTED	Stock	16.03	16.05	15.67	15.77	14040348.0
2011-12-28	AACC-DELISTED	Stock	3.77	3.84	3.69	3.8	5221.0
2011-12-28	AACG	Stock	7.56	8.05	7.54	7.56	4700.0
2011-12-28	AAIC-DELISTED	Stock	22.35	22.91	21.54	21.98	92899.0
2011-12-28	AAME	Stock	1.98	1.99	1.89	1.99	2600.0
2011-12-28	AAON	Stock	6.3585	6.3793	6.0267	6.0474	191025.0
2011-12-28	AAP	Stock	70.98	71.69	70.18	70.26	475900.0
2011-12-28	AAT	Stock	20.65	20.89	20.34	20.52	53200.0
2011-12-28	AATI-DELISTED	Stock	5.76	5.77	5.76	5.77	198334.0
2011-12-28	AAU-DELISTED	Stock	2.19	2.22	2.1	2.1599	185514.0
2011-12-28	AAUAF-DELISTED	Stock	2.19	2.22	2.1	2.1599	180514.0
2011-12-28	AAV-DELISTED	Stock	4.03	4.06	3.95	4.0	378982.0
2011-12-28	AAWW-DELISTED	Stock	39.14	39.31	37.25	37.47	330399.0
2011-12-28	AAXJ	Stock	49.89	49.91	49.26	49.34	327375.0
2011-12-28	AAXN-DELISTED	Stock	5.4	5.48	5.34	5.4	295620.0
2011-12-28	AB	Stock	13.2	13.28	13.01	13.11	303600.0
2011-12-28	ABAC-DELISTED	Stock	1.38	1.4	1.35	1.4	21170.0
2011-12-28	ABAX-DELISTED	Stock	27.97	28.04	27.34	27.41	34819.0
2011-12-28	ABB-DELISTED	Stock	18.71	18.73	18.42	18.5	1969026.0
2011-12-28	ABBNY-DELISTED	Stock	18.71	18.73	18.42	18.51	2074426.0
2011-12-28	ABC-DELISTED	Stock	37.73	37.76	36.8	36.85	1300548.0
2011-12-28	ABCB	Stock	10.32	10.32	10.06	10.12	54500.0
2011-12-28	ABCD-DELISTED	Stock	3.19	3.23	3.01	3.04	18414.0
2011-12-28	ABCO-DELISTED	Stock	36.97	36.97	36.48	36.59	72914.0
2011-12-28	ABCW-DELISTED	Stock	0.3414	0.3414	0.3313	0.3313	70500.0
2011-12-28	ABD-DELISTED	Stock	9.91	9.91	9.68	9.74	262480.0
2011-12-28	ABE-DELISTED	Stock	17.39	17.39	17.0	17.3	13050.0
2011-12-28	ABEO	Stock	1625.0	1700.0	1575.0	1662.5	8.0
2011-12-28	ABFS-DELISTED	Stock	19.08	19.3	18.75	18.83	223127.0
2011-12-28	ABG	Stock	20.97	21.16	20.86	20.99	134200.0
2011-12-28	ABH-DELISTED	Stock	14.72	14.72	14.4399	14.56	219435.0
2011-12-28	ABM	Stock	20.94	20.95	20.34	20.54	220900.0
2011-12-28	ABMD-DELISTED	Stock	18.38	18.43	18.15	18.28	141039.0
2011-12-28	ABR	Stock	3.67	3.69	3.56	3.58	24500.0
2011-12-28	ABT	Stock	26.8688	27.0463	26.7584	26.7872	8365777.0
2011-12-28	ABTL-DELISTED	Stock	3.8542	3.9061	3.6645	3.7	22103.0
2011-12-28	ABUS	Stock	1.5	1.62	1.5	1.52	6900.0
2011-12-28	ABV-DELISTED	Stock	36.05	36.06	35.575	35.67	1324223.0
2011-12-28	ABVA-DELISTED	Stock	3.319	3.44	3.31	3.44	5742.0
2011-12-28	ABVT-DELISTED	Stock	65.03	65.06	64.06	64.25	66131.0
2011-12-28	ABX-DELISTED	Stock	45.56	45.75	44.0	44.22	6002656.0

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

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