PREVIEW / stock_daily / 2013-07-17

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-17.parquet
  size:    209 KB
  rows:    6,342
  symbols: 3,508

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-17	AAPL	Stock	15.3464	15.4364	15.2936	15.3682	198990400.0
2013-07-17	MSFT	Stock	36.34	36.39	35.49	35.74	37285100.0
2013-07-17	NVDA	Stock	0.3672	0.3685	0.3642	0.3652	166100000.0
2013-07-17	AMZN	Stock	15.3485	15.44	15.2845	15.4345	40594000.0
2013-07-17	META	Stock	26.37	26.78	26.3	26.65	21518500.0
2013-07-17	TSLA	Stock	7.1013	8.108	6.9667	8.0167	390435000.0
2013-07-17	TLT	Stock	109.19	109.36	108.66	108.86	5931913.0
2013-07-17	ES	Stock	44.13	44.29	43.81	43.93	1027800.0
2013-07-17	CL	Stock	58.6	58.71	58.07	58.36	2873500.0
2013-07-17	A	Stock	32.8684	32.9757	32.5966	32.6252	1671309.0
2013-07-17	AABA-DELISTED	Stock	27.66	29.73	27.52	29.66	81505927.0
2013-07-17	AACG	Stock	4.63	4.64	4.5	4.5	6800.0
2013-07-17	AAIC-DELISTED	Stock	25.66	26.21	25.5075	26.12	139837.0
2013-07-17	AAMC-DELISTED	Stock	80.0	80.2941	80.0	80.2941	680.0
2013-07-17	AAME	Stock	3.73	3.74	3.54	3.71	8300.0
2013-07-17	AAMRQ-DELISTED	Stock	5.36	5.78	5.36	5.75	7299062.0
2013-07-17	AAON	Stock	11.3156	11.44	10.5733	10.6622	542250.0
2013-07-17	AAP	Stock	82.55	82.89	81.44	81.49	460800.0
2013-07-17	AAT	Stock	34.0	34.08	33.64	33.69	176800.0
2013-07-17	AAU-DELISTED	Stock	1.51	1.5149	1.415	1.44	47215.0
2013-07-17	AAUAF-DELISTED	Stock	1.52	1.52	1.42	1.43	47167.0
2013-07-17	AAV-DELISTED	Stock	4.17	4.27	4.15	4.16	198113.0
2013-07-17	AAWW-DELISTED	Stock	44.53	44.98	44.21	44.56	319336.0
2013-07-17	AAXJ	Stock	56.77	56.8	56.45	56.58	544777.0
2013-07-17	AAXN-DELISTED	Stock	9.15	9.17	8.96	9.09	423106.0
2013-07-17	AB	Stock	20.46	20.95	20.42	20.47	318600.0
2013-07-17	ABAC-DELISTED	Stock	0.55	0.59	0.55	0.58	15850.0
2013-07-17	ABAX-DELISTED	Stock	49.68	50.1	49.275	50.025	69863.0
2013-07-17	ABB-DELISTED	Stock	22.77	22.77	22.57	22.675	1184097.0
2013-07-17	ABBNY-DELISTED	Stock	22.77	22.77	22.57	22.69	1209425.0
2013-07-17	ABBV	Stock	43.97	44.15	43.74	43.96	3645400.0
2013-07-17	ABC-DELISTED	Stock	58.38	58.68	58.17	58.48	1103497.0
2013-07-17	ABCB	Stock	17.88	18.02	17.81	17.89	36000.0
2013-07-17	ABCD-DELISTED	Stock	1.26	1.369	1.26	1.369	7046.0
2013-07-17	ABCO-DELISTED	Stock	56.95	57.34	56.13	56.15	64837.0
2013-07-17	ABCW-DELISTED	Stock	0.3635	0.465	0.36	0.46	30060.0
2013-07-17	ABE-DELISTED	Stock	20.09	20.4099	20.0	20.32	5295.0
2013-07-17	ABEO	Stock	500.0	537.5	475.0	537.5	59.0
2013-07-17	ABFS-DELISTED	Stock	22.94	23.32	22.62	22.8	563156.0
2013-07-17	ABG	Stock	44.31	44.51	43.55	44.45	150400.0
2013-07-17	ABM	Stock	25.35	25.74	25.31	25.71	209200.0
2013-07-17	ABMD-DELISTED	Stock	23.77	24.5	23.67	24.5	332834.0
2013-07-17	ABR	Stock	6.49	7.36	6.45	7.18	679800.0
2013-07-17	ABR.A-DELISTED	Stock	25.1999	25.33	25.1999	25.3	6200.0
2013-07-17	ABR.B-DELISTED	Stock	24.12	24.2	23.88	23.91	6620.0
2013-07-17	ABT	Stock	35.88	36.48	35.73	35.82	7979400.0
2013-07-17	ABTL-DELISTED	Stock	5.04	5.08	5.02	5.03	5440.0
2013-07-17	ABUS	Stock	5.16	5.18	5.05	5.18	53300.0
2013-07-17	ABV-DELISTED	Stock	36.92	37.0	36.44	36.68	2107413.0
2013-07-17	ABX-DELISTED	Stock	16.17	16.31	15.67	15.7	20588344.0

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

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