PREVIEW / stock_daily / 2013-01-09

all stock daily files

  file:    by_date/stock_daily/2013/2013-01-09.parquet
  size:    202 KB
  rows:    6,202
  symbols: 3,477

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-01-09	AAPL	Stock	18.6607	18.7504	18.4282	18.4679	407604400.0
2013-01-09	MSFT	Stock	26.72	26.75	26.56	26.7	49047900.0
2013-01-09	NVDA	Stock	0.3148	0.3163	0.3032	0.3052	695020000.0
2013-01-09	AMZN	Stock	13.4085	13.475	13.27	13.3175	45312000.0
2013-01-09	META	Stock	29.67	30.6	29.49	30.59	104787700.0
2013-01-09	TSLA	Stock	2.2673	2.2793	2.2267	2.2427	10470000.0
2013-01-09	TLT	Stock	119.25	119.54	118.87	119.12	3870220.0
2013-01-09	ES	Stock	39.1	39.19	38.8	39.12	2163000.0
2013-01-09	CL	Stock	53.175	53.32	52.945	53.065	1967800.0
2013-01-09	A	Stock	30.7582	31.0801	30.5365	31.0086	5737951.0
2013-01-09	AABA-DELISTED	Stock	19.71	19.75	19.22	19.32	19239409.0
2013-01-09	AACC-DELISTED	Stock	4.61	4.614	4.52	4.59	11801.0
2013-01-09	AACG	Stock	6.13	6.19	5.97	5.97	2900.0
2013-01-09	AAIC-DELISTED	Stock	22.09	22.33	21.99	22.3	127569.0
2013-01-09	AAMC-DELISTED	Stock	23.75	25.3676	23.75	24.7059	180428.0
2013-01-09	AAME	Stock	3.2	3.25	3.01	3.21	5100.0
2013-01-09	AAMRQ-DELISTED	Stock	1.18	1.3	1.08	1.29	54573742.0
2013-01-09	AAON	Stock	6.3881	6.4711	6.3881	6.4356	140063.0
2013-01-09	AAP	Stock	72.39	73.22	72.22	72.39	537600.0
2013-01-09	AAT	Stock	28.54	28.63	28.19	28.51	127100.0
2013-01-09	AAU-DELISTED	Stock	3.09	3.12	2.9698	3.0	130965.0
2013-01-09	AAUAF-DELISTED	Stock	3.06	3.09	2.9401	3.0	132687.0
2013-01-09	AAV-DELISTED	Stock	3.18	3.23	3.18	3.2	112136.0
2013-01-09	AAWW-DELISTED	Stock	45.56	46.99	45.42	46.49	253557.0
2013-01-09	AAXJ	Stock	60.71	60.84	60.57	60.76	553287.0
2013-01-09	AAXN-DELISTED	Stock	9.14	9.56	9.14	9.44	1000785.0
2013-01-09	AB	Stock	19.12	19.5	19.1	19.36	536200.0
2013-01-09	ABAC-DELISTED	Stock	0.98	0.98	0.88	0.88	5485.0
2013-01-09	ABAX-DELISTED	Stock	38.0	38.71	37.75	38.32	167426.0
2013-01-09	ABB-DELISTED	Stock	20.99	21.27	20.98	21.25	1377189.0
2013-01-09	ABBNY-DELISTED	Stock	20.99	21.27	20.98	21.24	1416221.0
2013-01-09	ABBV	Stock	33.61	33.95	33.61	33.9	18800400.0
2013-01-09	ABC-DELISTED	Stock	43.81	43.985	43.58	43.76	1512166.0
2013-01-09	ABCB	Stock	12.94	12.99	12.75	12.85	98300.0
2013-01-09	ABCD-DELISTED	Stock	1.2001	1.24	1.2001	1.24	18220.0
2013-01-09	ABCO-DELISTED	Stock	50.03	50.7	49.98	50.67	157549.0
2013-01-09	ABCW-DELISTED	Stock	0.41	0.43	0.41	0.43	26384.0
2013-01-09	ABE-DELISTED	Stock	21.67	21.82	21.67	21.78	4862.0
2013-01-09	ABEO	Stock	300.0	312.5	300.0	312.5	8.0
2013-01-09	ABFS-DELISTED	Stock	10.24	10.25	9.71	9.73	273180.0
2013-01-09	ABG	Stock	34.16	35.07	34.16	34.36	216900.0
2013-01-09	ABM	Stock	20.56	20.63	20.33	20.51	155900.0
2013-01-09	ABMD-DELISTED	Stock	13.2	13.2	12.75	12.84	1223344.0
2013-01-09	ABR	Stock	6.73	6.83	6.71	6.72	191300.0
2013-01-09	ABT	Stock	33.66	33.71	33.09	33.57	11313000.0
2013-01-09	ABTL-DELISTED	Stock	3.8775	4.01	3.8775	3.983	1911.0
2013-01-09	ABUS	Stock	5.0	5.03	4.94	4.96	22500.0
2013-01-09	ABV-DELISTED	Stock	42.57	42.95	42.38	42.72	2602642.0
2013-01-09	ABX-DELISTED	Stock	33.56	33.72	33.31	33.61	7112150.0
2013-01-09	ACAD	Stock	4.96	5.01	4.85	4.95	665000.0

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

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