PREVIEW / stock_daily / 2013-02-19

all stock daily files

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

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-19	AAPL	Stock	16.4679	16.5261	16.2089	16.4282	435783600.0
2013-02-19	MSFT	Stock	27.88	28.09	27.8	28.05	38781400.0
2013-02-19	NVDA	Stock	0.3185	0.3188	0.312	0.314	433552000.0
2013-02-19	AMZN	Stock	13.2955	13.5055	13.225	13.4875	57084000.0
2013-02-19	META	Stock	28.23	29.08	28.12	28.93	49396400.0
2013-02-19	TSLA	Stock	2.4907	2.6193	2.4873	2.6187	40521000.0
2013-02-19	TLT	Stock	116.86	116.9	115.84	115.92	7383515.0
2013-02-19	ES	Stock	41.08	41.44	40.93	41.41	1942600.0
2013-02-19	CL	Stock	55.08	56.02	54.96	55.955	5458400.0
2013-02-19	A	Stock	30.1931	30.8441	30.1931	30.7654	5754448.0
2013-02-19	AABA-DELISTED	Stock	21.03	21.41	20.97	21.27	16349324.0
2013-02-19	AACC-DELISTED	Stock	5.63	5.65	5.47	5.55	16112.0
2013-02-19	AACG	Stock	4.15	4.28	4.03	4.1	8300.0
2013-02-19	AAIC-DELISTED	Stock	26.0	26.92	25.91	26.87	322097.0
2013-02-19	AAMC-DELISTED	Stock	36.4706	36.4706	34.9265	35.0735	66501.0
2013-02-19	AAME	Stock	3.11	3.3	3.11	3.21	28700.0
2013-02-19	AAMRQ-DELISTED	Stock	2.535	2.94	2.53	2.81	36815475.0
2013-02-19	AAON	Stock	7.0815	7.1911	7.0756	7.1763	363825.0
2013-02-19	AAP	Stock	79.12	81.44	78.57	80.72	1730700.0
2013-02-19	AAT	Stock	29.79	29.87	29.51	29.68	319500.0
2013-02-19	AAU-DELISTED	Stock	2.35	2.43	2.23	2.29	198964.0
2013-02-19	AAUAF-DELISTED	Stock	2.35	2.43	2.23	2.3	199997.0
2013-02-19	AAV-DELISTED	Stock	3.07	3.07	3.0	3.01	301808.0
2013-02-19	AAWW-DELISTED	Stock	47.11	47.44	46.12	46.79	282722.0
2013-02-19	AAXJ	Stock	60.66	60.7982	60.52	60.69	529699.0
2013-02-19	AAXN-DELISTED	Stock	8.71	8.8	8.35	8.5	691890.0
2013-02-19	AB	Stock	21.52	22.97	21.52	22.8	942100.0
2013-02-19	ABAC-DELISTED	Stock	0.85	0.92	0.85	0.86	6150.0
2013-02-19	ABAX-DELISTED	Stock	43.3	43.99	43.221	43.5	156778.0
2013-02-19	ABB-DELISTED	Stock	22.89	23.0	22.89	23.0	1360942.0
2013-02-19	ABBNY-DELISTED	Stock	22.89	23.0	22.89	23.0	1387773.0
2013-02-19	ABBV	Stock	37.54	38.33	37.11	38.19	8292700.0
2013-02-19	ABC-DELISTED	Stock	46.67	47.24	46.62	47.22	1718665.0
2013-02-19	ABCB	Stock	13.97	14.16	13.84	14.12	184000.0
2013-02-19	ABCD-DELISTED	Stock	1.29	1.31	1.23	1.24	19094.0
2013-02-19	ABCO-DELISTED	Stock	50.04	50.33	49.8	50.18	247164.0
2013-02-19	ABCW-DELISTED	Stock	0.59	0.69	0.59	0.6	28350.0
2013-02-19	ABE-DELISTED	Stock	21.39	21.48	21.2	21.2701	129512.0
2013-02-19	ABEO	Stock	562.5	625.0	562.5	625.0	2.0
2013-02-19	ABFS-DELISTED	Stock	11.68	11.775	11.408	11.49	503550.0
2013-02-19	ABG	Stock	37.17	37.27	35.22	35.81	511900.0
2013-02-19	ABM	Stock	23.13	23.47	23.09	23.43	299100.0
2013-02-19	ABMD-DELISTED	Stock	14.63	14.67	14.32	14.39	388591.0
2013-02-19	ABR	Stock	7.75	7.94	7.63	7.88	2380300.0
2013-02-19	ABR.A-DELISTED	Stock	25.2	25.26	25.2	25.25	14077.0
2013-02-19	ABT	Stock	35.18	35.29	34.75	34.82	9585000.0
2013-02-19	ABTL-DELISTED	Stock	4.09	4.487	4.09	4.29	8886.0
2013-02-19	ABUS	Stock	4.74	4.74	4.58	4.66	22700.0
2013-02-19	ABV-DELISTED	Stock	46.75	47.16	46.7	46.94	1755359.0
2013-02-19	ABX-DELISTED	Stock	31.5	31.73	30.9	31.51	11227470.0

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

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