PREVIEW / stock_daily / 2013-10-18

all stock daily files

  file:    by_date/stock_daily/2013/2013-10-18.parquet
  size:    215 KB
  rows:    6,427
  symbols: 3,548

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-10-18	AAPL	Stock	18.0711	18.1879	18.0611	18.1746	290542000.0
2013-10-18	MSFT	Stock	34.82	34.99	34.33	34.96	41811700.0
2013-10-18	NVDA	Stock	0.39	0.3965	0.3885	0.3953	255068000.0
2013-10-18	AMZN	Stock	15.968	16.5945	15.8375	16.4465	119396000.0
2013-10-18	META	Stock	54.18	54.83	53.6	54.22	88260000.0
2013-10-18	TSLA	Stock	12.2767	12.3973	12.168	12.2267	88962000.0
2013-10-18	TLT	Stock	107.11	107.48	106.98	107.04	9487800.0
2013-10-18	ES	Stock	42.5	42.6	42.24	42.34	1232200.0
2013-10-18	CL	Stock	63.13	63.13	62.13	62.81	4716400.0
2013-10-18	A	Stock	37.8612	38.083	37.6466	37.9041	4027498.0
2013-10-18	AABA-DELISTED	Stock	33.24	33.75	33.11	33.45	24354466.0
2013-10-18	AACG	Stock	4.58	4.84	4.57	4.63	7300.0
2013-10-18	AAIC-DELISTED	Stock	24.95	24.99	24.74	24.87	115850.0
2013-10-18	AAMC-DELISTED	Stock	152.6441	153.8235	151.4882	151.5882	8456.0
2013-10-18	AAME	Stock	4.04	4.07	4.04	4.04	4700.0
2013-10-18	AAMRQ-DELISTED	Stock	5.665	6.08	5.66	5.938	16146174.0
2013-10-18	AAOI	Stock	10.49	12.0	10.48	11.01	154200.0
2013-10-18	AAON	Stock	12.1822	12.1822	11.8711	12.1111	207225.0
2013-10-18	AAP	Stock	97.35	98.91	97.35	98.7	1300500.0
2013-10-18	AAT	Stock	33.56	33.56	32.97	33.19	170400.0
2013-10-18	AAU-DELISTED	Stock	1.31	1.3399	1.3	1.31	48719.0
2013-10-18	AAUAF-DELISTED	Stock	1.31	1.3399	1.3	1.31	48929.0
2013-10-18	AAV-DELISTED	Stock	3.98	4.13	3.97	4.08	349228.0
2013-10-18	AAWW-DELISTED	Stock	45.71	46.34	45.45	46.0	154047.0
2013-10-18	AAXJ	Stock	61.43	61.616	61.32	61.47	843828.0
2013-10-18	AAXN-DELISTED	Stock	15.85	16.1399	15.58	15.81	1386173.0
2013-10-18	AB	Stock	21.56	21.6	21.22	21.41	310400.0
2013-10-18	ABAC-DELISTED	Stock	1.7	1.78	1.67	1.72	166887.0
2013-10-18	ABAX-DELISTED	Stock	38.29	38.97	37.891	38.2	260014.0
2013-10-18	ABB-DELISTED	Stock	23.45	23.73	23.36	23.7	1422144.0
2013-10-18	ABBNY-DELISTED	Stock	23.46	23.73	23.36	23.68	1493040.0
2013-10-18	ABBV	Stock	48.38	48.95	47.77	48.33	9212900.0
2013-10-18	ABC-DELISTED	Stock	64.98	65.06	64.33	64.58	1091694.0
2013-10-18	ABCB	Stock	18.0	18.0	17.72	17.84	160100.0
2013-10-18	ABCD-DELISTED	Stock	1.31	1.36	1.25	1.35	36667.0
2013-10-18	ABCO-DELISTED	Stock	67.75	68.32	66.94	68.31	215876.0
2013-10-18	ABE-DELISTED	Stock	20.3	20.49	20.2301	20.484	4963.0
2013-10-18	ABEO	Stock	475.0	475.0	425.0	437.5	35.0
2013-10-18	ABFS-DELISTED	Stock	26.02	27.53	25.8001	27.455	828287.0
2013-10-18	ABG	Stock	54.12	54.18	53.13	54.05	311500.0
2013-10-18	ABGB-DELISTED	Stock	12.61	12.73	12.46	12.62	225906.0
2013-10-18	ABM	Stock	27.6	28.23	27.42	28.06	366700.0
2013-10-18	ABMD-DELISTED	Stock	20.62	20.75	20.073	20.12	289017.0
2013-10-18	ABR	Stock	7.0	7.02	6.87	6.94	422900.0
2013-10-18	ABR.A-DELISTED	Stock	24.77	24.77	24.42	24.7475	1560.0
2013-10-18	ABR.B-DELISTED	Stock	23.82	23.8665	23.47	23.47	3201.0
2013-10-18	ABT	Stock	37.17	37.29	36.9	37.29	11752300.0
2013-10-18	ABTL-DELISTED	Stock	8.25	8.47	8.22	8.3	125969.0
2013-10-18	ABUS	Stock	8.64	9.24	8.5	9.01	607700.0
2013-10-18	ABV-DELISTED	Stock	39.73	39.85	39.355	39.6	1348367.0

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

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