PREVIEW / stock_daily / 2013-07-08

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-08.parquet
  size:    210 KB
  rows:    6,345
  symbols: 3,518

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-08	AAPL	Stock	15.0039	15.0357	14.6661	14.8232	298138400.0
2013-07-08	MSFT	Stock	34.35	34.59	33.98	34.33	32396900.0
2013-07-08	NVDA	Stock	0.357	0.3588	0.3522	0.3542	262084000.0
2013-07-08	AMZN	Stock	14.321	14.5835	14.307	14.5295	60934000.0
2013-07-08	META	Stock	24.47	25.04	24.42	24.71	27064600.0
2013-07-08	TSLA	Stock	8.0913	8.1453	7.9213	8.1073	117213000.0
2013-07-08	TLT	Stock	107.07	107.56	106.95	107.29	8044167.0
2013-07-08	ES	Stock	41.24	41.82	41.07	41.76	1180800.0
2013-07-08	CL	Stock	57.98	58.64	57.98	58.58	2492100.0
2013-07-08	A	Stock	31.7454	31.9528	31.5594	31.731	3593000.0
2013-07-08	AABA-DELISTED	Stock	25.72	25.99	25.49	25.53	9989116.0
2013-07-08	AACG	Stock	4.54	4.7	4.5	4.7	1900.0
2013-07-08	AAIC-DELISTED	Stock	24.52	24.68	23.22	24.39	564687.0
2013-07-08	AAMC-DELISTED	Stock	77.9412	77.9412	77.9412	77.9412	425.0
2013-07-08	AAME	Stock	3.88	3.88	3.71	3.81	3500.0
2013-07-08	AAMRQ-DELISTED	Stock	4.28	4.42	4.26	4.3	1924574.0
2013-07-08	AAON	Stock	10.6667	10.8711	10.4978	10.5378	335475.0
2013-07-08	AAP	Stock	83.1	84.01	82.94	83.72	616000.0
2013-07-08	AAT	Stock	32.25	32.67	32.25	32.43	156300.0
2013-07-08	AAU-DELISTED	Stock	1.41	1.41	1.3	1.33	125196.0
2013-07-08	AAUAF-DELISTED	Stock	1.41	1.41	1.3	1.33	125496.0
2013-07-08	AAV-DELISTED	Stock	3.95	4.06	3.93	4.06	279376.0
2013-07-08	AAWW-DELISTED	Stock	42.66	43.24	42.66	42.99	260786.0
2013-07-08	AAXJ	Stock	53.62	53.999	53.5	53.7	388448.0
2013-07-08	AAXN-DELISTED	Stock	9.03	9.0699	8.84	8.89	333910.0
2013-07-08	AB	Stock	19.7	19.79	18.9	19.22	914400.0
2013-07-08	ABAC-DELISTED	Stock	0.501	0.73	0.501	0.56	123524.0
2013-07-08	ABAX-DELISTED	Stock	49.31	49.74	49.28	49.58	81033.0
2013-07-08	ABB-DELISTED	Stock	21.74	21.75	21.57	21.72	973612.0
2013-07-08	ABBNY-DELISTED	Stock	21.74	21.75	21.57	21.72	1053462.0
2013-07-08	ABBV	Stock	42.9	43.69	42.82	43.68	3978300.0
2013-07-08	ABC-DELISTED	Stock	55.83	56.3	55.59	56.27	1439567.0
2013-07-08	ABCB	Stock	18.81	18.99	18.61	18.69	57800.0
2013-07-08	ABCD-DELISTED	Stock	1.29	1.335	1.29	1.32	4867.0
2013-07-08	ABCO-DELISTED	Stock	55.1	55.27	54.29	55.19	87056.0
2013-07-08	ABCW-DELISTED	Stock	0.3	0.45	0.3	0.385	123741.0
2013-07-08	ABE-DELISTED	Stock	19.44	19.44	19.23	19.31	8265.0
2013-07-08	ABEO	Stock	537.5	625.0	525.0	625.0	38.0
2013-07-08	ABFS-DELISTED	Stock	23.09	23.3775	22.85	23.12	400459.0
2013-07-08	ABG	Stock	42.35	43.62	42.35	42.96	194400.0
2013-07-08	ABM	Stock	24.65	24.78	24.47	24.75	252700.0
2013-07-08	ABMD-DELISTED	Stock	22.4	22.96	22.28	22.92	199527.0
2013-07-08	ABR	Stock	6.2	6.37	6.12	6.32	67100.0
2013-07-08	ABR.A-DELISTED	Stock	24.74	25.29	24.74	25.27	2500.0
2013-07-08	ABR.B-DELISTED	Stock	24.2	24.2	24.2	24.2	250.0
2013-07-08	ABT	Stock	34.95	35.47	34.94	35.41	7545600.0
2013-07-08	ABTL-DELISTED	Stock	4.66	4.9	4.65	4.8	13688.0
2013-07-08	ABUS	Stock	4.81	4.95	4.81	4.9	21600.0
2013-07-08	ABV-DELISTED	Stock	36.89	36.96	36.16	36.23	1285984.0
2013-07-08	ABX-DELISTED	Stock	14.07	14.21	13.73	13.79	20758741.0

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

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