PREVIEW / stock_daily / 2013-02-21

all stock daily files

  file:    by_date/stock_daily/2013/2013-02-21.parquet
  size:    208 KB
  rows:    6,296
  symbols: 3,506

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
2013-02-21	AAPL	Stock	15.9286	16.0418	15.815	15.9307	447182400.0
2013-02-21	MSFT	Stock	27.74	27.74	27.23	27.49	49078500.0
2013-02-21	NVDA	Stock	0.309	0.3125	0.3065	0.3073	580408000.0
2013-02-21	AMZN	Stock	13.256	13.474	13.1625	13.297	72748000.0
2013-02-21	META	Stock	28.28	28.55	27.15	27.28	49642300.0
2013-02-21	TSLA	Stock	2.4327	2.4927	2.3027	2.344	135567000.0
2013-02-21	TLT	Stock	116.9	117.31	116.74	116.95	8297365.0
2013-02-21	ES	Stock	41.06	41.32	40.84	40.89	1528000.0
2013-02-21	CL	Stock	55.875	56.81	55.755	56.545	4462400.0
2013-02-21	A	Stock	30.1431	30.1431	29.6638	29.7783	4774450.0
2013-02-21	AABA-DELISTED	Stock	20.92	21.0	20.735	20.8156	13274347.0
2013-02-21	AACC-DELISTED	Stock	5.35	5.43	5.07	5.27	17555.0
2013-02-21	AACG	Stock	4.15	4.15	4.05	4.05	12300.0
2013-02-21	AAIC-DELISTED	Stock	25.64	25.79	25.16	25.28	288597.0
2013-02-21	AAMC-DELISTED	Stock	33.5294	33.9706	31.6176	32.3529	124817.0
2013-02-21	AAME	Stock	3.42	3.42	3.03	3.2	5000.0
2013-02-21	AAMRQ-DELISTED	Stock	2.7	2.83	2.55	2.62	17145928.0
2013-02-21	AAON	Stock	7.0281	7.117	7.0281	7.0815	236250.0
2013-02-21	AAP	Stock	79.26	80.05	78.56	79.06	915200.0
2013-02-21	AAT	Stock	30.16	30.28	29.6	29.71	114900.0
2013-02-21	AAU-DELISTED	Stock	2.16	2.24	2.13	2.15	190088.0
2013-02-21	AAUAF-DELISTED	Stock	2.16	2.24	2.13	2.17	190488.0
2013-02-21	AAV-DELISTED	Stock	2.88	2.91	2.79	2.85	741644.0
2013-02-21	AAWW-DELISTED	Stock	46.54	46.71	45.28	45.52	298386.0
2013-02-21	AAXJ	Stock	59.86	59.9887	59.51	59.79	814537.0
2013-02-21	AAXN-DELISTED	Stock	8.59	8.79	6.7	6.9	4192271.0
2013-02-21	AB	Stock	21.98	22.15	21.55	22.15	716800.0
2013-02-21	ABAC-DELISTED	Stock	0.9087	0.9087	0.875	0.875	1900.0
2013-02-21	ABAX-DELISTED	Stock	42.53	42.86	42.03	42.67	138235.0
2013-02-21	ABB-DELISTED	Stock	22.87	22.9499	22.61	22.73	2913496.0
2013-02-21	ABBNY-DELISTED	Stock	22.87	22.9499	22.61	22.74	3100182.0
2013-02-21	ABBV	Stock	38.49	39.03	38.19	38.78	7260900.0
2013-02-21	ABC-DELISTED	Stock	46.48	46.62	46.1633	46.49	1413731.0
2013-02-21	ABCB	Stock	13.81	14.2	13.81	13.95	29800.0
2013-02-21	ABCD-DELISTED	Stock	1.23	1.25	1.2	1.2	17440.0
2013-02-21	ABCO-DELISTED	Stock	49.85	50.4	49.83	49.91	136538.0
2013-02-21	ABCW-DELISTED	Stock	0.6	0.6	0.59	0.6	13688.0
2013-02-21	ABE-DELISTED	Stock	21.1	21.355	20.92	21.06	14414.0
2013-02-21	ABEO	Stock	612.5	612.5	612.5	612.5	5.0
2013-02-21	ABFS-DELISTED	Stock	11.35	11.53	10.83	10.975	240336.0
2013-02-21	ABG	Stock	34.95	34.95	32.94	33.12	504800.0
2013-02-21	ABM	Stock	23.0	23.3	22.7	22.86	186100.0
2013-02-21	ABMD-DELISTED	Stock	14.51	15.0	13.96	14.33	708750.0
2013-02-21	ABR	Stock	7.97	7.97	7.36	7.66	335600.0
2013-02-21	ABR.A-DELISTED	Stock	25.3	25.39	25.26	25.39	4716.0
2013-02-21	ABT	Stock	34.47	34.49	34.13	34.26	6572700.0
2013-02-21	ABTL-DELISTED	Stock	4.22	4.36	4.181	4.305	2764.0
2013-02-21	ABUS	Stock	4.5	4.58	4.47	4.47	10600.0
2013-02-21	ABV-DELISTED	Stock	46.32	46.32	44.98	45.38	2089664.0
2013-02-21	ABX-DELISTED	Stock	30.32	30.77	30.2	30.41	11434026.0

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

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