PREVIEW / stock_daily / 2013-11-18

all stock daily files

  file:    by_date/stock_daily/2013/2013-11-18.parquet
  size:    216 KB
  rows:    6,463
  symbols: 3,561

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-11-18	AAPL	Stock	18.7496	18.8282	18.5071	18.5225	244944000.0
2013-11-18	MSFT	Stock	37.35	37.58	37.07	37.2	53277500.0
2013-11-18	NVDA	Stock	0.3955	0.399	0.3935	0.3945	316948000.0
2013-11-18	AMZN	Stock	18.514	18.6745	18.2335	18.309	54748000.0
2013-11-18	META	Stock	48.47	48.84	45.8	45.83	85910000.0
2013-11-18	TSLA	Stock	9.018	9.03	7.974	8.1053	347073000.0
2013-11-18	TLT	Stock	104.65	105.41	104.65	105.36	5451405.0
2013-11-18	ES	Stock	43.01	43.04	42.66	42.85	945600.0
2013-11-18	CL	Stock	65.8	65.93	65.02	65.18	2039200.0
2013-11-18	A	Stock	38.9485	39.3276	38.3906	38.6624	5775837.0
2013-11-18	AABA-DELISTED	Stock	35.65	36.19	34.51	34.98	18935101.0
2013-11-18	AACG	Stock	4.24	4.24	4.1	4.11	11200.0
2013-11-18	AAIC-DELISTED	Stock	25.58	25.95	25.53	25.78	141722.0
2013-11-18	AAMC-DELISTED	Stock	182.3529	182.3529	180.8824	180.8824	6701.0
2013-11-18	AAME	Stock	4.03	4.07	4.01	4.03	6200.0
2013-11-18	AAMRQ-DELISTED	Stock	11.945	12.5	11.94	12.198	17297152.0
2013-11-18	AAOI	Stock	12.52	12.78	12.2	12.21	79900.0
2013-11-18	AAON	Stock	12.3822	12.56	12.1333	12.2089	161100.0
2013-11-18	AAP	Stock	99.68	99.99	97.9	98.31	407300.0
2013-11-18	AAT	Stock	32.36	32.69	32.06	32.12	93600.0
2013-11-18	AAU-DELISTED	Stock	1.19	1.19	1.14	1.17	156202.0
2013-11-18	AAUAF-DELISTED	Stock	1.19	1.19	1.14	1.17	156702.0
2013-11-18	AAV-DELISTED	Stock	4.05	4.11	3.92	3.92	145023.0
2013-11-18	AAWW-DELISTED	Stock	38.0	38.95	37.98	38.35	289104.0
2013-11-18	AAXJ	Stock	61.2	61.4899	60.971	61.02	246691.0
2013-11-18	AAXN-DELISTED	Stock	17.72	17.8	17.01	17.08	1337854.0
2013-11-18	AB	Stock	21.99	21.99	21.41	21.75	618500.0
2013-11-18	ABAC-DELISTED	Stock	2.15	2.15	1.98	2.0127	210816.0
2013-11-18	ABAX-DELISTED	Stock	35.41	35.71	34.928	35.44	177451.0
2013-11-18	ABB-DELISTED	Stock	25.57	25.6	25.37	25.42	982531.0
2013-11-18	ABBNY-DELISTED	Stock	25.57	25.6	25.37	25.43	1136461.0
2013-11-18	ABBV	Stock	48.89	49.96	48.73	48.87	8585700.0
2013-11-18	ABC-DELISTED	Stock	69.99	70.0	68.94	69.17	1449534.0
2013-11-18	ABCB	Stock	19.5	19.92	19.27	19.31	58500.0
2013-11-18	ABCD-DELISTED	Stock	1.42	1.5	1.39	1.43	83585.0
2013-11-18	ABCO-DELISTED	Stock	61.75	62.93	61.51	61.63	149118.0
2013-11-18	ABE-DELISTED	Stock	20.01	20.22	20.01	20.11	5821.0
2013-11-18	ABEO	Stock	350.0	400.0	350.0	400.0	52.0
2013-11-18	ABEV	Stock	7.63	7.79	7.55	7.67	8980400.0
2013-11-18	ABFS-DELISTED	Stock	32.55	33.15	31.981	32.06	546419.0
2013-11-18	ABG	Stock	51.34	51.41	49.9	50.02	234200.0
2013-11-18	ABGB-DELISTED	Stock	11.74	11.79	11.545	11.6	88160.0
2013-11-18	ABM	Stock	28.07	28.12	27.76	27.92	207400.0
2013-11-18	ABMD-DELISTED	Stock	27.59	27.75	26.71	26.99	258979.0
2013-11-18	ABR	Stock	6.81	6.81	6.63	6.68	99200.0
2013-11-18	ABR.A-DELISTED	Stock	24.6	24.6	24.17	24.35	3350.0
2013-11-18	ABT	Stock	38.04	38.15	37.88	37.94	4580900.0
2013-11-18	ABTL-DELISTED	Stock	10.75	11.6	10.37	10.59	251078.0
2013-11-18	ABUS	Stock	8.0	8.14	7.8	7.86	125500.0
2013-11-18	ABX-DELISTED	Stock	18.04	18.05	17.58	17.66	16332841.0

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

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