PREVIEW / stock_daily / 2013-04-02

all stock daily files

  file:    by_date/stock_daily/2013/2013-04-02.parquet
  size:    207 KB
  rows:    6,280
  symbols: 3,488

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-04-02	AAPL	Stock	15.2714	15.6479	15.2286	15.3496	529519200.0
2013-04-02	MSFT	Stock	28.59	28.85	28.52	28.8	28456500.0
2013-04-02	NVDA	Stock	0.3105	0.3113	0.305	0.307	371524000.0
2013-04-02	AMZN	Stock	13.12	13.2945	13.0275	13.166	52622000.0
2013-04-02	META	Stock	25.77	26.12	25.3	25.42	35153300.0
2013-04-02	TSLA	Stock	2.9067	3.0333	2.9007	2.956	99786000.0
2013-04-02	TLT	Stock	118.07	118.14	117.75	117.91	5437907.0
2013-04-02	ES	Stock	43.4	43.68	43.34	43.49	1013300.0
2013-04-02	CL	Stock	59.025	59.485	58.985	59.45	2619800.0
2013-04-02	A	Stock	29.4134	29.5851	29.0343	29.0844	3291451.0
2013-04-02	AABA-DELISTED	Stock	23.75	23.9	23.6	23.78	14302456.0
2013-04-02	AACC-DELISTED	Stock	6.77	6.77	6.7	6.72	92160.0
2013-04-02	AACG	Stock	4.13	4.13	4.0	4.0	1600.0
2013-04-02	AAIC-DELISTED	Stock	25.5	25.72	25.3901	25.58	298606.0
2013-04-02	AAMC-DELISTED	Stock	38.0882	38.2353	37.3529	38.2353	18659.0
2013-04-02	AAME	Stock	3.35	3.37	3.3	3.36	2300.0
2013-04-02	AAMRQ-DELISTED	Stock	3.99	4.0	3.71	3.74	11669215.0
2013-04-02	AAON	Stock	8.1778	8.2104	7.8519	7.9348	283163.0
2013-04-02	AAP	Stock	82.49	82.91	81.33	82.83	956300.0
2013-04-02	AAT	Stock	32.33	33.52	32.33	32.5	465200.0
2013-04-02	AAU-DELISTED	Stock	2.0	2.0586	1.91	1.93	127966.0
2013-04-02	AAUAF-DELISTED	Stock	2.02	2.0799	1.93	1.93	127116.0
2013-04-02	AAV-DELISTED	Stock	3.68	3.71	3.64	3.66	705307.0
2013-04-02	AAWW-DELISTED	Stock	40.09	40.336	39.2	39.28	339412.0
2013-04-02	AAXJ	Stock	59.0	59.01	58.73	58.81	396384.0
2013-04-02	AAXN-DELISTED	Stock	7.66	7.89	7.51	7.52	536797.0
2013-04-02	AB	Stock	21.88	22.24	21.78	21.88	268900.0
2013-04-02	ABAC-DELISTED	Stock	0.7299	0.76	0.702	0.73	18600.0
2013-04-02	ABAX-DELISTED	Stock	47.51	48.33	46.46	47.37	100516.0
2013-04-02	ABB-DELISTED	Stock	22.73	22.87	22.71	22.83	2050489.0
2013-04-02	ABBNY-DELISTED	Stock	22.73	22.88	22.71	22.82	2095583.0
2013-04-02	ABBV	Stock	41.22	41.22	40.52	40.71	5510700.0
2013-04-02	ABC-DELISTED	Stock	51.92	53.36	51.85	52.39	3998095.0
2013-04-02	ABCB	Stock	14.28	14.39	13.92	14.1	44600.0
2013-04-02	ABCO-DELISTED	Stock	52.26	52.47	51.16	51.25	132122.0
2013-04-02	ABCW-DELISTED	Stock	0.64	0.65	0.64	0.65	4300.0
2013-04-02	ABE-DELISTED	Stock	20.76	20.95	19.89	20.75	7735.0
2013-04-02	ABEO	Stock	562.5	637.5	537.5	550.0	35.0
2013-04-02	ABFS-DELISTED	Stock	11.28	11.4	11.11	11.32	275144.0
2013-04-02	ABG	Stock	36.65	37.33	36.52	36.6	283600.0
2013-04-02	ABM	Stock	21.81	22.0	21.74	21.75	164500.0
2013-04-02	ABMD-DELISTED	Stock	18.34	18.64	17.78	17.85	387440.0
2013-04-02	ABR	Stock	7.8	7.93	7.76	7.93	510500.0
2013-04-02	ABR.A-DELISTED	Stock	25.8	25.84	25.79	25.8	6423.0
2013-04-02	ABT	Stock	35.45	36.15	35.34	36.12	10956900.0
2013-04-02	ABTL-DELISTED	Stock	4.28	4.3	4.165	4.22	3147.0
2013-04-02	ABUS	Stock	4.6	4.65	4.52	4.63	224100.0
2013-04-02	ABV-DELISTED	Stock	42.1	42.19	41.8	42.01	1061111.0
2013-04-02	ABX-DELISTED	Stock	28.74	28.86	28.29	28.32	8670766.0
2013-04-02	ACAD	Stock	7.88	8.14	7.68	7.75	1976500.0

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

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