PREVIEW / stock_daily / 2010-12-27

all stock daily files

  file:    by_date/stock_daily/2010/2010-12-27.parquet
  size:    194 KB
  rows:    6,055
  symbols: 3,538

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
2010-12-27	AAPL	Stock	11.5304	11.6229	11.4829	11.5957	249816000.0
2010-12-27	MSFT	Stock	28.12	28.2	27.88	28.07	21652800.0
2010-12-27	NVDA	Stock	0.372	0.3778	0.3652	0.375	255500000.0
2010-12-27	AMZN	Stock	9.095	9.157	9.0225	9.107	44988000.0
2010-12-27	TSLA	Stock	1.868	1.9053	1.6707	1.7033	139528500.0
2010-12-27	TLT	Stock	92.76	93.88	92.3	93.76	5286378.0
2010-12-27	ES	Stock	31.74	31.8	31.54	31.76	1018100.0
2010-12-27	CL	Stock	40.225	40.33	40.075	40.205	1822000.0
2010-12-27	A	Stock	29.2489	30.0858	29.2489	29.9857	5207969.0
2010-12-27	AABA-DELISTED	Stock	16.62	16.6299	16.4	16.48	7476262.0
2010-12-27	AACC-DELISTED	Stock	5.75	6.03	5.75	6.03	26383.0
2010-12-27	AACG	Stock	3.71	3.71	3.71	3.71	300.0
2010-12-27	AAI-DELISTED	Stock	7.36	7.4	7.36	7.39	483434.0
2010-12-27	AAIC-DELISTED	Stock	24.48	24.65	24.3	24.42	28491.0
2010-12-27	AAME	Stock	2.0	2.0	1.96	2.0	500.0
2010-12-27	AAON	Stock	5.6849	5.7857	5.6849	5.7244	134662.0
2010-12-27	AAP	Stock	66.27	66.73	65.95	66.42	387200.0
2010-12-27	AATI-DELISTED	Stock	3.94	4.0	3.91	3.99	35284.0
2010-12-27	AAU-DELISTED	Stock	4.37	4.42	4.196	4.36	297513.0
2010-12-27	AAUAF-DELISTED	Stock	4.39	4.44	4.21	4.34	296703.0
2010-12-27	AAV-DELISTED	Stock	6.63	6.65	6.46	6.55	198396.0
2010-12-27	AAWW-DELISTED	Stock	57.28	57.52	56.4401	57.22	52062.0
2010-12-27	AAXJ	Stock	62.52	62.84	62.4	62.74	134854.0
2010-12-27	AAXN-DELISTED	Stock	4.71	4.87	4.65	4.84	287185.0
2010-12-27	AB	Stock	23.03	23.26	22.95	23.19	258500.0
2010-12-27	ABAC-DELISTED	Stock	6.09	6.09	5.73	5.98	47710.0
2010-12-27	ABAX-DELISTED	Stock	27.23	27.29	26.97	27.09	59721.0
2010-12-27	ABB-DELISTED	Stock	21.79	21.9525	21.74	21.93	895370.0
2010-12-27	ABBC-DELISTED	Stock	11.92	12.0	11.92	12.0	23852.0
2010-12-27	ABBNY-DELISTED	Stock	21.79	21.9525	21.74	21.94	912818.0
2010-12-27	ABC-DELISTED	Stock	34.25	34.4499	34.12	34.33	1939584.0
2010-12-27	ABCB	Stock	10.48	10.94	10.48	10.92	15000.0
2010-12-27	ABCD-DELISTED	Stock	3.47	3.5101	3.44	3.48	33211.0
2010-12-27	ABCO-DELISTED	Stock	23.91	24.17	23.66	23.97	40632.0
2010-12-27	ABCW-DELISTED	Stock	1.29	1.33	1.25	1.27	69550.0
2010-12-27	ABD-DELISTED	Stock	8.69	8.821	8.67	8.75	226190.0
2010-12-27	ABE-DELISTED	Stock	18.61	18.79	18.35	18.7799	18654.0
2010-12-27	ABEO	Stock	3437.5	3437.5	3125.0	3225.0	34.0
2010-12-27	ABFS-DELISTED	Stock	26.75	27.12	26.74	26.98	80512.0
2010-12-27	ABG	Stock	17.99	18.21	17.83	18.1	66600.0
2010-12-27	ABH-DELISTED	Stock	23.66	23.8699	23.31	23.53	99711.0
2010-12-27	ABM	Stock	26.44	26.88	26.44	26.76	113000.0
2010-12-27	ABMD-DELISTED	Stock	9.52	9.77	9.5	9.745	91933.0
2010-12-27	ABR	Stock	5.76	6.0	5.75	5.99	47400.0
2010-12-27	ABT	Stock	22.9296	22.9344	22.6945	22.7329	13794706.0
2010-12-27	ABTL-DELISTED	Stock	4.15	4.3056	4.15	4.15	4877.0
2010-12-27	ABUS	Stock	5.78	5.78	4.57	4.72	10000.0
2010-12-27	ABV-DELISTED	Stock	150.28	153.45	150.06	153.13	263708.0
2010-12-27	ABVA-DELISTED	Stock	3.96	3.96	3.96	3.96	100.0
2010-12-27	ABVT-DELISTED	Stock	57.78	57.86	57.35	57.53	48288.0

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

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