PREVIEW / stock_daily / 2013-07-02

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-02.parquet
  size:    209 KB
  rows:    6,339
  symbols: 3,515

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-07-02	AAPL	Stock	14.6414	15.0582	14.6239	14.9461	469865200.0
2013-07-02	MSFT	Stock	34.41	34.44	33.63	33.94	37630000.0
2013-07-02	NVDA	Stock	0.3505	0.3575	0.349	0.3522	256392000.0
2013-07-02	AMZN	Stock	14.052	14.329	14.0295	14.1865	64764000.0
2013-07-02	META	Stock	24.7	24.77	24.3	24.41	18394100.0
2013-07-02	TSLA	Stock	7.8833	8.126	7.7	7.8547	180961500.0
2013-07-02	TLT	Stock	110.5	110.8	110.24	110.34	5333892.0
2013-07-02	ES	Stock	41.18	41.53	40.9	41.13	1404700.0
2013-07-02	CL	Stock	57.94	58.2	57.5	57.72	3355700.0
2013-07-02	A	Stock	31.1159	31.3948	30.7225	30.8226	4175127.0
2013-07-02	AABA-DELISTED	Stock	25.27	25.495	24.9	24.98	10078729.0
2013-07-02	AACG	Stock	4.76	4.94	4.75	4.9	16500.0
2013-07-02	AAIC-DELISTED	Stock	27.04	27.28	26.6	26.89	107003.0
2013-07-02	AAMC-DELISTED	Stock	80.9118	80.9118	79.4118	79.4118	2193.0
2013-07-02	AAME	Stock	3.81	3.89	3.8	3.87	2100.0
2013-07-02	AAMRQ-DELISTED	Stock	4.49	4.5	4.05	4.17	3879231.0
2013-07-02	AAON	Stock	10.0533	10.1896	9.9733	10.0681	183263.0
2013-07-02	AAP	Stock	82.0	82.66	81.04	81.47	456300.0
2013-07-02	AAT	Stock	31.51	32.04	31.31	32.02	157400.0
2013-07-02	AAU-DELISTED	Stock	1.52	1.52	1.39	1.49	233965.0
2013-07-02	AAUAF-DELISTED	Stock	1.52	1.52	1.39	1.48	234865.0
2013-07-02	AAV-DELISTED	Stock	3.93	3.93	3.821	3.9	531900.0
2013-07-02	AAWW-DELISTED	Stock	43.33	43.78	42.56	42.79	192512.0
2013-07-02	AAXJ	Stock	54.75	55.07	54.05	54.33	457429.0
2013-07-02	AAXN-DELISTED	Stock	8.85	9.021	8.52	8.575	439439.0
2013-07-02	AB	Stock	20.46	21.0	20.4	20.85	516900.0
2013-07-02	ABAC-DELISTED	Stock	0.71	0.71	0.57	0.63	43200.0
2013-07-02	ABAX-DELISTED	Stock	48.19	48.51	47.27	47.91	47599.0
2013-07-02	ABB-DELISTED	Stock	21.46	21.64	21.31	21.45	1552262.0
2013-07-02	ABBNY-DELISTED	Stock	21.46	21.64	21.31	21.46	1587444.0
2013-07-02	ABBV	Stock	41.58	42.57	41.58	42.21	4365900.0
2013-07-02	ABC-DELISTED	Stock	55.04	55.32	54.66	54.83	1970534.0
2013-07-02	ABCB	Stock	17.42	17.95	17.37	17.72	152900.0
2013-07-02	ABCD-DELISTED	Stock	1.25	1.28	1.25	1.27	2298.0
2013-07-02	ABCO-DELISTED	Stock	54.69	55.52	54.23	55.08	96727.0
2013-07-02	ABCW-DELISTED	Stock	0.55	0.55	0.52	0.52	30246.0
2013-07-02	ABE-DELISTED	Stock	19.65	19.88	19.6	19.68	3418.0
2013-07-02	ABEO	Stock	587.5	625.0	587.5	625.0	25.0
2013-07-02	ABFS-DELISTED	Stock	22.59	22.94	21.87	22.49	623238.0
2013-07-02	ABG	Stock	40.6	41.45	40.38	41.05	202500.0
2013-07-02	ABM	Stock	24.62	24.68	24.31	24.44	133800.0
2013-07-02	ABMD-DELISTED	Stock	22.3	22.42	21.84	22.01	198862.0
2013-07-02	ABR	Stock	6.33	6.41	6.22	6.32	98200.0
2013-07-02	ABR.A-DELISTED	Stock	25.09	25.1	25.0886	25.1	23495.0
2013-07-02	ABR.B-DELISTED	Stock	24.3599	24.3599	24.25	24.25	600.0
2013-07-02	ABT	Stock	34.97	35.31	34.65	34.86	5793200.0
2013-07-02	ABTL-DELISTED	Stock	4.72	4.72	4.66	4.71	2600.0
2013-07-02	ABUS	Stock	4.99	4.99	4.75	4.76	40600.0
2013-07-02	ABV-DELISTED	Stock	37.29	37.69	36.13	36.46	3958142.0
2013-07-02	ABX-DELISTED	Stock	15.2305	15.2805	14.349	14.53	26575921.0

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

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